public HttpWebResponse getAllitems()
{
HttpWebResponse allItems = sendRequest(Constants.Urls.GET_LISTS_URL, HttpMethod.GET);
SendToOutput.SendHttpResponse(allItems);
return(allItems);
}
public HttpWebResponse createItems(string userName, string taskName, string taskDate)
{
string taskjsonBody = string.Format("{0}\"{2}\":{0}\"{3}\":\"{4}\"{1}{1}", "{", "}", userName, taskName, taskDate);
HttpWebResponse createItem = sendRequest(Constants.Urls.CREATE_LISTS_URL, HttpMethod.POST, taskjsonBody);
SendToOutput.SendHttpResponse(createItem);
return(createItem);
}
public List <Dictionary <string, object> > getUniqueTask(string taskName, DateTime taskDate)
{
List <Dictionary <string, object> > uniqueTask = new List <Dictionary <string, object> >();
try
{
DataTable Tasks = this.executeQuery(String.Format("SELECT * FROM LISTS WHERE NAME = '{0}' AND DATE = '{1}'", taskName, taskDate.ToString("yyyy-MM-dd")));
SendToOutput.SendSQLResponse(Tasks);
uniqueTask = this.serializeResult(Tasks);
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
return(uniqueTask);
}
public List <Dictionary <string, object> > getAllTasks()
{
List <Dictionary <string, object> > allTasks = new List <Dictionary <string, object> >();
try
{
DataTable Tasks = this.executeQuery(String.Format("SELECT * FROM LISTS"));
if (Tasks.Rows.Count == 0)
{
Console.WriteLine("Table is empty");
}
else
{
SendToOutput.SendSQLResponse(Tasks);
}
allTasks = this.serializeResult(Tasks);
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
allTasks = null;
}
return(allTasks);
}
/// <summary>
/// Activates the modules operations
/// </summary>
public override void Run()
{
SendToOutput?.Invoke("I am running!");
}
