public static bool SavePratiuttar(ATTPratiuttar objPratiuttar)
{
try
{
return(DLLPratiuttar.SavePratiuttar(objPratiuttar));
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
ATTPratiuttar objPratiuttar = new ATTPratiuttar();
objPratiuttar.CaseID = double.Parse(Session["CaseID"].ToString());
objPratiuttar.PratiuttarID = 0;
objPratiuttar.PratiuttarDate = this.txtPraDate_DT.Text.Trim();
objPratiuttar.AccountForward = "N";
objPratiuttar.SubmittedBy = null;
objPratiuttar.PratiuttarSummary = this.txtPraSummary.Text.Trim();
objPratiuttar.EntryBy = user.UserName;
foreach (GridViewRow row in this.grdLitigantRes.Rows)
{
CheckBox cb = (CheckBox)(row.FindControl("chkRes"));
if (cb.Checked)
{
ATTPratiuttarLitigants objPratiLitigants = new ATTPratiuttarLitigants
(
double.Parse(Session["CaseID"].ToString()),
objPratiuttar.PratiuttarID,
double.Parse(row.Cells[2].Text)
);
objPratiLitigants.Action = "A";
objPratiLitigants.EntryBy = user.UserName;
objPratiuttar.LstPratiuttarLitigants.Add(objPratiLitigants);
}
}
if (objPratiuttar.LstPratiuttarLitigants.Count == 0)
{
this.lblStatusMessage.Text = "Please Select Respondent(s).";
this.programmaticModalPopup.Show();
return;
}
objPratiuttar.LstPratiuttarEvidence = (List <ATTPratiuttarEvidence>)Session["PratiuttarEvidence"];
objPratiuttar.LstPratiuttarDocuments = (List <ATTPratiuttarDocuments>)Session["PratiuttarDocument"];
try
{
BLLPratiuttar.SavePratiuttar(objPratiuttar);
this.lblStatusMessage.Text = "Pratiuttar Successfully Saved.";
this.programmaticModalPopup.Show();
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static bool SavePratiuttar(ATTPratiuttar objPratiuttar)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
double pratiuttarID = 0;
List <OracleParameter> paramArray = new List <OracleParameter>();
try
{
paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", objPratiuttar.CaseID, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_PRATIUTTAR_ID", pratiuttarID, OracleDbType.Int32, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_PRATIUTTAR_DATE", objPratiuttar.PratiuttarDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACCOUNT_FORWARD", objPratiuttar.AccountForward, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_SUBMITTED_BY", objPratiuttar.SubmittedBy, OracleDbType.Double, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_PRATIUTTAR_SUMMARY", objPratiuttar.PratiuttarSummary, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objPratiuttar.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (objPratiuttar.PratiuttarID == 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_ADD_CASE_PRATIUTTAR", paramArray.ToArray());
}
else if (objPratiuttar.PratiuttarID > 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_EDIT_CASE_PRATIUTTAR", paramArray.ToArray());
}
objPratiuttar.PratiuttarID = int.Parse(paramArray[1].Value.ToString());
if (objPratiuttar.LstPratiuttarLitigants.Count > 0)
{
DLLPratiuttarLitigants.SavePratiuttarLitigants(objPratiuttar.LstPratiuttarLitigants, objPratiuttar.PratiuttarID, Tran);
}
if (objPratiuttar.LstPratiuttarEvidence.Count > 0)
{
DLLPratiuttarEvidence.SavePratiuttarEvidence(objPratiuttar.LstPratiuttarEvidence, objPratiuttar.PratiuttarID, Tran);
}
if (objPratiuttar.LstPratiuttarDocuments.Count > 0)
{
DLLPratiuttarDocuments.SavePratiuttarDocuments(objPratiuttar.LstPratiuttarDocuments, objPratiuttar.PratiuttarID, Tran);
}
Tran.Commit();
paramArray.Clear();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
