Beispiel #1
0
 //
 // 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));
        }
Beispiel #3
0
        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));
        }
Beispiel #4
0
        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));
        }