public void CreatePromotionalOfferDetails(PromotionalOfferDetailsDTOs promotionalOfferDetails)
{
if (promotionalOfferDetails == null)
{
throw new ArgumentNullException(nameof(promotionalOfferDetails));
}
_context.PromotionalOfferDetails.Add(promotionalOfferDetails);
SaveChanges();
}
public void UpdatePromotionalOfferDetails(string PromotionalOfferName, PromotionalOfferDetailsDTOs promotionalOfferDetails)
{
var promotionalOfferDetailAvailable = GetAllPromotionalOfferDetailsByName(PromotionalOfferName);
if (promotionalOfferDetailAvailable == null)
{
_logger.LogInformation("No Promotional offer details available");
}
var updatePromotionalOfferText = "Update dbo.PromotionalOfferDetails SET PromotionalOfferName = @PromotionalOfferName, PromotionalOfferDetail = @PromotionalOfferDetail, StartDate = @StartDate, EndDate = @EndDate, ModifiedDate = @ModifiedDate, ModifiedBy = @ModifiedBy, Active = @Active Where PromotionalOfferName = @PromotionalOfferName";
var promotionalOfferName = new SqlParameter("@PromotionalOfferName", PromotionalOfferName);
var promotionalOfferDetail = new SqlParameter("@PromotionalOfferDetail", promotionalOfferDetails.PromotionalOfferDetail);
var startDate = new SqlParameter("@StartDate", promotionalOfferDetails.StartDate);
var endDate = new SqlParameter("@EndDate", promotionalOfferDetails.EndDate);
var active = new SqlParameter("@Active", promotionalOfferDetails.Active);
var modifiedDate = new SqlParameter("@ModifiedDate", DateTime.Now);
var modifiedBy = new SqlParameter("@ModifiedBy", "Admin");
var promotionalOfferNameParam = new SqlParameter("@promotionalOfferNameParam", PromotionalOfferName);
int noOfRowUpdated = _context.Database.ExecuteSqlCommand(updatePromotionalOfferText, promotionalOfferName, promotionalOfferDetail, startDate, endDate, active, modifiedDate, modifiedBy, promotionalOfferNameParam);
}
public ActionResult <PromotionalOfferDetailsDTOs> UpdatePromotionalOfferDetails(string PromotionalOfferName, PromotionalOfferDetailsDTOs promotionalOfferDetails)
{
_writeRepository.UpdatePromotionalOfferDetails(PromotionalOfferName, promotionalOfferDetails);
return(NoContent());
}
public ActionResult <PromotionalOfferDetails> CreatePromotionalOfferDetails(PromotionalOfferDetailsDTOs promotionalOfferDetails)
{
_writeRepository.CreatePromotionalOfferDetails(promotionalOfferDetails);
return(Ok());
}
