public static bool SaveTarikhCourtBato(ATTTarekhCourtBato attTCB) { try { return(DLLTarekhCourtBato.SaveTarekhCourtBato(attTCB)); } catch (Exception ex) { throw ex; } }
public static bool SaveTarekhCourtBato(ATTTarekhCourtBato objTarekhCourtBato) { string InsertUpdateSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_COURT_ID", objTarekhCourtBato.CourtID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_FROM_DATE", objTarekhCourtBato.FromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_TOT_DAYS", objTarekhCourtBato.TotalDays, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_BATOKO_MYAAD", objTarekhCourtBato.BatoKoMayad, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objTarekhCourtBato.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (objTarekhCourtBato.Action == "A") { InsertUpdateSQL = "SP_ADD_TARIKH_COURT_BATO"; } else if (objTarekhCourtBato.Action == "E") { InsertUpdateSQL = "SP_EDIT_TARIKH_COURT_BATO"; } GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); Tran.Commit(); 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(); } }
public static List <ATTTarekhCourtBato> GetTarikhCourtBato(int courtID) { List <ATTTarekhCourtBato> lstTCB = new List <ATTTarekhCourtBato>(); try { foreach (DataRow row in DLLTarekhCourtBato.GetTarekhCourtBato(courtID).Rows) { ATTTarekhCourtBato TarekhCourtBato = new ATTTarekhCourtBato ( int.Parse(row["COURT_ID"].ToString()), (string)row["FROM_DATE"], int.Parse(row["TOT_DAYS"].ToString()), int.Parse(row["BATO_KO_MYAAD"].ToString()) ); lstTCB.Add(TarekhCourtBato); } return(lstTCB); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtFromDate_RQD.Text == "____/__/__") { lblStatusMessage.Text = "Please Enter From Date First."; programmaticModalPopup.Show(); return; } if (txtTotalDays_RQD.Text == "") { lblStatusMessage.Text = "Please Enter Total Days First."; programmaticModalPopup.Show(); return; } if (txtBatoKoMyaad_RQD.Text == "") { lblStatusMessage.Text = "Please Enter Bato ko Myaad First."; programmaticModalPopup.Show(); return; } ATTTarekhCourtBato attTCB = new ATTTarekhCourtBato(); try { if (this.lstCourt.SelectedIndex > -1) { attTCB.CourtID = int.Parse(lstCourt.SelectedValue); attTCB.FromDate = txtFromDate_RQD.Text.Trim(); attTCB.TotalDays = int.Parse(txtTotalDays_RQD.Text.ToString()); attTCB.BatoKoMayad = int.Parse(txtBatoKoMyaad_RQD.Text.ToString()); attTCB.EntryBy = strUser; if ((this.txtFromDate_RQD.HasAttributes) && (this.txtTotalDays_RQD.HasAttributes) && (this.txtBatoKoMyaad_RQD.HasAttributes)) { if ((this.txtFromDate_RQD.Text == this.txtFromDate_RQD.Attributes["FromDate"].ToString()) && (this.txtTotalDays_RQD.Text == this.txtTotalDays_RQD.Attributes["TotalDays"].ToString()) && (this.txtBatoKoMyaad_RQD.Text == this.txtBatoKoMyaad_RQD.Attributes["BatoKoMyaad"].ToString())) { this.lblStatusMessage.Text = "No Changes Have Been Made."; this.programmaticModalPopup.Show(); return; } if ((txtFromDate_RQD.Text.Trim()).CompareTo(this.txtFromDate_RQD.Attributes["FromDate"].ToString()) < 0) { lblStatusMessage.Text = "Please Enter Date Greater Than (Or) Equal To " + this.txtFromDate_RQD.Attributes["FromDate"].ToString(); programmaticModalPopup.Show(); return; } if (this.txtFromDate_RQD.Text == this.txtFromDate_RQD.Attributes["FromDate"].ToString()) { attTCB.Action = "E"; } else { attTCB.Action = "A"; } } else { attTCB.Action = "A"; } BLLTarekhCourtBato.SaveTarikhCourtBato(attTCB); ClearControls(); } else { lblStatusMessage.Text = "Please Select The Court."; programmaticModalPopup.Show(); } } catch (Exception ex) { lblStatusMessage.Text = ex.Message; programmaticModalPopup.Show(); } }