public static List <ATTInvItemsCategory> GetItemCategoryList(int?itemCategoryID, string itemCatActive, string itemSubCatActive, bool ContainsDefault) { List <ATTInvItemsCategory> lstItemCategoryList = new List <ATTInvItemsCategory>(); //List<ATTInvItemsSubCategory> lstItemsSubCategory = BLLInvItemsSubCategory.GetItemSubCategory(itemCategoryID, itemSubCatActive, ContainsDefault); try { foreach (DataRow row in DLLInvItemsCategory.GetItemCategory(itemCategoryID, itemCatActive).Rows) { ATTInvItemsCategory obj = new ATTInvItemsCategory(int.Parse(row["ITEMS_CATEGORY_ID"].ToString()), row["ITEMS_CATEGORY_NAME"].ToString()); obj.LstItemSubCategory = BLLInvItemsSubCategory.GetItemSubCategory(obj.ItemsCategoryID, itemSubCatActive, ContainsDefault); //lstItemsSubCategory.FindAll(delegate(ATTInvItemsSubCategory subCat) { return subCat.ItemsCategoryID == obj.ItemCategoryID; }); lstItemCategoryList.Add(obj); } if (lstItemCategoryList.Count > 0 && ContainsDefault == true) { ATTInvItemsCategory def = new ATTInvItemsCategory(); def.ItemsCategoryID = -1; def.ItemsCategoryName = "----छान्नुहोस----"; lstItemCategoryList.Insert(0, def); } return(lstItemCategoryList); } catch (Exception ex) { throw ex; } }
protected void lstItemCategory_SelectedIndexChanged(object sender, EventArgs e) { chkICActive.Checked = true; chkISCActive.Checked = true; this.grdItemSubCategory.DataSource = ""; grdItemSubCategory.DataBind(); //grdItemSubCategory.SelectedIndex = -1; List <ATTInvItemsCategory> invItemsCategory = (List <ATTInvItemsCategory>)Session["ItemCategory_List"]; ATTInvItemsCategory obj = invItemsCategory[this.lstItemCategory.SelectedIndex].CreateDeepCopy(); Session["ItemCategory"] = obj; this.txtItemCategoryName_Rqd.Text = obj.ItemsCategoryName; string chk = obj.Active; if (chk == "Y") { this.chkICActive.Checked = true; } else { this.chkICActive.Checked = false; } this.grdItemSubCategory.DataSource = obj.LstItemSubCategory; grdItemSubCategory.DataBind(); this.txSubCategory_Rqd.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (Session["Login_User_Detail"] == null) { Response.Redirect("~/MODULES/Login.aspx", true); } ////block if from URL ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); if (!Page.IsPostBack) { LoadItemCategoryList(); Session["ItemCategory"] = new ATTInvItemsCategory();// } /* * if (user.MenuList.ContainsKey("5,5,1") == true) * { * if (!Page.IsPostBack) * { * // load grid; * * } * } * else * Response.Redirect("~/MODULES/Login.aspx", true); * */ }
public static List <ATTInvItemsCategory> GetItemCategoryList(int?itemCategoryID, string active) { List <ATTInvItemsCategory> lstitemCategoryList = new List <ATTInvItemsCategory>(); try { foreach (DataRow row in DLLInvItemsCategory.GetItemCategoryTable(itemCategoryID, active).Rows) { ATTInvItemsCategory itemsCategory = new ATTInvItemsCategory(); itemsCategory.ItemsCategoryID = int.Parse(row["items_category_id"].ToString()); itemsCategory.ItemsCategoryName = row["items_category_name"].ToString(); itemsCategory.Active = row["active"].ToString(); itemsCategory.Action = ""; //itemsCategory.Active = "Y"; //itemsCategory.EntryBy = row["entry_by"].ToString(); itemsCategory.LstItemSubCategory = BLLInvItemsSubCategory.GetItemSubCategoryList(itemsCategory.ItemsCategoryID, itemsCategory.Active); lstitemCategoryList.Add(itemsCategory); } return(lstitemCategoryList); } catch (Exception ex) { throw new Exception("Error occur while selecting Item Category" + ex.Message); } }
public static bool AddUpdateItemCategory(ATTInvItemsCategory itemsCategory) { try { return(DLLInvItemsCategory.AddUpdateItemCategory(itemsCategory)); } catch (Exception ex) { throw new Exception("Error occur while adding and updating ItemCategory" + ex.Message); } }
protected void grdItemSubCategory_SelectedIndexChanged(object sender, EventArgs e) { ATTInvItemsCategory obj = (ATTInvItemsCategory)Session["ItemCategory"]; List <ATTInvItemSubCategory> itemsSubCategory = obj.LstItemSubCategory; string chkd = itemsSubCategory[grdItemSubCategory.SelectedIndex].Active; this.txSubCategory_Rqd.Text = itemsSubCategory[this.grdItemSubCategory.SelectedIndex].ItemsSubCategoryName; chkISCActive.Checked = (chkd == "Y") ? true : false; itemsSubCategory[grdItemSubCategory.SelectedIndex].Action = (itemsSubCategory[grdItemSubCategory.SelectedIndex].Action == "A" ? "A" : "E"); }
private void LoadCategory() { List <ATTInvItemsCategory> lst = BLLInvItemsCategory.GetItemCategoryList(null, null); ATTInvItemsCategory obj = new ATTInvItemsCategory(); obj.ItemsCategoryName = "----छान्नुहोस----"; obj.ItemsCategoryID = -1; lst.Insert(0, obj); ddlCategory.DataSource = lst; ddlCategory.DataBind(); }
void ClearitemCategory() { this.lstItemCategory.SelectedIndex = -1; this.txtItemCategoryName_Rqd.Text = ""; this.chkICActive.Checked = true; this.grdItemSubCategory.SelectedIndex = -1; this.grdItemSubCategory.DataSource = ""; grdItemSubCategory.DataBind(); this.txSubCategory_Rqd.Text = ""; this.chkISCActive.Checked = true; this.lblStatus.Text = ""; LoadItemCategoryList(); Session["ItemCategory"] = new ATTInvItemsCategory(); }
public static bool AddUpdateItemCategory(ATTInvItemsCategory itemsCategory) { string sp = ""; if (itemsCategory.Action == "A") { sp = "sp_inv_add_items_category"; } else if (itemsCategory.Action == "E") { sp = "sp_inv_edit_items_category"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", itemsCategory.ItemsCategoryID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_items_category_name", itemsCategory.ItemsCategoryName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_active", itemsCategory.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by", itemsCategory.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.OAS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, sp, paramArray.ToArray()); itemsCategory.ItemsCategoryID = int.Parse(paramArray[0].Value.ToString()); DLLInvItemSubCategory.AddUpdateDeleteItemSubCategory(itemsCategory.LstItemSubCategory, itemsCategory.ItemsCategoryID, Tran); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
protected void grdItemSubCategory_RowDeleting(object sender, GridViewDeleteEventArgs e) { int i = e.RowIndex; ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"]; List <ATTInvItemSubCategory> itemSubCategory = itemsCategory.LstItemSubCategory; if ((itemSubCategory[i].Action == null) || (itemSubCategory[i].Action == "E")) { itemSubCategory[i].Action = "D"; } else if (itemSubCategory[i].Action == "D") { itemSubCategory[i].Action = "E"; } else if (itemSubCategory[i].Action == "A") { itemSubCategory.RemoveAt(i); } this.grdItemSubCategory.DataSource = itemSubCategory; this.grdItemSubCategory.DataBind(); this.grdItemSubCategory.SelectedIndex = -1; SetGridColor(4, 6, this.grdItemSubCategory); }
private void LoadItemCategory() { try { List <ATTInvItemsCategory> lstItemCategory = BLLInvItemsCategory.GetItemCategoryList(null, null); ATTInvItemsCategory obj = new ATTInvItemsCategory(); obj.ItemsCategoryID = -5; obj.ItemsCategoryName = "--- छान्नुहोस् ---"; lstItemCategory.Insert(0, obj); Session["Item_ItemCategory"] = lstItemCategory; this.DDLItemCategory.DataSource = lstItemCategory; this.DDLItemCategory.DataTextField = "ItemsCategoryName"; this.DDLItemCategory.DataValueField = "ItemsCategoryID"; this.DDLItemCategory.DataBind(); } catch (Exception ex) { this.lblStatus.Text = ex.Message; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (this.txtItemCategoryName_Rqd.Text == "") { this.lblStatusMessage.Text = "Please enter item category name."; this.programmaticModalPopup.Show(); this.lblStatus.Focus(); return; } ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"]; List <ATTInvItemsCategory> lstall = (List <ATTInvItemsCategory>)Session["ItemCategory_List"]; if (lstItemCategory.SelectedIndex == -1) { bool Exists = lstall.Exists( delegate(ATTInvItemsCategory ob) { return(ob.ItemsCategoryName == txtItemCategoryName_Rqd.Text); } ); if (Exists) { this.lblStatusMessage.Text = "Item category name already exists"; this.programmaticModalPopup.Show(); return; } else { int count = 0; foreach (ATTInvItemSubCategory varNew in itemsCategory.LstItemSubCategory) { foreach (ATTInvItemsCategory var in lstall) { int index = var.LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == varNew.ItemsSubCategoryName); } ); if (index >= 0) { count++; } } } if (count > 0) { this.lblStatusMessage.Text = "Already Exists"; this.programmaticModalPopup.Show(); return; } else { itemsCategory.Active = (chkICActive.Checked ? "Y" : "N"); itemsCategory.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; itemsCategory.ItemsCategoryName = txtItemCategoryName_Rqd.Text; if (lstItemCategory.SelectedIndex >= 0) { itemsCategory.Action = "E"; } else { itemsCategory.Action = "A"; } if (BLLInvItemsCategory.AddUpdateItemCategory(itemsCategory)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessage.Text = "Information could not be Saved"; this.programmaticModalPopup.Show(); } } } } else { bool valid = true; int indx = lstall.FindIndex( delegate(ATTInvItemsCategory ob) { return(ob.ItemsCategoryName == txtItemCategoryName_Rqd.Text); } ); if (indx > 0) { if (indx != lstItemCategory.SelectedIndex) { valid = false; } } if (!valid) { this.lblStatusMessage.Text = "Item category name already exists"; this.programmaticModalPopup.Show(); return; } else { int count = 0; foreach (ATTInvItemSubCategory varNew in itemsCategory.LstItemSubCategory) { for (int i = 0; i < lstall.Count; i++) { if (i != lstItemCategory.SelectedIndex) { int index = lstall[i].LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == varNew.ItemsSubCategoryName); } ); if (index >= 0) { count++; } } } } if (count > 0) { this.lblStatusMessage.Text = "Already Exists"; this.programmaticModalPopup.Show(); return; } else { itemsCategory.Active = (chkICActive.Checked ? "Y" : "N"); itemsCategory.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; itemsCategory.ItemsCategoryName = txtItemCategoryName_Rqd.Text; if (lstItemCategory.SelectedIndex >= 0) { itemsCategory.Action = "E"; } else { itemsCategory.Action = "A"; } if (BLLInvItemsCategory.AddUpdateItemCategory(itemsCategory)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessage.Text = "Information could not be Saved"; this.programmaticModalPopup.Show(); } } } } ClearitemCategory(); }
protected void btnAddItemSubCategory_Click(object sender, EventArgs e) { if (this.txSubCategory_Rqd.Text == "") { return; } ////////// ATTInvItemsCategory itemsCategory = (ATTInvItemsCategory)Session["ItemCategory"]; List <ATTInvItemsCategory> lstall = (List <ATTInvItemsCategory>)Session["ItemCategory_List"]; if (lstItemCategory.SelectedIndex == -1) { foreach (ATTInvItemsCategory var in lstall) { int index = var.LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } ); if (index >= 0) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } else { if (grdItemSubCategory.SelectedIndex < 0) { if (itemsCategory.LstItemSubCategory.Exists( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } )) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } } else { int ind = itemsCategory.LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } ); if (ind >= 0) { if (ind != grdItemSubCategory.SelectedIndex) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } } } } } } else { int index = -1; for (int i = 0; i < lstall.Count; i++) { if (i != lstItemCategory.SelectedIndex) { index = lstall[i].LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } ); } if (index >= 0) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } else { if (grdItemSubCategory.SelectedIndex < 0) { if (itemsCategory.LstItemSubCategory.Exists( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } )) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } } else { int ind = itemsCategory.LstItemSubCategory.FindIndex( delegate(ATTInvItemSubCategory ob) { return(ob.ItemsSubCategoryName == txSubCategory_Rqd.Text); } ); if (ind >= 0) { if (ind != grdItemSubCategory.SelectedIndex) { this.lblStatusMessage.Text = "Item SubCategory Already Exists"; this.programmaticModalPopup.Show(); return; } } } } } } ////////// ATTInvItemsCategory obj = (ATTInvItemsCategory)Session["ItemCategory"]; if (grdItemSubCategory.SelectedIndex > -1) { obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].ItemsSubCategoryName = txSubCategory_Rqd.Text; obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Active = (chkISCActive.Checked == true ? "Y" : "N"); obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Action = (obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].Action == "A" ? "A" : "E"); obj.LstItemSubCategory[grdItemSubCategory.SelectedIndex].EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; } else { ATTInvItemSubCategory ob = new ATTInvItemSubCategory(); ob.ItemsSubCategoryName = txSubCategory_Rqd.Text; ob.Active = chkISCActive.Checked == true ? "Y" : "N"; ob.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName; ob.Action = "A"; obj.LstItemSubCategory.Add(ob); this.grdItemSubCategory.SelectedIndex = -1; this.txSubCategory_Rqd.Text = ""; this.chkISCActive.Checked = true; } grdItemSubCategory.DataSource = obj.LstItemSubCategory; grdItemSubCategory.DataBind(); grdItemSubCategory.SelectedIndex = -1; txSubCategory_Rqd.Text = ""; this.chkISCActive.Checked = true; }