public static int SaveReligions(ATTReligion objReligions) { try { return(DLLReligion.AddReligions(objReligions)); } catch (System.Exception ex) { throw ex; } }
public static int AddReligions(ATTReligion objReligions) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn().BeginTransaction(); int religionID = 0; try { string InsertUpdateSQL = ""; if (objReligions.ReligionId <= 0) { InsertUpdateSQL = "SP_ADD_RELIGIONS"; } else { InsertUpdateSQL = "SP_EDIT_RELIGIONS"; } OracleParameter[] ParamArray = new OracleParameter[3]; ParamArray[0] = Utilities.GetOraParam(":p_RELG_ID", objReligions.ReligionId, OracleDbType.Int64, ParameterDirection.InputOutput); ParamArray[1] = Utilities.GetOraParam(":p_RELG_NEP_NAME", objReligions.ReligionNepName, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[2] = Utilities.GetOraParam(":p_RELG_ENG_NAME", objReligions.ReligionEngName, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, ParamArray[0], ParamArray); religionID = int.Parse(ParamArray[0].Value.ToString()); Tran.Commit(); return(religionID); } 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 <ATTReligion> GetReligions(int?relgID, int FlagForDefault) { List <ATTReligion> lstReligions = new List <ATTReligion>(); foreach (DataRow row in DLLReligion.GetReligions(relgID).Rows) { ATTReligion obj = new ATTReligion(int.Parse(row["RELIGION_ID"].ToString()), ((row["RELIGION_NEP_NAME"] == System.DBNull.Value) ? "" : (string)row["RELIGION_NEP_NAME"]), ((row["RELIGION_ENG_NAME"] == System.DBNull.Value) ? "" : (string)row["RELIGION_ENG_NAME"])); lstReligions.Add(obj); } if (FlagForDefault == 0) { lstReligions.Insert(0, new ATTReligion(0, "छान्नुहोस", "")); } return(lstReligions); }
protected void btnSave_Click(object sender, EventArgs e) { try { lblStatusMessage.Text = ""; List <ATTReligion> lstReligions = (List <ATTReligion>)Session["Religions"]; int religionID = 0; if (this.grdReligions.SelectedIndex > -1) { religionID = lstReligions[this.grdReligions.SelectedIndex].ReligionId; } ATTReligion objReligions = new ATTReligion(religionID, this.txtRelgNepName_rqd.Text.Trim(), this.txtRelgEngName.Text.Trim()); religionID = BLLReligion.SaveReligions(objReligions); if (this.grdReligions.SelectedIndex > -1) { lstReligions[this.grdReligions.SelectedIndex].ReligionId = religionID; lstReligions[this.grdReligions.SelectedIndex].ReligionNepName = this.txtRelgNepName_rqd.Text.Trim(); lstReligions[this.grdReligions.SelectedIndex].ReligionEngName = this.txtRelgEngName.Text.Trim(); } else { ATTReligion objNewReligions = new ATTReligion(religionID, this.txtRelgNepName_rqd.Text.Trim(), this.txtRelgEngName.Text.Trim()); lstReligions.Add(objNewReligions); } Session["Religions"] = lstReligions; this.grdReligions.DataSource = lstReligions; ClearComponents(); this.lblStatusMessage.Text = "Successfully Saved"; this.programmaticModalPopup.Show(); this.grdReligions.DataBind(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }