/// <summary>
/// UpdateInsert the Document Upload record
/// </summary>
/// <param name="DocumentUploadBO"></param>
/// <returns>int</returns>
public void UpdateInsert(DocumentUploadBO duBO)
{
// Define Constants
const string sp = "dbo.Update_Insert_Document_Upload";
// Set Stored Procedure
DbCommand dbCommand = _DB.GetStoredProcCommand(sp);
try
{
_DB.AddInParameter(dbCommand, "Project_Id", DbType.Int32, duBO.Project_Id);
_DB.AddInParameter(dbCommand, "Project_Name", DbType.String, duBO.Project_Name);
_DB.AddInParameter(dbCommand, "Upload_Criteria_Id", DbType.Int32, duBO.Upload_Criteria_Id);
_DB.AddInParameter(dbCommand, "Effective_Date", DbType.DateTime, duBO.Effective_Date);
_DB.AddInParameter(dbCommand, "Ack_Due_Date", DbType.DateTime, duBO.Ack_Due_Date);
_DB.AddInParameter(dbCommand, "Primary_Barcode", DbType.String, duBO.Primary_Barcode);
_DB.AddInParameter(dbCommand, "Secondary_Barcode", DbType.String, duBO.Secondary_Barcode);
_DB.AddInParameter(dbCommand, "Email_Notification", DbType.String, duBO.Email_Notification);
_DB.AddInParameter(dbCommand, "Email_Reminder", DbType.String, duBO.Email_Reminder);
_DB.AddInParameter(dbCommand, "Zip_File_Name", DbType.String, duBO.Zip_File_Name);
_DB.AddInParameter(dbCommand, "Control_File_Name", DbType.String, duBO.Control_File_Name);
_DB.AddInParameter(dbCommand, "PDF_File_Name", DbType.String, duBO.PDF_File_Name);
_DB.AddInParameter(dbCommand, "Criteria_Name", DbType.String, duBO.Criteria_Name);
_DB.AddInParameter(dbCommand, "Project_Created_By", DbType.String, duBO.Project_Created_By);
_DB.AddInParameter(dbCommand, "Modified_By", DbType.String, duBO.Modified_By);
_DB.AddOutParameter(dbCommand, "Id", DbType.Int32, 0);
_DB.ExecuteNonQuery(dbCommand);
if (duBO.Project_Id == 0)
{
HttpContext.Current.Session["ProjectId"] = Convert.ToInt32(_DB.GetParameterValue(dbCommand, "@Id"));
}
}
catch (InternalException err)
{
// Re-Throw the Internal Exception
throw;
}
catch (Exception err)
{
// Format the Parameters
string parms = CommonDA.FormatParmsSQL(dbCommand);
// Database Error
ErrMsg = string.Format("{0} - UpdateInsert Document Upload Error - Parameters = {1} - {2}",
GetType().FullName,
parms,
err.Message);
// Save the Error
CommonDA.SaveError(ErrMsg, err);
}
}
/// <summary>
/// Retrieves the Document Upload record for an Project Id
/// </summary>
/// <param name="projectId"></param>
/// <returns>documentUploadBO</returns>
public DocumentUploadBO GetByProjectId(Int32 projectId)
{
// Define Constants
const string sp = "dbo.Get_DocUpload_By_Project_Id";
// Set Stored Procedure
DbCommand dbCommand = _DB.GetStoredProcCommand(sp);
// Define Variables
DocumentUploadBO duBO = new DocumentUploadBO();
try
{
// Set Input Parameters
_DB.AddInParameter(dbCommand, "Project_Id", DbType.Int32, projectId);
using (IDataReader dr = _DB.ExecuteReader(dbCommand))
{
// Process all the records
while (dr.Read())
{
// Save the DocUpload record
duBO.Save(dr);
}
}
}
catch (InternalException err)
{
// Re-Throw the Internal Exception
throw;
}
catch (Exception err)
{
// Format the Parameters
string parms = CommonDA.FormatParmsSQL(dbCommand);
// Database Error
ErrMsg = string.Format("{0} - Get DocUpload By Project Id Error - Parameters = {1} - {2}",
GetType().FullName,
parms,
err.Message);
// Save the Error
CommonDA.SaveError(ErrMsg, err);
}
return(duBO);
}