public async Task <IActionResult> Edit(string id, [Bind("StyleCode,Pairs,BrandId,Quantity,CatId,ProdQuality,CertifyId,ProdId,GoldTypeId,GoldWt,StoneWt,NetGold,WstgPer,Wstg,TotGrossWt,GoldRate,GoldAmt,GoldMaking,StoneMaking,OtherMaking,TotMaking,Mrp")] ItemMst itemMst)
{
if (id != itemMst.StyleCode)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(itemMst);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemMstExists(itemMst.StyleCode))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BrandId"] = new SelectList(_context.BrandMst, "BrandId", "BrandId", itemMst.BrandId);
ViewData["CatId"] = new SelectList(_context.CatMst, "CatId", "CatId", itemMst.CatId);
ViewData["CertifyId"] = new SelectList(_context.CertifyMst, "CertifyId", "CertifyId", itemMst.CertifyId);
ViewData["GoldTypeId"] = new SelectList(_context.GoldKrtMst, "GoldTypeId", "GoldTypeId", itemMst.GoldTypeId);
ViewData["ProdId"] = new SelectList(_context.ProdMst, "ProdId", "ProdId", itemMst.ProdId);
return(View(itemMst));
}
public ActionResult DeleteConfirmed(string id)
{
ItemMst itemMst = db.ItemMsts.Find(id);
db.ItemMsts.Remove(itemMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//Item page for details of particular product
public ActionResult ItemDetails(string id)
{
ItemMst item = _context.ItemMsts.Where(i => i.itemCode.Equals(id)).FirstOrDefault();
if (item == null || id == null)
{
return(RedirectToAction("ErrorPage"));
}
ViewBag.RelatedItem = _context.ItemMsts.Where(i => i.brandId == item.brandId).ToList();
ViewBag.CmtList = _context.CommentMsts.OrderByDescending(c => c.cmtId).ToList();
return(View(item));
}
public ActionResult Edit([Bind(Include = "itemCode,brandId,catId,certificateId,prodId,dimId,goldId,stoneId,itemName,itemDescription,itemImg,pairs,dimQty,dimTot,stoneQty,stoneTot,goldWt,goldTot,wstgPer,wstg,goldMaking,stoneMaking,otherMaking,totMaking,MRP")] ItemMst itemMst, HttpPostedFileBase[] files, bool itemStatus)
{
if (ModelState.IsValid)
{
int index = 0;
if (files[0] == null)
{
ViewBag.brandId = new SelectList(db.BrandMsts, "brandId", "brandType", itemMst.brandId);
ViewBag.catId = new SelectList(db.CategoryMsts, "catId", "catName", itemMst.catId);
ViewBag.certificateId = new SelectList(db.CertificateMsts, "certificateId", "certificateType", itemMst.certificateId);
ViewBag.dimId = new SelectList(db.DimInfoMsts, "dimId", "dimShape", itemMst.dimId);
ViewBag.goldId = new SelectList(db.GoldInfoMsts, "goldId", "goldType", itemMst.goldId);
ViewBag.prodId = new SelectList(db.ProductMsts, "prodId", "prodType", itemMst.prodId);
ViewBag.stoneId = new SelectList(db.StoneInfoMsts, "stoneId", "stoneShape", itemMst.stoneId);
return(View(itemMst));
}
foreach (HttpPostedFileBase file in files)
{
index++;
//Checking file is available to save.
if (file != null)
{
if (files.Length != index)
{
itemMst.itemImg += file.FileName + ",";
}
else
{
itemMst.itemImg += file.FileName;
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/assets/image/") + InputFileName);
//Save file to server folder
file.SaveAs(ServerSavePath);
}
}
itemMst.itemStatus = itemStatus;
itemMst.created_at = DateTime.Now;
db.Entry(itemMst).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.brandId = new SelectList(db.BrandMsts, "brandId", "brandType", itemMst.brandId);
ViewBag.catId = new SelectList(db.CategoryMsts, "catId", "catName", itemMst.catId);
ViewBag.certificateId = new SelectList(db.CertificateMsts, "certificateId", "certificateType", itemMst.certificateId);
ViewBag.dimId = new SelectList(db.DimInfoMsts, "dimId", "dimShape", itemMst.dimId);
ViewBag.goldId = new SelectList(db.GoldInfoMsts, "goldId", "goldType", itemMst.goldId);
ViewBag.prodId = new SelectList(db.ProductMsts, "prodId", "prodType", itemMst.prodId);
ViewBag.stoneId = new SelectList(db.StoneInfoMsts, "stoneId", "stoneShape", itemMst.stoneId);
return(View(itemMst));
}
// GET: Admin/ItemMsts/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ItemMst itemMst = db.ItemMsts.Find(id);
if (itemMst == null)
{
return(HttpNotFound());
}
return(View(itemMst));
}
public async Task <IActionResult> Create([Bind("StyleCode,Pairs,BrandId,Quantity,CatId,ProdQuality,CertifyId,ProdId,GoldTypeId,GoldWt,StoneWt,NetGold,WstgPer,Wstg,TotGrossWt,GoldRate,GoldAmt,GoldMaking,StoneMaking,OtherMaking,TotMaking,Mrp")] ItemMst itemMst)
{
if (ModelState.IsValid)
{
_context.Add(itemMst);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BrandId"] = new SelectList(_context.BrandMst, "BrandId", "BrandId", itemMst.BrandId);
ViewData["CatId"] = new SelectList(_context.CatMst, "CatId", "CatId", itemMst.CatId);
ViewData["CertifyId"] = new SelectList(_context.CertifyMst, "CertifyId", "CertifyId", itemMst.CertifyId);
ViewData["GoldTypeId"] = new SelectList(_context.GoldKrtMst, "GoldTypeId", "GoldTypeId", itemMst.GoldTypeId);
ViewData["ProdId"] = new SelectList(_context.ProdMst, "ProdId", "ProdId", itemMst.ProdId);
return(View(itemMst));
}
public ActionResult ProductDetail(string id)
{
if (id == null)
{
return(View("Error"));
}
ItemMst itemMst = db.ItemMsts.Find(id);
if (itemMst == null)
{
return(View("Error"));
}
ViewBag.RelationItems = db.ItemMsts.Where(i => i.SalePrice >= (itemMst.SalePrice - 50.0) && i.SalePrice <= (itemMst.SalePrice + 100.0)).ToList();
return(View(itemMst));
}
public ActionResult Edit(ItemMst itemMst)
{
if (ModelState.IsValid)
{
db.Entry(itemMst).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BrandId = new SelectList(db.BrandMsts, "BrandId", "BrandType", itemMst.BrandId);
ViewBag.CatId = new SelectList(db.CatMsts, "CatId", "CatName", itemMst.CatId);
ViewBag.CertifyId = new SelectList(db.CertifyMsts, "CertifyId", "CertifyType", itemMst.CertifyId);
ViewBag.StyleCode = new SelectList(db.DimMsts, "StyleCode", "DimQltyId", itemMst.StyleCode);
ViewBag.GoldTypeId = new SelectList(db.GoldKrts, "GoldTypeId", "GoldCrt", itemMst.GoldTypeId);
ViewBag.JewelleryId = new SelectList(db.JewelTypeMsts, "JewelleryId", "JewelleryType", itemMst.JewelleryId);
ViewBag.ProdId = new SelectList(db.ProdMsts, "ProdId", "ProdType", itemMst.ProdId);
ViewBag.StyleCode = new SelectList(db.StoneMsts, "StyleCode", "StoneQltyId", itemMst.StyleCode);
return(View(itemMst));
}
// GET: Admin/ItemMsts/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ItemMst itemMst = db.ItemMsts.Find(id);
if (itemMst == null)
{
return(HttpNotFound());
}
ViewBag.brandId = new SelectList(db.BrandMsts, "brandId", "brandType", itemMst.brandId);
ViewBag.catId = new SelectList(db.CategoryMsts, "catId", "catName", itemMst.catId);
ViewBag.certificateId = new SelectList(db.CertificateMsts, "certificateId", "certificateType", itemMst.certificateId);
ViewBag.dimId = new SelectList(db.DimInfoMsts, "dimId", "dimShape", itemMst.dimId);
ViewBag.goldId = new SelectList(db.GoldInfoMsts, "goldId", "goldType", itemMst.goldId);
ViewBag.prodId = new SelectList(db.ProductMsts, "prodId", "prodType", itemMst.prodId);
ViewBag.stoneId = new SelectList(db.StoneInfoMsts, "stoneId", "stoneShape", itemMst.stoneId);
return(View(itemMst));
}
// GET: Admin/ItemMsts/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ItemMst itemMst = db.ItemMsts.Find(id);
if (itemMst == null)
{
return(HttpNotFound());
}
ViewBag.BrandId = new SelectList(db.BrandMsts, "BrandId", "BrandType", itemMst.BrandId);
ViewBag.CatId = new SelectList(db.CatMsts, "CatId", "CatName", itemMst.CatId);
ViewBag.CertifyId = new SelectList(db.CertifyMsts, "CertifyId", "CertifyType", itemMst.CertifyId);
ViewBag.StyleCode = new SelectList(db.DimMsts, "StyleCode", "DimQltyId", itemMst.StyleCode);
ViewBag.GoldTypeId = new SelectList(db.GoldKrts, "GoldTypeId", "GoldCrt", itemMst.GoldTypeId);
ViewBag.JewelleryId = new SelectList(db.JewelTypeMsts, "JewelleryId", "JewelleryType", itemMst.JewelleryId);
ViewBag.ProdId = new SelectList(db.ProdMsts, "ProdId", "ProdType", itemMst.ProdId);
ViewBag.StyleCode = new SelectList(db.StoneMsts, "StyleCode", "StoneQltyId", itemMst.StyleCode);
return(View(itemMst));
}
public ActionResult Create(ItemMst itemMst, string StoneQltyId, string DimQltyId, string DimSubTypeId)
{
itemMst.StyleCode = "item" + Guid.NewGuid().ToString().GetHashCode().ToString("x");
//itemMst.StoneMst.StoneQltyId = StoneQltyId;
//itemMst.DimMst.DimQltyId = DimQltyId;
//itemMst.DimMst.DimSubTypeId = DimSubTypeId;
if (ModelState.IsValid)
{
db.ItemMsts.Add(itemMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BrandId = new SelectList(db.BrandMsts, "BrandId", "BrandType", itemMst.BrandId);
ViewBag.CatId = new SelectList(db.CatMsts, "CatId", "CatName", itemMst.CatId);
ViewBag.CertifyId = new SelectList(db.CertifyMsts, "CertifyId", "CertifyType", itemMst.CertifyId);
ViewBag.GoldTypeId = new SelectList(db.GoldKrts, "GoldTypeId", "GoldCrt", itemMst.GoldTypeId);
ViewBag.JewelleryId = new SelectList(db.JewelTypeMsts, "JewelleryId", "JewelleryType", itemMst.JewelleryId);
ViewBag.ProdId = new SelectList(db.ProdMsts, "ProdId", "ProdType", itemMst.ProdId);
//ViewBag.StyleCode = new SelectList(db.StoneMsts, "StyleCode", "StoneQltyId", itemMst.StyleCode);
return(View(itemMst));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtItemName.Text.Length == 0)
{
MessageBox.Show("Kindly enter item name.");
txtItemName.Focus();
return;
}
if (cmbTax.Text.Length == 0)
{
MessageBox.Show("Kindly select tax.");
cmbTax.Focus();
return;
}
cmbTax.Tag = dbx.TaxMsts.Where(u => u.TaxName == cmbTax.Text.Trim()).Select(s => s.TaxId).FirstOrDefault();
if (mPkValue == 0)
{
ItemMst objitm = new ItemMst();
objitm.ItemName = txtItemName.Text;
objitm.ItemCode = txtItemCode.Text;
objitm.Unit = cmbUnit.Text;
objitm.ItemDesc = txtItemDesc.Text;
objitm.TaxId = Convert.ToInt32(cmbTax.Tag);
objitm.IGSTPer = AppFun.ToDecimal(txtIGST.Text);
objitm.CGSTPer = AppFun.ToDecimal(txtCGST.Text);
objitm.SGSTPer = AppFun.ToDecimal(txtSGST.Text);
objitm.PurchasePrice = AppFun.ToDecimal(txtPurchasePrice.Text);
objitm.SalePrice = AppFun.ToDecimal(txtSalePrice.Text);
objitm.HSNCode = txtHSNCode.Text;
dbx.ItemMsts.Add(objitm);
dbx.SaveChanges();
MessageBox.Show("Item detail saved..");
}
else
{
var objitm = dbx.ItemMsts.Where(u => u.ItemId == mPkValue).First();
if (objitm != null)
{
objitm.ItemName = txtItemName.Text;
objitm.ItemCode = txtItemCode.Text;
objitm.Unit = cmbUnit.Text;
objitm.ItemDesc = txtItemDesc.Text;
objitm.TaxId = Convert.ToInt32(cmbTax.Tag);
objitm.IGSTPer = Convert.ToDecimal(txtIGST.Text);
objitm.CGSTPer = Convert.ToDecimal(txtCGST.Text);
objitm.SGSTPer = Convert.ToDecimal(txtSGST.Text);
objitm.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
objitm.SalePrice = Convert.ToDecimal(txtSalePrice.Text);
objitm.HSNCode = txtHSNCode.Text;
dbx.SaveChanges();
MessageBox.Show("Item detail updated..");
}
}
var lqryu = dbx.UnitMsts.Where(u => u.UnitName == cmbUnit.Text.Trim());
if (lqryu.Count() == 0)
{
UnitMst objumt = new UnitMst();
objumt.UnitName = cmbUnit.Text;
dbx.UnitMsts.Add(objumt);
dbx.SaveChanges();
HelperClass.bCombBox_Unit(cmbUnit);
}
ClearControls();
}
