public static List <ATTCaseStatus> GetCaseStatus(int?CaseStatus, string active, int defaultFlag) { List <ATTCaseStatus> CaseStatusList = new List <ATTCaseStatus>(); try { foreach (DataRow row in DLLCaseStatus.GetCaseStatus(CaseStatus, active).Rows) { ATTCaseStatus Reglst = new ATTCaseStatus( int.Parse(row["CASE_STATUS_ID"].ToString()), row["CASE_STATUS_NAME"].ToString(), row["ACTIVE"].ToString()); CaseStatusList.Add(Reglst); } if (defaultFlag > 0) { CaseStatusList.Insert(0, new ATTCaseStatus(0, "छान्नुहोस", "")); } return(CaseStatusList); } catch (Exception ex) { throw ex; } }
public static bool SaveCaseStatus(ATTCaseStatus objCaseStatus) { try { return(DLLCaseStatus.SaveCaseStatus(objCaseStatus)); } catch (Exception ex) { throw ex; } }
public static bool SaveCaseStatus(ATTCaseStatus objCaseStatus) { string InsertUpdateSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_CASE_STATUS_ID", objCaseStatus.CaseStatusID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_CASE_STATUS_NAME", objCaseStatus.CaseStatusName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objCaseStatus.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objCaseStatus.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (objCaseStatus.Action == "A") { InsertUpdateSQL = "SP_ADD_CASE_STATUS"; } else if (objCaseStatus.Action == "E") { InsertUpdateSQL = "SP_EDIT_CASE_STATUS"; } GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); objCaseStatus.CaseStatusID = 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 (txtCaseStatus_RQD.Text == "") { lblStatusMessage.Text = "मुदाको ञव्स्था लेख्नुस"; programmaticModalPopup.Show(); return; } int CaseStatus = 0; if (lstCaseStatus.SelectedIndex != -1) { CaseStatus = int.Parse(lstCaseStatus.SelectedValue); } foreach (ListItem lst in lstCaseStatus.Items) { if (lst.Selected == true) { continue; } if (lst.Text.Trim().ToLower() == txtCaseStatus_RQD.Text.Trim().ToLower()) { this.lblStatusMessage.Text = "Case Ststus Already Exists"; this.programmaticModalPopup.Show(); return; } } ATTCaseStatus objCaseStatus = new ATTCaseStatus(CaseStatus, this.txtCaseStatus_RQD.Text.Trim(), this.chkActive.Checked == true ? "Y" : "N"); objCaseStatus.EntryBy = strUser; if (this.lstCaseStatus.SelectedIndex > -1) { objCaseStatus.Action = "E"; } else { objCaseStatus.Action = "A"; } try { List <ATTCaseStatus> ListCaseStatusList = (List <ATTCaseStatus>)Session["CaseStatus"]; BLLCaseStatus.SaveCaseStatus(objCaseStatus); if (this.lstCaseStatus.SelectedIndex > -1) { ListCaseStatusList[this.lstCaseStatus.SelectedIndex].CaseStatusID = objCaseStatus.CaseStatusID; ListCaseStatusList[this.lstCaseStatus.SelectedIndex].CaseStatusName = objCaseStatus.CaseStatusName; ListCaseStatusList[this.lstCaseStatus.SelectedIndex].Active = objCaseStatus.Active; } else { ListCaseStatusList.Add(objCaseStatus); } ClearControls(); this.lstCaseStatus.DataSource = ListCaseStatusList; this.lstCaseStatus.DataBind(); this.lblStatusMessage.Text = "Case Status Successfully Saved."; this.programmaticModalPopup.Show(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }