public static DataTable updateAd([FromBody] UpdateAd updateAd) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@adId", updateAd.adId)); parameters.Add(new SqlParameter("@name", updateAd.name)); parameters.Add(new SqlParameter("@description", updateAd.description)); parameters.Add(new SqlParameter("@navigatioURL", updateAd.navigationURL)); parameters.Add(new SqlParameter("@image", updateAd.image)); parameters.Add(new SqlParameter("@priority", updateAd.priority)); parameters.Add(new SqlParameter("@expiryDate", updateAd.expiryDate)); parameters.Add(new SqlParameter("@adStatus", updateAd.adStatus)); parameters.Add(new SqlParameter("@action", null)); using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveAd", parameters.ToArray()).Tables[0]) { return(dt); } } catch (Exception e) { throw e; } }
public async Task CreateUpdateAdAsync(int adId) { if (!await context.Ads.AnyAsync(x => x.Id == adId)) { throw new ArgumentException(GlobalConstants.InvalidAdIdErrorMessage); } var updateAd = new UpdateAd { AdId = adId }; await context.UpdateAds.AddAsync(updateAd); await context.SaveChangesAsync(); }
public IActionResult updateAd([FromBody] UpdateAd updateAd) { try { DataTable dt = Data.Ads.updateAd(updateAd); string Response = dt.Rows[0][0].ToString(); if (Response == "Success") { return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully")); } else { return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("updateCharity", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message })); } }
public async Task <IActionResult> UpdateAd(UpdateAd command) { return(Ok(await _mediator.Send(command))); }