public ResponseJson Delete(string token, string isFailed, ScheduleRequestLog scheduleLog)
{
if(AuthData.GetRole(token) != Role.Admin)
{
return ResponseJson.GetResponseJson(string.Empty, false);
}
int id = scheduleLog.ID;
if (id > 0)
{
if ("true".Equals(isFailed, StringComparison.OrdinalIgnoreCase))
{
DataProcess.DeleteScheduleFailedRequestLog(id);
}
else
{
DataProcess.DeleteScheduleRequestLog(id);
}
}
else
{
if ("true".Equals(isFailed, StringComparison.OrdinalIgnoreCase))
{
DataProcess.DeleteScheduleRequestLog(scheduleLog, true);
}
else
{
DataProcess.DeleteScheduleRequestLog(scheduleLog, false);
}
}
var resultObject = new { IsSuccess = true, Message = "Deleted"};
return ResponseJson.GetResponseJson(resultObject);
}
public static void DeleteScheduleRequestLog(ScheduleRequestLog scheduleLog, bool isFailRequest = false)
{
if (scheduleLog != null) SQLiteProcess.DeleteScheduleRequestLog(scheduleLog, isFailRequest);
}
public static List<ScheduleRequestLog> GetReportForCurrentDate(string fromDate, string toDate, bool isFailRequest = false)
{
List<ScheduleRequestLog> schedules = new List<ScheduleRequestLog>();
using (var sql_con = new SQLiteConnection(ReportConnectString))
{
sql_con.Open();
using (var sql_cmd = sql_con.CreateCommand())
{
sql_cmd.CommandText = "SELECT CurrentDate, SUM(NumberOfRequests) AS NumberOfRequests FROM " + (isFailRequest ? "ScheduleFailedRequestLogs" : "ScheduleRequestLogs") + " WHERE CurrentDate >= @fromDate AND CurrentDate <= @toDate GROUP BY CurrentDate ";
var myParameters = sql_cmd.Parameters;
myParameters.AddWithValue("@fromDate", fromDate);
myParameters.AddWithValue("@toDate", toDate);
using (var reader = sql_cmd.ExecuteReader())
{
while (reader.Read())
{
var scheduleRequestLog = new ScheduleRequestLog();
scheduleRequestLog.CurrentDate = (reader["CurrentDate"] ?? "").ToString();
scheduleRequestLog.NumberOfRequests = Int32.Parse((reader["NumberOfRequests"] ?? "").ToString());
schedules.Add(scheduleRequestLog);
}
}
}
sql_con.Close();
}
return schedules;
}
public static void DeleteScheduleRequestLog(ScheduleRequestLog scheduleLog, bool isFailRequest = false)
{
string where = (scheduleLog.ChannelKey == null ? "" : " AND ChannelKey=@ChannelKey") + (scheduleLog.CurrentDate == null ? "" : " AND CurrentDate=@CurrentDate") + (scheduleLog.DateOn == null ? "" : " AND DateOn=@DateOn") + (scheduleLog.DeviceId == null ? "" : " AND DeviceId=@DeviceId") + (scheduleLog.OpenKey == null ? "" : " AND OpenKey=@OpenKey") + (scheduleLog.AppVersion == null ? "" : " AND AppVersion=@AppVersion");
if (!string.IsNullOrWhiteSpace(where))
{
where = " WHERE" + where;
where = where.Replace("WHERE AND ", "WHERE ");
}
else
{
where = " WHERE ChannelKey=@ChannelKey AND CurrentDate=@CurrentDate AND DateOn=@DateOn AND DeviceId=@DeviceId AND OpenKey=@OpenKey AND AppVersion=@AppVersion ";
}
string sqlSaveChannel = "DELETE FROM " + (isFailRequest ? "ScheduleFailedRequestLogs" : "ScheduleRequestLogs") + " " + where;
using (var sql_con = new SQLiteConnection(ReportConnectString))
{
sql_con.Open();
using (var sql_cmd = sql_con.CreateCommand())
{
sql_cmd.CommandText = sqlSaveChannel;
var myParameters = sql_cmd.Parameters;
if (scheduleLog.ChannelKey != null) myParameters.AddWithValue("@ChannelKey", scheduleLog.ChannelKey);
if (scheduleLog.CurrentDate != null) myParameters.AddWithValue("@CurrentDate", scheduleLog.CurrentDate);
if (scheduleLog.DateOn != null) myParameters.AddWithValue("@DateOn", scheduleLog.DateOn);
if (scheduleLog.DeviceId != null) myParameters.AddWithValue("@DeviceId", scheduleLog.DeviceId);
if (scheduleLog.OpenKey != null) myParameters.AddWithValue("@OpenKey", scheduleLog.OpenKey);
if (scheduleLog.AppVersion != null) myParameters.AddWithValue("@AppVersion", scheduleLog.AppVersion);
sql_cmd.ExecuteNonQuery();
}
sql_con.Close();
}
}
public static List<ScheduleRequestLog> GetGroupScheduleRequestLogs(ReportFilter filter, bool isFailRequest = false)
{
if (filter == null) filter = new ReportFilter();
List<ScheduleRequestLog> schedules = new List<ScheduleRequestLog>();
using (var sql_con = new SQLiteConnection(ReportConnectString))
{
sql_con.Open();
using (var sql_cmd = sql_con.CreateCommand())
{
sql_cmd.CommandText = filter.GenSelectCommand(isFailRequest);
var myParameters = sql_cmd.Parameters;
using (var reader = sql_cmd.ExecuteReader())
{
while (reader.Read())
{
var scheduleRequestLog = new ScheduleRequestLog();
if (!filter.NoChannelKey || (filter.IsAllFalse)) scheduleRequestLog.ChannelKey = (reader["ChannelKey"] ?? "").ToString();
if (!filter.NoCurrentDate || (filter.IsAllFalse)) scheduleRequestLog.CurrentDate = (reader["CurrentDate"] ?? "").ToString();
if (!filter.NoDateOn || (filter.IsAllFalse)) scheduleRequestLog.DateOn = (reader["DateOn"] ?? "").ToString();
if (!filter.NoDeviceId || (filter.IsAllFalse)) scheduleRequestLog.DeviceId = (reader["DeviceId"] ?? "").ToString();
if (!filter.NoOpenKey || (filter.IsAllFalse)) scheduleRequestLog.OpenKey = (reader["OpenKey"] ?? "").ToString();
if (!filter.NoAppVersion || (filter.IsAllFalse)) scheduleRequestLog.AppVersion = (reader["AppVersion"] ?? "").ToString();
scheduleRequestLog.NumberOfRequests = Int32.Parse((reader["NumberOfRequests"] ?? "").ToString());
schedules.Add(scheduleRequestLog);
}
}
}
sql_con.Close();
}
return schedules;
}
