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