public JArray GetFileActivity(DateTime?fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNum = null, string usrId = null)
{
var result = AuditManager.Rep.WsActivity.GetActivity(fDate, tDate, activityFilterType, engNum, usrId);
var retModel = JArray.FromObject(result);
return(retModel);
}
public async Task <ActionResult <List <UserActivityDTO> > > GetActivities(string username, ActivityFilterType filter)
{
return(await this.Mediator.Send(new UserActivitiesQuery(username, filter)));
}
public UserActivitiesQuery(string username, ActivityFilterType filter)
{
this.Username = username;
this.Filter = filter;
}
public static List<FileActivityModel> GetActivity(DateTime? fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNum = null, string usrId = null)
{
var userWithWsUserType = IM.Mgr.WsUtility.GetAllWsForUserWithWsUserType(usrId);
var engNums = string.IsNullOrWhiteSpace(engNum) ? string.Join(",", userWithWsUserType.Select(x => x.Key).ToList()) : engNum;
List<FileActivityModel> result = new List<FileActivityModel>();
if (activityFilterType == ActivityFilterType.ALL
|| activityFilterType == ActivityFilterType.RET
|| activityFilterType == ActivityFilterType.RF)
{
var ssc_Activity = GetActivity_SSC(fDate, tDate, activityFilterType, engNums);
ssc_Activity.ForEach(x =>
{
x.WsUserType = userWithWsUserType.Where(y => y.Key == x.EngagementNumber).Select(z => z.Value).FirstOrDefault();
x.DocumentStatus = new DocumentStatus
{
ActionBy = x.ActionPerformedBy,
ActionDate = x.ActionPerformedOn,
DocumentNumber = x.DocNum,
DocumentType = x.RequestType,
FileIn = FileIn.SSC,
Status = x.Status,
UniqueId = x.FAID,
};
});
result.AddRange(ssc_Activity);
}
if (activityFilterType == ActivityFilterType.ALL
|| activityFilterType == ActivityFilterType.S2
|| activityFilterType == ActivityFilterType.S2_RET
|| activityFilterType == ActivityFilterType.S2_RF)
{
var s2_Activity = GetActivity_S2(fDate, tDate, activityFilterType, engNums);
s2_Activity.ForEach(x =>
{
x.WsUserType = userWithWsUserType.Where(y => y.Key == x.EngagementNumber).Select(z => z.Value).FirstOrDefault();
x.DocumentStatus = new DocumentStatus
{
ActionBy = x.ActionPerformedBy,
ActionDate = x.ActionPerformedOn,
DocumentNumber = x.DocNum,
DocumentType = x.RequestType,
FileIn = FileIn.S2,
Status = x.Status,
UniqueId = x.FAID,
};
});
result.AddRange(s2_Activity);
}
return result;
}
private static List<FileActivityModel> GetActivity_SSC(DateTime? fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNums)
{
using (var db = new SSCDbContext())
{
SqlParameter p1;
if (activityFilterType == ActivityFilterType.ALL)
{
p1 = new SqlParameter("@ActivityType", DBNull.Value);
}
else
{
p1 = new SqlParameter("@ActivityType", activityFilterType == ActivityFilterType.RET ? activityFilterType.ToEnumDesc() : activityFilterType.ToString());
}
SqlParameter p2 = new SqlParameter("@EngagementNumber", engNums);
SqlParameter p3 = new SqlParameter("@From_Dt", fDate.GetValueOrDefault().ToUTCAdjustment());
SqlParameter p4 = new SqlParameter("@To_Dt", tDate.ToUTCAdjustment());
var result = db.Database.SqlQuery<FileActivityModel>("EXEC spGetAllActivitiesByEngagements @ActivityType, @EngagementNumber, @From_Dt, @To_Dt",
p1, p2, p3, p4).ToList();
return result;
}
}
private static List<FileActivityModel> GetActivity_S2(DateTime? fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNums)
{
using (var db = new S2DbContext())
{
SqlParameter p1 = new SqlParameter("@ActivityType", DBNull.Value);
SqlParameter p2 = new SqlParameter("@EngagementNumber", engNums);
SqlParameter p3 = new SqlParameter("@From_Dt", fDate.GetValueOrDefault().ToUTCAdjustment());
SqlParameter p4 = new SqlParameter("@To_Dt", tDate.ToUTCAdjustment());
var result = db.Database.SqlQuery<FileActivityModel>("EXEC [S2CLR].spGetS2CActivitiesByEngagements @ActivityType, @EngagementNumber, @From_Dt, @To_Dt",
p1, p2, p3, p4).ToList();
return result;
}
}
public JArray GetFileActivity(DateTime? fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNum = null, string usrId = null)
{
var result = AuditManager.Rep.WsActivity.GetActivity(fDate, tDate, activityFilterType, engNum, usrId);
var retModel = JArray.FromObject(result);
return retModel;
}
private static List <FileActivityModel> GetActivity_S2(DateTime?fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNums)
{
using (var db = new S2DbContext())
{
SqlParameter p1 = new SqlParameter("@ActivityType", DBNull.Value);
SqlParameter p2 = new SqlParameter("@EngagementNumber", engNums);
SqlParameter p3 = new SqlParameter("@From_Dt", fDate.GetValueOrDefault().ToUTCAdjustment());
SqlParameter p4 = new SqlParameter("@To_Dt", tDate.ToUTCAdjustment());
var result = db.Database.SqlQuery <FileActivityModel>("EXEC [S2CLR].spGetS2CActivitiesByEngagements @ActivityType, @EngagementNumber, @From_Dt, @To_Dt",
p1, p2, p3, p4).ToList();
return(result);
}
}
private static List <FileActivityModel> GetActivity_SSC(DateTime?fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNums)
{
using (var db = new SSCDbContext())
{
SqlParameter p1;
if (activityFilterType == ActivityFilterType.ALL)
{
p1 = new SqlParameter("@ActivityType", DBNull.Value);
}
else
{
p1 = new SqlParameter("@ActivityType", activityFilterType == ActivityFilterType.RET ? activityFilterType.ToEnumDesc() : activityFilterType.ToString());
}
SqlParameter p2 = new SqlParameter("@EngagementNumber", engNums);
SqlParameter p3 = new SqlParameter("@From_Dt", fDate.GetValueOrDefault().ToUTCAdjustment());
SqlParameter p4 = new SqlParameter("@To_Dt", tDate.ToUTCAdjustment());
var result = db.Database.SqlQuery <FileActivityModel>("EXEC spGetAllActivitiesByEngagements @ActivityType, @EngagementNumber, @From_Dt, @To_Dt",
p1, p2, p3, p4).ToList();
return(result);
}
}
public static List <FileActivityModel> GetActivity(DateTime?fDate, DateTime tDate, ActivityFilterType activityFilterType, string engNum = null, string usrId = null)
{
var userWithWsUserType = IM.Mgr.WsUtility.GetAllWsForUserWithWsUserType(usrId);
var engNums = string.IsNullOrWhiteSpace(engNum) ? string.Join(",", userWithWsUserType.Select(x => x.Key).ToList()) : engNum;
List <FileActivityModel> result = new List <FileActivityModel>();
if (activityFilterType == ActivityFilterType.ALL ||
activityFilterType == ActivityFilterType.RET ||
activityFilterType == ActivityFilterType.RF)
{
var ssc_Activity = GetActivity_SSC(fDate, tDate, activityFilterType, engNums);
ssc_Activity.ForEach(x =>
{
x.WsUserType = userWithWsUserType.Where(y => y.Key == x.EngagementNumber).Select(z => z.Value).FirstOrDefault();
x.DocumentStatus = new DocumentStatus
{
ActionBy = x.ActionPerformedBy,
ActionDate = x.ActionPerformedOn,
DocumentNumber = x.DocNum,
DocumentType = x.RequestType,
FileIn = FileIn.SSC,
Status = x.Status,
UniqueId = x.FAID,
};
});
result.AddRange(ssc_Activity);
}
if (activityFilterType == ActivityFilterType.ALL ||
activityFilterType == ActivityFilterType.S2 ||
activityFilterType == ActivityFilterType.S2_RET ||
activityFilterType == ActivityFilterType.S2_RF)
{
var s2_Activity = GetActivity_S2(fDate, tDate, activityFilterType, engNums);
s2_Activity.ForEach(x =>
{
x.WsUserType = userWithWsUserType.Where(y => y.Key == x.EngagementNumber).Select(z => z.Value).FirstOrDefault();
x.DocumentStatus = new DocumentStatus
{
ActionBy = x.ActionPerformedBy,
ActionDate = x.ActionPerformedOn,
DocumentNumber = x.DocNum,
DocumentType = x.RequestType,
FileIn = FileIn.S2,
Status = x.Status,
UniqueId = x.FAID,
};
});
result.AddRange(s2_Activity);
}
return(result);
}
