public static List<DALRoleAssignment> GetUserRoles(int userId) { var retVal = new List<DALRoleAssignment>(); using (var context = new ISGAdminEntities()) { var roleAssignments = context.RoleAssignments.Where(f => f.UserId == userId).ToList(); if (!roleAssignments.Any()) { return retVal; } // ReSharper disable once LoopCanBeConvertedToQuery foreach (var ra in roleAssignments) { retVal.Add(new DALRoleAssignment { InstanceId = ra.InstanceId, RoleId = ra.RoleId, Status = ra.Status }); } } return retVal; }
public static List<DALRoleMapping> GetRoleMappings(int functionId) { var retVal = new List<DALRoleMapping>(); using (var context = new ISGAdminEntities()) { var user = context.RoleMappings.Where(f => f.FunctionId == functionId).ToList(); if (!user.Any()) { return retVal; } // ReSharper disable once LoopCanBeConvertedToQuery foreach (var u in user) { retVal.Add(new DALRoleMapping { InstanceId = u.InstanceId, RoleId = u.RoleId, FunctionId = u.FunctionId, Status = u.Status }); } } return retVal; }
public static List<DALExcelValidationRecord> GetAllExcelValidationRecords() { List<DALExcelValidationRecord> rtrn = null; using (var context = new ISGAdminEntities()) { var excelValidationRecords = context.ExcelValidationRecords; if (excelValidationRecords.Any()) { rtrn = TransformDBtoDALExcelValidationRecords(excelValidationRecords.ToList()); } } return rtrn; }
public static List<DALExcelValidationRecord> GetExcelValidationRecordsByFileName(string fileName) { List<DALExcelValidationRecord> rtrn = null; using (var context = new ISGAdminEntities()) { var excelValidationRecords = context.ExcelValidationRecords.Where(x => string.Equals(x.FileName, fileName, StringComparison.CurrentCultureIgnoreCase)); if (excelValidationRecords.Any()) { rtrn = TransformDBtoDALExcelValidationRecords(excelValidationRecords.ToList()); } } return rtrn; }
public static List<DALYearQuarter> GetYearQuarters() { List<DALYearQuarter> rtrn = null; using (var context = new ISGAdminEntities()) { var yearQuarters = context.YearQuaters; foreach (var yearQuarter in yearQuarters) { rtrn = rtrn ?? new List<DALYearQuarter>(); rtrn.Add( new DALYearQuarter { Id = yearQuarter.Id, Quarter = yearQuarter.Quater, LastMonth = yearQuarter.LastMonth, EndDate = yearQuarter.EndDate }); } } return rtrn; }
public static void AddExcelValidationRecords(List<DALExcelValidationRecord> records) { using (var context = new ISGAdminEntities()) { records.ForEach( x => context.ExcelValidationRecords.Add( new ExcelValidationRecord { Code = x.Code, ExcelColumn = x.ExcelColumn, ExcelRow = x.ExcelRow, ExcelSheet = x.ExcelSheet, ExcelValidationDataType = context.ExcelValidationDataTypes.FirstOrDefault(y => y.Id == (int)x.ExcelValidationDataType), ExcelValidationResultType = context.ExcelValidationResultTypes.FirstOrDefault(y => y.Id == (int)x.ExcelValidationResultType), MaxStringLength = x.MaxStringLength, CreationDate = DateTime.Now, Message = x.Message, FileName = x.FileName, BadValue = x.BadValue })); context.SaveChanges(); } }
public static DALUser GetUser(string userName) { var retVal = new DALUser(); using (var context = new ISGAdminEntities()) { var user = context.Users.FirstOrDefault(f => string.Equals(f.Name, userName, StringComparison.CurrentCultureIgnoreCase)); if (user != null) { retVal = new DALUser { InstanceId = user.InstanceId, Name = user.Name, Password = user.Password, StartDate = user.StartDate, EndDate = user.EndDate, Status = user.Status }; } } return retVal; }