public DriverInterviewProfileEntity GetDriverDataByInterviewProfileID(bool isSubmitted, int interviewprofileid)
{
DriverInterviewProfileEntity driverSale = new DriverInterviewProfileEntity();
using (uow = new UnitOfWork.UnitOfWork())
{
driverSale = uow.DriverInterviewProfileRepository.Get().Select(dv => new DriverInterviewProfileEntity
{
CDLNonCDL = dv.CDLNonCDL,
Class = dv.Class,
IsSubmitted = isSubmitted,
Date = dv.Date,
DOB = dv.DOB,
OrderFormID = dv.OrderFormID,
DriverInterviewID = dv.DriverInterviewID,
DriverName = dv.DriverName,
EIN = dv.EIN,
Email = dv.Email,
ExpirationDate = dv.ExpirationDate,
LegalName = dv.LegalName,
LicenseNo = dv.LicenseNo,
Notes = dv.Notes,
Phone = dv.Phone,
SSN = dv.SSN,
StatusIssued = dv.StatusIssued,
Supervisor = dv.Supervisor,
USDOT = dv.USDOT,
DriverCargos = uow.DriverVehicleCargoRepository.Get().Where(x => x.DriverVehicleID == interviewprofileid).Select(p => new DriverVehicleCargoEntity {
CargoCarriedName = p.CargoCarriedName, DriverVehicleID = p.DriverVehicleID, VehicleCargoID = p.VehicleCargoID
}).ToList(),
DriverServices = uow.DriverServiceRepository.Get().Join(uow.DocumentMasterRepository.Get(), msd => msd.ServiceID, dms => dms.DocumentID, (msd, dms) => new { msd, dms })
.Select(p => new DriverServiceEntity {
DriverServiceID = p.msd.DriverServiceID, ServiceID = (int)p.msd.ServiceID, DriverInterviewProfileID = p.msd.DriverInterviewProfileID, ServiceName = p.dms.DocumentName, ServicePrice = p.dms.Description
})
.Where(x => x.DriverInterviewProfileID == interviewprofileid).ToList(),
DriverVehicle = uow.DriverVehicleRepository.Get().Where(x => x.OrderFormID == interviewprofileid).Select(p => new DriverVehicleEntity {
DriverVehicleInfo = p.DriverVehicleInfo, GVW = p.GVW, Make = p.Make, Model = p.Model, OrderFormID = p.OrderFormID, Year = p.Year
}).FirstOrDefault(),
}).Where(x => x.DriverInterviewID == interviewprofileid && x.IsSubmitted == isSubmitted).FirstOrDefault();
}
return(driverSale);
}
protected void btnSaveDriver_Click(object sender, EventArgs e)
{
interviewprofileid = Convert.ToInt32(Request.QueryString["interviewprofileid"]);
List <DriverServiceEntity> driverServices = new List <DriverServiceEntity>();
List <ListItem> items = chkServices.Items.Cast <ListItem>().Where(n => n.Selected).ToList();
foreach (ListItem item in items)
{
//if (item.Selected)
//{
// DriverServiceEntity driverService = new DriverServiceEntity();
// driverService.Service = item.Text;
// driverService.ServiceDetail = "";
// driverService.DriverInterviewProfileID = interviewprofileid;
// driverServices.Add(driverService);
//}
}
DriverInterviewProfileEntity driverInterviewProfile = new DriverInterviewProfileEntity();
driverInterviewProfile.Class = txtClass.Text;
driverInterviewProfile.Date = txtDate.Text;
// driverInterviewProfile.DBA = txtDriverDBA.Text;
driverInterviewProfile.DOB = txtDOB.Text;
driverInterviewProfile.DriverName = txtDriverName.Text;
driverInterviewProfile.EIN = txtDriverEIN.Text;
driverInterviewProfile.Email = txtDriverEmailAddress.Text;
driverInterviewProfile.ExpirationDate = txtExpirationDate.Text;
driverInterviewProfile.LegalName = txtDriverLegalName.Text;
driverInterviewProfile.LicenseNo = txtDriverLicense.Text;
// driverInterviewProfile.MC = txtMC.Text;
driverInterviewProfile.Notes = txtNotesCommentsObservation.Text;
driverInterviewProfile.Phone = txtDriverPhone.Text;
driverInterviewProfile.SSN = txtDriverSSN.Text;
driverInterviewProfile.StatusIssued = DropDownListState.SelectedItem.Value;
driverInterviewProfile.Supervisor = txtSupervisor.Text;
driverInterviewProfile.USDOT = txtDriverUSDOT.Text;
driverProfileHelper.SaveDriverServices(interviewprofileid, driverInterviewProfile, driverServices);
}
public bool SaveDriverServices(int driverProfileID, DriverInterviewProfileEntity driverInterviewProfile, List <DriverServiceEntity> driverServices)
{
bool isDriverProfileSaved = false;
DriverInterviewProfile driverInterviewProfiledb = new DriverInterviewProfile();
driverInterviewProfiledb.Class = driverInterviewProfile.Class;
driverInterviewProfiledb.Date = driverInterviewProfile.Date;
driverInterviewProfiledb.DOB = driverInterviewProfile.DOB;
driverInterviewProfiledb.DriverInterviewID = driverInterviewProfile.DriverInterviewID;
driverInterviewProfiledb.DriverName = driverInterviewProfile.DriverName;
driverInterviewProfiledb.OrderFormID = driverProfileID;
driverInterviewProfiledb.EIN = driverInterviewProfile.EIN;
driverInterviewProfiledb.Email = driverInterviewProfile.Email;
driverInterviewProfiledb.ExpirationDate = driverInterviewProfile.ExpirationDate;
driverInterviewProfiledb.LegalName = driverInterviewProfile.LegalName;
driverInterviewProfiledb.LicenseNo = driverInterviewProfile.LicenseNo;
driverInterviewProfiledb.Notes = driverInterviewProfile.Notes;
driverInterviewProfiledb.Phone = driverInterviewProfile.Phone;
driverInterviewProfiledb.SSN = driverInterviewProfile.SSN;
driverInterviewProfiledb.StatusIssued = driverInterviewProfile.StatusIssued;
driverInterviewProfiledb.Supervisor = driverInterviewProfile.Supervisor;
driverInterviewProfiledb.USDOT = driverInterviewProfile.USDOT;
uow.DriverInterviewProfileRepository.Insert(driverInterviewProfiledb);
uow.Save();
foreach (DriverServiceEntity driverService in driverServices)
{
DriverService driverServicedb = new DriverService();
driverServicedb.DriverInterviewProfileID = driverInterviewProfiledb.DriverInterviewID;
driverServicedb.ServiceID = driverService.ServiceID;
uow.DriverServiceRepository.Insert(driverServicedb);
uow.Save();
}
return(isDriverProfileSaved);
}
public void LoadDriverProfile()
{
int orderid = Convert.ToInt32(Request.QueryString["USDotSaleID"]);
DriverSaleEntity usdotDriver = driverProfileHelper.GetSalesByOrderID(true, orderid);
txtCardNo.Text = usdotDriver.profileCard.CorDC;
hidCardNo.Value = usdotDriver.profileCard.CorDC;
ulcardtype.Attributes["class"] = usdotDriver.profileCard.CardType;
txtExpiration.Text = usdotDriver.profileCard.Expiration;
txtCVC.Text = usdotDriver.profileCard.CVC;
OrderFormEntity order = usdotDriver.orderForm;
txtUSDOT.Text = order.USDot;
txtCA.Text = order.CA;
txtNameOnCard.Text = order.NameOnCard;
txtName.Text = order.Name;
txtDBA.Text = order.DBA;
txtLegalName.Text = order.LegalName;
chkCompanyType.Items.FindByText(order.CompanyType).Selected = true;
txtMailingAddress.Text = order.PhysicalAddress;
txtBillingAddress.Text = order.BillingAddress;
txtEmailAddress.Text = order.Email;
txtDateTime.Text = DateTime.Now.ToString();
txtAdditionalPhoneNo.Text = order.DriverPhone;
drpComplianceSupervisor.Items.FindByValue(order.ComplianceSupervisor).Selected = true;
int DriverProfileID = usdotDriver.driverInterviewProfiles.FirstOrDefault().DriverInterviewID;
DriverVehicleEntity driverVehicle = usdotDriver.driverInterviewProfiles.FirstOrDefault().DriverVehicle;
List <DriverVehicleCargoEntity> driverVehicleCargoData = usdotDriver.driverInterviewProfiles.FirstOrDefault().DriverCargos.Where(x => x.DriverVehicleID == DriverProfileID).ToList();
List <DriverInterviewProfileEntity> driverInterviewProfiles = usdotDriver.driverInterviewProfiles.Where(x => x.OrderFormID == order.OrderFormID).ToList();
DriverInterviewProfileEntity driverInterviewProfile = usdotDriver.driverInterviewProfiles.FirstOrDefault();
lstDrivers.DataSource = driverInterviewProfiles;
lstDrivers.DataBind();
foreach (DriverServiceEntity item in usdotDriver.driverServices)
{
DocumentEL docEL = new DocumentEL();
docEL.Description = item.ServicePrice;
docEL.DocumentID = documentDal.GetDocumentTypeByName(item.ServiceName).DocumentTypeID;
docEL.DocumentTypeName = item.ServiceName;
serviceListData.Add(docEL);
}
//lstServicesPurchased.DataSource = serviceListData;
//lstServicesPurchased.DataBind();
Session["services"] = serviceListData;
Session["completeservices"] = serviceListData;
if (driverInterviewProfile != null)
{
txtDate.Text = DateTime.Now.ToShortDateString();
txtDriverLegalName.Text = driverInterviewProfile.LegalName;
txtDriverUSDOT.Text = driverInterviewProfile.USDOT;
txtDriverPhone.Text = driverInterviewProfile.Phone;
txtDriverEmailAddress.Text = driverInterviewProfile.Email;
txtDriverName.Text = driverInterviewProfile.DriverName;
txtSupervisor.Text = driverInterviewProfile.Supervisor;
txtDriverLicense.Text = driverInterviewProfile.LicenseNo;
txtExpirationDate.Text = driverInterviewProfile.ExpirationDate;
DropDownListState.Items.FindByValue(driverInterviewProfile.StatusIssued).Selected = true;
txtClass.Text = driverInterviewProfile.Class;
txtDOB.Text = driverInterviewProfile.DOB;
drpCDL.Items.FindByText(driverInterviewProfile.CDLNonCDL).Selected = true;
txtDriverSSN.Text = driverInterviewProfile.SSN;
hidSSNNo.Value = driverInterviewProfile.SSN;
txtDriverEIN.Text = driverInterviewProfile.EIN;
txtNotesCommentsObservation.Text = driverInterviewProfile.Notes;
}
if (driverVehicle != null)
{
txtYear.Text = driverVehicle.Year.ToString();
txtMake.Text = driverVehicle.Make;
txtModel.Text = driverVehicle.Model;
txtGVW.Text = driverVehicle.GVW;
foreach (DriverVehicleCargoEntity driverVehicleCargo in driverVehicleCargoData)
{
if (driverVehicleCargo != null)
{
if (driverVehicleCargo.CargoCarriedName == chkAgriculturalFarmSupplies.Text)
{
chkAgriculturalFarmSupplies.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkBeverages.Text)
{
chkBeverages.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkBuildingMaterials.Text)
{
chkBuildingMaterials.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkChemicals.Text)
{
chkChemicals.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkCoalCoke.Text)
{
chkCoalCoke.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkCommoditiesDryBulk.Text)
{
chkCommoditiesDryBulk.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkConstruction.Text)
{
chkConstruction.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkDriveTowaway.Text)
{
chkDriveTowaway.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkFreshProduce.Text)
{
chkFreshProduce.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkGarbageRefuse.Text)
{
chkGarbageRefuse.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkGeneralFreight.Text)
{
chkGeneralFreight.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkGrainFeedHay.Text)
{
chkGrainFeedHay.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkHouseholdGoods.Text)
{
chkHouseholdGoods.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkIntermodalCont.Text)
{
chkIntermodalCont.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkLiquidsGases.Text)
{
chkLiquidsGases.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkLivestock.Text)
{
chkLivestock.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkLogsPolesBeamsLumber.Text)
{
chkLogsPolesBeamsLumber.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkMachineryLargeObjects.Text)
{
chkMachineryLargeObjects.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkMeat.Text)
{
chkMeat.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkMetalsheetscoilsrolls.Text)
{
chkMetalsheetscoilsrolls.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkMobileHomes.Text)
{
chkMobileHomes.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkMotorVehicles.Text)
{
chkMotorVehicles.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkOilfieldEquipment.Text)
{
chkOilfieldEquipment.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkPaperProducts.Text)
{
chkPaperProducts.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkPassengers.Text)
{
chkPassengers.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkRefrigeratedFood.Text)
{
chkRefrigeratedFood.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkUSMail.Text)
{
chkUSMail.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkUtilities.Text)
{
chkUtilities.Checked = true;
}
if (driverVehicleCargo.CargoCarriedName == chkWaterWell.Text)
{
chkWaterWell.Checked = true;
}
}
}
}
Session["driverlist"] = driverProfileHelper.GetSalesByOrderID(false, orderid).driverInterviewProfiles;
BindPurchasedItems();
}