コード例 #1
0
        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));
            }
        }
コード例 #2
0
        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));
            }
        }
コード例 #3
0
        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));
            }
        }
コード例 #4
0
        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));
            }
        }
コード例 #5
0
        //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));
            }
        }
コード例 #6
0
        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));
            }
        }
コード例 #7
0
        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));
            }
        }
コード例 #8
0
        //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));
            }
        }
コード例 #9
0
        //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);
            }
        }
コード例 #10
0
        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 }));
            }
        }
コード例 #11
0
        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));
            }
        }
コード例 #12
0
 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));
     }
 }
コード例 #13
0
 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));
     }
 }
コード例 #14
0
 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));
     }
 }
コード例 #15
0
        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));
            }
        }
コード例 #16
0
        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));
            }
        }
コード例 #17
0
        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));
            }
        }
コード例 #18
0
        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));
            }
        }
コード例 #19
0
        //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));
            }
        }
コード例 #20
0
        //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));
            }
        }
コード例 #21
0
 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));
     }
 }
コード例 #22
0
        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));
            }
        }
コード例 #23
0
        //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));
            }
        }
コード例 #24
0
 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));
     }
 }
コード例 #25
0
        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));
            }
        }
コード例 #26
0
        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));
            }
        }
コード例 #27
0
        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));
            }
        }
コード例 #28
0
        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));
            }
        }
コード例 #29
0
        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));
            }
        }
コード例 #30
0
        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));
            }
        }