public static List <ATTPesiType> GetPesiType(int?PesiTypeID, string active, int defaultFlag) { List <ATTPesiType> PesiTypeLST = new List <ATTPesiType>(); try { foreach (DataRow row in DLLPesiType.GetPesiType(PesiTypeID, active).Rows) { ATTPesiType objPesiType = new ATTPesiType(); objPesiType.PesiTypeID = int.Parse(row["PESI_TYPE_ID"].ToString()); objPesiType.PesiTypeName = row["PESI_TYPE_NAME"].ToString(); objPesiType.Active = row["ACTIVE"].ToString(); PesiTypeLST.Add(objPesiType); } if (defaultFlag > 0) { ATTPesiType obj = new ATTPesiType(); obj.PesiTypeID = 0; obj.PesiTypeName = "छान्नुहोस"; PesiTypeLST.Insert(0, obj); } return(PesiTypeLST); } catch (Exception ex) { throw ex; } }
public static bool SavePesiType(ATTPesiType objPesiType) { try { return(DLLPesiType.SavePesiType(objPesiType)); } catch (Exception ex) { throw ex; } }
public static bool SavePesiType(ATTPesiType objPesiType) { string InsertUpdateSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { paramArray.Add(Utilities.GetOraParam(":P_PESI_TYPE_ID", objPesiType.PesiTypeID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_PESI_TYPE_NAME", objPesiType.PesiTypeName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objPesiType.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objPesiType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (objPesiType.Action == "A") { InsertUpdateSQL = "SP_ADD_BENCH_TYPE"; } else if (objPesiType.Action == "E") { InsertUpdateSQL = "SP_EDIT_BENCH_TYPE"; } SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); objPesiType.PesiTypeID = int.Parse(paramArray[0].Value.ToString()); objPesiType.Action = ""; 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 (this.txtPesiType.Text == "") { this.lblStatusMessage.Text = "Pesi Type Can't Be Left Blank"; this.programmaticModalPopup.Show(); return; } ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); List <ATTPesiType> PesiTypeLST = (List <ATTPesiType>)Session["PesiType"]; int i = -1; if (this.lstPesiType.SelectedIndex > -1) { i = PesiTypeLST.FindIndex(delegate(ATTPesiType obj) { return(this.txtPesiType.Text == obj.PesiTypeName && this.lstPesiType.SelectedItem.Text != this.txtPesiType.Text); }); } else { i = PesiTypeLST.FindIndex(delegate(ATTPesiType obj) { return(this.txtPesiType.Text == obj.PesiTypeName); }); } if (i > -1) { this.lblStatusMessage.Text = "Pesi Type Name Already Exists"; this.programmaticModalPopup.Show(); return; } ATTPesiType objPesiType = new ATTPesiType(); objPesiType.PesiTypeID = (this.lstPesiType.SelectedIndex == -1) ? 0 : int.Parse(this.lstPesiType.SelectedValue); objPesiType.PesiTypeName = this.txtPesiType.Text; objPesiType.Active = (chkPesiTypeActive.Checked == true) ? "Y" : "N"; objPesiType.EntryBy = user.UserName; objPesiType.Action = (this.lstPesiType.SelectedIndex == -1) ? "A" : "E"; try { if (BLLPesiType.SavePesiType(objPesiType) == true) { if (this.lstPesiType.SelectedIndex == -1) { PesiTypeLST.Add(objPesiType); } else { PesiTypeLST.RemoveAt(this.lstPesiType.SelectedIndex); PesiTypeLST.Add(objPesiType); } lstPesiType.DataSource = PesiTypeLST; lstPesiType.DataValueField = "PesiTypeID"; lstPesiType.DataTextField = "PesiTypeName"; lstPesiType.DataBind(); clearAll(); } } catch (Exception ex) { this.lblStatusMessage.Text = "Pesi Type Couldn't Be Saved<BR>" + ex.Message; this.programmaticModalPopup.Show(); } }