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