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