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