private IDbDataParameter[] CreateParameters(bool forUpdate)
{
int offSet = 0;
IDbDataParameter[] parameters = new SqlParameter[9];
if (forUpdate)
{
parameters = new SqlParameter[10];
parameters[0] = dataAccess.CreateParameter("@ID", View.Id);
offSet++;
}
parameters[0 + offSet] = dataAccess.CreateParameter("@ClientName", View.ClientName);
parameters[1 + offSet] = dataAccess.CreateParameter("@ClientNumber", View.ClientNumber);
parameters[2 + offSet] = dataAccess.CreateParameter("@ClientLeader", View.ClientPrincipal);
parameters[3 + offSet] = dataAccess.CreateParameter("@ReviewDate", View.reviewDate.GetValueOrDefault(new DateTime(1900, 01, 01)));
parameters[4 + offSet] = dataAccess.CreateParameter("@Comments", View.comments);
parameters[5 + offSet] = dataAccess.CreateParameter("@FileLocation", "");
parameters[6 + offSet] = dataAccess.CreateParameter("@FileLocation2", "");
parameters[7 + offSet] = dataAccess.CreateParameter("@SecureStorage", View.SecureStorage);
parameters[8 + offSet] = dataAccess.CreateParameter("@BoxDetails", ConvertKVPToString(View.boxDetails));
if (View.file.ContentLength > 0)
{
View.file.SaveAs(ConfigurationManager.AppSettings["FileSaveLocation"] + Path.GetFileName(View.file.FileName));
parameters[5 + offSet].Value = Path.GetFileName(View.file.FileName);
}
if (View.file2.ContentLength > 0)
{
View.file2.SaveAs(ConfigurationManager.AppSettings["FileSaveLocation"] + Path.GetFileName(View.file2.FileName));
parameters[6 + offSet].Value = Path.GetFileName(View.file2.FileName);
}
return parameters;
}