public ActionResult CheckUser(string id)
{
try
{
using (linqDBContext db = new linqDBContext())
{
var query = (from us in db.tblUsers
where us.userName == id
select us).FirstOrDefault();
if (query != null)
{
string formatted = "+92" + id.Substring(1, id.Length - 1);
if (formatted.Length == 13)
{
return(Json(new { status = "success", Data = formatted }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "warning", Data = "Ask administrator to update your number!" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { status = "error", Data = "You're not allowed here!" }, 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));
}
}
//POPULATELOOSE
public ActionResult PopulateLoose(int id)
{
try
{
using (linqDBContext db = new linqDBContext())
{
var mainID = db.Lots.Where(x => x.id == id).Select(y => y.mainCatId.Value).FirstOrDefault();
var query = (from us in db.Lot_Loose_Items
where us.lotID == id
select us).ToList();
if (query.Count > 0)
{
return(Json(new { status = "1", Data = query }, JsonRequestBehavior.AllowGet));
}
else
{
var sQuery = (from us in db.sizes
where us.mainCatID == mainID
select us).ToList();
if (sQuery != null)
{
return(Json(new { status = "2", Data = sQuery }, JsonRequestBehavior.AllowGet));
}
return(Json(new { status = "0", Data = "Not found." }, 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 Populate(int id)
{
try
{
using (linqDBContext db = new linqDBContext())
{
var query = (from us in db.tblResellers
where us.id == id
select us).FirstOrDefault();
if (query != null)
{
return(Json(new JsonResult()
{
Data = query
}, 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 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));
}
}
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 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 JsonResult GetItem(string id)
{
try
{
using (linqDBContext db = new linqDBContext())
{
//sessionIssueId = Convert.ToInt32(Session["sessionIssueID"]);
int lotID = Convert.ToInt32(Session["lotID"]);
var item = db.tblItems.Where(x => x.itemCode.Contains(id) && x.lotId == lotID).FirstOrDefault();
if (item == null)
{
return(Json(new { status = "error", Data = "This item does not belong to the selected lot." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "success", Data = item }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = 0 }, JsonRequestBehavior.AllowGet));
}
}
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 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[] 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 Details()
{
try
{
int a = Convert.ToInt32(Session["invID"]);
if (a == 0)
{
return(RedirectToAction("Index", "Login"));
}
else
{
using (linqDBContext db = new linqDBContext())
{
var data = (from us in db.tblOrderSummaries
join cl in db.tblUsers
on us.userID equals cl.id
where us.id == a
select new { us, cl }).FirstOrDefault();
if (data != null)
{
ViewBag.invNum = a;
ViewBag.name = data.us.firstName;
ViewBag.mob = data.us.mobile;
ViewBag.address = data.us.shippingAddress;
}
}
}
}
catch (Exception x)
{
return(RedirectToAction("Index", "Login"));
}
return(View());
}
//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 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 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 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 Manage()
{
using (linqDBContext db = new linqDBContext())
{
var network = (from us in db.tblSubInventories
select us.networkID).Distinct().ToList();
List <SelectListItem> item = new List <SelectListItem>();
foreach (var itemm in network)
{
var query = (from us in db.tblRetails
where us.id == itemm.Value
select us).FirstOrDefault();
if (query != null)
{
item.Add(new SelectListItem
{
Text = query.name,
Value = query.id.ToString()
});
}
}
ViewBag.network = item;
}
return(View());
}
public ActionResult step02(string fName, string lName, string address, string mob, string city, string country, int bill, int dc)
{
string userID = "0";
userID = Session["uID"].ToString();
Session["fName"] = fName;
Session["address"] = address;
Session["mob"] = mob;
Session["city"] = city;
Session["country"] = country;
Session["bill"] = bill;
Session["dc"] = dc;
ViewBag.dc = dc;
ViewBag.bill = bill;
//Verification Page
string tt = ShopController.GetTotalCount(userID);
string[] arr = tt.Split('-');
ViewBag.count = arr[0];
ViewBag.total = arr[1];
//Session["bill"] = arr[1];
Session["bill-count"] = arr[0];
using (linqDBContext db = new linqDBContext())
{
string content = "";
string sectionsPath = Server.MapPath("~/data/templates/" + "cart-verification" + ".txt");
content = System.IO.File.ReadAllText(sectionsPath);
string cartContent = "";
var cart = (from us in db.tblCarts
join it in db.tblItems
on us.itemID equals it.id
join cat in db.tblCategories
on it.subCategory equals cat.id
where us.userMob == userID
orderby it.id ascending
select new { us, it, cat }).ToList();
if (cart != null)
{
foreach (var item in cart)
{
cartContent += content;
cartContent = cartContent.Replace("#itemNameHere", item.it.itemName + " - " + item.us.size);
cartContent = cartContent.Replace("#itemCatHere", item.cat.name);
cartContent = cartContent.Replace("#itemQtyHere", item.us.itemQty.Value.ToString());
cartContent = cartContent.Replace("#itemPriceHere", "-");
cartContent = cartContent.Replace("#itemUnitPrice", "-");
}
ViewBag.data = cartContent;
}
}
return(View());
}
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));
}
}
//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));
}
}
public ActionResult GetCart(string uID)
{
using (linqDBContext db = new linqDBContext())
{
try
{
var q = (from us in db.tblItems
join c in db.tblCarts on us.id equals c.itemID
where c.userMob == uID
select new { us.id, cartID = c.id, us.itemName, pic = us.coverImage, c.itemQty, us.netPrice, c.userMob, pr = c.Price.Value, size = c.size }).ToList();
if (q != null)
{
return(Json(new { status = "success", Data = q }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "error", Data = "no data found." }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
}
//public ActionResult Edit(int id, string Type)
//{
// try
// {
// using (linqDBContext db = new linqDBContext())
// {
// var query = (from us in db.tblSubInventories
// where us.id == id
// select us).FirstOrDefault();
// if (query != null)
// {
// query. = Type;
// 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 Populate(string id)
{
try
{
using (linqDBContext db = new linqDBContext())
{
int lotid = Convert.ToInt32(Session["sessionlotid"]);
var proID = db.tblItems.Where(x => x.itemCode.Contains(id)).Select(y => y.id).FirstOrDefault();
var query = (from us in db.tblItems
join l in db.tblLots on us.lotId equals l.id
join m in db.tblMainCategories on us.mainCategory equals m.id
where us.lotId == lotid && us.id == proID
select new { id = us.id, lotname = l.lotName, itm = us.itemName, netPrice = us.netPrice, itmCode = us.itemCode, category = m.name }).FirstOrDefault();
if (query != null)
{
return(Json(new JsonResult()
{
Data = query
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResult()
{
Data = "failed"
}, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult LoadData()
{
try
{
Program.createTable("drop table temp_dist");
Program.createTable("DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX) select @cols = STUFF((SELECT ',' + QUOTENAME(size) from Lot_Distributed_Loose group by size order by size FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') set @query = 'SELECT id = IDENTITY(INT, 1, 1), issueId, itemId,' + @cols + ' into temp_dist from ( select issueId, itemId, size, qty from Lot_Distributed_Loose) x pivot ( sum(qty) for size in (' + @cols + ') ) p ' execute(@query);");
Program.createTable("ALTER TABLE temp_dist ADD PRIMARY KEY ( id );");
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Find Order Column
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (linqDBContext abc = new linqDBContext())
{
int issueID = Convert.ToInt32(Session["lid"]);
var v = (from a in abc.vDists
where a.issueId == issueID
orderby a.itemId
select new { id = a.itemId, Code = a.itemCode, PacA = a.pacA, PacB = a.pacB, S = a.S, M = a.M, L = a.L, XL = a.XL, a.XXL, a.XXXL, K_14 = a.K_14, K_16 = a.K_16, K_18 = a.K_18, K_20 = a.K_20, K_22 = a.K_22, K_24 = a.K_24, K_26 = a.K_26, K_28 = a.K_28, _28 = a.C28, _30 = a.C30, _32 = a.C32, _34 = a.C34, _36 = a.C36, _38 = a.C38, _40 = a.C40, _42 = a.C42, _44 = a.C44 });
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
if (!string.IsNullOrEmpty(searchValue))
{
v = v.Where(m => m.Code.Contains(searchValue));
}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
var dt = data;
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
//Load DATA
public ActionResult LoadData()
{
int utype = Convert.ToInt32(Session["uType"]);
int uId = Convert.ToInt32(Session["uID"]);
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Find Order Column
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (linqDBContext abc = new linqDBContext())
{
//dc.Configuration.LazyLoadingEnabled = false; // if your table is relational, contain foreign key
var v = (from a in abc.tblIssues
join c in abc.issuedRetailers on a.issuedRetailId equals c.Id
join b in abc.tblRetails on c.retailId equals b.id
join d in abc.tblLots on a.lotId equals d.id
select new { id = a.id, type = b.name, name = c.localName, lot = d.lotName, pacA = a.packetA, pacB = a.packetB, small = a.small, med = a.medium, large = a.large, xlarge = a.xLarge, issueDate = a.issueDate.Value.Day + "/" + a.issueDate.Value.Month + "/" + a.issueDate.Value.Year, isFromReturn = a.isFromReturn });
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
//if (!string.IsNullOrEmpty(searchValue))
//{
// v = v.Where(m => m.lot.Contains(searchValue) ||
// m.id.ToString() == searchValue || m.Qnty.ToString() == searchValue);
//}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
var dt = data;
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception x)
{
throw;
}
}
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));
}
}
public ActionResult LoadInvResellers()
{
try
{
var netID = (from us in dc.vInvs
where us.networkID == 3
select us.issuedRetailId).FirstOrDefault();
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Find Order Column
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (linqDBContext abc = new linqDBContext())
{
//dc.Configuration.LazyLoadingEnabled = false; // if your table is relational, contain foreign key
var v = (from a in dc.tblSubInventories
join item in dc.tblItems
on a.itemId equals item.id
where a.issueRetailId == netID
select new { a.id, code = item.itemCode, name = item.itemName, S = a.small, M = a.medium, L = a.large, XL = a.xLarge });
//SORT
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
if (!string.IsNullOrEmpty(searchValue))
{
v = v.Where(m => m.name.Contains(searchValue) ||
m.code == searchValue);
}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
var dt = data;
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult LoadData()
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Find Order Column
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (linqDBContext abc = new linqDBContext())
{
int sessionIssueId = Convert.ToInt32(Session["sessionIssueID"]);
var v = (from a in abc.tblsubInventoryDetails where a.issueId == sessionIssueId
join d in abc.tblIssues on a.issueId equals d.id
join c in abc.tblItems on a.itemId equals c.id
select new { id = a.id, itemCode = c.itemCode, pacA = a.packetA, pacB = a.packetB, small = a.small, med = a.medium, large = a.large, xlarge = a.xLarge });
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
if (!string.IsNullOrEmpty(searchValue))
{
v = v.Where(m => m.itemCode.Contains(searchValue));
}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
var dt = data;
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult ResellersInvTotal(int netID)
{
using (linqDBContext db = new linqDBContext())
{
string inv = "";
try
{
var v = (from a in dc.tblSubInventories
where a.networkID == netID
select a.small).Sum();
inv = "S = " + v + Environment.NewLine;
}
catch (Exception x)
{
}
try
{
var v = (from a in dc.tblSubInventories
where a.networkID == netID
select a.medium).Sum();
inv += "M = " + v + Environment.NewLine;
}
catch (Exception x)
{
}
try
{
var v = (from a in dc.tblSubInventories
where a.networkID == netID
select a.large).Sum();
inv += "L = " + v + Environment.NewLine;
}
catch (Exception x)
{
}
try
{
var v = (from a in dc.tblSubInventories
where a.networkID == netID
select a.xLarge).Sum();
inv += "XL = " + v + Environment.NewLine;
}
catch (Exception x)
{
}
return(Json(new { status = "success", Data = inv }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult LoadInvData()
{
try
{
Program.createTable("drop table temp_inv");
Program.createTable("DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX) select @cols = STUFF((SELECT ',' + QUOTENAME(size) from Inventory_Latest group by size order by size FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') set @query = 'SELECT id = IDENTITY(INT, 1, 1), itemId,' + @cols + ' into temp_inv from ( select itemId, qty, size from Inventory_Latest where network = 3 and localID = 0) x pivot ( sum(qty) for size in (' + @cols + ') ) p ' execute(@query);");
Program.createTable("ALTER TABLE temp_inv ADD PRIMARY KEY ( id );");
//var netID = (from us in dc.vInvs
// where us.networkID == 3
// select us.issuedRetailId).FirstOrDefault();
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Find Order Column
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (linqDBContext abc = new linqDBContext())
{
//dc.Configuration.LazyLoadingEnabled = false; // if your table is relational, contain foreign key
var v = (from a in dc.temp_inv
join item in dc.tblItems
on a.itemId equals item.id
orderby a.itemId
select new { id = a.itemId, Code = item.itemCode, S = a.S, M = a.M, L = a.L, XL = a.XL, a.XXL, a.XXXL, K_14 = a.K_14, K_16 = a.K_16, K_18 = a.K_18, K_20 = a.K_20, K_22 = a.K_22, K_24 = a.K_24, K_26 = a.K_26, K_28 = a.K_28, _28 = a.C28, _30 = a.C30, _32 = a.C32, _34 = a.C34, _36 = a.C36, _38 = a.C38, _40 = a.C40, _42 = a.C42, _44 = a.C44 });
//Search
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
if (!string.IsNullOrEmpty(searchValue))
{
v = v.Where(m => m.Code.Contains(searchValue));
}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
var dt = data;
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
