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