/// <summary>
/// Map data
/// </summary>
/// <param name="dbContext"></param>
/// <param name="oldObject"></param>
/// <param name="localArea"></param>
/// <param name="systemId"></param>
private static void CopyToInstance(DbAppContext dbContext, ImportModels.Area oldObject, ref LocalArea localArea, string systemId)
{
bool isNew = false;
if (oldObject.Area_Id <= 0)
{
return;
}
if (localArea == null)
{
isNew = true;
localArea = new LocalArea {
Id = oldObject.Area_Id
};
}
try
{
localArea.Name = oldObject.Area_Desc.Trim();
}
catch
{
// do nothing
}
try
{
ServiceArea serviceArea = dbContext.ServiceAreas.FirstOrDefault(x => x.MinistryServiceAreaID == oldObject.Service_Area_Id);
localArea.ServiceArea = serviceArea;
}
catch
{
// do nothing
}
if (isNew)
{
localArea.CreateUserid = systemId;
localArea.CreateTimestamp = DateTime.UtcNow;
dbContext.LocalAreas.Add(localArea);
}
else
{
localArea.LastUpdateUserid = systemId;
localArea.LastUpdateTimestamp = DateTime.UtcNow;
dbContext.LocalAreas.Update(localArea);
}
}
/// <summary>
/// Map data
/// </summary>
/// <param name="dbContext"></param>
/// <param name="oldObject"></param>
/// <param name="localArea"></param>
/// <param name="systemId"></param>
private static void CopyToInstance(DbAppContext dbContext, ImportModels.Area oldObject,
ref HetLocalArea localArea, string systemId)
{
try
{
if (oldObject.Area_Id <= 0)
{
return;
}
string tempLocalArea = ImportUtility.CleanString(oldObject.Area_Desc);
tempLocalArea = ImportUtility.GetCapitalCase(tempLocalArea);
localArea = new HetLocalArea
{
LocalAreaId = oldObject.Area_Id,
LocalAreaNumber = oldObject.Area_Id,
Name = tempLocalArea
};
// map to the correct service area
HetServiceArea serviceArea = dbContext.HetServiceArea.AsNoTracking()
.FirstOrDefault(x => x.MinistryServiceAreaId == oldObject.Service_Area_Id);
if (serviceArea == null)
{
// not mapped correctly
return;
}
localArea.ServiceAreaId = serviceArea.ServiceAreaId;
localArea.AppCreateUserid = systemId;
localArea.AppCreateTimestamp = DateTime.UtcNow;
localArea.AppLastUpdateUserid = systemId;
localArea.AppLastUpdateTimestamp = DateTime.UtcNow;
dbContext.HetLocalArea.Add(localArea);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
