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