public static bool SaveSubmissionDetails(ATTSubmissionDetails objSD)
{
GetConnection Conn = new GetConnection();
try
{
string SaveSQL = "SP_ADD_SUBMISSIONDETAILS";
//OracleConnection DBConn = Conn.GetDbConn("PMS_ADMIN", "PMS_ADMIN");
OracleConnection DBConn = Conn.GetDbConn(Module.PMS);
OracleParameter[] paramArray = new OracleParameter[4];
paramArray[0] = Utilities.GetOraParam(":P_EMP_ID", objSD.EmpID, OracleDbType.Int64, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_SUB_DATE", objSD.SubmissionDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_SUB_OFFICE", objSD.SubmissionOffice, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam("::p_SUB_OFFICE_PLACE", objSD.SubmissionPlace, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, SaveSQL, paramArray);
return(true);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
Conn.CloseDbConn();
}
}
public static bool SaveSubmissionDetails(ATTSubmissionDetails objSD)
{
try
{
return(DLLSubmissionDetails.SaveSubmissionDetails(objSD));
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveSubmissionDetails()
{
try
{
if (Session["SetSubDate"].ToString() == "False")
{
ATTSubmissionDetails objSD = new ATTSubmissionDetails();
//objSD.EmpID = int.Parse(txtEmployeeNo_rqd.Text);
objSD.EmpID = int.Parse(Session["PrpEmpID"].ToString());
objSD.SubmissionDate = txtSubDate_RDT.Text;
objSD.SubmissionOffice = drpOrganisation_rqd.SelectedItem.Text;
objSD.SubmissionPlace = txtSubOffPlace_rqd.Text;
if (BLLSubmissionDetails.SaveSubmissionDetails(objSD))
{
this.lblStatusMessage.Text = "Property Details Saves Successfully.";
this.programmaticModalPopup.Show();
Session["SubDate"] = txtSubDate_RDT.Text;
if (Session["SubDate"] != null)
{
Session["SetSubDate"] = true;
txtSubDate_RDT.ReadOnly = true;
txtSubOffPlace_rqd.ReadOnly = true;
drpOrganisation_rqd.Enabled = false;
}
else
{
this.lblStatusMessageTitle.Text = "Submission Status";
this.lblStatusMessage.Text = "Enter Submission Details";
this.programmaticModalPopup.Show();
}
}
}
}
catch (Exception ex)
{
this.lblStatusMessageTitle.Text = "Error Status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
