public CommodityAnalysisModel GetList() { try { using (db = new IEDEntities()) { var commoAnaModel = new CommodityAnalysisModel(); var commoAnalysis = (from x in db.T_CommodityAnalysis where !x.IsDeleted && x.ObjectType == (int)eObjectType.isCommodity select new ProAnaModel() { Id = x.Id, Name = x.Name, Node = x.Node, ObjectId = x.ObjectId, ObjectType = x.ObjectType, ParentId = x.ParentId, Description = x.Description, CreatedDate = x.CreatedDate }); if (commoAnalysis != null) { commoAnaModel.CommoAna.AddRange(commoAnalysis); commoAnaModel.years.AddRange(commoAnalysis.Select(x => x.CreatedDate.Month).Distinct()); } return(commoAnaModel); } } catch (Exception ex) { throw ex; } }
public double CalculationMachineTMU(int equipmentId, int equipmentType, float distance, double stopPrecision, int applyPressure, double natureCut) { try { using (db = new IEDEntities()) { var eAtrr = db.T_EquipmentAttribute.FirstOrDefault(x => !x.IsDeleted && x.EquipmentId == equipmentId); double machineTMU = 0; if (equipmentType == (int)eEquipType_Default.isSewingMachine) { // tinh theo cong thuc may may var RPM = double.Parse(eAtrr.Column1); var St = double.Parse(eAtrr.Column2); var BST = (St / (RPM * 0.0006)); var SST = (BST * distance) + 18 + stopPrecision; machineTMU = SST; } else { // tinh theo cong thuc may cat var F = applyPressure; var CT = natureCut; var Weight = double.Parse(eAtrr.Column1); var BCT = Math.Sqrt((Weight * 0.01) / applyPressure) * 27.8; var C = (BCT * natureCut * distance) + stopPrecision; machineTMU = C; } return(Math.Round(machineTMU, 3)); } } catch (Exception ex) { throw ex; } }
private bool CheckExists(string name, string code, int Id, int CompanyId, IEDEntities db) { try { T_WorkShop objectExists = null; if (!string.IsNullOrEmpty(name)) { objectExists = db.T_WorkShop.FirstOrDefault(c => !c.IsDeleted && c.Id != Id && c.CompanyId == CompanyId && c.Name.Trim().ToUpper().Equals(name.Trim().ToUpper())); } else { objectExists = db.T_WorkShop.FirstOrDefault(c => !c.IsDeleted && c.Id != Id && c.CompanyId == CompanyId && c.Code.Trim().ToUpper().Equals(code.Trim().ToUpper())); } if (objectExists == null) { return(false); } return(true); } catch (Exception ex) { throw ex; } }
public List <ModelSelectItem> GetListEquipmentType() { try { using (db = new IEDEntities()) { List <ModelSelectItem> listModelSelect = new List <ModelSelectItem>(); listModelSelect.Add(new ModelSelectItem() { Value = 0, Name = "- - Chọn Loại Thiết Bị - -" }); listModelSelect.AddRange(db.T_EquipmentType.Where(x => !x.IsDeleted).Select(x => new ModelSelectItem() { Value = x.Id, Name = x.Name, Data = x.EquipTypeDefaultId ?? 0, //Code = x.Code })); return(listModelSelect); } } catch (Exception ex) { throw ex; } }
public List<ModelSelectItem> GetListTimeTypePrepareSelect(int CompanyId, int[] relationCompanyIds) { try { using (db = new IEDEntities()) { var timeType = db.T_TimeTypePrepare.Where(x => !x.IsDeleted); if (timeType != null && timeType.Count() > 0) { return timeType.Select( x => new ModelSelectItem() { Value = x.Id, Name = x.Name }).ToList(); } else return new List<ModelSelectItem>(); } } catch (Exception ex) { throw ex; } }
public ResponseBase ChangeInfo(int userId, string mail, string first, string last) { ResponseBase rs = new ResponseBase(); try { using (var db = new IEDEntities()) { SUser user = db.SUsers.FirstOrDefault(x => x.Id == userId && !x.IsDeleted); if (user == null) { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "change info", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại." }); } else { user.Email = mail; user.FisrtName = first; user.LastName = last; user.UpdatedUser = userId; user.UpdatedDate = DateTime.Now; db.SaveChanges(); rs.IsSuccess = true; } } } catch (Exception ex) { throw ex; } return(rs); }
public List <ModelFeature> GetListFeatureByListRoleId(List <int> listRoleId, IEDEntities db) { List <ModelFeature> listFeature = null; try { if (listRoleId != null && listRoleId.Count > 0) { var featureIds = (from x in db.SRolePermissions where !x.IsDeleted && !x.SFeature.IsDeleted && !x.SFeature.SModule.IsDeleted && listRoleId.Contains(x.RoleId) select x.FeatureId).Distinct(); if (featureIds != null) { listFeature = (from c in db.SFeatures where featureIds.Contains(c.Id) select new ModelFeature() { Id = c.Id, FeatureName = c.FeatureName, SystemName = c.SystemName, ModuleId = c.ModuleId, IsDefault = c.IsDefault }).ToList(); } } } catch (Exception ex) { throw ex; } return(listFeature); }
public PagedList <TimePrepareModel> Gets(int timeTypeId, int startIndexRecord, int pageSize, string sorting) { try { using (db = new IEDEntities()) { if (string.IsNullOrEmpty(sorting)) { sorting = "Id DESC"; } var pageNumber = (startIndexRecord / pageSize) + 1; var timeTypes = db.T_TimePrepare.Where(x => !x.IsDeleted && x.TimeTypePrepareId == timeTypeId && !x.T_TimeTypePrepare.IsDeleted).OrderByDescending(x => x.CreatedDate). Select(x => new TimePrepareModel() { Id = x.Id, Name = x.Name, Code = x.Code, TimeTypePrepareId = x.TimeTypePrepareId, TimeTypePrepareName = x.T_TimeTypePrepare.Name, TMUNumber = x.TMUNumber, Description = x.Description, }).OrderBy(sorting).ToList(); return(new PagedList <TimePrepareModel>(timeTypes, pageNumber, pageSize)); } } catch (Exception ex) { throw ex; } }
private bool CheckExists(string keyword, int id, bool isCheckName, IEDEntities db) { try { T_TimeTypePrepare timeType = null; keyword = keyword.Trim().ToUpper(); if (isCheckName) { timeType = db.T_TimeTypePrepare.FirstOrDefault(x => !x.IsDeleted && x.Id != id && x.Name.Trim().ToUpper().Equals(keyword)); } else { timeType = db.T_TimeTypePrepare.FirstOrDefault(x => !x.IsDeleted && x.Id != id && x.Code.Trim().ToUpper().Equals(keyword)); } if (timeType == null) { return(false); } return(true); } catch (Exception ex) { throw ex; } }
public List <T_File> GetManipulationFileById(int Id) { try { using (db = new IEDEntities()) { var filesID = db.T_ManipulationFile.Where(x => !x.IsDeleted && x.ManipulationId == Id && !x.T_ManipulationLibrary.IsDeleted && !x.T_File.IsDeleted).Select(x => x.FileId).ToList(); if (filesID != null && filesID.Count > 0) { var files = db.T_File.Where(x => !x.IsDeleted && filesID.Contains(x.Id)).ToList(); if (files != null && files.Count() > 0) { return(files.ToList()); } return(null); } else { return(null); } } } catch (Exception ex) { throw ex; } }
public ResponseBase GetAllManipulation() { var result = new ResponseBase(); try { using (db = new IEDEntities()) { var list = db.T_ManipulationLibrary.Where(x => !x.IsDeleted && !x.T_ManipulationTypeLibrary.IsDeleted).Select(x => new ManipulationLibraryModel() { Id = x.Id, Code = x.Code, Name = x.Name, Description = x.Description, ManipulationTypeId = x.ManipulationTypeId, isUseMachine = x.T_ManipulationTypeLibrary.IsUseMachine, StandardTMU = x.StandardTMU, UserTMU = x.UserTMU }); if (list != null && list.Count() > 0) { result.Data = list.ToList(); } result.IsSuccess = true; } } catch (Exception ex) { throw ex; } return(result); }
public PagedList <ManipulationEquipmentModel> GetManipulationEquipment(int Id, int startIndexRecord, int pageSize, string sorting) { try { using (db = new IEDEntities()) { if (string.IsNullOrEmpty(sorting)) { sorting = "Id DESC"; } var manis = db.T_ManipulationEquipment.Where(x => !x.IsDeleted && x.ManipulationId == Id).OrderByDescending(x => x.CreatedDate).Select(x => new ManipulationEquipmentModel() { Id = x.Id, ManipulationId = x.ManipulationId, MachineTMU = x.MachineTMU, UserTMU = x.UserTMU, Note = x.Note, EquipmentId = x.EquipmentId, EquipmentName = x.T_Equipment.Name }).OrderBy(sorting).ToList(); var pageNumber = (startIndexRecord / pageSize) + 1; return(new PagedList <ManipulationEquipmentModel>(manis, pageNumber, pageSize)); } } catch (Exception ex) { throw ex; } }
public PagedList <LabourDivisionModel> GetList(int parentId, int startIndexRecord, int pageSize, string sorting) { try { using (db = new IEDEntities()) { if (string.IsNullOrEmpty(sorting)) { sorting = "CreatedDate ASC"; } var objs = db.T_LabourDivision.Where(c => !c.IsDeleted && c.ParentId == parentId).OrderByDescending(x => x.CreatedDate).Select(x => new LabourDivisionModel() { Id = x.Id, LineId = x.LineId, LineName = x.T_Line.Name, WorkShopId = x.T_Line.WorkShopId, WorkShopName = string.Empty, TechProVer_Id = x.TechProVer_Id, ParentId = x.ParentId, LastEditer = x.UpdatedUser != null ? x.SUser1.UserName : x.SUser.UserName, LastEditTime = x.UpdatedDate != null ? x.UpdatedDate.Value : x.CreatedDate, TotalPosition = x.TotalPosition }).ToList(); var pageNumber = (startIndexRecord / pageSize) + 1; return(new PagedList <LabourDivisionModel>(objs, pageNumber, pageSize)); } } catch (Exception ex) { throw ex; } }
public ResponseBase Delete(int Id) { ResponseBase rs; try { using (db = new IEDEntities()) { rs = new ResponseBase(); var obj = Get(Id); if (obj != null) { obj.IsDeleted = true; db.SaveChanges(); rs.IsSuccess = true; } else { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "Delete", Message = "Đối Tượng Đã Bị Xóa. Vui Lòng Kiểm Tra Lại" }); } } } catch (Exception ex) { throw ex; } return(rs); }
public ResponseBase Delete(int id, int userId) { ResponseBase result; try { result = new ResponseBase(); using (var db = new IEDEntities()) { var menuObj = db.SMenus.FirstOrDefault(x => x.Id == id && !x.IsDeleted); if (menuObj == null) { result.IsSuccess = false; result.Errors.Add(new Error() { MemberName = "DeleteMenu", Message = "Menu đang thao tác không tồn tại. Vui lòng kiểm tra lại!" }); } else { menuObj.IsDeleted = true; menuObj.DeletedUser = userId; menuObj.DeletedDate = DateTime.Now; db.Entry <SMenu>(menuObj).State = EntityState.Modified; db.SaveChanges(); result.IsSuccess = true; } } } catch (Exception ex) { throw ex; } return(result); }
public List <ModelSelectItem> GetListTimeTypePrepareByworkShopId(int id) { try { using (db = new IEDEntities()) { var timeType = db.T_TimeTypePrepare.Where(x => !x.IsDeleted && x.IsPublic); if (timeType != null && timeType.Count() > 0) { return(timeType.Select( x => new ModelSelectItem() { Value = x.Id, Name = x.Name }).ToList()); } else { return(new List <ModelSelectItem>()); } } } catch (Exception ex) { throw ex; } }
public ResponseBase Delete(int accountId, int actionUserId) { ResponseBase rs = null; try { using (var db = new IEDEntities()) { rs = new ResponseBase(); SUser user = db.SUsers.FirstOrDefault(x => x.Id == accountId && !x.IsDeleted); if (user != null) { user.IsDeleted = true; user.DeletedUser = actionUserId; user.DeletedDate = DateTime.Now; db.SaveChanges(); rs.IsSuccess = true; } else { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "Delete Account", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại!" }); } } } catch (Exception ex) { throw ex; } return(rs); }
public PagedList <ModelEquipmentTypeAttribute> GetList(int startIndexRecord, int pageSize, string sorting, int equipmentTypeId) { try { using (db = new IEDEntities()) { if (string.IsNullOrEmpty(sorting)) { sorting = "CreatedDate DESC"; } var objs = db.T_EquipmentTypeAttribute.Where(c => !c.IsDeleted && c.EquipmentTypeId == equipmentTypeId).OrderByDescending(x => x.CreatedDate).Select(c => new ModelEquipmentTypeAttribute() { Id = c.Id, OrderIndex = c.OrderIndex, IsUseForTime = c.IsUseForTime, EquipmentTypeId = c.EquipmentTypeId, EquipmentTypeName = c.T_EquipmentType.Name, Name = c.Name, IsDefault = c.IsDefault, }).ToList(); var pageNumber = (startIndexRecord / pageSize) + 1; return(new PagedList <ModelEquipmentTypeAttribute>(objs, pageNumber, pageSize)); } } catch (Exception ex) { throw ex; } }
public List <ModelModule> GetListModuleByListRoleId(List <int> listRoleId, IEDEntities db) { List <ModelModule> listModule = null; try { if (listRoleId != null && listRoleId.Count > 0) { var moduleIds = (from x in db.SRolePermissions where listRoleId.Contains(x.RoleId) && !x.IsDeleted && !x.SModule.IsDeleted && x.SModule.IsShow && x.SModule.IsSystem select x.ModuleId).Distinct(); if (moduleIds != null) { listModule = (from c in db.SModules where moduleIds.Contains(c.Id) select new ModelModule() { Id = c.Id, IsSystem = c.IsSystem, SystemName = c.SystemName, ModuleName = c.ModuleName, ModuleUrl = c.ModuleUrl, OrderIndex = c.OrderIndex, Description = c.Description }).OrderBy(x => x.OrderIndex).ToList(); } } } catch (Exception ex) { throw ex; } return(listModule); }
public List <ModelEquipmentTypeAttribute> GetEquipmentTypeAttributeByEquipmentTypeId(int equipmentTypeId) { List <ModelEquipmentTypeAttribute> equipmentTypeAttributes = null; try { using (db = new IEDEntities()) { equipmentTypeAttributes = db.T_EquipmentTypeAttribute.Where(c => !c.IsDeleted && c.EquipmentTypeId == equipmentTypeId).Select(c => new ModelEquipmentTypeAttribute() { Id = c.Id, Name = c.Name, EquipmentTypeId = c.EquipmentTypeId, EquipmentTypeName = c.T_EquipmentType.Name, OrderIndex = c.OrderIndex, IsDefault = c.IsDefault, IsUseForTime = c.IsUseForTime, }).OrderBy(x => x.OrderIndex).ToList(); } } catch (Exception ex) { throw ex; } return(equipmentTypeAttributes); }
public ResponseBase DeleteById(int id, int userId) { ResponseBase rs; try { using (db = new IEDEntities()) { rs = new ResponseBase(); var obj = db.T_EquipmentType.FirstOrDefault(c => !c.IsDeleted && c.Id == id); if (obj != null) { obj.IsDeleted = true; obj.DeletedUser = userId; obj.DeletedDate = DateTime.Now; db.SaveChanges(); rs.IsSuccess = true; } else { rs.IsSuccess = false; rs.Errors.Add(new Error() { MemberName = "Delete", Message = "Đối Tượng Đã Bị Xóa,Vui Lòng Kiểm Tra Lại" }); } } } catch (Exception ex) { throw ex; } return(rs); }
public void ChangeIsDefaultSatusOfListConfigByTableNameAndCompanyIdNotObjectId(string tableName, int companyId, int objectId, int actionUser) { using (var db = new IEDEntities()) { try { var listConfig = (from x in db.SConfigs where x.ConpanyId == companyId && x.TableName.Equals(tableName) && x.IsDefault && !x.IsDeleted && x.ObjectId != objectId select x); if (listConfig != null) { foreach (var config in listConfig) { config.IsDefault = false; config.UpdatedUser = actionUser; config.UpdatedDate = DateTime.Now; db.Entry <SConfig>(config).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } } catch (Exception ex) { throw ex; } } }
public List <ModelSelectItem> GetListEquipmentTypeDefault() { try { using (db = new IEDEntities()) { List <ModelSelectItem> objs = new List <ModelSelectItem>(); objs.Add(new ModelSelectItem() { Value = 0, Name = "-- Chọn mã bộ phận --" }); objs.AddRange(db.T_EquipType_Default.Select(x => new ModelSelectItem() { Value = x.Id, Name = x.Name })); objs.Add(new ModelSelectItem() { Value = 0, Name = "Khác" }); return(objs); } } catch (Exception ex) { throw ex; } }
public List <ModelConfig> GetListModelConfigByTableNameAndCompanyId(string tableName, int companyId) { using (var db = new IEDEntities()) { try { List <ModelConfig> listConfig = null; listConfig = (from c in db.SConfigs where !c.IsDeleted && c.TableName == tableName && c.ConpanyId == companyId select new ModelConfig() { Id = c.Id, TableName = c.TableName, ObjectId = c.ObjectId, IsHidden = c.IsHidden, IsDefault = c.IsDefault }).ToList(); return(listConfig); } catch (Exception ex) { throw ex; } } }
public ResponseBase Delete(int Id, int actionUserId, int companyId) { ResponseBase result; try { using (db = new IEDEntities()) { result = new ResponseBase(); var obj = db.HR_Employee.Where(c => c.CompanyId == companyId && !c.IsDeleted && c.Id == Id).FirstOrDefault(); if (obj == null) { result.IsSuccess = false; result.Errors.Add(new Error() { MemberName = "Delete", Message = "Dữ liệu đang thao tác không tồn tại. Vui lòng kiểm tra lại!" }); } else { obj.IsDeleted = true; obj.DeletedUser = actionUserId; obj.DeletedDate = DateTime.Now; db.SaveChanges(); result.IsSuccess = true; } } } catch (Exception ex) { throw ex; } return(result); }
public ResponseBase Delete(int id, int acctionUserId) { try { using (db = new IEDEntities()) { var result = new ResponseBase(); var obj = db.T_Customer.FirstOrDefault(x => !x.IsDeleted && x.Id == id); if (obj == null) { result.IsSuccess = false; result.Errors.Add(new Error() { MemberName = "Delete Customer Type", Message = "Khách hàng bạn đang thao tác đã bị xóa hoặc không tồn tại. Vui lòng kiểm tra lại !." }); } else { obj.IsDeleted = true; obj.DeletedUser = acctionUserId; obj.DeletedDate = DateTime.Now; db.SaveChanges(); result.IsSuccess = true; } return(result); } } catch (Exception ex) { throw ex; } }
public List <ModelSelectItem> GetListWorkShop() { try { using (db = new IEDEntities()) { List <ModelSelectItem> objs = new List <ModelSelectItem>(); var workshops = db.T_WorkShop.Where(x => !x.IsDeleted).Select(x => new ModelSelectItem() { Value = x.Id, Name = x.Name }); if (workshops != null && workshops.Count() > 0) { objs.AddRange(workshops); } else { objs.Add(new ModelSelectItem() { Value = 0, Name = " Không có Dữ Liệu " }); } return(objs); } } catch (Exception ex) { throw ex; } }
public PagedList <CustomerModel> GetList(string keyWord, int companyId, int[] relationCompanyId, int startIndexRecord, int pageSize, string sorting) { try { using (db = new IEDEntities()) { if (string.IsNullOrEmpty(sorting)) { sorting = "CreatedDate DESC"; } List <CustomerModel> CustomerTypes = null; if (string.IsNullOrEmpty(keyWord)) { CustomerTypes = GetAll(sorting, companyId, relationCompanyId); } else { CustomerTypes = GetByKeyword(keyWord, companyId, relationCompanyId, sorting); } var pageNumber = (startIndexRecord / pageSize) + 1; return(new PagedList <CustomerModel>(CustomerTypes, pageNumber, pageSize)); } } catch (Exception ex) { throw ex; } }
public List <ModelSelectItem> GetUserRolesModelByUserId(int userId, bool IsOwner, int companyId) { List <ModelSelectItem> roles = null; try { using (db = new IEDEntities()) { if (IsOwner) { roles = db.SRoLes.Where(x => !x.IsDeleted && x.CompanyId == companyId).Select(x => new ModelSelectItem() { Name = x.RoleName, Value = x.Id }).ToList(); } else { roles = db.SUserRoles.Where(x => !x.IsDeleted && x.UserId == userId).Select(x => new ModelSelectItem() { Name = x.SRoLe.RoleName, Value = x.SRoLe.Id }).ToList(); } return(roles); } } catch (Exception ex) { throw ex; } }
public List <ModelSelectItem> GetSelectItem(int companyId, int[] relationCompanyId) { try { using (db = new IEDEntities()) { var listModelSelect = new List <ModelSelectItem>(); var productTypes = db.T_ProductGroup.Where(x => !x.IsDeleted && (x.CompanyId == null || x.CompanyId == companyId || relationCompanyId.Contains(x.CompanyId ?? 0))) .OrderByDescending(x => x.CreatedDate) .Select( x => new ModelSelectItem() { Value = x.Id, Name = x.Name }).ToList(); //if (productTypes != null && productTypes.Count() > 0) //{ // listModelSelect.Add(new ModelSelectItem() { Value = 0, Name = " - - Chọn nhóm mã hàng - - " }); listModelSelect.AddRange(productTypes); //} //else // listModelSelect.Add(new ModelSelectItem() { Value = 0, Name = " Không có nhóm mã hàng " }); return(listModelSelect); } } catch (Exception ex) { throw ex; } }