/// <summary> /// Add supplier carton details /// </summary> /// <param name="supplierCarton"></param> /// <returns></returns> public JsonResult AddSupplierCartoonDetails(SupplierCartoon supplierCartoon) { SupplierCartoon data = new SupplierCartoon(); try { using (var db = new ArityEntities()) { data.CartoonBM = supplierCartoon.CartoonBM; data.CartoonNumber = supplierCartoon.CartoonNumber; data.CartoonSize = supplierCartoon.CartoonSize; data.CreatedDate = DateTime.UtcNow; data.GrossWeight = supplierCartoon.GrossWeight; data.ModifiedDate = DateTime.UtcNow; data.NetWeight = supplierCartoon.NetWeight; data.PcsPerCartoon = supplierCartoon.PcsPerCartoon; data.Status = supplierCartoon.Status; data.SupplierAssignedMapId = supplierCartoon.SupplierAssignedMapId; data.TotalCartoons = supplierCartoon.TotalCartoons; data.TotalGrossWeight = supplierCartoon.TotalGrossWeight; data.TotalNetWeight = supplierCartoon.TotalNetWeight; db.SupplierCartoons.Add(data); db.SaveChanges(); } return(Json(new { data = data }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }
public ActionResult Create(int?Id) { try { Product product = new Product(); ArityEntities dataContext = new ArityEntities(); int[] parentIds = null; int[] supplierIds = null; product = dataContext.Products.Where(x => x.Id == Id).FirstOrDefault(); if (product != null) { parentIds = !string.IsNullOrWhiteSpace(product.ParentIds) ? Array.ConvertAll(product.ParentIds.Split(','), int.Parse) : null; supplierIds = !string.IsNullOrWhiteSpace(product.Suppliers) ? Array.ConvertAll(product.Suppliers.Split(','), int.Parse) : null; } ViewBag.productList = product == null ? new MultiSelectList(dataContext.Products.Where(x => x.Parent_Id == 0 && x.IsActive == true).ToList(), "Id", "English_Name") : new MultiSelectList(dataContext.Products.Where(x => x.Parent_Id == 0).ToList(), "Id", "English_Name", parentIds); var suppliers = dataContext.Users.Where(x => x.UserType == 5 && x.IsActive == true && x.CompanyName != "").Select(s => new { Id = s.Id, SupplierName = s.CompanyName }).ToList(); ViewBag.supplierList = product == null || supplierIds == null || supplierIds.Count() == 0 ? new MultiSelectList(suppliers, "Id", "SupplierName") : new MultiSelectList(suppliers, "Id", "SupplierName", supplierIds); ProductDetails productModel = ConvertModeltoDTO(product); return(View(productModel)); } catch (Exception ex) { var exception = ex; return(View()); } }
public ActionResult ProductList() { ArityEntities dataContext = new ArityEntities(); var productList = (from product in dataContext.Products.ToList().Where(_ => _.Parent_Id == 0) select new { Id = product.Id, Chinese_Name = product.Chinese_Name, English_Name = product.English_Name, Quantity = product.Quantity, Dollar_Price = product.Dollar_Price, RMB_Price = product.RMB_Price, Unit = product.Unit, Description = product.Description, ModifiedDate = product.ModifiedDate.GetValueOrDefault().ToString("MM/dd/yyyy h:m tt"), ChildProducts = (from subProcduct in dataContext.Products.ToList().Where(_ => _.Parent_Id == product.Id) select new { Id = subProcduct.Id, Chinese_Name = subProcduct.Chinese_Name, English_Name = subProcduct.English_Name, Quantity = subProcduct.Quantity, Dollar_Price = subProcduct.Dollar_Price, RMB_Price = subProcduct.RMB_Price, Unit = subProcduct.Unit, Description = subProcduct.Description, ModifiedDate = subProcduct.ModifiedDate.GetValueOrDefault().ToString("MM/dd/yyyy h:m tt") }).ToList() }).ToList(); return(Json(new { data = productList }, JsonRequestBehavior.AllowGet)); ///return View(productList,JsonRequestBehavior.AllowGet); }
/// <summary> /// Get product for order /// </summary> /// <param name="id"></param> /// <param name="qty"></param> /// <returns></returns> public JsonResult AddProductToCart(int id, int qty) { ArityEntities objDb = new ArityEntities(); var product = (from pro in objDb.Products.ToList() where pro.Id == id select new Product { Dollar_Price = pro.Dollar_Price }).FirstOrDefault(); var items = objDb.Products.Where(_ => _.Id == id).Union(objDb.Products.Where(_ => _.Parent_Id == id)).ToList(); items.ForEach(_ => _.Quantity = qty); var productList = (from lst in items select new Product { English_Name = lst.English_Name, Chinese_Name = lst.Chinese_Name, Dollar_Price = lst.Dollar_Price, RMB_Price = lst.RMB_Price, Quantity = lst.Quantity, Id = lst.Id, Parent_Id = lst.Parent_Id }).ToList(); return(Json(new { data = productList }, JsonRequestBehavior.AllowGet)); }
public ActionResult Login(LoginModel entity) { try { using (var db = new ArityEntities()) { if (!ModelState.IsValid) { return(View(entity)); } //check user credentials var userInfo = db.Users.Where(s => s.EmailId == entity.Email.Trim() && s.Password == entity.Password.Trim()).FirstOrDefault(); if (userInfo != null) { FormsAuthentication.SetAuthCookie(entity.Email, true); //Set A Unique name in session Session["Username"] = entity.Email; return(RedirectToAction("OrderList", "Order", "Order")); } else { //Login Fail TempData["ErrorMSG"] = "Access Denied! Wrong Credential"; return(View(entity)); } } } catch { throw; } }
public ActionResult Create(Product product) { ArityEntities dataContext = new ArityEntities(); if (product != null && product.Id > 0) { var existingProduct = dataContext.Products.Where(_ => _.Id == product.Id).FirstOrDefault(); existingProduct.Chinese_Name = product.Chinese_Name; existingProduct.English_Name = product.English_Name; existingProduct.Quantity = product.Quantity; existingProduct.Unit = product.Unit; existingProduct.Dollar_Price = product.Dollar_Price; existingProduct.RMB_Price = product.RMB_Price; existingProduct.Parent_Id = product.Parent_Id == null ? existingProduct.Parent_Id : product.Parent_Id; } else { if (product.Parent_Id == null) { product.Parent_Id = 0; } dataContext.Products.Add(product); } dataContext.SaveChanges(); return(RedirectToAction("list", "product")); }
/// <summary> /// Place order landing page /// </summary> /// <returns></returns> public ActionResult MakeOrder() { ArityEntities objDb = new ArityEntities(); ViewBag.Products = new SelectList(objDb.Products.Where(_ => _.Parent_Id == 0).ToList(), "Id", "English_Name"); return(View()); }
/// <summary> /// Add supplier order line items /// </summary> /// <param name="SupplierOrderLineItemModel"></param> /// <returns></returns> public JsonResult AddSupplierOrderLineItems(SupplierOrderLineItemModel model) { Supplier_Assigned_OrderLineItem data = new Supplier_Assigned_OrderLineItem(); try { if (model != null) { using (var db = new ArityEntities()) { data.OrderSupplierMapId = model.OrderSupplierMapId; data.Quantity = model.Quantity; data.Status = "Draft"; data.SupplierId = model.SupplierId; data.CreatedDate = DateTime.UtcNow; data.ModifiedDate = DateTime.UtcNow; db.Supplier_Assigned_OrderLineItem.Add(data); db.SaveChanges(); } } return(Json(new { data = data }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw; } }
public ActionResult Login(LoginModel entity) { try { using (var db = new ArityEntities()) { if (!ModelState.IsValid) { return(View(entity)); } //check user credentials var userInfo = db.Users.Where(s => s.EmailId == entity.Email.Trim() && s.Password == entity.Password.Trim()).FirstOrDefault(); if (userInfo != null && userInfo.IsActive == true) { FormsAuthentication.SetAuthCookie(entity.Email, true); //Set A Unique name in cookie var Username = new HttpCookie("Username"); Username.Value = userInfo.EmailId; Username.Expires = DateTime.Now.AddDays(7d); var UserType = new HttpCookie("UserType"); UserType.Value = userInfo.UserType.ToString(); UserType.Expires = DateTime.Now.AddDays(7d); var UserId = new HttpCookie("UserId"); UserId.Value = userInfo.Id.ToString(); UserId.Expires = DateTime.Now.AddDays(7d); Response.Cookies.Add(Username); Response.Cookies.Add(UserType); Response.Cookies.Add(UserId); //Session["Username"] = userInfo.EmailId; //Session["UserType"] = userInfo.UserType; //Session["UserId"] = userInfo.Id; if (!string.IsNullOrEmpty(entity.ReturnURL)) { return(RedirectToAction(entity.ReturnURL)); } if (userInfo.UserType == (int)AritySystems.Common.EnumHelpers.UserType.Admin) { return(RedirectToAction("orders", "order")); } else if (userInfo.UserType == (int)AritySystems.Common.EnumHelpers.UserType.Supplier) { return(RedirectToAction("suppliersorder", "order")); } return(RedirectToAction("orderlist", "order")); } else { //Login Fail TempData["ErrorMSG"] = "Access Denied! Wrong Credential or User is not Active"; return(View(entity)); } } } catch { throw; } }
/// <summary> /// Get Product details by Id /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult GetProductDetail(int id) { ArityEntities objDb = new ArityEntities(); var product = (from pro in objDb.Products.ToList() where pro.Id == id select new Product { Dollar_Price = pro.Dollar_Price }).FirstOrDefault(); return(Json(product, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int?id) { ArityEntities dataContext = new ArityEntities(); id = id ?? 0; var product = dataContext.Products.Where(x => x.Id == id).FirstOrDefault(); if (product != null) { } return(View()); }
public ActionResult Create(ProductDetails product) { string productParentIds = string.Empty; string suppliers = string.Empty; int parent = 0; if (product.ParentIdsArray != null) { productParentIds = string.Join(",", product.ParentIdsArray); parent = 1; } if (product.SuppliersArray != null) { suppliers = string.Join(",", product.SuppliersArray); } ArityEntities dataContext = new ArityEntities(); if (product != null && product.Id > 0) { var existingProduct = dataContext.Products.Where(_ => _.Id == product.Id).FirstOrDefault(); existingProduct.Chinese_Name = product.Chinese_Name; existingProduct.English_Name = product.English_Name; existingProduct.Quantity = product.Quantity; existingProduct.Unit = product.Unit; existingProduct.Dollar_Price = product.Dollar_Price; existingProduct.RMB_Price = product.RMB_Price; existingProduct.Parent_Id = parent; existingProduct.Description = product.Description; existingProduct.ModifiedDate = DateTime.Now; existingProduct.ParentIds = productParentIds; existingProduct.Suppliers = suppliers; existingProduct.IsActive = true; existingProduct.BOM = product.BOM; existingProduct.Weight = product.Weight; existingProduct.CBM = product.Cubic_Meter; } else { product.Parent_Id = parent; product.ParentIds = productParentIds; product.ModifiedDate = DateTime.Now; product.CreatedDate = DateTime.Now; product.IsActive = true; var data = ConvertDTOtoModel(product); dataContext.Products.Add(ConvertDTOtoModel(product)); } dataContext.SaveChanges(); return(RedirectToAction("list", "product")); }
public ActionResult Delete(int?id) { ArityEntities dataContext = new ArityEntities(); id = id ?? 0; var product = dataContext.Products.Where(x => x.Id == id).FirstOrDefault(); if (product != null) { product.IsActive = false; dataContext.SaveChanges(); } return(RedirectToAction("List")); }
/// <summary> /// Get order details for customer /// </summary> /// <returns></returns> public JsonResult GetOrderList() { ArityEntities objDb = new ArityEntities(); var orderLst = (from order in objDb.Orders.OrderByDescending(_ => _.CreatedDate).ToList() select new { Id = order.Id, Prefix = order.Prefix, CreatedDate = order.CreatedDate.GetValueOrDefault().ToString("MM/dd/yyyy h:m tt"), Status = order.Status, TotalItem = order.OrderLineItems.Sum(_ => _.Quantity), Total = order.OrderLineItems.Sum(_ => (_.DollarPurchasePrice * _.Quantity)) }).ToList(); return(Json(new { data = orderLst }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(int?Id) { try { Product product = new Product(); ArityEntities dataContext = new ArityEntities(); product = dataContext.Products.Where(x => x.Id == Id).FirstOrDefault(); ViewBag.productList = product == null ? new SelectList(dataContext.Products.Where(x => x.Parent_Id == 0).ToList(), "Id", "English_Name") : new SelectList(dataContext.Products.Where(x => x.Parent_Id == 0).ToList(), "Id", "English_Name", product.Parent_Id ?? 0); return(View(product)); } catch (Exception ex) { var exception = ex; return(View()); } }
public ActionResult MakeOrder(FormCollection fc) { ArityEntities objDb = new ArityEntities(); List <KeyValuePair <int, int> > lineItem = new List <KeyValuePair <int, int> >(); ViewBag.Products = new SelectList(objDb.Products.Where(_ => _.Parent_Id == 0).ToList(), "Id", "English_Name"); if (fc != null) { try { for (int i = 1; i <= 999999; i++) { if (fc["productId_" + i] == null && fc["qty_" + i] == null) { break; } lineItem.Add(new KeyValuePair <int, int>(Convert.ToInt32(fc["productId_" + i]), Convert.ToInt32(fc["qty_" + i]))); } if (lineItem.Any()) { var order = objDb.Orders.Add(new Order() { CustomerId = 1, CreatedDate = DateTime.Now, Prefix = "user1", Status = "1" }); objDb.SaveChanges(); foreach (var item in lineItem.Where(_ => _.Value > 0)) { var prodcut = objDb.Products.Where(_ => _.Id == item.Key).FirstOrDefault(); objDb.OrderLineItems.Add(new OrderLineItem() { OrderId = order.Id, ProductId = prodcut.Id, DollarPurchasePrice = prodcut.Dollar_Price, RMDPurchasePrice = prodcut.RMB_Price, Quantity = item.Value }); } objDb.SaveChanges(); } } catch (Exception ex) { TempData["Error"] = "Error occured while place your order. Please try again."; return(View()); } } TempData["Success"] = "Order Placed. Thank you"; return(View()); }
private List <ProductDetails> GetChildProducts(int parentId) { ArityEntities dataContext = new ArityEntities(); List <ProductDetails> childProductList = new List <ProductDetails>(); var parentsCsv = (from data in dataContext.Products where data.ParentIds != null && data.ParentIds != string.Empty && data.IsActive select new { Id = data.Id, parents = data.ParentIds }).ToList(); foreach (var data in parentsCsv) { var ids = data.parents.Split(new[] { ',' }) .Select(x => int.Parse(x)) .ToArray(); var childProductDetails = (from childProduct in dataContext.Products.ToList().Where(x => ids.Contains(parentId) && x.Id == data.Id) select new ProductDetails() { Id = childProduct.Id, Chinese_Name = childProduct.Chinese_Name, Description = childProduct.Description, Dollar_Price = childProduct.Dollar_Price, ModifiedDate = childProduct.ModifiedDate, English_Name = childProduct.English_Name, Quantity = childProduct.Quantity, RMB_Price = childProduct.RMB_Price, Unit = getEnumValue(childProduct.Unit), BOM = GetBOMForParent(parentId, childProduct.Id) }).FirstOrDefault(); if (childProductDetails != null) { childProductList.Add(childProductDetails); } } return(childProductList); }
/// <summary> /// Order Line Item list and supplier order line item list with order details /// </summary> /// <param name="OrderId"></param> /// <returns></returns> public ActionResult OrderLineItems(int OrderId) { OrderDetailModel model = new OrderDetailModel(); try { using (var db = new ArityEntities()) { model.OrderName = db.Orders.Where(x => x.Id == OrderId).Select(x => x.Prefix).FirstOrDefault(); model.OrderDate = db.Orders.Where(x => x.Id == OrderId).Select(x => x.CreatedDate).FirstOrDefault() ?? DateTime.MinValue; model.Status = db.Orders.Where(x => x.Id == OrderId).Select(x => x.Status).FirstOrDefault(); model.OrderLineItemsList = db.OrderLineItems.Where(x => x.OrderId == OrderId).ToList(); foreach (var item in model.OrderLineItemsList) { model.OrderTotal = item.DollarPurchasePrice * item.Quantity ?? 0; } model.SupplierOrderLineItemList = (from a in db.Supplier_Assigned_OrderLineItem join b in db.OrderLineItem_Supplier_Mapping on a.OrderSupplierMapId equals b.Id join c in db.OrderLineItems on b.OrderLineItemId equals c.Id join d in db.Orders on c.OrderId equals d.Id where d.Id == OrderId select new SupplierOrderLineItemModel { Id = a.Id, CreatedDate = a.CreatedDate, ModifiedDate = a.ModifiedDate, OrderSupplierMapId = a.OrderSupplierMapId, Order_Prefix = d.Prefix, Quantity = a.Quantity, Status = a.Status, SupplierId = a.SupplierId, SupplierName = b.User.UserName }).ToList(); } return(Json(new { data = model }, JsonRequestBehavior.AllowGet)); //return View(model); } catch (Exception ex) { throw; } }
public ActionResult ProductList() { ArityEntities dataContext = new ArityEntities(); var productList = (from product in dataContext.Products.ToList().Where(_ => _.Parent_Id == 0 && Convert.ToBoolean(_.IsActive)) select new { Id = product.Id, Chinese_Name = product.Chinese_Name, English_Name = product.English_Name, Quantity = product.Quantity, Dollar_Price = product.Dollar_Price, RMB_Price = product.RMB_Price, Unit = getEnumValue(Convert.ToInt32(product.Unit)), Description = product.Description, ModifiedDate = product.ModifiedDate.GetValueOrDefault().ToString("dd/MM/yyyy"), ChildProducts = GetChildProducts(product.Id) }).ToList(); return(Json(new { data = productList }, JsonRequestBehavior.AllowGet)); ///return View(productList,JsonRequestBehavior.AllowGet); }
public List <SelectListItem> SupplierDD() { List <SelectListItem> list = new List <SelectListItem>(); try { using (var db = new ArityEntities()) { var data = (from a in db.Users join b in db.UserTypes on a.Id equals b.UserId where b.Id == 4 select new SelectListItem { Text = a.UserName, Value = a.Id.ToString() }); } return(list); } catch (Exception ex) { throw; } }
/// <summary> /// Order details /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult OrderDetail(int id) { ArityEntities objDb = new ArityEntities(); return(View(objDb.Orders.Where(_ => _.Id == id).FirstOrDefault())); }
public UserController() { dataContext = new ArityEntities(); }