public JArray GetProfileHistory(string engNum, string usrId, WsActivityType? wsActivityType = null, WsActivityType? wsActivitySubType = null) { var result = AuditManager.Rep.AuditManagerDb.GetProfileHistory(engNum, usrId, wsActivityType, wsActivitySubType); if (result == null) return null; var retModel = JArray.FromObject(result); return retModel; }
public JArray GetClosureReport(DateTime fromD, DateTime toD, WsActivityType? wsActivityType = null, WsActivityType? wsActivitySubType = null) { var result = AuditManager.Rep.AuditManagerDb.GetClosureReport(fromD, toD, wsActivityType, wsActivitySubType); if (result == null) return null; var retModel = JArray.FromObject(result); return retModel; }
public JArray GetWsActivityHistory(string engNum, string usrId, WsActivityType wsActivityType, WsActivityType?wsActivitySubType = null) { var result = AuditManager.Rep.AuditManagerDb.GetWsActivityHistory(engNum, usrId, wsActivityType, wsActivitySubType); if (result == null) { return(null); } var retModel = JArray.FromObject(result); return(retModel); }
public static List<WsActivityHistory> GetClosureHistory(string engNum, string usrId, WsActivityType? wsActivityType = null, WsActivityType? wsActivitySubType = null) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { List<WsActivityHistory> actHist = null; if (string.IsNullOrWhiteSpace(engNum) && string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == WsActivityType.CLOSURE_INITIATE && x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase) && x.UserId.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(engNum) && !string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == WsActivityType.CLOSURE_INITIATE ).ToList(); } else if (!string.IsNullOrWhiteSpace(engNum)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == WsActivityType.CLOSURE_INITIATE && x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == WsActivityType.CLOSURE_INITIATE && x.UserId.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } //return actHist.OrderByDescending(x => x.DateCreated).ThenByDescending(x => x.EngNum).ToList(); return actHist.OrderByDescending(x => x.DateCreated).ToList(); } } }
public static List<WsActivityHistory> GetClosureReport(DateTime fromD, DateTime toD, WsActivityType? wsActivityType = null, WsActivityType? wsActivitySubType = null) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { List<WsActivityHistory> actHist = null; toD = toD.AddDays(1); actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == WsActivityType.CLOSURE_INITIATE && x.DateCreated >= fromD && x.DateCreated <= toD).ToList(); return actHist.OrderByDescending(x => x.DateCreated).ToList(); } } }
public static dynamic GetClosurePastDue(int days, WsActivityType mailTypeEnum) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { var result = db.Set<WsActivityHistory>().Where( x => ( x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == mailTypeEnum && x.DateCreated <= DbFunctions.AddDays(DateTime.Now, -(days)) )).Select(x => new { EngNum = x.EngNum //, RecepientArray = x }).ToList(); var dynamicResult = result.Select(x => x.ToDynamic()).ToList(); return dynamicResult; } } }
public static dynamic GetClosurePastDue(int days, WsActivityType mailTypeEnum) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { var result = db.Set <WsActivityHistory>().Where( x => ( x.WsActivityTypeId == WsActivityType.CLOSURE && x.WsSubActivityTypeId == mailTypeEnum && x.DateCreated <= DbFunctions.AddDays(DateTime.Now, -(days)) )).Select(x => new { EngNum = x.EngNum //, RecepientArray = x }).ToList(); var dynamicResult = result.Select(x => x.ToDynamic()).ToList(); return(dynamicResult); } } }
public static List<WsFloatingField> GetProfileHistory(string engNum, string usrId, WsActivityType? wsActivityType = null, WsActivityType? wsActivitySubType = null) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { List<WsFloatingField> profHist = null; if (string.IsNullOrWhiteSpace(engNum) && string.IsNullOrWhiteSpace(usrId)) { profHist = db.WsFloatingField.Where(x => x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase) && x.EnteredBy.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(engNum) && !string.IsNullOrWhiteSpace(usrId)) { profHist = db.WsFloatingField.ToList(); } else if (!string.IsNullOrWhiteSpace(engNum)) { profHist = db.WsFloatingField.Where(x => x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(usrId)) { profHist = db.WsFloatingField.Where(x => x.EnteredBy.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } //return profHist.OrderByDescending(x => x.EngNum).ThenByDescending(x => x.EnteredDate).ToList(); return profHist.OrderByDescending(x => x.EnteredDate).ToList(); } } }
public static List <WsActivityHistory> GetWsActivityHistory(string engNum, string usrId, WsActivityType wsActivityType, WsActivityType?wsActivitySubType = null) { using (var db = new AmDbContext()) { using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted)) { List <WsActivityHistory> actHist = null; if (string.IsNullOrWhiteSpace(engNum) && string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == wsActivityType && //x.WsSubActivityTypeId == wsActivitySubType && x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase) && x.UserId.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(engNum) && !string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == wsActivityType //&& x.WsSubActivityTypeId == wsActivitySubType ).ToList(); } else if (!string.IsNullOrWhiteSpace(engNum)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == wsActivityType && //x.WsSubActivityTypeId == wsActivitySubType && x.EngNum.Equals(engNum, StringComparison.OrdinalIgnoreCase)).ToList(); } else if (!string.IsNullOrWhiteSpace(usrId)) { actHist = db.WsActivityHistory.Include("WsActivity").Include("WsSubActivity").Where(x => x.WsActivityTypeId == wsActivityType && //x.WsSubActivityTypeId == wsActivitySubType && x.UserId.Equals(usrId, StringComparison.OrdinalIgnoreCase)).ToList(); } //return actHist.OrderByDescending(x => x.DateCreated).ThenByDescending(x => x.EngNum).ToList(); return(actHist.OrderByDescending(x => x.DateCreated).ToList()); } } }