예제 #1
0
        //public IQueryable<Sys_AllSetting> GetAll()
        //{
        //    IQueryable<Sys_AllSetting> result = this.DbSet.ToList().AsQueryable();
        //    return result;
        //}

        /// <summary>
        /// Lấy đối tượng overtime bởi store hrm_att_sp_get_OvertimeByProfileId [Tam.Le - 2014/05/19]
        /// </summary>
        /// <returns></returns>
        public string GetSubMenu(Sys_AllSettingEntity model)
        {
            var result = this.UnitOfWork.Context.Database.SqlQuery <Sys_AllSettingEntity>(ConstantSql.hrm_sys_sp_get_UserSetting_Submenu,
                                                                                          new SqlParameter
            {
                ParameterName = "Name",
                Value         = model.Name
            },
                                                                                          new SqlParameter
            {
                ParameterName = "Keyword",
                Value         = model.Value1
            },
                                                                                          new SqlParameter
            {
                ParameterName = "UserID",
                Value         = model.UserID
            }).FirstOrDefault();

            if (result == null)
            {
                return("");
            }
            else
            {
                return(result.Value2);
            }
        }
예제 #2
0
        public Sys_AllSettingModel Put(Sys_AllSettingModel model)
        {
            var sysAllSetting = new Sys_AllSettingEntity
            {
                ID         = model.ID,
                Name       = model.Name,
                Value1     = model.Value1,
                Value2     = model.Value2,
                ModuleName = model.ModuleName,
                UserID     = model.UserID
            };
            var service = new Sys_AllSettingServices();

            if (model.ID != Guid.Empty)
            {
                sysAllSetting.ID = model.ID;
                service.Edit <Sys_AllSettingEntity>(sysAllSetting);
            }
            else
            {
                service.Add <Sys_AllSettingEntity>(sysAllSetting);
            }

            return(model);
        }
예제 #3
0
        public Sys_AllSettingModel Put(Sys_AllSettingModel model)
        {
            var sysAllSetting = new Sys_AllSettingEntity
            {
                ID = model.ID,
                Name = model.Name + "_" + model.UserID.ToString(),
                Value1 = model.Value1,
                Value2 = model.Value2,
                ModuleName = model.ModuleName,
                UserID = model.UserID
            };
            //var service = new Sys_AllSettingServices();
            //if (model.ID != Guid.Empty)
            //{
            //    sysAllSetting.ID = model.ID;
            //    service.Edit<Sys_AllSettingEntity>(sysAllSetting);
            //}
            //else
            //{
            //    service.Add<Sys_AllSettingEntity>(sysAllSetting);
            //}

            var sysAllSettingServices = new Sys_AttOvertimePermitConfigServices();
            sysAllSettingServices.CreateOrUpdateSysAllSetting(sysAllSetting.Name, model.Value1);
            return model;
        }
예제 #4
0
        /// <summary>
        /// [Tam.Le 8.1.2014 Modify]
        /// </summary>
        /// <param name="request"></param>
        /// <param name="model"></param>
        /// <returns></returns>
        public string CheckConnectTAM()
        {
            var    service = new Lau_TamServices();
            string message = "";
            bool   status  = false;

            bool isconnect = service.IsConnected(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_, ref message);

            if (isconnect == true)
            {
                status = true;
            }
            else
            {
                status = false;
            }

            var sys_AllSetting = new Sys_AllSettingEntity();

            sys_AllSetting = LibraryService.GetSys_AllSettingByKey(Constant.HRM_SYS_COMPUTE_TAMLOG_LAU);
            string result   = string.Empty;
            string DateFrom = string.Empty;
            string DateTo   = string.Empty;

            if (sys_AllSetting != null)
            {
                DateFrom = sys_AllSetting.Value2 != null?sys_AllSetting.Value2.ToString() : string.Empty;

                DateTo = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToString().Split(' ')[1] + " " + DateTime.Now.ToString().Split(' ')[2];
            }

            result = status.ToString() + "|" + DateFrom + "|" + DateTo;
            return(result);
        }
예제 #5
0
        public static Sys_AllSettingEntity GetSys_AllSettingByKey(string key)
        {
            var    service        = new BaseService();
            var    sys_AllSetting = new Sys_AllSettingEntity();
            string status         = string.Empty;
            var    lstEntity      = service.GetData <Sys_AllSettingEntity>(key, ConstantSql.hrm_sys_sp_get_AllSettingByKey, string.Empty, ref status);

            if (lstEntity != null)
            {
                sys_AllSetting = lstEntity.FirstOrDefault();
            }
            return(sys_AllSetting);
        }
예제 #6
0
 /// <summary>
 /// Lấy toàn bộ data theo store
 /// </summary>
 /// <returns></returns>
 public string GetSubmenu(string name, string key, Guid user)
 {
     using (var context = new VnrHrmDataContext())
     {
         var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
         var repo       = new Sys_AllSettingRepository(unitOfWork);
         Sys_AllSettingEntity entity = new Sys_AllSettingEntity();
         entity.Name   = name;
         entity.Value1 = key;
         entity.UserID = user;
         var result = string.Empty;// repo.GetSubMenu(entity);
         return(result);
     }
 }