public BO.ServiceStatus <BO.TodoItem> Toggle([FromBody] BO.TodoItem param)
{
BO.ServiceStatus <BO.TodoItem> result = new Models.BO.ServiceStatus <BO.TodoItem>();
try
{
int id = param.ID;
//controllo presenza parametri
if (id == 0)
{
result.AddError("`id` in required");
}
if (result.Messages.Count == 0)
{
result.Data = Code.Manager.Toggle(id);
if (result.Data == null)
{
result.AddError("Error: not toggled");
}
else
{
result.AddSuccess("Toggled id: " + id.ToString());
result.Success = true;
}
}
}
catch (Exception ex)
{
result.AddError(ex);
}
return(result);
}
public BO.ServiceStatus Delete([FromBody] BO.TodoItem param)
{
BO.ServiceStatus result = new Models.BO.ServiceStatus();
try
{
//controllo presenza parametri
int id = param.ID;
if (id == 0)
{
result.AddError("`id` in required");
}
if (result.Messages.Count == 0)
{
int r = Code.Manager.Delete(id);
if (r == 0)
{
result.AddError("Error: not deleted");
}
else
{
result.AddSuccess("Deleted id: " + id.ToString());
result.Success = true;
}
}
}
catch (Exception ex)
{
result.AddError(ex);
}
return(result);
}
public BO.ServiceStatus Updarte([FromBody] BO.TodoItem param)
{
BO.ServiceStatus result = new Models.BO.ServiceStatus();
try
{
//controllo presenza parametri
if (param.ID == 0)
{
result.AddError("`id` in required");
}
//if (!req.body.hasOwnProperty('date')) result.addError('`date` required');
if (string.IsNullOrWhiteSpace(param.Title))
{
result.AddError("`title` required");
}
if (param.IDCategory == 0)
{
result.AddError("`idCategory` required");
}
if (result.Messages.Count == 0)
{
int id = param.ID;
DateTime date = param.Date;
string title = param.Title;
int idCategory = param.IDCategory;
string note = param.Note;
DateTime?completed = param.Completed;
int r = Code.Manager.Update(id, date, title, note, idCategory, completed);
if (r == 0)
{
result.AddError("Error: not updated");
}
else
{
result.AddSuccess("Updated: " + 1);
result.Success = true;
}
}
}
catch (Exception ex)
{
result.AddError(ex);
}
return(result);
}
public static BO.TodoItem Toggle(int id)
{
BO.TodoItem result = null;
//eseguo la query sul DB
using (SqlConnection cnn = GetConnection())
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = queries.Toggle + queries.Read;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cnn.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
BO.TodoItem item = new BO.TodoItem();
item.ID = (int)dr["ID"];
item.Date = (DateTime)dr["Date"];
item.Title = dr["Title"] == DBNull.Value ? "" : (string)dr["Title"];
item.Note = dr["Note"] == DBNull.Value ? "" : (string)dr["Note"];
item.IDCategory = (int)dr["IDCategory"];
item.Category = (string)dr["Category"];
if (dr["Completed"] != DBNull.Value)
{
item.Completed = (DateTime)dr["Completed"];
}
item.Created = (DateTime)dr["Created"];
item.Modified = (DateTime)dr["Modified"];
result = item;
}
}
}
}
return(result);
}
public static List <BO.TodoItem> Search(int startIndex, int pageSize, string text, int?idCategory, int?status, string sort)
{
List <BO.TodoItem> result = new List <BO.TodoItem>();
//eseguo la query sul DB
using (SqlConnection cnn = GetConnection())
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = queries.Search;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@startIndex", SqlDbType.Int).Value = startIndex;;
cmd.Parameters.Add("@pageSize", SqlDbType.Int).Value = pageSize;
SqlParameter pText = cmd.Parameters.Add("@text", SqlDbType.NVarChar, 100);
if (text != null)
{
pText.Value = text;
}
else
{
pText.Value = DBNull.Value;
}
SqlParameter pCategory = cmd.Parameters.Add("@idCategory", SqlDbType.Int);
if (idCategory.HasValue)
{
pCategory.Value = idCategory.Value;
}
else
{
pCategory.Value = DBNull.Value;
}
SqlParameter pStatus = cmd.Parameters.Add("@status", SqlDbType.Int);
if (status.HasValue)
{
pStatus.Value = status.Value;
}
else
{
pStatus.Value = DBNull.Value;
}
cmd.Parameters.Add("@sort", SqlDbType.NVarChar, 100).Value = sort;
cnn.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
BO.TodoItem item = new BO.TodoItem();
item.ID = (int)dr["ID"];
item.Date = (DateTime)dr["Date"];
item.Title = dr["Title"] == DBNull.Value ? "" : (string)dr["Title"];
item.Note = dr["Note"] == DBNull.Value ? "" : (string)dr["Note"];
item.IDCategory = (int)dr["IDCategory"];
item.Category = (string)dr["Category"];
item.Color = (string)dr["Color"];
if (dr["Completed"] != DBNull.Value)
{
item.Completed = (DateTime)dr["Completed"];
}
item.Created = (DateTime)dr["Created"];
item.Modified = (DateTime)dr["Modified"];
item.TotalItems = (int)dr["TotalItems"];
result.Add(item);
}
}
}
}
return(result);
}
