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));
}
}
