// // GET: /Materials/Create public ActionResult Get(Page model) { using (AppDB db = new AppDB()) { return(Json(IEnumerableData.GetPageResponse <MaterialModel>(model, (from m in db.Materials join s in db.Sellers on m.SellerId equals s.Id join o in db.Orders on m.OrderId equals o.Id join u in db.Employees on m.CreatedBy equals u.Id where m.OrderId == model.id select new MaterialModel() { Id = m.Id, SellerId = m.SellerId, Seller = s.Name, OrderId = m.OrderId, Order = o.CodeNumber, Amount = m.Amount, Description = m.Description, OrderDate = m.OrderDate, DeliveryDate = m.DeliveryDate, CreatedBy = m.CreatedBy, CreatedByName = u.Name, ReceivedDate = m.ReceivedDate })), JsonRequestBehavior.AllowGet)); } }
public ActionResult Get(Page model) { ResponseJson response = new ResponseJson() { Data = new List <object>() }; var data = new Pagger <dynamic>(); using (AppDB db = new AppDB()) { response = IEnumerableData.GetPageResponse <BundleModel>(model, (from b in db.Bundles join s in db.Styles on b.StyleId equals s.Id join st in db.Status on b.Status equals st.Id join o in db.Employees on b.OperatorId equals o.Id join l in db.Employees on b.LinkingBy equals l.Id where b.Status == 2 select new BundleModel() { BarCode = b.BarCode, Style = s.Name, StyleId = b.StyleId, Id = b.Id, Quantity = b.Quantity, Status = st.Name, StatusId = st.Id, KnittingMachine = b.KnittingMachine, LinkingEndAt = b.LinkingEndAt, OperatorId = b.OperatorId, Operator = o.Name, LinkingBy = l.Name, LinkingById = l.Id })); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Get(Page model) { ResponseJson response = new ResponseJson() { Data = new List <object>() }; var data = new Pagger <dynamic>(); using (AppDB db = new AppDB()) { response = IEnumerableData.GetPageResponse <StyleModel>(model, (from s in db.Styles join b in db.Buyers on s.BuyerId equals b.Id join st in db.Status on s.Status equals st.Id select new StyleModel() { BarCode = s.BarCode, Buyer = b.Name, BuyerId = s.BuyerId, Id = s.Id, Name = s.Name, Quantity = s.Quantity, Status = st.Name, StatusId = st.Id, ShippingDate = s.ShippingDate, Description = s.Description, YarnType = s.YarnType, Size = s.Size, })); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Get(Page model) { ResponseJson response = new ResponseJson() { Data = new List <object>() }; using (AppDB db = new AppDB()) { var currentRole = db.Roles.Where(r => CurrentUser.Roles.Contains(r.Code)).Min(r => r.Priority); response = IEnumerableData.GetPageResponse <EmployeeModel>(model, (from b in db.Employees join r in db.Roles on b.Role equals r.Code where r.Priority > currentRole select new EmployeeModel() { Id = b.Id, BarCode = b.BarCode, Name = b.Name, Phone = b.Phone, Email = b.Email, Address = b.Address, Role = r.Name, CreatedAt = b.CreatedAt, IsActive = b.IsActive })); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Get(Page model) { ResponseJson response = new ResponseJson() { Data = new List <object>() }; using (AppDB db = new AppDB()) { response = IEnumerableData.GetPageResponse <OrderModel>(model, (from o in db.Orders join b in db.Buyers on o.BuyerId equals b.Id where o.Status != 10 select new OrderModel() { Id = o.Id, Buyer = b.Name, BuyerId = o.BuyerId, CodeNumber = o.CodeNumber, Color = o.Color, DeliveryDate = o.DeliveryDate, Description = o.Description, Size = o.Size, Style = o.Style, Quantity = o.TotalQuantity, Completed = o.TotalCompleted, ProductionStartAT = o.ProductionStartAT, OrderDate = o.OrderDate, CurrentDate = DateTime.Now }).ToList()); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public ActionResult Get(Page model) { ResponseJson response = new ResponseJson() { Data = new List <object>() }; using (AppDB db = new AppDB()) { response = IEnumerableData.GetPageResponse <BuyerModel>(model, (from b in db.Buyers select new BuyerModel() { Id = b.Id, Name = b.Name, Phone = b.Phone, Email = b.Email, Address = b.Address, CreatedAt = b.CreatedAt })); } return(Json(response, JsonRequestBehavior.AllowGet)); }