public ActionResult DeleteConfirmed(int id) { Inv_ProductType inv_producttype = db.Inv_ProductType.Find(id); db.Inv_ProductType.Remove(inv_producttype); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Inv_ProductTypeId,ProductTypeName,ProductTypeCode,Note,CreatedDate,UpdateDate,IsActive,IsDeleted,UserId")] Inv_ProductType inv_producttype) { if (ModelState.IsValid) { db.Entry(inv_producttype).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inv_producttype)); }
internal int InsertProductType(Inv_ProductType _ProductType) { try { _context.Inv_ProductType.AddObject(_ProductType); _context.SaveChanges(); return(_ProductType.ProductTypeId); } catch (Exception ex) { throw ex; } }
// GET: /ProductType/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Inv_ProductType inv_producttype = db.Inv_ProductType.Find(id); if (inv_producttype == null) { return(HttpNotFound()); } return(View(inv_producttype)); }
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 InsertProductType(Inv_ProductType _ProductType) { return(productDal.InsertProductType(_ProductType)); }