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