private static object[] GetProductSqlParameters(SaveBugetCategoryModel model, long userId)
{
object[] parameters = new object[]
{
new SqlParameter("id", model.Id),
new SqlParameter("organizationId", model.OrganizationId),
new SqlParameter("name", model.Name),
new SqlParameter("createdBy", userId),
new SqlParameter("createdAt", DateTime.UtcNow),
};
return(parameters);
}
public virtual JsonResult Save(SaveBugetCategoryModel model)
{
var response = new { Success = false, Data = "" };
if (model == null)
{
return(Json(response));
}
//var customIdentity = GetIdentity();
var reponse = BugetCategoriesCore.Save(model, 2);
if (!reponse)
{
return(Json(response));
}
return(Json(new { Success = true }));
}
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);
}
