public static List <ATTCaseProceeding> GetCaseProceeding(int?CaseProceeding, string active, int defaultFlag)
{
List <ATTCaseProceeding> CaseProceedingList = new List <ATTCaseProceeding>();
try
{
foreach (DataRow row in DLLCaseProceeding.GetCaseProceeding(CaseProceeding, active).Rows)
{
ATTCaseProceeding Reglst = new ATTCaseProceeding(
int.Parse(row["PROCEEDING_ID"].ToString()),
row["PROCEEDING_NAME"].ToString(),
row["ACTIVE"].ToString());
CaseProceedingList.Add(Reglst);
}
if (defaultFlag > 0)
{
CaseProceedingList.Insert(0, new ATTCaseProceeding(0, "छान्नुहोस", ""));
}
return(CaseProceedingList);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveCaseProceeding(ATTCaseProceeding objCaseProceeding)
{
try
{
return(DLLCaseProceeding.SaveCaseProceeding(objCaseProceeding));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveCaseProceeding(ATTCaseProceeding objCaseProceeding)
{
string InsertUpdateSQL = "";
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_PROCEEDING_ID", objCaseProceeding.CaseProceedingID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_PROCEEDING_NAME", objCaseProceeding.CaseProceedingName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objCaseProceeding.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objCaseProceeding.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (objCaseProceeding.Action == "A")
{
InsertUpdateSQL = "SP_ADD_CASE_PROCEEDING";
}
else if (objCaseProceeding.Action == "E")
{
InsertUpdateSQL = "SP_EDIT_PROCEEDING";
}
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
objCaseProceeding.CaseProceedingID = int.Parse(paramArray[0].Value.ToString());
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();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtCaseProceedingName_RQD.Text == "")
{
lblStatusMessage.Text = "कामको किसिम लेख्नुस";
programmaticModalPopup.Show();
return;
}
int CaseProceeding = 0;
if (lstCaseProceeding.SelectedIndex != -1)
{
CaseProceeding = int.Parse(lstCaseProceeding.SelectedValue);
}
foreach (ListItem lst in lstCaseProceeding.Items)
{
if (lst.Selected == true)
{
continue;
}
if (lst.Text.Trim().ToLower() == txtCaseProceedingName_RQD.Text.Trim().ToLower())
{
this.lblStatusMessage.Text = "Case Proceeding Already Exists";
this.programmaticModalPopup.Show();
return;
}
}
ATTCaseProceeding objCaseProceeding = new ATTCaseProceeding(CaseProceeding, this.txtCaseProceedingName_RQD.Text.Trim(), this.chkActive.Checked == true ? "Y" : "N");
objCaseProceeding.EntryBy = strUser;
if (this.lstCaseProceeding.SelectedIndex > -1)
{
objCaseProceeding.Action = "E";
}
else
{
objCaseProceeding.Action = "A";
}
try
{
List <ATTCaseProceeding> ListCaseProceedingList = (List <ATTCaseProceeding>)Session["CaseProceeding"];
BLLCaseProceeding.SaveCaseProceeding(objCaseProceeding);
if (this.lstCaseProceeding.SelectedIndex > -1)
{
ListCaseProceedingList[this.lstCaseProceeding.SelectedIndex].CaseProceedingID = objCaseProceeding.CaseProceedingID;
ListCaseProceedingList[this.lstCaseProceeding.SelectedIndex].CaseProceedingName = objCaseProceeding.CaseProceedingName;
ListCaseProceedingList[this.lstCaseProceeding.SelectedIndex].Active = objCaseProceeding.Active;
}
else
{
ListCaseProceedingList.Add(objCaseProceeding);
}
ClearControls();
this.lstCaseProceeding.DataSource = ListCaseProceedingList;
this.lstCaseProceeding.DataBind();
this.lblStatusMessage.Text = "Case Proceeding Successfully Saved.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
