public ActionResult Edit(product_types model) { var obj = db.product_types.FirstOrDefault(x => x.id_product_type == model.id_product_type); obj.name = model.name; db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "AdminCategory")); }
public ActionResult Delete(int id, FormCollection collection) { product_types obj = db.product_types.Find(id); db.product_types.Remove(obj); db.SaveChanges(); return(RedirectToAction("Index", "AdminCategory")); }
public ActionResult AddCategory(product_types model) { if (ModelState.IsValid) { db.product_types.Add(new product_types { name = model.name }); db.SaveChanges(); return(RedirectToAction(actionName: "Index", controllerName: "AdminCategory")); } return(View(model)); }
public IHttpActionResult purchaseProducts(JPurchase purchase) { try { SMS_DBEntities1 db = new SMS_DBEntities1(); var user = db.users.FirstOrDefault(y => y.api_key.Equals(purchase.apiKey)); if (null == user) { return(Ok(-1)); } var shop = db.shops.FirstOrDefault(y => y.shop_id == user.shop_id); var inventory = shop.inventories.ToList(); int i = 1; List <purchase> purchases = new List <purchase>(); try { if (null != db.purchases.FirstOrDefault(y => y.purch_id == purchase.purch_id)) { return(Ok(-1)); } } catch (Exception ex) { } foreach (var product in purchase.products) { var prod_id = product.product_id; var brand_id = -1; var product_type = -1; inventory = shop.inventories.ToList(); if (null == inventory.FirstOrDefault(y => y.product.brand_id == product.brand.brand_id) && null == inventory.FirstOrDefault(y => y.product.brand.brand_name.ToLower().Equals(product.brand.brand_name.ToLower()))) { db.brands.Add(new brand { brand_name = product.brand.brand_name }); db.SaveChanges(); brand_id = db.brands.Where(y => y.brand_name.Equals(product.brand.brand_name)).First(y => y.products.Count == 0).brand_id; } else if (null != inventory.FirstOrDefault(y => y.product.brand.brand_name.ToLower().Equals(product.brand.brand_name.ToLower()))) { brand_id = inventory.FirstOrDefault(y => y.product.brand.brand_name.ToLower().Equals(product.brand.brand_name.ToLower())).product.brand_id; } else if (null != db.brands.FirstOrDefault(y => y.brand_id == product.brand.brand_id) && product.brand.brand_name != null && !product.brand.brand_name.Equals("")) { brand b = db.brands.FirstOrDefault(y => y.brand_id == product.brand.brand_id); b.brand_name = product.brand.brand_name; db.SaveChanges(); brand_id = b.brand_id; } if (null == inventory.FirstOrDefault(y => y.product.product_type == product.product_type.type_id) && null == inventory.FirstOrDefault(y => y.product.product_types.type_name.ToLower().Equals(product.product_type.type_name.ToLower()))) { db.product_types.Add(new product_types { type_name = product.product_type.type_name }); db.SaveChanges(); product_type = db.product_types.Where(y => y.type_name.Equals(product.product_type.type_name)).First(y => y.products.Count == 0).type_id; } else if (null != inventory.FirstOrDefault(y => y.product.product_types.type_name.ToLower().Equals(product.product_type.type_name.ToLower()))) { product_type = inventory.FirstOrDefault(y => y.product.product_types.type_name.ToLower().Equals(product.product_type.type_name.ToLower())).product.product_type; } else if (null != db.product_types.FirstOrDefault(y => y.type_id == product.product_type.type_id) && product.product_type.type_name != null && !product.product_type.type_name.Equals("")) { product_types p = db.product_types.FirstOrDefault(y => y.type_id == product.product_type.type_id); p.type_name = product.product_type.type_name; db.SaveChanges(); product_type = p.type_id; } int msr_unit = -1; if (null == inventory.FirstOrDefault(y => y.product.msrmnt_units.sr_no == product.unit_of_msrmnt.sr_no) && null == inventory.FirstOrDefault(y => y.product.msrmnt_units.description.ToLower().Equals(product.unit_of_msrmnt.description))) { db.msrmnt_units.Add(new msrmnt_units { description = product.unit_of_msrmnt.description }); db.SaveChanges(); msr_unit = db.msrmnt_units.Where(y => y.description.Equals(product.unit_of_msrmnt.description)).First(y => y.products.Count == 0).sr_no; } else if (null != inventory.FirstOrDefault(y => y.product.msrmnt_units.description.ToLower().Equals(product.unit_of_msrmnt.description))) { msr_unit = inventory.FirstOrDefault(y => y.product.msrmnt_units.description.ToLower().Equals(product.unit_of_msrmnt.description)).product.unit_of_msrmnt; } else { var msmnt_unit = db.msrmnt_units.FirstOrDefault(y => y.sr_no.Equals(product.unit_of_msrmnt.sr_no)); msmnt_unit.description = product.unit_of_msrmnt.description; msr_unit = msmnt_unit.sr_no; db.SaveChanges(); } if (null == inventory.FirstOrDefault(y => y.product_id == product.product_id) && null == inventory.FirstOrDefault(y => y.product.product_name.ToLower().Equals(product.product_name.ToLower()))) { db.products.Add(new product { product_name = product.product_name, unit_price = product.unit_price, unit_of_msrmnt = msr_unit, specs = product.specs, brand_id = brand_id, product_type = product_type }); db.SaveChanges(); var pros = db.products.Where(y => y.product_name.ToLower().Equals(product.product_name.ToLower())).First(y => y.inventories.Count == 0); prod_id = pros.product_id; } if (0 != product.product_id) { prod_id = product.product_id; var prod = db.products.First(y => y.product_id == product.product_id); prod.product_name = product.product_name; db.SaveChanges(); } var invObj = inventory.FirstOrDefault(y => y.product_id == prod_id); if (invObj != null) { invObj.prod_quant += product.qty; } else { db.inventories.Add(new inventory { product_id = prod_id, shop_id = shop.shop_id, prod_quant = product.qty, is_brand_active = "Y", is_prod_active = "Y" }); } foreach (var inv in inventory.Where(y => y.product.brand_id == brand_id)) { inv.is_brand_active = "Y"; } if (i == purchase.products.Length) { var isClr = "N"; if (purchase.amount_paid == purchase.total_amount) { isClr = "Y"; } purchases.Add(new purchase { purch_id = purchase.purch_id, prod_id = prod_id, dlr_dtls = purchase.dlr_info, prod_quant = (int)product.qty, pur_date = purchase.purch_dtime.Date, pur_time = purchase.purch_dtime.TimeOfDay, shop_id = shop.shop_id, agent_id = user.user_id, is_pmnt_clr = isClr, total_amt = purchase.total_amount, paid_amt = purchase.amount_paid, is_invoice = "Y" }); } else { purchases.Add(new purchase { purch_id = purchase.purch_id, prod_id = prod_id, prod_quant = (int)product.qty, pur_date = purchase.purch_dtime.Date, pur_time = purchase.purch_dtime.TimeOfDay, shop_id = shop.shop_id, agent_id = user.user_id, is_pmnt_clr = "N", is_invoice = "N" }); } i++; db.SaveChanges(); } foreach (var purchase1 in purchases) { db.purchases.Add(purchase1); } db.SaveChanges(); } catch (Exception ex) { return(Ok(-1)); } finally { } return(Ok(purchase.purch_id)); }