public ActionResult EditDistributor(int id, string Name, string City, string Address, string NIC, string NTN, string Moblie, string ContactNo, string ReferredBy) { try { string mob = Moblie.Replace("-", ""); mob = mob.Replace(" ", String.Empty); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Distributors" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var query = (from us in db.tblDistributors where us.id == id select us).FirstOrDefault(); if (query != null) { query.Name = Name; query.City = City; query.Address = Address; query.NIC = NIC; query.NTN = NTN; query.Moblie = mob; query.ContactNo = ContactNo; query.ReferredBy = ReferredBy; db.SaveChanges(); var user = (from us in db.tblUsers where us.localID == id && us.type == retailType select us).FirstOrDefault(); if (user != null) { user.userName = mob; db.SaveChanges(); } return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Wholesellers" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var u = (from us in db.tblUsers where us.type == retailType && us.localID == id select us).FirstOrDefault(); if (u != null) { db.tblUsers.Remove(u); db.SaveChanges(); } var data = db.tblWholesellers.Single(x => x.id == id); db.tblWholesellers.Remove(data); db.SaveChanges(); return(Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveLandingPic(string pic) { try { using (linqDBContext db = new linqDBContext()) { var chk = (from us in db.tblItemPictures where us.itemID == 0 select us).FirstOrDefault(); if (chk != null) { chk.picLocation = pic; db.SaveChanges(); } else { tblItemPicture p = new tblItemPicture(); p.itemID = 0; p.picLocation = pic; db.tblItemPictures.Add(p); db.SaveChanges(); } } return(Json(new { status = "success", Data = "Done" }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id, string name, string fName, int supervisor, string mob, string nic, string address) { try { string mobile = mob.Replace("-", ""); mobile = mobile.Replace(" ", String.Empty); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Resellers" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var query = (from us in db.tblResellers where us.id == id select us).FirstOrDefault(); if (query != null) { query.name = name; query.fatherName = fName; query.supervisor = supervisor; query.Mob = mobile; query.NIC = nic; query.address = address; db.SaveChanges(); var user = (from us in db.tblUsers where us.localID == id && us.type == retailType select us).FirstOrDefault(); if (user != null) { user.userName = mobile; db.SaveChanges(); } return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//ADD public ActionResult Add(string cat, string name, string pacA, string pacB) { try { int assignedID = 0; using (linqDBContext db = new linqDBContext()) { Lot lt = new Lot(); lt.mainCatId = Convert.ToInt32(cat); lt.lotName = name; lt.A = Convert.ToInt32(pacA); lt.B = Convert.ToInt32(pacB); db.Lots.Add(lt); db.SaveChanges(); assignedID = lt.id; var chkqry = (from b in dc.Main_Inventory where b.mainCatID == lt.mainCatId select b).FirstOrDefault(); if (chkqry == null) { Main_Inventory mI = new Main_Inventory(); mI.mainCatID = lt.mainCatId; mI.packet_A = lt.A; mI.packet_B = lt.B; dc.Main_Inventory.Add(mI); dc.SaveChanges(); } else { //update main invenrty chkqry.packet_A += lt.A; chkqry.packet_B += lt.B; dc.SaveChanges(); } } return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } catch (ApplicationException m) { return(Json(new { status = "error", Data = m.Message }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddProduct(string code, string name, string fabric, string priceO, string discount, string priceNet, int cat, string mcat, int lotId, string articleId, string desc, string[] picsArr) { try { int assignedID = 0; using (linqDBContext db = new linqDBContext()) { int getCatId = (from a in db.tblMainCategories where a.name == mcat select a.id).FirstOrDefault(); tblItem it = new tblItem(); it.itemCode = code; it.itemName = name; it.fabric = fabric; it.originalPrice = Convert.ToDecimal(priceO); it.discount = Convert.ToDecimal(discount); it.netPrice = Convert.ToDecimal(priceNet); it.subCategory = cat; it.mainCategory = getCatId; it.description = desc; it.tag = ""; it.articleId = articleId; it.lotId = lotId; it.date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.tblItems.Add(it); db.SaveChanges(); assignedID = it.id; if (picsArr != null) { foreach (var item in picsArr) { //var physicalPath = Path.Combine(Server.MapPath(subPath), item); tblItemPicture p = new tblItemPicture(); p.itemID = assignedID; p.picLocation = item; db.tblItemPictures.Add(p); db.SaveChanges(); } } } return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var chk = (from us in db.tblItemsSolds where us.itemID == id select us).FirstOrDefault(); if (chk == null) { var pics = (from us in db.tblItemPictures where us.itemID == id select us).ToList(); if (pics != null) { foreach (var item in pics) { db.tblItemPictures.Remove(item); db.SaveChanges(); } } var data = (from us in db.tblItems where us.id == id select us).FirstOrDefault(); if (data != null) { db.tblItems.Remove(data); db.SaveChanges(); } return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Used in orders!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//ADD public ActionResult Add(string size, int cat) { try { int assignedID = 0; using (linqDBContext db = new linqDBContext()) { size lt = new size(); lt.mainCatID = cat; lt.size1 = size; db.sizes.Add(lt); db.SaveChanges(); assignedID = lt.id; } return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } catch (ApplicationException m) { return(Json(new { status = "error", Data = m.Message }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//DELETE public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var data = db.tblLots.Single(x => x.id == id); tblMainInventry mainInventry = (from us in db.tblMainInventries where us.mainCatId == data.mainCatId select us).FirstOrDefault(); //applying deletion to main inventry first mainInventry.pacA -= data.packets_A; mainInventry.pacB -= data.packets_B; mainInventry.small -= data.small; mainInventry.medium -= data.medium; mainInventry.large -= data.large; mainInventry.xLarge -= data.xLarge; db.tblLots.Remove(data); db.SaveChanges(); return Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet); } } catch (Exception x) { return Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet); } }
public ActionResult Return(int[] arr) { try { using (linqDBContext db = new linqDBContext()) { int invoiceID = 0; decimal priceSum = 0; string code = ""; var data = (from us in db.tblItemsSolds where arr.Contains(us.id) select us).ToList(); if (data != null) { foreach (var item in data) { invoiceID = item.invoiceNum.Value; priceSum += item.price.Value; code += db.tblItems.Where(x => x.id == item.itemID).Select(y => y.itemCode).FirstOrDefault() + " "; //update inv var inv = (from us in db.Inventory_Latest where us.itemId == item.itemID && us.size == item.size && us.network == 3 && us.localID == 0 select us).FirstOrDefault(); if (inv != null) { int qty = Convert.ToInt32(item.quantity); inv.qty += qty; } } //update tblOrders summary var summary = (from us in db.tblOrderSummaries where us.id == invoiceID select us).FirstOrDefault(); if (summary != null) { int cost = Convert.ToInt32(priceSum); summary.netAmount -= cost; summary.totalAmount -= cost; summary.balance -= cost; summary.note += Environment.NewLine + code + " (Returned)"; } //Remove from tblItems Sold db.tblItemsSolds.RemoveRange(data); db.SaveChanges(); } } return(Json(new { status = "success", data = "done" })); } catch (Exception x) { return(Json(new { status = "error", data = x.Message })); } }
public ActionResult UpdateStatus(int id, string status, string dBy, decimal paid, decimal dc) { try { using (linqDBContext db = new linqDBContext()) { var data = db.tblOrderSummaries.Where(m => m.id == id).FirstOrDefault(); if (data != null) { data.status = status; data.deliveryOption = dBy; data.paid = Convert.ToDecimal(paid); data.deliveryCharges = dc; data.totalAmount = data.netAmount + dc; data.balance = data.totalAmount - data.paid; db.SaveChanges(); return(Json(new { status = "success", Data = "Status Updated!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult RemoveImage(int imageID) { try { using (linqDBContext db = new linqDBContext()) { var images = (from us in db.tblItemPictures where us.id == imageID select us).FirstOrDefault(); if (images != null) { db.tblItemPictures.Remove(images); db.SaveChanges(); return(Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "No image found" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult VerifyUser(string num) { try { num = "0" + num.Substring(3, 10); using (linqDBContext db = new linqDBContext()) { var query = (from us in db.tblUsers where us.userName == num select us).FirstOrDefault(); if (query != null) { Session["uType"] = query.type; Session["uID"] = query.id; query.status = "Approved"; db.SaveChanges(); return(Json(new { status = "success", Data = "Verified" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Invalid verification code, please enter correct code." }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveSettings(string share) { try { using (linqDBContext db = new linqDBContext()) { var query = (from us in db.tblShares where us.id == 1 select us).FirstOrDefault(); if (query != null) { query.amount = Convert.ToInt32(share); db.SaveChanges(); } return(Json(new JsonResult() { Data = "success" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateStock(int id, int[] ids, int[] vals, int count) { try { using (linqDBContext db = new linqDBContext()) { for (int i = 0; i < count; i++) { int _id = ids[i]; int _qty = vals[i]; var query = (from us in db.Inventory_Latest where us.id == _id select us).FirstOrDefault(); if (query != null) { query.qty = _qty; } } db.SaveChanges(); return(Json(new { status = "success", Data = "Done" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id, string name) { try { using (linqDBContext db = new linqDBContext()) { var query = (from us in db.tblRetails where us.id == id select us).FirstOrDefault(); if (query != null) { query.name = name; db.SaveChanges(); return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult RemoveFromCart(int id, int uID) { try { string usrID = uID.ToString(); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblCarts join item in db.tblItems on us.itemID equals item.id where us.userMob == usrID && us.id == id select us).FirstOrDefault(); if (q != null) { db.tblCarts.Remove(q); db.SaveChanges(); return(Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = "error", Data = "not-found" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateStock(int id, int small, int medium, int large, int xLarge) { try { using (linqDBContext db = new linqDBContext()) { var data = db.tblItems.Where(m => m.id == id).FirstOrDefault(); if (data != null) { //data.small += small; //data.medium += medium; //data.large += large; //data.xLarge += xLarge; db.SaveChanges(); //Save Stock History --> Later return(Json(new { status = "Success", Data = "Stock Updated!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//EDIT public ActionResult Edit(string id_, string cat, string name, string pacA, string pacB) { try { int catId = Convert.ToInt32(cat); int id = Convert.ToInt32(id_); using (linqDBContext db = new linqDBContext()) { Lot query = (from us in db.Lots where us.id == id select us).FirstOrDefault(); Main_Inventory mainInventry = (from us in db.Main_Inventory where us.mainCatID == catId select us).FirstOrDefault(); if (query != null) { int diffA = Convert.ToInt32(pacA) - query.A.Value; int diffB = Convert.ToInt32(pacB) - query.B.Value; //Applying Changes to main inventry mainInventry.packet_A += diffA; mainInventry.packet_B += diffB; query.lotName = name; query.A = Convert.ToInt32(pacA); query.B = Convert.ToInt32(pacB); db.SaveChanges(); return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//DELETE public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var data = db.Lots.Single(x => x.id == id); //Lot Loose Stock var queryLoose = (from us in db.Lot_Loose_Items where us.lotID == data.id select us).ToList(); if (queryLoose != null) { foreach (var item in queryLoose) { //Update Loose inventory var looseInv = (from us in db.Main_Inventory_Loose where us.mainCatID == data.mainCatId && us.size == item.size select us).FirstOrDefault(); if (looseInv != null) { looseInv.qty -= item.qty; } } } var mainInventry = (from us in db.Main_Inventory where us.mainCatID == data.mainCatId select us).FirstOrDefault(); if (mainInventry != null) { mainInventry.packet_A -= data.A; mainInventry.packet_B -= data.B; } db.Lots.Remove(data); db.SaveChanges(); return(Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var data = db.tblRetails.Single(x => x.id == id); db.tblRetails.Remove(data); db.SaveChanges(); return(Json(new { status = "success", Data = "done" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult RemovePic() { try { using (linqDBContext db = new linqDBContext()) { var chk = (from us in db.tblItemPictures where us.itemID == 0 select us).FirstOrDefault(); if (chk != null) { db.tblItemPictures.Remove(chk); db.SaveChanges(); } } return(Json(new { status = "success", Data = "Done" }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
//EDIT public ActionResult Edit(int id_, string size, int cat) { try { using (linqDBContext db = new linqDBContext()) { size query = (from us in db.sizes where us.id == id_ select us).FirstOrDefault(); if (query != null) { //Calculating difference bw current values and updated values query.size1 = size; query.mainCatID = cat; db.SaveChanges(); return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateCover(int id, string cover) { try { using (linqDBContext db = new linqDBContext()) { var it = (from us in db.tblItems where us.id == id select us).FirstOrDefault(); if (it != null) { it.coverImage = cover; db.SaveChanges(); return(Json(new { status = "success", Data = "Done" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "No item found." }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Add(string name) { try { int assignedID = 0; using (linqDBContext db = new linqDBContext()) { tblRetail it = new tblRetail(); it.name = name; db.tblRetails.Add(it); db.SaveChanges(); assignedID = it.id; } return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(int id, string name, string fName, string mob, string nic, string address) { try { retailType = 0; string mobile = mob.Replace("-", ""); mobile = mobile.Replace(" ", String.Empty); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Supervisors" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var query = (from us in db.tblResellers where us.id == id select us).FirstOrDefault(); if (query != null) { query.name = name; query.fatherName = fName; query.Mob = mobile; query.NIC = nic; query.address = address; db.SaveChanges(); var user = (from us in db.tblUsers where us.localID == id && us.type == retailType select us).FirstOrDefault(); if (user != null) { user.userName = mobile; db.SaveChanges(); } else { Random rn = new Random(); string pwd = rn.Next(1000, 9999).ToString(); tblUser u = new tblUser(); u.userName = mobile; u.status = "Approved"; u.localID = id; u.type = retailType; u.password = pwd; db.tblUsers.Add(u); db.SaveChanges(); } return(Json(new JsonResult() { Data = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResult() { Data = "Not found!" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Add(string name, string fName, string mob, string nic, string address) { try { retailType = 0; int assignedID = 0; string mobile = mob.Replace("-", ""); mobile = mobile.Replace(" ", String.Empty); using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Supervisors" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var chk = (from us in db.tblUsers where us.userName == mob select us).FirstOrDefault(); if (chk != null) { return(Json(new JsonResult() { Data = 0 }, JsonRequestBehavior.AllowGet)); } tblReseller it = new tblReseller(); it.name = name; it.fatherName = fName; //it.supervisor = it.id; it.Mob = mobile; it.NIC = nic; it.address = address; it.isActive = true; it.isSupervisor = true; it.DOA = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.tblResellers.Add(it); db.SaveChanges(); assignedID = it.id; Random rn = new Random(); string pwd = rn.Next(1000, 9999).ToString(); tblUser u = new tblUser(); u.userName = mobile; u.status = "Approved"; u.localID = assignedID; u.type = retailType; u.password = pwd; db.tblUsers.Add(u); db.SaveChanges(); return(Json(new JsonResult() { Data = assignedID }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddToCart(int id, int uID, decimal qty, string size) { try { string usrID = uID.ToString(); decimal quantity = qty; using (linqDBContext db = new linqDBContext()) { var cartQty = (from us in db.tblCarts where us.userMob == usrID && us.itemID == id && us.size == size select us).FirstOrDefault(); if (cartQty != null) { quantity += cartQty.itemQty.Value; } //Availibity var chkAvailibity = (from us in db.Inventory_Latest where us.itemId == id && us.network == 3 && us.localID == 0 && us.size == size select us).FirstOrDefault(); if (quantity > chkAvailibity.qty) { if (chkAvailibity.qty == 0) { return(Json(new { status = "error", Data = size + " size if out of stock." }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Inventory has only " + chkAvailibity.qty + " " + size + " items left." }, JsonRequestBehavior.AllowGet)); } } var q = (from us in db.tblCarts join item in db.tblItems on us.itemID equals item.id where us.userMob == usrID && us.itemID == id && us.size == size select new { us, item }).FirstOrDefault(); if (q != null) { if (qty < 0) { if ((q.us.itemQty == null) || (q.us.itemQty == 1)) { return(Json(new { status = "error", Data = "Cannot remove further." }, JsonRequestBehavior.AllowGet)); } } if (q.us.itemQty != null) { q.us.itemQty += qty; q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value); db.SaveChanges(); } else { q.us.itemQty = qty; q.us.Price = Convert.ToDecimal(q.us.itemQty.Value * q.item.netPrice.Value); db.SaveChanges(); } return(Json(new { status = "success", Data = GetItem(q.us.id, usrID).ToList() }, JsonRequestBehavior.AllowGet)); } else { var itemPrice = (from us in db.tblItems where us.id == id select us.netPrice.Value).FirstOrDefault(); //Add tblCart c = new tblCart(); c.userMob = usrID; c.itemQty = qty; c.itemID = id; c.size = size; c.Price = Convert.ToDecimal(qty * itemPrice); db.tblCarts.Add(c); db.SaveChanges(); return(Json(new { status = "success", Data = GetItem(c.id, usrID).ToList() }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { try { using (linqDBContext db = new linqDBContext()) { var q = (from us in db.tblRetails where us.name == "Supervisors" select us.id).FirstOrDefault(); if (q > 0) { retailType = q; } var chk = (from us in db.tblOrderSummaries where us.userID == id select us).FirstOrDefault(); if (chk == null) { var data = (from us in db.tblResellers where us.id == id select us).FirstOrDefault(); if (data != null) { //Checl users working under var usersWorking = (from us in db.tblResellers where us.supervisor == id select us).FirstOrDefault(); if (usersWorking == null) { //Remove user var user = (from us in db.tblUsers where us.type == retailType && us.localID == id select us).FirstOrDefault(); if (user != null) { db.tblUsers.Remove(user); db.SaveChanges(); } //Remove Reseller db.tblResellers.Remove(data); db.SaveChanges(); return(Json(new { status = "Success", Data = "Supervisor removed successfully!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "error", Data = "Resellers are working under this supervisor!" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = "error", Data = "Not found" }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { status = "error", Data = "Supervisor has data in previous orders" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception x) { return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Checkout(int uID, string name, string address, string mob, string city, string country, string bill, string dc) { using (linqDBContext db = new linqDBContext()) { string userID = uID.ToString(); var cart = (from us in db.tblCarts where us.userMob == userID.ToString() select us).ToList(); if (cart != null) { int orderID = 0; bool invError = false; try //Check inv count { foreach (var item in cart) { var query = (from us in db.tblItems join inv in db.Inventory_Latest on us.id equals inv.itemId where inv.network == 3 && inv.localID == 0 && us.id == item.itemID && inv.size == item.size select inv).FirstOrDefault(); if (item.itemQty > query.qty) { item.itemQty = 0; item.Price = 0; invError = true; } } if (invError) { db.SaveChanges(); return(Json(new { status = "error", Data = "inv" }, JsonRequestBehavior.AllowGet)); } } catch (Exception x) { return(Json(new { status = "error", Data = "Error in checking inventory." }, JsonRequestBehavior.AllowGet)); } try { tblOrderSummary s = new tblOrderSummary(); s.userID = uID; s.firstName = name; s.shippingAddress = address; s.mobile = mob; s.city = city; s.country = country; s.totalAmount = Convert.ToDecimal(bill) + Convert.ToDecimal(dc); s.netAmount = Convert.ToDecimal(bill); s.paid = 0; s.discount = 0; s.balance = s.totalAmount; s.status = "Order Received"; s.deliveryOption = Program.delivery_option; s.deliveryCharges = Convert.ToDecimal(dc); s.payMode = "Cash"; s.note = ""; s.date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); s.time = DateTime.Now; db.tblOrderSummaries.Add(s); db.SaveChanges(); orderID = s.id; } catch (Exception x) { return(Json(new { status = "error", Data = "error in order summary: " + x.Message }, JsonRequestBehavior.AllowGet)); } try { foreach (var item in cart) { tblItemsSold items_sold = new tblItemsSold(); items_sold.invoiceNum = orderID; items_sold.itemID = item.itemID; items_sold.price = item.Price; items_sold.quantity = item.itemQty; items_sold.size = item.size; items_sold.userID = uID; items_sold.date = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.tblItemsSolds.Add(items_sold); db.SaveChanges(); //Update Inventory var query = (from us in db.tblItems join inv in db.Inventory_Latest on us.id equals inv.itemId where inv.network == 3 && inv.localID == 0 && us.id == item.itemID && inv.size == item.size select inv).FirstOrDefault(); if (query != null) { query.qty -= Convert.ToInt32(item.itemQty.Value); db.SaveChanges(); } //Clear Cart db.tblCarts.Remove(item); db.SaveChanges(); } return(Json(new { status = "success", Data = "Order saved." }, JsonRequestBehavior.AllowGet)); } catch (Exception x) { return(Json(new { status = "error", Data = "error in items sold: " + x.Message }, JsonRequestBehavior.AllowGet)); } } return(Json(new { status = "error", Data = "Cart was empty" }, JsonRequestBehavior.AllowGet)); } }