Esempio n. 1
0
        public int Insert(tblResumeData resumeData)
        {
            try
            {
                using (var dbContext = new PMSEntities())
                {
                    resumeData.ResumeId = Guid.NewGuid();
                    dbContext.tblResumeDatas.Add(resumeData);
                    foreach (var obj in resumeData.tblEducations)
                    {
                        obj.ResumeId    = resumeData.ResumeId;
                        obj.EducationId = Guid.NewGuid();
                        dbContext.tblEducations.Add(obj);
                    }


                    dbContext.SaveChanges();
                }
                return(1);
            }
            catch (Exception ex)
            {
                return(0);
            }
        }
Esempio n. 2
0
 public List <Vehicle_Parking> GetAllVehicles()
 {
     using (PMSEntities db = new PMSEntities())
     {
         return(db.Vehicle_Parking.ToList());
     }
 }
Esempio n. 3
0
        public static List <ClusterModel> GetNSCForChart(int lineId, TimeSpan timeStart, TimeSpan timeEnd, string date)
        {
            try
            {
                var db       = new PMSEntities();
                var clusters = BLLCluster.GetAllByLineId(lineId);
                if (clusters != null && clusters.Count > 0)
                {
                    var ids  = clusters.Select(x => x.Id);
                    var tdns = db.TheoDoiNgays.Where(x => !x.Chuyen.IsDeleted && !x.Cum.IsDeleted && x.Date == date && x.MaChuyen == lineId && ids.Contains(x.CumId)).ToList();

                    foreach (var item in clusters)
                    {
                        var tang = tdns.Where(x => x.CumId == item.Id && x.Time >= timeStart && x.Time <= timeEnd && x.CommandTypeId == (int)eCommandRecive.ProductIncrease && x.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(x => x.ThanhPham);
                        var giam = tdns.Where(x => x.CumId == item.Id && x.Time >= timeStart && x.Time <= timeEnd && x.CommandTypeId == (int)eCommandRecive.ProductReduce && x.ProductOutputTypeId == (int)eProductOutputType.KCS).Sum(x => x.ThanhPham);
                        tang     = tang - giam;
                        item.KCS = tang > 0 ? tang : 0;
                    }
                    return(clusters);
                }
            }
            catch (Exception ex)
            {
            }
            return(null);
        }
        public void DeleteWorkSpace(WorkSpace ws)
        {
            //Setup a fake HttpRequest
            Mock <HttpContextBase>    moqContext    = new Mock <HttpContextBase>();
            Mock <HttpRequestBase>    moqRequest    = new Mock <HttpRequestBase>();
            Mock <HttpPostedFileBase> moqPostedFile = new Mock <HttpPostedFileBase>();

            moqRequest.Setup(r => r.Files.Count).Returns(0);
            moqContext.Setup(x => x.Request).Returns(moqRequest.Object);

            //arrange
            var         controller = new HomeController();
            PMSEntities db         = new PMSEntities();

            ws.ID = 1;
            var       work_id   = ws.ID;
            WorkSpace workspace = db.WorkSpaces.Find(work_id);

            db.WorkSpaces.Remove(workspace);

            controller.ControllerContext = new ControllerContext(moqContext.Object, new RouteData(), controller);
            var validationResults = TestModelHelper.ValidateModel(controller, workspace);

            //act
            var redirectRoute = controller.Index() as RedirectToRouteResult;

            //assert
            Assert.IsNotNull(redirectRoute);
            Assert.AreEqual("Index", redirectRoute.RouteValues["action"]);
            //Assert.AreEqual("Home", redirectRoute.RouteValues["controller"]);
            Assert.AreEqual(0, validationResults.Count);
        }
Esempio n. 5
0
        public List <AddPhaseQuantitiesModel> GetPhaseDayInfo(List <int> assignIds, int phaseType, DateTime date)
        {
            var rs = new List <AddPhaseQuantitiesModel>();

            using (var db = new PMSEntities())
            {
                rs.AddRange(db.P_PhaseDaily.Where(x =>
                                                  x.CreatedDate.Day == date.Day &&
                                                  x.CreatedDate.Month == date.Month &&
                                                  x.CreatedDate.Year == date.Year &&
                                                  assignIds.Contains(x.AssignId) &&
                                                  x.P_Phase.Type == phaseType)
                            .OrderByDescending(x => x.CreatedDate).Select(x => new AddPhaseQuantitiesModel()
                {
                    AssignId       = x.AssignId,
                    PhaseId        = x.PhaseId,
                    LineName       = x.Chuyen_SanPham.Chuyen.TenChuyen,
                    Date           = x.CreatedDate,
                    Quantity       = x.Quantity,
                    CommandTypeId  = x.CommandTypeId,
                    strCommandType = (x.CommandTypeId == (int)eCommandRecive.ProductIncrease ? "Tăng" : "Giảm")
                }));
                for (int i = 0; i < rs.Count; i++)
                {
                    rs[i].strDate = rs[i].Date.ToString("d/M/yyyy HH:mm");
                }
            }
            return(rs);
        }
Esempio n. 6
0
        public static ResponseBase Update(P_MonthlyProductionPlans proObj)
        {
            var result = new ResponseBase();

            try
            {
                var db  = new PMSEntities();
                var obj = db.P_MonthlyProductionPlans.FirstOrDefault(x => !x.IsDeleted && x.Id == proObj.Id);
                if (obj != null)
                {
                    obj.LK_TH  = proObj.LK_TH;
                    obj.LK_TC  = proObj.LK_TC;
                    obj.LK_BTP = proObj.LK_BTP;
                    db.SaveChanges();
                    result.IsSuccess = true;
                }
            }
            catch (Exception)
            {
                result.IsSuccess = false;
                result.Messages.Add(new Message()
                {
                    Title = "Lỗi", msg = "Lỗi không cập nhật được thông tin."
                });
            }
            return(result);
        }
 public static List <CompletionPhase_DailyModel> GetDetailInDay(string date, int commoId)
 {
     try
     {
         var db = new PMSEntities();
         return(db.P_CompletionPhase_Daily.Where(x => !x.IsDeleted && x.Date == date && x.P_AssignCompletion.CommoId == commoId).Select(x => new CompletionPhase_DailyModel()
         {
             Id = x.Id,
             AssignId = x.AssignId,
             CommandTypeId = x.CommandTypeId,
             CommoName = x.P_AssignCompletion.SanPham.TenSanPham,
             CompletionPhaseId = x.CompletionPhaseId,
             PhaseName = x.P_CompletionPhase.Name,
             Quantity = x.Quantity,
             Date = x.Date,
             CreatedDate = x.CreatedDate,
             //Time = x.CreatedDate.TimeOfDay,
             TypeName = x.CommandTypeId == (int)eCommandRecive.ProductIncrease ? "Tăng" : "Giảm"
         }).OrderByDescending(x => x.CreatedDate).ToList());
     }
     catch (Exception ex)
     {
     }
     return(new List <CompletionPhase_DailyModel>());
 }
Esempio n. 8
0
 public List <ModelSelectItem> GetNSNgayCuaChuyen(int LineId)
 {
     try
     {
         using (var db = new PMSEntities())
         {
             var now = DateTime.Now.ToString("d/M/yyyy");
             if (LineId != 0)
             {
                 return(db.Chuyen_SanPham.Where(x => !x.IsDelete && !x.HideForever &&
                                                !x.SanPham.IsDelete && x.MaChuyen == LineId)
                        .OrderBy(x => x.STTThucHien)
                        .Select(x => new ModelSelectItem()
                 {
                     Value = x.STT,
                     Data = x.STT,
                     Name = x.SanPham.TenSanPham
                 }).ToList());
             }
         }
         return(null);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 9
0
 public List <NhapSLModel> GetDayInfo(int LineId, string date)
 {
     try
     {
         using (var db = new PMSEntities())
         {
             if (LineId != 0)
             {
                 return(db.NangXuats.Where(x => !x.IsDeleted && !x.Chuyen_SanPham.IsDelete && !x.Chuyen_SanPham.HideForever &&
                                           !x.Chuyen_SanPham.SanPham.IsDelete && x.Chuyen_SanPham.MaChuyen == LineId && x.Ngay == date)
                        .OrderBy(x => x.Chuyen_SanPham.STTThucHien)
                        .Select(x => new NhapSLModel()
                 {
                     cspId = x.STTCHuyen_SanPham,
                     ERR = (x.SanLuongLoi - x.SanLuongLoiGiam),
                     TC = (x.BTPThoatChuyenNgay - x.BTPThoatChuyenNgayGiam),
                     DinhMuc = x.DinhMucNgay,
                     LK_TC = x.Chuyen_SanPham.LuyKeBTPThoatChuyen,
                     KCS = (x.ThucHienNgay - x.ThucHienNgayGiam),
                     LK_KCS = x.Chuyen_SanPham.LuyKeTH,
                     ColorName = x.Chuyen_SanPham.P_Color.Name,
                     ProName = x.Chuyen_SanPham.SanPham.TenSanPham,
                     SizeName = x.Chuyen_SanPham.P_Size.Name
                 }).ToList());
             }
         }
         return(null);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 10
0
        public static List <ProductModel> Gets(int floorId, int All)
        {
            try
            {
                using (var db = new PMSEntities())
                {
                    var query = db.SanPhams.Where(x => !x.IsDelete);
                    if (All != 1)
                    {
                        query = query.Where(x => x.Floor.Value == floorId);
                    }

                    return(query.OrderBy(x => x.MaSanPham).Select(x => new ProductModel()
                    {
                        MaSanPham = x.MaSanPham,
                        TenSanPham = x.TenSanPham,
                        DinhNghia = x.DinhNghia,
                        DonGia = x.DonGia,
                        DonGiaCM = x.DonGiaCM,
                        Floor = x.Floor ?? 0,
                        ProductionTime = x.ProductionTime
                    }).ToList());
                }
            }
            catch (Exception)
            {
            }
            return(null);
        }
Esempio n. 11
0
        public static ResponseBase Delete(int Id)
        {
            var result = new ResponseBase();

            try
            {
                var db        = new PMSEntities();
                var lineShift = db.P_LineWorkingShift.FirstOrDefault(x => !x.IsDeleted && x.Id == Id);
                if (lineShift != null)
                {
                    lineShift.IsDeleted = true;
                    db.SaveChanges();
                    result.IsSuccess = true;
                    result.Messages.Add(new Message()
                    {
                        Title = "Thông Báo", msg = "Xóa thành công."
                    });
                }
                else
                {
                    result.IsSuccess = false;
                    result.Messages.Add(new Message()
                    {
                        Title = "Lỗi", msg = "Không tìm thấy thông tin."
                    });
                }
            }
            catch (Exception)
            { }
            return(result);
        }
Esempio n. 12
0
        public IEnumerable <Order> GetOrder()
        {
            IList <Order> orders  = db.Orders.ToList <Order>();
            List <Order>  orders1 = new List <Order>();

            using (var context = new PMSEntities())
            {
                var query = from st in context.Orders
                            select st;
            }
            foreach (var p in orders)
            {
                Order List = new Order()
                {
                    OrderId         = p.OrderId,
                    ProductId       = p.ProductId,
                    ProductQuantity = p.ProductQuantity,
                    UserId          = p.UserId,
                    BookingOn       = p.BookingOn,
                    DeliveredOn     = p.DeliveredOn,
                };

                orders1.Add(List);
            }
            return(orders1);
        }
Esempio n. 13
0
        public ResponseBase Update(List <P_ReadPercentOfLine> items)
        {
            var result = new ResponseBase();

            try
            {
                db = new PMSEntities();
                if (items != null && items.Count > 0)
                {
                    var ids  = items.Select(x => x.Id).ToArray();
                    var objs = db.P_ReadPercentOfLine.Where(x => !x.IsDeleted && ids.Contains(x.Id));
                    foreach (var itemObj in objs)
                    {
                        var obj = items.FirstOrDefault(x => x.Id == itemObj.Id);
                        if (obj != null)
                        {
                            itemObj.ReadPercent_KCSInventoryId = obj.ReadPercent_KCSInventoryId;
                        }
                        itemObj.ReadPercent_KCSInventoryId = obj.ReadPercent_KCSInventoryId == 0 ? null : obj.ReadPercent_KCSInventoryId;
                    }
                }
                db.SaveChanges();
                result.IsSuccess = true;
                result.Messages.Add(new Message()
                {
                    Title = "Thông Báo", msg = "Lưu thành công."
                });
            }
            catch (Exception ex)
            {
            }
            return(result);
        }
Esempio n. 14
0
 public int Update(tblResumeData resumeData)
 {
     try
     {
         using (var dbContext = new PMSEntities())
         {
             dbContext.tblResumeDatas.Attach(resumeData);
             dbContext.Entry(resumeData).State = EntityState.Modified;
             foreach (var obj in resumeData.tblEducations)
             {
                 if (obj.Id != 0)
                 {
                     dbContext.tblEducations.Attach(obj);
                     dbContext.Entry(obj).State = EntityState.Modified;
                 }
                 else
                 {
                     obj.ResumeId    = resumeData.ResumeId;
                     obj.EducationId = Guid.NewGuid();
                     dbContext.tblEducations.Add(obj);
                 }
             }
             dbContext.SaveChanges();
         }
         return(1);
     }
     catch (Exception ex)
     {
         return(0);
     }
 }
Esempio n. 15
0
        /// <summary>
        /// Insert phân công hoàn tất
        /// </summary>
        /// <param name="csp"></param>
        /// <returns></returns>
        public static ResponseBase Insert(P_AssignCompletion csp)
        {
            var result = new ResponseBase();

            try
            {
                var db = new PMSEntities();
                db.P_AssignCompletion.Add(csp);
                db.SaveChanges();
                result.IsSuccess = true;
                result.Messages.Add(new Message()
                {
                    Title = "Thông Báo", msg = "Lưu Phân công thành công."
                });
            }
            catch (Exception ex)
            {
                result.IsSuccess = false;
                result.Messages.Add(new Message()
                {
                    Title = "Lỗi Lưu Phân Công", msg = "Lưu Phân công cho Chuyền bị lỗi.\n" + ex.Message
                });
            }
            return(result);
        }
Esempio n. 16
0
 public List <ErrorModel> GetErrors(int cspId, string ngay)
 {
     using (var db = new PMSEntities())
     {
         var errors = db.Errors.Where(x => !x.IsDeleted && !x.GroupError.IsDeleted).Select(x => new ErrorModel()
         {
             Id        = x.Id,
             Code      = x.Code,
             Name      = x.Name,
             GroupName = x.GroupError.Name,
             PhaseName = x.P_Phase.Name,
             Quantity  = 0
         }).OrderBy(x => x.Code).ToList();
         if (errors.Count > 0)
         {
             var errsInDay = db.TheoDoiNgays.Where(x => ngay == x.Date && x.ErrorId.HasValue && x.STTChuyenSanPham == cspId).ToList();
             if (errsInDay.Count > 0)
             {
                 foreach (var item in errors)
                 {
                     int tang = errsInDay.Where(x => x.ErrorId == item.Code && x.CommandTypeId == (int)eCommandRecive.ErrorIncrease).Sum(x => x.ThanhPham);
                     tang          = tang - errsInDay.Where(x => x.ErrorId == item.Code && x.CommandTypeId == (int)eCommandRecive.ErrorReduce).Sum(x => x.ThanhPham);
                     item.Quantity = tang;
                 }
             }
         }
         return(errors);
     }
 }
Esempio n. 17
0
 public List <ClientDataModel> getCleints()
 {
     try
     {
         using (var dbContext = new PMSEntities())
         {
             return(dbContext.tblInwardWOes.Select(x => new ClientDataModel()
             {
                 ClientName = x.ClientName,
                 Address1 = x.Address1,
                 Address2 = x.Address2,
                 State = x.State,
                 PinCode = x.PinCode,
                 ContactPerson1 = x.ContactPerson1,
                 ContactPerson2 = x.ContactPerson2,
                 Mobile1 = x.Mobile1,
                 Mobile2 = x.Mobile2,
                 Email1 = x.Email1,
                 Email2 = x.Email2,
             }).Distinct().ToList());
         }
     }
     catch (Exception ex)
     {
     }
     return(new List <ClientDataModel>());
 }
Esempio n. 18
0
 public static List <LineModel> GetLines(int floorId)
 {
     try
     {
         var db   = new PMSEntities();
         var list = new List <LineModel>();
         return(db.Chuyens.Where(x => !x.IsDeleted && !x.Floor.IsDeleted && x.FloorId == floorId).Select(x => new LineModel()
         {
             MaChuyen = x.MaChuyen,
             TenChuyen = x.TenChuyen,
             Code = x.Code,
             DinhNghia = x.DinhNghia,
             LaoDongDinhBien = x.LaoDongDinhBien,
             IdDen = x.IdDen,
             IdDenNangSuat = x.IdDenNangSuat,
             IdTyLeDoc = x.IdTyLeDoc,
             IntSTT = x.IntSTT,
             Floor = x.Floor,
             Sound = x.Sound,
             STTReadNS = x.STTReadNS,
         }).ToList());
     }
     catch (Exception ex)
     {
     }
     return(new List <LineModel>());
 }
Esempio n. 19
0
        public static ResponseBase FindAccount(string userName, string password)
        {
            var result = new ResponseBase();

            try
            {
                using (var db = new PMSEntities())
                {
                    var user = db.TaiKhoans.FirstOrDefault(x => x.UserName.Trim().ToUpper().Equals(userName.Trim().ToUpper()) && x.Password.Trim().ToUpper().Equals(password.Trim().ToUpper()));
                    if (user != null)
                    {
                        result.IsSuccess = true;
                        result.Data      = user;
                    }
                    else
                    {
                        result.IsSuccess = false;
                        result.Messages.Add(new Message()
                        {
                            Title = "Đăng Nhập", msg = "Tên Đăng Nhập hoặc Mật Khẩu không đúng."
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                result.IsSuccess = false;
                result.Messages.Add(new Message()
                {
                    Title = "Lỗi Đăng Nhập", msg = "Lỗi: trong quá trình kiểm tra đăng nhập. " + ex.Message
                });
            }
            return(result);
        }
Esempio n. 20
0
        public string FindConfigValue(int appId, string configName)
        {
            var value = string.Empty;

            try
            {
                var     db = new PMSEntities();
                dynamic cf = db.Config_App.FirstOrDefault(x => x.AppId == appId && x.Config.Name.Trim().ToUpper().Equals(configName));
                if (cf == null)
                {
                    cf = db.Configs.FirstOrDefault(x => x.IsActive && x.Name.Trim().ToUpper().Equals(configName));
                    if (cf != null)
                    {
                        value = cf.ValueDefault.Trim();
                    }
                }
                else
                {
                    value = cf.Value.Trim();
                }
            }
            catch (Exception)
            {
            }
            return(value);
        }
Esempio n. 21
0
        public static ResponseBase Delete(int Id)
        {
            var result = new ResponseBase();

            try
            {
                var db            = new PMSEntities();
                var MAIL_SCHEDULE = db.MAIL_SCHEDULE.FirstOrDefault(x => !x.IsDeleted && x.Id == Id);
                if (MAIL_SCHEDULE != null)
                {
                    MAIL_SCHEDULE.IsDeleted = true;
                    db.SaveChanges();
                    result.IsSuccess = true;
                    result.Messages.Add(new Message()
                    {
                        Title = "Thông Báo", msg = "Xóa thành công."
                    });
                }
                else
                {
                    result.IsSuccess = false;
                    result.Messages.Add(new Message()
                    {
                        Title = "Thông Báo", msg = "Không tìm thấy thông tin bạn đang thao tác."
                    });
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(result);
        }
Esempio n. 22
0
        public List <AppConfigModel> GetAll(int appId)
        {
            var configs = new List <AppConfigModel>();

            try
            {
                var db = new PMSEntities();
                configs.AddRange(db.Configs.Where(x => x.IsActive).Select(x => new AppConfigModel()
                {
                    Id = x.Id, Name = x.Name, DisplayName = x.DisplayName, Value = x.ValueDefault, Description = x.Description
                }).ToList());
                var configApp = db.Config_App.Where(x => x.AppId == appId).ToList();

                if (configs.Count > 0 && configApp.Count > 0)
                {
                    foreach (var item in configApp)
                    {
                        var obj = configs.FirstOrDefault(x => x.Id == item.ConfigId);
                        if (obj != null)
                        {
                            obj.Value = item.Value;
                        }
                    }
                }
            }
            catch (Exception)
            {
            }
            return(configs);
        }
Esempio n. 23
0
        public List <ModelSelectItem> GetHistoryPhase(int assignId, int phaseId)
        {
            var rs = new List <ModelSelectItem>();

            using (var db = new PMSEntities())
            {
                rs.AddRange((from p in db.P_PhaseDaily
                             where p.AssignId == assignId && p.PhaseId == phaseId
                             select p).ToList()
                            .Select(p => new ModelSelectItem()
                {
                    Id    = p.Id,
                    Name  = p.CreatedDate.ToString("dd/MM/yyyy"),
                    Data  = p.Quantity,
                    Date  = p.CreatedDate,
                    Value = p.CommandTypeId
                }).OrderByDescending(x => x.Date)
                            .GroupBy(p => p.Name).Select(p => new ModelSelectItem
                {
                    Name  = p.Key,
                    Data  = p.Where(x => x.Value == (int)eCommandRecive.ProductIncrease).Sum(x => x.Data),
                    Value = p.Where(x => x.Value == (int)eCommandRecive.ProductReduce).Sum(x => x.Data),
                    Date  = p.FirstOrDefault().Date
                }));
            }
            return(rs);
        }
Esempio n. 24
0
 public static List <LineModel> GetWorkingTime()
 {
     try
     {
         var db     = new PMSEntities();
         var shifts = db.Shifts.OrderBy(c => c.TimeStart).ToList();
         if (shifts != null && shifts.Count > 0)
         {
             var chuyenIds = shifts.Select(x => x.MaChuyen).Distinct();
             var Lines     = db.Chuyens.Where(x => !x.IsDeleted && chuyenIds.Contains(x.MaChuyen)).Select(x => new LineModel()
             {
                 MaChuyen = x.MaChuyen, TenChuyen = x.TenChuyen
             }).OrderBy(x => x.MaChuyen).ToList();
             foreach (var line in Lines)
             {
                 line.WorkingTimes = ProcessShift(shifts.Where(x => x.MaChuyen == line.MaChuyen).ToList());
             }
             return(Lines);
         }
         return(null);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 25
0
        public ModelSelectItem GetLKPhase(int phaseId, int cspId)
        {
            var rs = new ModelSelectItem()
            {
                Id = 0, Value = 0
            };

            using (var db = new PMSEntities())
            {
                var phaseLog = db.P_Phase_Assign_Log.FirstOrDefault(x => x.AssignId == cspId && x.PhaseId == phaseId);
                if (phaseLog != null)
                {
                    rs.Id    = phaseLog.Quantity;
                    rs.Value = phaseLog.Chuyen_SanPham.LuyKeTH;
                    rs.Name  = phaseLog.Chuyen_SanPham.Chuyen.TenChuyen;
                }
                else
                {
                    var csp = db.Chuyen_SanPham.FirstOrDefault(x => x.STT == cspId);
                    if (csp != null)
                    {
                        rs.Value = csp.LuyKeTH;
                        rs.Name  = csp.Chuyen.TenChuyen;
                    }
                }
            }
            return(rs);
        }
Esempio n. 26
0
        public static ResponseBase DeleteShift(int Id)
        {
            var result = new ResponseBase();

            try
            {
                var db    = new PMSEntities();
                var shift = db.P_WorkingShift.FirstOrDefault(x => !x.IsDeleted && x.Id == Id);
                if (shift != null)
                {
                    shift.IsDeleted = true;
                    db.SaveChanges();
                    result.IsSuccess = true;
                    result.Messages.Add(new Message()
                    {
                        msg = "Lưu thông tin thành công.", Title = "Thông Báo"
                    });
                }
            }
            catch (Exception)
            {
                result.IsSuccess = false;
                result.Messages.Add(new Message()
                {
                    msg = "Lưu thông tin bị lỗi.", Title = "Lỗi"
                });
            }
            return(result);
        }
Esempio n. 27
0
 public Vehicle_Parking GetById(string id)
 {
     using (PMSEntities db = new PMSEntities())
     {
         return(db.Vehicle_Parking.Find(id));
     }
 }
Esempio n. 28
0
        public static SelectListAndDefaultModel GetFloorForComBoBox()
        {
            var rs = new SelectListAndDefaultModel();

            try
            {
                var db           = new PMSEntities();
                var floors       = db.Floors.ToList();
                var defaultValue = 0;
                if (floors.Count > 0)
                {
                    foreach (var item in floors)
                    {
                        rs.SelectList.Add(item);
                        defaultValue = item.IsDefault ? item.IdFloor : defaultValue;
                    }
                }
                else
                {
                    rs.SelectList.Add(new Floor()
                    {
                        IdFloor = 0, Name = "Không có thông tin Lầu"
                    });
                }
                rs.DefaultValue = defaultValue;
            }
            catch (Exception)
            { }
            return(rs);
        }
        public static ResponseBase InsertOrUpdate(ThoiGianTinhNhipDoTT obj)
        {
            var rs = new ResponseBase();

            try
            {
                var db  = new PMSEntities();
                var old = db.ThoiGianTinhNhipDoTTs.FirstOrDefault(x => x.Ngay == obj.Ngay && x.MaChuyen == obj.MaChuyen);
                if (old == null)
                {
                    db.ThoiGianTinhNhipDoTTs.Add(obj);
                }
                else
                {
                    old.ThoiGianBatDau = obj.ThoiGianBatDau;
                }
                db.SaveChanges();
                rs.IsSuccess = true;
            }
            catch (Exception)
            {
                rs.IsSuccess = false;
            }
            return(rs);
        }
Esempio n. 30
0
 public static List <VideoScheduleModel> Gets(int LineId)
 {
     try
     {
         var db   = new PMSEntities();
         var objs = db.P_PlayVideoShedule.Where(x => !x.IsDeleted && x.LineId == LineId).Select(x => new VideoScheduleModel()
         {
             Id        = x.Id,
             TimeStart = x.TimeStart,
             TimeEnd   = x.TimeEnd,
             LineId    = x.LineId,
             IsActive  = x.IsActive
         }).ToList();
         if (objs.Count > 0)
         {
             var ids        = objs.Select(x => x.Id);
             var detailObjs = db.P_PlayVideoSheduleDetail.Where(x => !x.IsDeleted && !x.P_VideoLibrary.IsDeleted && ids.Contains(x.VideoSheduleId)).ToList();
             if (detailObjs.Count > 0)
             {
                 foreach (var item in objs)
                 {
                     item.Detail.AddRange(detailObjs.Where(x => x.VideoSheduleId == item.Id));
                 }
             }
         }
         return(objs);
     }
     catch (Exception)
     {
     }
     return(new List <VideoScheduleModel>());
 }