public async Task <IActionResult> SaveCustomerAdditionalDetails([FromForm] CustomerAdditionalDetails customerAdditionalDetails)
{
if (ModelState.IsValid)
{
await _customerRegistrationService.SaveCustomerAdditionalDetails(customerAdditionalDetails);
return(Ok());
}
return(BadRequest());
}
public async Task <string> SaveCustomerAdditionalDetails(CustomerAdditionalDetails customerAdditionalDetails)
{
SqlTransaction transaction = null;
try
{
using (SqlCommand sqlcommand = new SqlCommand())
{
sqlcommand.CommandText = "spInsertIntoCustomerDetails";
sqlcommand.Connection = _connection;
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.AddWithValue("CustomerID", customerAdditionalDetails.customerID);
sqlcommand.Parameters.AddWithValue("Occupation", customerAdditionalDetails.occupation);
sqlcommand.Parameters.AddWithValue("Phone", customerAdditionalDetails.phone);
sqlcommand.Parameters.AddWithValue("State", customerAdditionalDetails.state);
sqlcommand.Parameters.AddWithValue("City", customerAdditionalDetails.city);
sqlcommand.Parameters.AddWithValue("Zip", customerAdditionalDetails.zip);
sqlcommand.Parameters.AddWithValue("FlatNumber", customerAdditionalDetails.flatNumber);
sqlcommand.Parameters.AddWithValue("Street", customerAdditionalDetails.street);
sqlcommand.Parameters.AddWithValue("Country", customerAdditionalDetails.country);
sqlcommand.Parameters.AddWithValue("Income", customerAdditionalDetails.income);
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
transaction = _connection.BeginTransaction();
sqlcommand.Transaction = transaction;
int rowsaffected = sqlcommand.ExecuteNonQuery();
if (rowsaffected > 0)
{
//var uri = "http://localhost:5000/api/AzureBlobOperations/" + "UploadAadhaarImageToAzureBlobContainer";
var client = _httpClientFactory.CreateClient();
if (customerAdditionalDetails.signature.Length > 0)
{
using (MemoryStream fs = new MemoryStream())
{
await customerAdditionalDetails.signature.CopyToAsync(fs);
var byteData = fs.ToArray();
var byteContent = new ByteArrayContent(byteData);
var content = new MultipartFormDataContent();
content.Add(byteContent, "signature");
content.Add(new StringContent(customerAdditionalDetails.customerID), "customerID");
content.Add(new StringContent(BlobType.Signature.ToString()), "type");
var response = await client.PostAsync("http://localhost:5000/api/AzureBlobOperations/UploadAadhaarImageToAzureBlobContainer", content);
}
}
//if (customerAdditionalDetails.signature != null)
//{
// var result = await SaveToAzureBlob(new BlobDetails()
// {
// BlobFile = customerAdditionalDetails.signature,
// CustomerID = customerAdditionalDetails.customerID,
// Type = BlobType.Signature
// });
// if (result && customerAdditionalDetails.passport != null)
// {
// var result1 = await SaveToAzureBlob(new BlobDetails()
// {
// BlobFile = customerAdditionalDetails.passport,
// CustomerID = customerAdditionalDetails.customerID,
// Type = BlobType.PASSPORTPHOTO
// });
// if (!result1)
// {
// throw new Exception("SaveToBlob failed");
// }
// }
// else
// {
// throw new Exception("SaveToBlob failed");
// }
//}
}
transaction.Commit();
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
_connection.Close();
}
return(string.Empty);
}
