private string GenerateCustomerID(CustomerLoginDetails customerLoginDetails)
{
string customerID = string.Empty;
try
{
using (SqlCommand command = new SqlCommand("spGetNextCustomerID", _connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("FirmID", customerLoginDetails.FirmID);
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
customerID = reader.GetString(0);
}
}
}
}
catch (SqlNullValueException ex)
{
var firm = _firmService.GetFirmDetails(customerLoginDetails.FirmID);
throw new SqlNullValueException($"Number of customers to the Firm {customerLoginDetails.FirmID} reached maximum . Please contact Firm Owner. Phone Number : { firm.PhoneNumber } . EmailID : {firm.Email}", ex);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_connection.Close();
}
return(customerID.Trim());
}
