public IHttpActionResult DailyReport()
{
DataService Service = new DataService();
try
{
ReportBoot result = Service.DailyReport();
return(Ok(result));
}
catch (Exception ex)
{
return(Exception(ex.Message));
}
}
public IHttpActionResult ReportBoot(String Start, String End)
{
DataService Service = new DataService();
try
{
ReportBoot result = Service.ReportBoot(Start, End);
return(Ok(result));
}
catch (Exception ex)
{
return(Exception(ex.Message));
}
}
public ReportBoot ReportBoot(String Start, String End)
{
CultureInfo provider = CultureInfo.InvariantCulture;
DateTime StartDate = DateTime.ParseExact(Start, "yyyy-MM-dd", null);
DateTime EndDate = DateTime.ParseExact(End, "yyyy-MM-dd", null);
int S = db.Articles.Where(o => o.CreatedAt >= StartDate).Count();
int E = db.Articles.Where(o => o.CreatedAt > EndDate).Count();
List <Article> Success = db.Articles
.SqlQuery("select * from Articles where CreatedAt >=' " + Start + " '")
.ToList();
int Ok = 0;
int NotYet = 0;
int Error = 0;
foreach (Article Ar in Success)
{
DateTime Artime = (DateTime)Ar.EditedAt;
if ((Ar.Status.ToString().Equals("ACTIVE")) && (Ar.EditedAt != null) && (DateTime.Compare(Artime, EndDate) < 0))
{
Ok++;
}
if ((Ar.Status.ToString().Equals("INITIAL")) && (Ar.EditedAt != null) && (DateTime.Compare(Artime, EndDate) < 0))
{
NotYet++;
}
if ((Ar.Status.ToString().Equals("DEACTIVE")) && (Ar.EditedAt != null) && (DateTime.Compare(Artime, EndDate) < 0))
{
Error++;
}
}
Debug.WriteLine("total: " + (S - E));
ReportBoot result = new ReportBoot()
{
TotalUrl = S - E,
Success = Ok,
Error = Error,
NotYet = NotYet,
};
return(result);
}
public ReportBoot DailyReport()
{
Debug.WriteLine("===Start DailyReport===");
String DateNow = DateTime.Now.ToString("yyyy/MM/dd");
Debug.WriteLine("report at: " + DateNow);
int T = db.Articles.SqlQuery("select * from Articles where CreatedAt >= '" + DateNow + "'").Count();
Debug.WriteLine("sql: " + T);
int S = db.Articles.SqlQuery("select * from Articles where CreatedAt >= '" + DateNow + "' and status=2").Count();
int E = db.Articles.SqlQuery("select * from Articles where CreatedAt >= '" + DateNow + "' and status=0").Count();
int N = db.Articles.SqlQuery("select * from Articles where CreatedAt >= '" + DateNow + "' and status=1").Count();
ReportBoot result = new ReportBoot()
{
TotalUrl = T,
Success = S,
Error = E,
NotYet = N,
};
return(result);
}
