public async Task <IActionResult> createUpdateCustomer(Models.CreateUpdateCustomerReq requestModel) { try { Helpers.Customer obj = new Helpers.Customer(); var data = obj.createUpdateCustomer(requestModel); return(Ok(data)); } catch (Exception ex) { if (ex.Message.IndexOf("Email") > -1) { return(BadRequest("Email Already Exists.")); } else if (ex.Message.IndexOf("Phone") > -1) { return(BadRequest("Phone Already Exists.")); } else { return(BadRequest("Something went wrong.")); } } }
public int createUpdateCustomer(Models.CreateUpdateCustomerReq obj) { try { EFModels.NTECommerceDBContext context = new EFModels.NTECommerceDBContext(); var result = context.Customers .FromSqlRaw($"EXEC CreateUpdateCustomer {obj.Id}, '{obj.FirstName}', '{obj.LastName}', '{obj.EmailAddress}', '{obj.Password}', '{obj.PhoneNumber}'") .ToList(); return(result.FirstOrDefault().Id); } catch (Exception ex) { throw ex; } }