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