public static bool SaveWritSubject(ATTWritSubject objWritSubject)
{
try
{
return(DLLWritSubject.SaveWritSubject(objWritSubject));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveWritSubject(ATTWritSubject objWritSubject)
{
string InsertUpdateSQL = "";
if (objWritSubject.Action == "A")
{
InsertUpdateSQL = "SP_ADD_WRIT_SUBJECT";
}
else if (objWritSubject.Action == "E")
{
InsertUpdateSQL = "SP_EDIT_WRIT_SUBJECT";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_WRIT_SUB_ID", objWritSubject.WritSubjectID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_WRIT_SUB_NAME", objWritSubject.WritSubjectName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objWritSubject.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objWritSubject.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
objWritSubject.WritSubjectID = int.Parse(paramArray[0].Value.ToString());
objWritSubject.Action = "";
if (objWritSubject.WritCategoryLST != null)
{
DLLWritCategory.AddWritCategory(objWritSubject.WritCategoryLST, Tran, objWritSubject.WritSubjectID);
}
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 grdWritSubCatTitle_SelectedIndexChanged(object sender, EventArgs e)
{
if (CheckNull.NullString(this.grdWritSubCatTitle.SelectedRow.Cells[5].Text) == "")
{
this.grdWritSubCatTitle.SelectedRow.Cells[5].Text = "E";
}
this.txtWritSubCatTitle.Text = this.grdWritSubCatTitle.SelectedRow.Cells[3].Text;
this.chkWritSubCatTitleActive.Checked = (this.grdWritSubCatTitle.SelectedRow.Cells[4].Text == "Y") ? true : false;
ATTWritSubject WritSubjectOBJ = (ATTWritSubject)Session["TempWritSubject"];
List <ATTWritCategory> WritSubCatLST = WritSubjectOBJ.WritCategoryLST;
this.grdWritSubCatSubTitle.DataSource = WritSubCatLST[this.grdWritCategory.SelectedIndex].WritCategoryTitleLST[this.grdWritSubCatTitle.SelectedIndex].WritCategorySubTitleLST;
this.grdWritSubCatSubTitle.DataBind();
}
protected void lstWritSubject_SelectedIndexChanged(object sender, EventArgs e)
{
clearAll(0);
List <ATTWritSubject> writSubjectLST = (List <ATTWritSubject>)Session["WritSubject"];
createTempObj();
Session["TempWritSubject"] = (ATTWritSubject)writSubjectLST[this.lstWritSubject.SelectedIndex].Clone();
ATTWritSubject TempWritSubjectOBJ = (ATTWritSubject)Session["TempWritSubject"];
this.txtWritSubject_RQD.Text = TempWritSubjectOBJ.WritSubjectName;
this.chkWritActive.Checked = (TempWritSubjectOBJ.Active == "Y") ? true : false;
this.grdWritCategory.DataSource = TempWritSubjectOBJ.WritCategoryLST;
this.grdWritCategory.DataBind();
this.grdWritCategory.SelectedIndex = -1;
}
public static List <ATTWritSubject> GetWritSubjectDetailsLST(int?writSubjectID,
string active,
bool writSubDV,
bool writCatDV,
bool writTitleDV,
bool writSubTitleDV)
{
List <ATTWritSubject> WritSubjectLST = new List <ATTWritSubject>();
try
{
foreach (DataRow row in DLLWritSubject.GetWritSubject(writSubjectID, active).Rows)
{
ATTWritSubject WritSubOBJ = new ATTWritSubject();
WritSubOBJ.WritSubjectID = int.Parse(row["WRIT_SUB_ID"].ToString());
WritSubOBJ.WritSubjectName = row["WRIT_SUB_NAME"].ToString();
WritSubOBJ.Active = row["ACTIVE"].ToString();
WritSubOBJ.Action = "";
WritSubOBJ.WritCategoryLST = BLLWritSubjectCategory.GetWritSubjCategoryDetailsLST(int.Parse(row["WRIT_SUB_ID"].ToString()), null, null, writCatDV, writTitleDV, writSubTitleDV);
WritSubjectLST.Add(WritSubOBJ);
}
if (writSubDV == true)
{
ATTWritSubject obj = new ATTWritSubject();
obj.WritSubjectID = 0;
obj.WritSubjectName = "छान्नुहोस";
WritSubjectLST.Insert(0, obj);
}
return(WritSubjectLST);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
List <ATTWritSubject> WritSubjectLST = (List <ATTWritSubject>)Session["WritSubject"];
int i = -1;
if (this.lstWritSubject.SelectedIndex > -1)
{
i = WritSubjectLST.FindIndex(delegate(ATTWritSubject obj)
{
return(this.txtWritSubject_RQD.Text.ToUpper() == obj.WritSubjectName.ToUpper() && this.lstWritSubject.SelectedItem.Text.ToUpper() != this.txtWritSubject_RQD.Text.ToUpper());
});
}
else
{
i = WritSubjectLST.FindIndex(delegate(ATTWritSubject obj)
{
return(this.txtWritSubject_RQD.Text.ToUpper() == obj.WritSubjectName.ToUpper());
});
}
if (i > -1)
{
this.lblStatusMessage.Text = "Writ Subject Name Already Exists";
this.programmaticModalPopup.Show();
return;
}
ATTWritSubject objWritSubject = (ATTWritSubject)Session["TempWritSubject"];
try
{
objWritSubject.WritSubjectName = this.txtWritSubject_RQD.Text;
objWritSubject.Active = (chkWritActive.Checked == true) ? "Y" : "N";
objWritSubject.EntryBy = user.UserName;
objWritSubject.Action = (lstWritSubject.SelectedIndex == -1) ? "A" : "E";
if (BLLWritSubject.SaveWritSubject(objWritSubject) == true)
{
if (lstWritSubject.SelectedIndex > -1)
{
WritSubjectLST.RemoveAt(this.lstWritSubject.SelectedIndex);
}
WritSubjectLST.Add(objWritSubject);
}
lstWritSubject.DataSource = WritSubjectLST;
lstWritSubject.DataValueField = "WritSubjectID";
lstWritSubject.DataTextField = "WritSubjectName";
lstWritSubject.DataBind();
createTempObj();
this.clearAll(1);
}
catch (Exception ex)
{
this.lblStatus.Text = "Save Status";
this.lblStatusMessage.Text = "Writ Subject Details Can't be Saved<BR><BR>" + ex.Message;
this.programmaticModalPopup.Show();
}
}
private void createTempObj()
{
Session["TempWritSubject"] = new ATTWritSubject();
}
protected void btnAddWritSubCatSubTitle_Click(object sender, EventArgs e)
{
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
if (this.grdWritSubCatTitle.SelectedIndex == -1)
{
this.lblStatus.Text = "Add Writ Subject Category Sub Title Status";
this.lblStatusMessage.Text = "Please Select Writ Subject Category Sub Title";
this.programmaticModalPopup.Show();
return;
}
ATTWritSubject WritSubjectOBJ = (ATTWritSubject)Session["TempWritSubject"];
List <ATTWritCategory> WritSubCatLST = WritSubjectOBJ.WritCategoryLST;
List <ATTWritCategoryTitle> WritSubCatTitleLST = WritSubCatLST[this.grdWritCategory.SelectedIndex].WritCategoryTitleLST;
List <ATTWritCategorySubTitle> WritSubCatSubTitleLST = WritSubCatTitleLST[this.grdWritSubCatTitle.SelectedIndex].WritCategorySubTitleLST;
try
{
if (grdWritSubCatSubTitle.SelectedIndex == -1)
{
ATTWritCategorySubTitle objEWritSubCatSubTitle = new ATTWritCategorySubTitle();
objEWritSubCatSubTitle.WritSubjectID = 0;
objEWritSubCatSubTitle.WritSubjectCatID = 0;
objEWritSubCatSubTitle.WritSubjectCatTitleID = 0;
objEWritSubCatSubTitle.WritSubjectCatSubTitleID = 0;
objEWritSubCatSubTitle.WritSubjectCatSubTitleName = this.txtWritSubCatSubTitle.Text;
objEWritSubCatSubTitle.Active = (chkWritSubCatSubTitleActive.Checked == true) ? "Y" : "N";
objEWritSubCatSubTitle.Action = "A";
objEWritSubCatSubTitle.EntryBy = user.UserName;
WritSubCatSubTitleLST.Add(objEWritSubCatSubTitle);
}
else
{
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].WritSubjectID = int.Parse(this.grdWritSubCatSubTitle.SelectedRow.Cells[0].Text);
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].WritSubjectCatID = int.Parse(this.grdWritSubCatSubTitle.SelectedRow.Cells[1].Text);
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].WritSubjectCatTitleID = int.Parse(this.grdWritSubCatSubTitle.SelectedRow.Cells[2].Text);
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].WritSubjectCatSubTitleID = int.Parse(this.grdWritSubCatSubTitle.SelectedRow.Cells[3].Text);
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].WritSubjectCatSubTitleName = this.txtWritSubCatSubTitle.Text;
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].Active = (chkWritSubCatSubTitleActive.Checked == true) ? "Y" : "N";;
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].Action = (this.grdWritSubCatSubTitle.SelectedRow.Cells[6].Text == "A") ? "A" : "E";
WritSubCatSubTitleLST[grdWritSubCatSubTitle.SelectedIndex].EntryBy = user.UserName;
}
grdWritSubCatSubTitle.DataSource = WritSubCatSubTitleLST;
grdWritSubCatSubTitle.DataBind();
WritSubCatLST[this.grdWritCategory.SelectedIndex].WritCategoryTitleLST[this.grdWritSubCatTitle.SelectedIndex].WritCategorySubTitleLST = WritSubCatSubTitleLST;
this.grdWritSubCatSubTitle.SelectedIndex = -1;
this.txtWritSubCatSubTitle.Text = "";
this.chkWritSubCatSubTitleActive.Checked = true;
}
catch (Exception ex)
{
this.lblStatus.Text = "Add Writ Category Sub Title Status";
this.lblStatusMessage.Text = "Writ Subject Category Sub Title can't Be Added To Grid";
this.programmaticModalPopup.Show();
}
}
protected void btnAddWritSubjectCategory_Click(object sender, EventArgs e)
{
if (this.txtWritSubject_RQD.Text == "")
{
this.lblStatus.Text = "Add Writ Category Status";
this.lblStatusMessage.Text = "Writ Subject Can't Be Blank";
this.programmaticModalPopup.Show();
return;
}
if (this.txtWritSubjectCategory.Text == "")
{
this.lblStatus.Text = "Add Writ Category Status";
this.lblStatusMessage.Text = "Writ Category Can't Be Blank";
this.programmaticModalPopup.Show();
return;
}
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
ATTWritSubject WritSubjectOBJ = (ATTWritSubject)Session["TempWritSubject"];
List <ATTWritCategory> WritSubCatLST = WritSubjectOBJ.WritCategoryLST;
try
{
if (grdWritCategory.SelectedIndex == -1)
{
ATTWritCategory objEWritCat = new ATTWritCategory();
objEWritCat.WritSubjectID = 0;
objEWritCat.WritSubjectCatID = 0;
objEWritCat.WritSubjectCatName = this.txtWritSubjectCategory.Text;
objEWritCat.Active = (chkWritSubCatActive.Checked == true) ? "Y" : "N";
objEWritCat.Action = "A";
objEWritCat.EntryBy = user.UserName;
WritSubCatLST.Add(objEWritCat);
}
else
{
WritSubCatLST[grdWritCategory.SelectedIndex].WritSubjectID = int.Parse(this.grdWritCategory.SelectedRow.Cells[0].Text);
WritSubCatLST[grdWritCategory.SelectedIndex].WritSubjectCatID = int.Parse(this.grdWritCategory.SelectedRow.Cells[1].Text);
WritSubCatLST[grdWritCategory.SelectedIndex].WritSubjectCatName = this.txtWritSubjectCategory.Text;
WritSubCatLST[grdWritCategory.SelectedIndex].Active = (chkWritSubCatActive.Checked == true) ? "Y" : "N";;
WritSubCatLST[grdWritCategory.SelectedIndex].Action = (this.grdWritCategory.SelectedRow.Cells[4].Text == "A") ? "A" : "E";
WritSubCatLST[grdWritCategory.SelectedIndex].EntryBy = user.UserName;
}
grdWritCategory.DataSource = WritSubCatLST;
grdWritCategory.DataBind();
this.grdWritCategory.SelectedIndex = -1;
this.grdWritSubCatTitle.SelectedIndex = -1;
this.grdWritSubCatTitle.DataSource = "";
this.grdWritSubCatTitle.DataBind();
this.grdWritSubCatSubTitle.SelectedIndex = -1;
this.grdWritSubCatSubTitle.DataSource = "";
this.grdWritSubCatSubTitle.DataBind();
this.txtWritSubjectCategory.Text = "";
this.chkWritSubCatActive.Checked = true;
}
catch (Exception ex)
{
this.lblStatus.Text = "Add Writ Subject Category";
this.lblStatus.Text = "Writ Subject Category Can't be Added To Grid<BR>" + ex.ToString();
this.programmaticModalPopup.Show();
}
}
