public void CreatePromotionalCategory(PromotionalCategoryDTOs promotionalCategories)
{
if (promotionalCategories == null)
{
throw new ArgumentNullException(nameof(promotionalCategories));
}
_context.PromotionalCategory.Add(promotionalCategories);
SaveChanges();
}
public void UpdatePromotionalCategory(int PromotionalCategoryID, PromotionalCategoryDTOs promotionalCategories)
{
var promoCategories = GetPromotionalCategoryByID(PromotionalCategoryID);
if (promoCategories == null)
{
_logger.LogInformation("No Promotional Categories available");
}
var updatePromotionalCategoryText = "Update dbo.PromotionalCategory SET PromotionalCategoryName = @PromotionalCategoryName, Active = @Active, ModifiedDate = @ModifiedDate, ModifiedBy = @ModifiedBy Where PromotionalCategoryID = @PromotionalCategoryIDParam";
var PromotionalCategoryName = new SqlParameter("@PromotionalCategoryName", promotionalCategories.PromotionalCategoryName);
var Active = new SqlParameter("@Active", promotionalCategories.Active);
var ModifiedDate = new SqlParameter("@ModifiedDate", DateTime.Now);
var ModifiedBy = new SqlParameter("@ModifiedBy", "Admin");
var PromotionalCategoryIDParam = new SqlParameter("@PromotionalCategoryIDParam", PromotionalCategoryID);
int noOfRowUpdated = _context.Database.ExecuteSqlCommand(updatePromotionalCategoryText, PromotionalCategoryName, Active, ModifiedDate, ModifiedBy, PromotionalCategoryIDParam);
}
public ActionResult <PromotionalCategoryDTOs> UpdatePromotionalCategory(int promotionalCategoryID, PromotionalCategoryDTOs promotionalCategoryDTOs)
{
_writeRepository.UpdatePromotionalCategory(promotionalCategoryID, promotionalCategoryDTOs);
return(NoContent());
}
public ActionResult <PromotionalCategory> CreatePromotionalCategory(PromotionalCategoryDTOs promotionalCategoryDTOs)
{
_writeRepository.CreatePromotionalCategory(promotionalCategoryDTOs);
return(Ok());
}
