public void VehicleScheduleHoldEdit(VehicleScheduleViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
VehicleScheduleHold vehicle = new VehicleScheduleHold
{
City = model.City,
DateAdded = model.DateAdded,
DateDeleted = model.DateDeleted,
EditType = "Edit",
MakeModel = model.MakeModel,
MemberCoverageID = model.MemberCoverageID,
Notes = model.Notes,
OwnLeaseID = model.OwnLeaseID,
StateID = model.StateID,
VehicleScheduleID = model.VehicleScheduleID,
VIN = model.VIN,
Year = model.Year,
Zipcode = model.Zipcode,
COI = model.COI,
UserID = UserId,
ScheduleStatusID = 2 // pending status
};
ContextPerRequest.CurrentData.VehicleScheduleHolds.Add(vehicle);
ContextPerRequest.CurrentData.SaveChanges();
}
public void VehicleScheduleDelete(VehicleDeleteViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
var query = (from vehicle in ContextPerRequest.CurrentData.VehicleSchedules
where vehicle.VehicleScheduleID == model.VehicleScheduleID
select vehicle).FirstOrDefault();
if (query != null)
{
VehicleScheduleHold veh = new VehicleScheduleHold
{
City = query.City,
DateAdded = query.DateAdded,
DateDeleted = model.DateDeleted,
MakeModel = query.MakeModel,
Notes = query.Notes,
OwnLeaseID = query.OwnLeaseID,
StateID = query.StateID,
VehicleScheduleID = query.VehicleScheduleID,
VIN = query.VIN,
Year = query.Year,
Zipcode = query.Zipcode,
MemberCoverageID = query.MemberCoverageID,
EditType = "Delete",
UserID = UserId,
ScheduleStatusID = 2 // pending status
};
ContextPerRequest.CurrentData.VehicleScheduleHolds.Add(veh);
ContextPerRequest.CurrentData.SaveChanges();
}
}
public void TransferScheduleRecords(VehicleScheduleHold model)
{
if (model.EditType == "Edit")
{
var query = (from veh in ContextPerRequest.CurrentData.VehicleSchedules
where veh.VehicleScheduleID == model.VehicleScheduleID
select veh).FirstOrDefault();
if (query != null)
{
query.City = model.City;
query.DateAdded = model.DateAdded;
query.DateDeleted = model.DateDeleted;
query.MakeModel = model.MakeModel;
query.MemberCoverageID = model.MemberCoverageID;
query.Notes = model.Notes;
query.OwnLeaseID = model.OwnLeaseID;
query.StateID = model.StateID;
query.VehicleValue = model.VehicleValue;
query.VIN = model.VIN;
query.Year = model.Year;
query.Zipcode = model.Zipcode;
ContextPerRequest.CurrentData.SaveChanges();
}
}
else if (model.EditType == "Add")
{
VehicleSchedule vehicle = new VehicleSchedule
{
City = model.City,
DateAdded = model.DateAdded,
MakeModel = model.MakeModel,
MemberCoverageID = model.MemberCoverageID,
Notes = model.Notes,
OwnLeaseID = model.OwnLeaseID,
StateID = model.StateID,
VIN = model.VIN,
Year = model.Year,
Zipcode = model.Zipcode
};
ContextPerRequest.CurrentData.VehicleSchedules.Add(vehicle);
ContextPerRequest.CurrentData.SaveChanges();
}
else if (model.EditType == "Delete")
{
var deleteQuery = (from veh in ContextPerRequest.CurrentData.VehicleSchedules
where veh.VehicleScheduleID == model.VehicleScheduleID
select veh).FirstOrDefault();
if (deleteQuery != null)
{
deleteQuery.DateDeleted = model.DateDeleted;
ContextPerRequest.CurrentData.SaveChanges();
}
}
}
public EmailVehicles VehiclePendingApprove(string scheduleIds)
{
EmailVehicles emailModel = new EmailVehicles();
emailModel.VehicleCOIList = new List <SendingVehicleInfo>();
emailModel.VehicleAddList = new List <SendingVehicleInfo>();
emailModel.VehicleDeleteList = new List <SendingVehicleInfo>();
emailModel.VehicleEditList = new List <SendingVehicleInfo>();
List <string> listScheduleID = new List <string>();
listScheduleID = scheduleIds.Split(',').ToList();
foreach (var item in listScheduleID)
{
int scheduleHoldID = Convert.ToInt32(item.ToString());
var query = (from vehicle in ContextPerRequest.CurrentData.VehicleScheduleHolds
join state in ContextPerRequest.CurrentData.States on vehicle.StateID equals state.StateId
join own in ContextPerRequest.CurrentData.OwnLeases on vehicle.OwnLeaseID equals own.OwnLeaseID
where vehicle.VehicleScheduleHoldID == scheduleHoldID
select new VehicleScheduleHoldViewModel
{
City = vehicle.City,
DateAdded = vehicle.DateAdded,
DateDeleted = vehicle.DateDeleted,
EditType = vehicle.EditType,
MakeModel = vehicle.MakeModel,
MemberCoverageID = vehicle.MemberCoverageID,
Notes = vehicle.Notes,
OwnLeaseDescription = own.Description,
StateName = state.Name,
VehicleScheduleHoldID = vehicle.VehicleScheduleHoldID,
VehicleScheduleID = vehicle.VehicleScheduleID,
VIN = vehicle.VIN,
Year = vehicle.Year ?? 0,
Zipcode = vehicle.Zipcode,
COI = vehicle.COI,
OwnLeaseID = vehicle.OwnLeaseID ?? 0,
ScheduleStatusID = vehicle.ScheduleStatusID,
StateID = vehicle.StateID ?? 0
}).FirstOrDefault();
var queryUpdate = (from veh in ContextPerRequest.CurrentData.VehicleScheduleHolds
where veh.VehicleScheduleHoldID == scheduleHoldID
select veh).FirstOrDefault <VehicleScheduleHold>();
if (query != null && queryUpdate != null)
{
int statusId = query.ScheduleStatusID;
if (statusId == 2 && query.COI == true) // pending and COI is checked.
{
SendingVehicleInfo coiModel = new SendingVehicleInfo();
coiModel.MakeModel = query.MakeModel;
coiModel.VIN = query.VIN;
coiModel.Year = query.Year ?? 0;
coiModel.DateAdded = (query.DateAdded.HasValue == true ? Convert.ToDateTime(query.DateAdded).ToShortDateString() : string.Empty);
coiModel.City = query.City;
coiModel.State = query.StateName;
coiModel.Zip = query.Zipcode;
emailModel.VehicleCOIList.Add(coiModel);
queryUpdate.ScheduleStatusID = 3;
ContextPerRequest.CurrentData.SaveChanges();
}
if (statusId == 3)
{
queryUpdate.ScheduleStatusID = 5;
ContextPerRequest.CurrentData.SaveChanges();
}
else if (statusId == 2) // pending and no COI
{
if (query.EditType == "Add")
{
SendingVehicleInfo addModel = new SendingVehicleInfo();
addModel.MakeModel = query.MakeModel;
addModel.VIN = query.VIN;
addModel.Year = query.Year ?? 0;
addModel.DateAdded = (query.DateAdded.HasValue == true ? Convert.ToDateTime(query.DateAdded).ToShortDateString() : string.Empty);
addModel.City = query.City;
addModel.State = query.StateName;
addModel.Zip = query.Zipcode;
addModel.OwnLease = query.OwnLeaseDescription;
emailModel.VehicleAddList.Add(addModel);
ContextPerRequest.CurrentData.SaveChanges();
}
else if (query.EditType == "Edit" && query.COI)
{
SendingVehicleInfo editModel = new SendingVehicleInfo();
editModel.MakeModel = query.MakeModel;
editModel.VIN = query.VIN;
editModel.Year = query.Year ?? 0;
editModel.DateAdded = (query.DateAdded.HasValue == true ? Convert.ToDateTime(query.DateAdded).ToShortDateString() : string.Empty);
editModel.City = query.City;
editModel.State = query.StateName;
editModel.Zip = query.Zipcode;
editModel.OwnLease = query.OwnLeaseDescription;
emailModel.VehicleEditList.Add(editModel);
ContextPerRequest.CurrentData.SaveChanges();
}
else if (query.EditType == "Delete")
{
SendingVehicleInfo deleteModel = new SendingVehicleInfo();
deleteModel.MakeModel = query.MakeModel;
deleteModel.VIN = query.VIN;
deleteModel.Year = query.Year ?? 0;
deleteModel.DateAdded = (query.DateAdded.HasValue == true ? Convert.ToDateTime(query.DateAdded).ToShortDateString() : string.Empty);
deleteModel.DateRemoved = (query.DateDeleted.HasValue == true ? Convert.ToDateTime(query.DateDeleted).ToShortDateString() : string.Empty);
deleteModel.City = query.City;
deleteModel.State = query.StateName;
deleteModel.Zip = query.Zipcode;
emailModel.VehicleDeleteList.Add(deleteModel);
ContextPerRequest.CurrentData.SaveChanges();
}
VehicleScheduleHold model = new VehicleScheduleHold
{
City = query.City,
COI = query.COI,
DateAdded = query.DateAdded,
DateDeleted = query.DateDeleted,
EditType = query.EditType,
MakeModel = query.MakeModel,
MemberCoverageID = query.MemberCoverageID,
Notes = query.Notes,
OwnLeaseID = query.OwnLeaseID,
ScheduleStatusID = query.ScheduleStatusID,
StateID = query.StateID,
VehicleScheduleID = query.VehicleScheduleID,
VehicleScheduleHoldID = query.VehicleScheduleHoldID,
VehicleValue = 0,
VIN = query.VIN,
Year = query.Year,
Zipcode = query.Zipcode
};
// need to transfer records.
TransferScheduleRecords(model);
if (queryUpdate.ScheduleStatusID != 3)
{
queryUpdate.ScheduleStatusID = 5;
}
ContextPerRequest.CurrentData.SaveChanges();
}
}
}
return(emailModel);
}
