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(); }