private async Task insertLocations(TFPMEntities context, LocationData loc, int?LocConfigID, int CompanyID, string Userid, int LocId, bool isActive)
{
List <LocationMetadata> metadata = new List <LocationMetadata>();
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "LocationName", loc.LocationName, 1, loc.Tags, Userid, DateTime.Now, LocId, isActive));
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "FirstContactName", loc.FirstContactName, 3, loc.Tags, Userid, DateTime.Now, LocId, isActive));
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "FirstContactEmail", loc.FirstContactEmail, 2, loc.Tags, Userid, DateTime.Now, LocId, isActive));
if (!string.IsNullOrEmpty(loc.SecondContactName))
{
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "SecondContactName", loc.SecondContactName, 5, loc.Tags, Userid, DateTime.Now, LocId, isActive));
}
if (!string.IsNullOrEmpty(loc.SecondContactEmail))
{
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "SecondContactEmail", loc.SecondContactEmail, 4, loc.Tags, Userid, DateTime.Now, LocId, isActive));
}
if (!string.IsNullOrEmpty(loc.ThirdContactName))
{
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "ThirdContactName", loc.ThirdContactName, 7, loc.Tags, Userid, DateTime.Now, LocId, isActive));
}
if (!string.IsNullOrEmpty(loc.ThirdContactEmail))
{
metadata.Add(SetMeta(CompanyID, LocConfigID ?? 0, "ThirdContactEmail", loc.ThirdContactEmail, 6, loc.Tags, Userid, DateTime.Now, LocId, isActive));
}
context.LocationMetadatas.AddRange(metadata);
await context.SaveChangesAsync();
}
private async Task InsertDrivers(UploadDrivers model, string Userid)
{
var companyId = model.CompanyID;
foreach (var driver in model.DriverData)
{
var Lcount = context.Drivers.Where(m => m.LicenseNumber == driver.LicenseNumber && m.CompanyId == model.CompanyID && m.isDelete == false).FirstOrDefault();
if (Lcount == null)
{
var drivermodel = new Driver
{
CompanyId = companyId,
FirstName = driver.FirstName,
LastName = driver.LastName,
DOB = Convert.ToDateTime(driver.DOB).Date,
LicenseState = driver.LicenseState,
LicenseNumber = driver.LicenseNumber,
DOTNumber = driver.DotNumber,
CreatedBy = Userid,
CreatedOn = DateTime.Now,
ModifiedBy = Userid,
ModifiedOn = DateTime.Now,
isActive = (driver.isActive.ToLower() == "yes" || driver.isActive.ToLower() == "y") ? true : false,
isDelete = false
};
context.Drivers.Add(drivermodel);
}
else
{
Lcount.FirstName = driver.FirstName;
Lcount.LastName = driver.LastName;
Lcount.DOB = Convert.ToDateTime(driver.DOB).Date;
Lcount.LicenseState = driver.LicenseState;
Lcount.LicenseNumber = driver.LicenseNumber;
Lcount.DOTNumber = driver.DotNumber;
Lcount.ModifiedBy = Userid;
Lcount.ModifiedOn = DateTime.Now;
Lcount.isActive = (driver.isActive.ToLower() == "yes" || driver.isActive.ToLower() == "y") ? true : false;
}
await context.SaveChangesAsync();
}
}
public async Task <UploadLocation> UploadLocations(UploadLocation model, string Userid)
{
if (IsActiveProfile)
{
var locData = ValidateModel(model);
int?LocConfigID = GetLocationConfigByCompany(model.CompanyID);
foreach (var loc in locData.ValidData.Locationdata)
{
bool isActive = (loc.isActive.ToLower() == "yes" || loc.isActive.ToLower() == "y") ? true : false;
//Insert Location Data
var Locationadata = await context.Locations.FirstOrDefaultAsync(locCode => locCode.LocCode == loc.LocCode && locCode.CompanyID == model.CompanyID);
if (Locationadata == null)
{
Locationadata = new Location
{
LocCode = loc.LocCode,
CompanyID = model.CompanyID,
ModifiedBy = Userid,
ModifiedOn = DateTime.Now,
CreatedBy = Userid,
CreatedOn = DateTime.Now,
IsActive = isActive,
IsDelete = false
};
context.Locations.Add(Locationadata);
await context.SaveChangesAsync();
//Insert Location Meta data
await insertLocations(context, loc, LocConfigID, model.CompanyID, Userid, Locationadata.LocId, isActive);
}
else
{
//UpdateLocationMeta Locationmeta if Exists
var LocationMeta = Locationadata.LocationMetadatas.Where(x => x.LocId == Locationadata.LocId && x.CustomerID == model.CompanyID).ToList();
await UpdateLocationMeta(LocationMeta, Userid, loc, LocConfigID, model.CompanyID, Locationadata.LocId, isActive);
}
}
return(locData.UnValidData);
}
else
{
return(null);
}
}
private async Task AddInspection(RPT_REG_CARRIER_PROFILE_XMLG_RPT_REG_CP_INSPG_RPT_REG_CP_INSP_ID inspection, string UserId, string DOTNumber, string Trans_ID, int CompanyId)
{
var insp = new Entitys.G_RPT_REG_CP_INSP_ID
{
CompanyId = CompanyId,
DOTNumber = DOTNumber,
TransID = Trans_ID,
CreatedBy = UserId,
ModifiedBy = UserId,
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now,
CARRIER_CITY1 = inspection.CARRIER_CITY1,
CARRIER_NAME1 = inspection.CARRIER_NAME1,
CARRIER_STATE1 = inspection.CARRIER_STATE1,
COMPANY_NUMBER1 = inspection.COMPANY_NUMBER1,
COMPANY_NUMBER2 = inspection.COMPANY_NUMBER2,
COMPANY_NUMBER3 = Convert.ToString(inspection.COMPANY_NUMBER3),
COMPANY_NUMBER4 = Convert.ToString(inspection.COMPANY_NUMBER4),
COMPANY_NUMBER5 = Convert.ToString(inspection.COMPANY_NUMBER5),
COMPANY_NUMBER6 = Convert.ToString(inspection.COMPANY_NUMBER6),
COUNTY_NAME1 = inspection.COUNTY_NAME1,
DRIVER_DOB = Convert.ToDateTime(inspection.DRIVER_DOB),
VEH_ST_LICENSE1 = inspection.VEH_ST_LICENSE1,
VEH_ST_LICENSE2 = inspection.VEH_ST_LICENSE2,
VEN_ST_LICENSE3 = Convert.ToString(inspection.VEH_ST_LICENSE3),
VEN_ST_LICENSE4 = Convert.ToString(inspection.VEH_ST_LICENSE4),
VEH_ST_LICENSE5 = Convert.ToString(inspection.VEH_ST_LICENSE5),
VEH_ST_LICENSE6 = Convert.ToString(inspection.VEH_ST_LICENSE6),
DRIVER_FIRST_NAME1 = inspection.DRIVER_FIRST_NAME1,
DRIVER_LAST_NAME1 = inspection.DRIVER_LAST_NAME,
DRIVER_LICENSE = inspection.DRIVER_LICENSE,
DRIVER_LICENSE_STATE = inspection.DRIVER_LICENSE_STATE,
DRIVER_MI1 = inspection.DRIVER_MI1,
UNIT_VIN1 = inspection.UNIT_VIN1,
UNIT_VIN2 = inspection.UNIT_VIN2,
UNIT_VIN3 = Convert.ToString(inspection.UNIT_VIN3),
UNIT_VIN4 = Convert.ToString(inspection.UNIT_VIN4),
UNIT_VIN5 = Convert.ToString(inspection.UNIT_VIN5),
UNIT_VIN6 = Convert.ToString(inspection.UNIT_VIN6),
UNIT_NUMBER1 = Convert.ToString(inspection.UNIT_NUMBER1),
UNIT_NUMBER2 = Convert.ToString(inspection.UNIT_NUMBER2),
UNIT_NUMBER3 = Convert.ToString(inspection.UNIT_NUMBER3),
UNIT_NUMBER4 = Convert.ToString(inspection.UNIT_NUMBER4),
UNIT_NUMBER5 = Convert.ToString(inspection.UNIT_NUMBER5),
UNIT_NUMBER6 = Convert.ToString(inspection.UNIT_NUMBER6),
UNIT_TYPE1 = inspection.UNIT_TYPE1,
UNIT_TYPE2 = inspection.UNIT_TYPE2,
UNIT_TYPE3 = Convert.ToString(inspection.UNIT_TYPE3),
UNIT_TYPE4 = Convert.ToString(inspection.UNIT_TYPE4),
UNIT_TYPE5 = Convert.ToString(inspection.UNIT_TYPE5),
UNIT_TYPE6 = Convert.ToString(inspection.UNIT_TYPE6),
TOTAL_OOS = inspection.TOTAL_OOS,
TOTAL_VIOL = inspection.TOTAL_VIOL,
INSPECTION_ID = Convert.ToInt32(inspection.INSPECTION_ID),
INSP_DATE = Convert.ToDateTime(inspection.INSP_DATE),
INSP_LEVEL_CODE = Convert.ToString(inspection.INSP_LEVEL_CODE),
INSP_TIME = inspection.INSP_TIME,
LOCATION1 = inspection.LOCATION1,
REPORT_NUMBER1 = inspection.REPORT_NUMBER1,
REPORT_STATE = inspection.REPORT_STATE,
HM = inspection.HM
};
context.G_RPT_REG_CP_INSP_ID.Add(insp);
await context.SaveChangesAsync();
}
