internal int InsertGroup(Inv_ProductGroup groupObj) { try { _context.Inv_ProductGroup.AddObject(groupObj); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal Inv_ProductGroup GetConstructionId(string constructionName) { try { Inv_ProductGroup construction = (from p in _Context.Inv_ProductGroup where p.GroupName == constructionName select p).FirstOrDefault(); return(construction); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
internal int UpdateGroup(int groupId, Inv_ProductGroup groupObj) { try { Inv_ProductGroup grpObj = _context.Inv_ProductGroup.First(x => x.GroupId == groupId); grpObj.GroupName = groupObj.GroupName; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
protected void constructionSearchTextBox_TextChanged(object sender, EventArgs e) { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; Guid createUser = ((SessionUser)Session["SessionUser"]).UserId; string constructionName = constructionSearchTextBox.Text; Inv_ProductGroup aInv_ProductGroup = new Inv_ProductGroup(); aInv_ProductGroup = aYarnCountDeterminationBLL.GetConstructionId(constructionName); int constructionId = aInv_ProductGroup.GroupId; List <YarnDeterminationShowRepo> aYarnDeterminationShowRepo = aYarnCountDeterminationBLL.GetAllInformationOfGridViewByConstruction(OCODE, constructionId, createUser); YarnDeterminationGridView.DataSource = aYarnDeterminationShowRepo; YarnDeterminationGridView.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Inv_ProductGroup groupObj = new Inv_ProductGroup(); Inv_Product productObj = new Inv_Product(); Inv_Unit _unitObj = new Inv_Unit(); Inv_ProductType _ProductType = new Inv_ProductType(); lblMessage.Text = ""; #region //temGroup int grpID = 0; if (chkItemGroup.Checked == true) { groupObj.GroupName = txtItemGroup.Text; groupObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; int Count = (from gplq in _context.Inv_ProductGroup join pn in _context.Inv_Product on gplq.GroupId equals pn.GroupId where gplq.GroupName == txtItemGroup.Text select gplq.GroupId).Count(); if (Count != 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Group Already Exists!')", true); return; } else { int result = productBll.InsertGroup(groupObj); grpID = result; } productObj.GroupId = Convert.ToInt32(grpID.ToString()); } else { productObj.GroupId = Convert.ToInt32(ddlGroupName.SelectedValue); } #endregion if (chkItemName.Checked == true) { productObj.ProductName = txtProductName.Text; } else { productObj.ProductName = ddlItemName.SelectedItem.Text; } if (chkColorBrand.Checked == true) { productObj.Brand = txtBrand.Text; } else { productObj.Brand = ddlColorBrand.SelectedItem.Text; } if (chkStyleSize.Checked == true) { productObj.StyleAndSize = txtStyleSize.Text; } else { productObj.StyleAndSize = ddlStyleSize.SelectedItem.Text; } #region Unit int unID = 0; if (chkUnit.Checked == true) { _unitObj.UnitName = txtUnit.Text; _unitObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; int Count = (from un in _context.Inv_Unit join pn in _context.Inv_Product on un.UnitId equals pn.UnitId where un.UnitName == txtUnit.Text select un.UnitId).Count(); if (Count != 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Unit Already Exists!')", true); return; } else { int result = productBll.InsertUnit(_unitObj); unID = result; } productObj.UnitId = Convert.ToInt32(unID.ToString()); } else { productObj.UnitId = Convert.ToInt32(ddlUnit.SelectedValue); } #endregion #region Product Type int ptId = 0; if (chktemType.Checked == true) { _ProductType.ProductType = txtItemType.Text; _ProductType.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString(); _ProductType.EditUser = ((SessionUser)Session["SessionUser"]).UserId; _ProductType.EditDate = DateTime.Now; int Count = (from un in _context.Inv_ProductType join pn in _context.Inv_Product on un.ProductTypeId equals pn.ProductTypeId where un.ProductType == txtItemType.Text select un.ProductTypeId).Count(); if (Count != 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Type Already Exists!')", true); return; } else { int result = productBll.InsertProductType(_ProductType); ptId = result; } productObj.ProductTypeId = Convert.ToInt32(ptId.ToString()); } else { productObj.ProductTypeId = Convert.ToInt32(ddlItemType.SelectedValue); } #endregion productObj.ReOrderQty = Convert.ToDouble(txtReorder.Text); //productObj.ProductType = ddlAssetType.SelectedItem.Text.Trim(); if (btnSubmit.Text == "Submit") { int Productcount = (from prod in _context.Inv_Product where prod.ProductName == productObj.ProductName && prod.Brand == productObj.Brand && prod.StyleAndSize == productObj.StyleAndSize select prod.ProductId).Count(); if (Productcount != 0) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Item Name Already Exists!')", true); return; } if (Productcount == 0) { productObj.EditDate = DateTime.Now; productObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; productObj.OCode = ((SessionUser)Session["SessionUser"]).OCode.ToString(); int result = productBll.InsertProduct(productObj); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saving Failure')", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exist')", true); txtProductName.Text = ""; txtProductName.Focus(); } } else { int productId = Convert.ToInt16(hdfProductID.Value); int result = productBll.UpdateProduct(productObj, productId); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating failure')", true); } } GetProductInfo(); GetAllGroup(); ClearAllControl(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int UpdateGroup(Inv_ProductGroup groupObj, int groupId) { return(groupDal.UpdateGroup(groupId, groupObj)); }
internal int InsertGroup(Inv_ProductGroup groupObj) { return(groupDal.InsertGroup(groupObj)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Inv_ProductGroup groupObj = new Inv_ProductGroup(); groupObj.GroupName = txtGroupName.Text; //if (groupBll.GetGroupByName(groupObj.GroupName) != null) //{ // lblMessage.Text = "Data Already in the List"; // lblMessage.ForeColor = System.Drawing.Color.Red; // txtGroupName.Text = ""; // return; //} int Groupcount = (from grp in _context.Inv_ProductGroup where grp.GroupName == groupObj.GroupName select grp.GroupId).Count(); if (Groupcount == 0) { if (btnSubmit.Text == "Submit") { //groupObj.EditUser = Guid.Parse("a376708d-757f-4777-bd05-bfc89b6971ce"); groupObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; int result = groupBll.InsertGroup(groupObj); if (result == 1) { // lblMessage.Text = "Data Saved Successfully"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } else { // lblMessage.Text = "Data Saving Failure"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saving Failure')", true); } } else { int groupId = Convert.ToInt32(hdfProductGroupID.Value); int result = groupBll.UpdateGroup(groupObj, groupId); if (result == 1) { // lblMessage.Text = "Data Updated Successfully"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true); } else { // lblMessage.Text = "Data Updating failure"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating failure')", true); } } GetAllProductGroup(); txtGroupName.Text = ""; txtGroupName.Focus(); btnSubmit.Text = "Submit"; } else { //lblMessage.Text = "Data Already Exist"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exist')", true); txtGroupName.Text = ""; txtGroupName.Focus(); btnSubmit.Text = "Submit"; } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }