public static DataTable updateCharity([FromBody] UpdateCharity updateCharity)
{
try
{
string ConnectionString = Common.GetConnectionString();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@charityId", updateCharity.charityId));
parameters.Add(new SqlParameter("@firstName", updateCharity.firstName));
parameters.Add(new SqlParameter("@lastName", updateCharity.lastName));
parameters.Add(new SqlParameter("@phoneNumber", updateCharity.phoneNumber));
parameters.Add(new SqlParameter("@email", updateCharity.email));
parameters.Add(new SqlParameter("@gender", updateCharity.gender));
parameters.Add(new SqlParameter("@profileImage", updateCharity.profileImage));
parameters.Add(new SqlParameter("@address", updateCharity.address));
parameters.Add(new SqlParameter("@action", null));
using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveCharity", parameters.ToArray()).Tables[0])
{
return(dt);
}
}
catch (Exception e)
{
throw e;
}
}
public IActionResult updateCharity([FromBody] UpdateCharity updateCharity)
{
try
{
if (!String.IsNullOrEmpty(updateCharity.email))
{
Regex regexEmail = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
System.Text.RegularExpressions.Match Email = regexEmail.Match(updateCharity.email);
if (Email.Success == false)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter valid Email" }));
}
}
DataTable dt = Data.Charity.updateCharity(updateCharity);
string Response = dt.Rows[0][0].ToString();
if (Response == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully"));
}
else
{
if (Response.Contains("UQ__tblChari__4849DA019F375FD8") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone Number is already exist" }));
}
else if (Response.Contains("UQ__tblChari__AB6E61640FFFF0AF") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Email is already exist" }));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("updateCharity", e.Message);
if (e.Message.Contains("UQ__tblChari__4849DA01906D6338") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone No is already taken" }));
}
if (e.Message.Contains("UQ__tblChari__AB6E6164E0E77029") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Email is already taken" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
