public static List <BugetCategoryMinifiedModel> GetList()
{
var bugetCategoriesCore = new BugetCategoriesCore();
var categoryList = bugetCategoriesCore.GetListQuery(t => t.Id != 0)
.Select(item => new BugetCategoryMinifiedModel
{
Id = item.Id,
OrganizationId = item.OrganizationId,
Name = item.Name,
}).ToList();
return(categoryList);
}
public static bool Save(SaveBugetCategoryModel model, long userId)
{
var bugetCategoriesCore = new BugetCategoriesCore();
if (model.Id == 0)
{
//Create Product
var parameters = GetProductSqlParameters(model, userId);
var query = "INSERT INTO BugetCategories(OrganizationId,Name,CreatedBy,CreatedAt)" +
"VALUES(@organizationId, @name, @createdBy, @createdAt)";
try
{
var rows = bugetCategoriesCore.ExecuteSqlCommand(query, parameters);
if (rows == 0)
{
return(false);
}
}
catch (Exception e)
{
throw;
}
}
else
{
//Update
var parameters = GetProductSqlParameters(model, userId);
var query = "UPDATE Products SET Name=@name, OrganizationId=@organizationId" +
" WHERE Id=@id";
var rows = bugetCategoriesCore.ExecuteSqlCommand(query, parameters);
if (rows == 0)
{
return(false);
}
}
return(true);
}
