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(); } }