private static string BuildProviderAddress(ProviderAddress sourceProviderAddress)
{
var returnAddressFields = new List <string>();
if (!string.IsNullOrEmpty(sourceProviderAddress.Address1))
{
returnAddressFields.Add(sourceProviderAddress.Address1);
}
if (!string.IsNullOrEmpty(sourceProviderAddress.Address2))
{
returnAddressFields.Add(sourceProviderAddress.Address2);
}
if (!string.IsNullOrEmpty(sourceProviderAddress.Address3))
{
returnAddressFields.Add(sourceProviderAddress.Address3);
}
if (!string.IsNullOrEmpty(sourceProviderAddress.Address4))
{
returnAddressFields.Add(sourceProviderAddress.Address4);
}
if (!string.IsNullOrEmpty(sourceProviderAddress.Town))
{
returnAddressFields.Add(sourceProviderAddress.Town);
}
if (!string.IsNullOrEmpty(sourceProviderAddress.Postcode))
{
returnAddressFields.Add(sourceProviderAddress.Postcode);
}
return(string.Join(", ", returnAddressFields));
}
public async Task <IActionResult> Edit(int id, [Bind("ProviderID,AddressID")] ProviderAddress providerAddress)
{
if (id != providerAddress.ProviderID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(providerAddress);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProviderAddressExists(providerAddress.ProviderID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AddressID"] = new SelectList(_context.Addresses, "AddressID", "AddressID", providerAddress.AddressID);
ViewData["ProviderID"] = new SelectList(_context.Providers, "ProviderID", "ProviderID", providerAddress.ProviderID);
return(View(providerAddress));
}
public async Task <IActionResult> Create([Bind("ProviderID,AddressID")] ProviderAddress providerAddress)
{
if (ModelState.IsValid)
{
_context.Add(providerAddress);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AddressID"] = new SelectList(_context.Addresses, "AddressID", "AddressID", providerAddress.AddressID);
ViewData["ProviderID"] = new SelectList(_context.Providers, "ProviderID", "ProviderID", providerAddress.ProviderID);
return(View(providerAddress));
}
public bool InsertProviderAddress(List <ProviderStaging> stagingdata)
{
List <ProviderAddress> addresstable = new List <ProviderAddress>();
ProviderAddress addressrow;
foreach (ProviderStaging row in stagingdata)
{
addressrow = new ProviderAddress();
addressrow.Address1 = row.AddressAddressLine1;
addressrow.Address2 = row.AddressAddressLine2;
addressrow.AddressTypeId = (int)AddressType.Billing;
addressrow.City = row.AddressCity;
addressrow.Zip = row.AddressZipCode;
addressrow.StateProvinceId = GetStateProvinenceId(row.AddressState);
addresstable.Add(addressrow);
}
foreach (ProviderStaging row in stagingdata)
{
addressrow = new ProviderAddress();
addressrow.Address1 = row.RenderingAddressLine1;
addressrow.Address2 = row.RenderingAddressLine2;
addressrow.AddressTypeId = (int)AddressType.Rendering;
addressrow.Zip = row.RenderingZipCode;
addressrow.StateProvinceId = GetStateProvinenceId(row.RenderingState);
addresstable.Add(addressrow);
}
try
{
conn = new SqlConnection(connString);
conn.Open();
foreach (ProviderAddress addresstablerow in addresstable)
{
cmd = new SqlCommand(String.Format("insert into ProviderAddress(AddressTypeId,Address1,Address2,City,Zip,StatePovinceId) values({0},'{1}','{2}','{3}',{4},{5})", addresstablerow.AddressTypeId, addresstablerow.Address1, addresstablerow.Address2, addresstablerow.City, addresstablerow.Zip, addresstablerow.StateProvinceId), conn);
cmd.ExecuteNonQuery();
}
conn.Close();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(false);
}
}
/// <inheritdoc/>
public string ToDelimitedString()
{
CultureInfo culture = CultureInfo.CurrentCulture;
return(string.Format(
culture,
StringHelper.StringFormatSequence(0, 10, Configuration.FieldSeparator),
Id,
ProviderRole != null ? string.Join(Configuration.FieldRepeatSeparator, ProviderRole.Select(x => x.ToDelimitedString())) : null,
ProviderName != null ? string.Join(Configuration.FieldRepeatSeparator, ProviderName.Select(x => x.ToDelimitedString())) : null,
ProviderAddress?.ToDelimitedString(),
ProviderLocation?.ToDelimitedString(),
ProviderCommunicationInformation != null ? string.Join(Configuration.FieldRepeatSeparator, ProviderCommunicationInformation.Select(x => x.ToDelimitedString())) : null,
PreferredMethodOfContact?.ToDelimitedString(),
ProviderIdentifiers != null ? string.Join(Configuration.FieldRepeatSeparator, ProviderIdentifiers.Select(x => x.ToDelimitedString())) : null,
EffectiveStartDateOfProviderRole.HasValue ? EffectiveStartDateOfProviderRole.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null,
EffectiveEndDateOfProviderRole.HasValue ? EffectiveEndDateOfProviderRole.Value.ToString(Consts.DateTimeFormatPrecisionSecond, culture) : null
).TrimEnd(Configuration.FieldSeparator.ToCharArray()));
}
