/// <summary>
/// category update
/// </summary>
/// <param name="id"></param>
/// <param name="idCategory"></param>
/// <returns></returns>
public static BO.TodoCategoryItem Category(int id, int idCategory)
{
BO.TodoCategoryItem result = new BO.TodoCategoryItem();
//eseguo la query sul DB
using (SqlConnection cnn = GetConnection())
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = queries.UpdateCategory;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@idCategory", SqlDbType.Int).Value = idCategory;
cnn.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dr.Read())
{
result.ID = (int)dr["ID"];
result.IDCategory = (int)dr["IDCategory"];
}
}
}
}
return(result);
}
public BO.ServiceStatus <BO.TodoCategoryItem> Category([FromBody] BO.TodoCategoryItem param)
{
BO.ServiceStatus <BO.TodoCategoryItem> result = new BO.ServiceStatus <BO.TodoCategoryItem>();
try
{
//controllo presenza parametri
if (param.ID == 0)
{
result.AddError("`id` in required");
}
if (result.Messages.Count == 0)
{
result.Data = Code.Manager.Category(param.ID, param.IDCategory);
//result.AddSuccess("Category updated id: " + param.ID.ToString());
result.Success = true;
}
}
catch (Exception ex)
{
result.AddError(ex);
}
return(result);
}