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());
}
}
}
