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