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