public static DataTable createCharity([FromBody] CreateCharity createCharity)
{
try
{
string ConnectionString = Common.GetConnectionString();
//var encryptPassword = Common.EncryptData(createCharity.password);
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@firstName", createCharity.firstName));
parameters.Add(new SqlParameter("@lastName", createCharity.lastName));
parameters.Add(new SqlParameter("@phoneNumber", createCharity.phoneNumber));
parameters.Add(new SqlParameter("@password", null));
parameters.Add(new SqlParameter("@email", createCharity.email));
parameters.Add(new SqlParameter("@gender", createCharity.gender));
parameters.Add(new SqlParameter("@profileImage", createCharity.profileImage));
parameters.Add(new SqlParameter("@address", createCharity.address));
parameters.Add(new SqlParameter("@action", "add"));
using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveCharity", parameters.ToArray()).Tables[0])
{
return(dt);
}
}
catch (Exception e)
{
throw e;
}
}
public IActionResult createCharity(CreateCharity createCharity)
{
try
{
if (createCharity.firstName == "" || createCharity.firstName == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter First Name" }));
}
else if (createCharity.email == "" || createCharity.email == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter Email" }));
}
else if (!String.IsNullOrEmpty(createCharity.email))
{
Regex regexEmail = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
System.Text.RegularExpressions.Match Email = regexEmail.Match(createCharity.email);
if (Email.Success == false)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter valid Email" }));
}
}
else if (createCharity.phoneNumber == "" || createCharity.phoneNumber == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter phonenumber" }));
}
DataTable dt = Data.Charity.createCharity(createCharity);
string Response = dt.Rows[0][0].ToString();
if (Response == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "Saved Successfully"));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("createCharity", e.Message);
if (e.Message.Contains("UQ__tblChari__4849DA019F375FD8")) // Check Duplicate Key for PhoneNumber
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone Number is already exist" }));
}
if (e.Message.Contains("UQ__tblChari__AB6E61640FFFF0AF")) // Check Duplicate Key for PhoneNumber
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Email is already exist" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
