public void PrimaryCareScheduleDelete(PrimaryCareDeleteViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
var query = (from primary in ContextPerRequest.CurrentData.PrimaryCareSchedules
where primary.PrimaryCareScheduleID == model.PrimaryCareScheduleID
select primary).FirstOrDefault();
if (query != null)
{
PrimaryCareScheduleHold primary = new PrimaryCareScheduleHold
{
BoardCertifiedID = query.BoardCertifiedID,
BoardEligibleID = query.BoardEligibleID,
ContractorEmployeeID = query.ContractorEmployeeID,
DateAdded = query.DateAdded,
DateRemoved = model.DateRemoved,
EditType = "Delete",
FirstName = query.FirstName,
HoursWorked = query.HoursWorked,
LastName = query.LastName,
MemberCoverageID = query.MemberCoverageID,
OwnMalPracticeID = query.OwnMalPracticeID,
PrimaryCareScheduleID = query.PrimaryCareScheduleID,
RetroDate = query.RetroDate,
SpecialtyID = query.SpecialtyID,
ScheduleStatusID = 2,
UserID = UserId
};
ContextPerRequest.CurrentData.PrimaryCareScheduleHolds.Add(primary);
ContextPerRequest.CurrentData.SaveChanges();
}
}
public void PrimaryCareScheduleEdit(PrimaryCareViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
PrimaryCareScheduleHold primary = new PrimaryCareScheduleHold
{
BoardCertifiedID = model.BoardCertifiedID,
BoardEligibleID = model.BoardEligibleID,
ContractorEmployeeID = model.ContractorEmployeeID,
DateAdded = model.DateAdded,
DateRemoved = model.DateRemoved,
EditType = "Edit",
FirstName = model.FirstName,
HoursWorked = model.HoursWorked,
LastName = model.LastName,
MemberCoverageID = model.MemberCoverageID,
OwnMalPracticeID = model.OwnMalpracticeID,
PrimaryCareScheduleID = model.PrimaryCareScheduleID,
RetroDate = model.RetroDate,
SpecialtyID = model.SpecialtyID,
COI = model.COI,
ScheduleStatusID = 2,
UserID = UserId
};
ContextPerRequest.CurrentData.PrimaryCareScheduleHolds.Add(primary);
ContextPerRequest.CurrentData.SaveChanges();
}
public void TransferScheduleRecords(PrimaryCareScheduleHold model)
{
if (model.EditType == "Edit")
{
var query = (from primary in ContextPerRequest.CurrentData.PrimaryCareSchedules
where primary.PrimaryCareScheduleID == model.PrimaryCareScheduleID
select primary).FirstOrDefault();
if (query != null)
{
query.BoardCertifiedID = model.BoardCertifiedID;
query.BoardEligibleID = model.BoardEligibleID;
query.ContractorEmployeeID = model.ContractorEmployeeID;
query.DateAdded = model.DateAdded;
query.DateRemoved = model.DateRemoved;
query.FirstName = model.FirstName;
query.HoursWorked = model.HoursWorked;
query.LastName = model.LastName;
query.MemberCoverageID = model.MemberCoverageID;
query.OwnMalPracticeID = model.OwnMalPracticeID;
query.RetroDate = model.RetroDate;
query.SpecialtyID = model.SpecialtyID;
ContextPerRequest.CurrentData.SaveChanges();
}
}
else if (model.EditType == "Add")
{
PrimaryCareSchedule vehicle = new PrimaryCareSchedule
{
BoardCertifiedID = model.BoardCertifiedID,
BoardEligibleID = model.BoardEligibleID,
ContractorEmployeeID = model.ContractorEmployeeID,
DateAdded = model.DateAdded,
DateRemoved = model.DateRemoved,
FirstName = model.FirstName,
HoursWorked = model.HoursWorked,
LastName = model.LastName,
MemberCoverageID = model.MemberCoverageID,
OwnMalPracticeID = model.OwnMalPracticeID,
RetroDate = model.RetroDate,
SpecialtyID = model.SpecialtyID
};
ContextPerRequest.CurrentData.PrimaryCareSchedules.Add(vehicle);
ContextPerRequest.CurrentData.SaveChanges();
}
else if (model.EditType == "Delete")
{
var deleteQuery = (from primary in ContextPerRequest.CurrentData.PrimaryCareSchedules
where primary.PrimaryCareScheduleID == model.PrimaryCareScheduleID
select primary).FirstOrDefault();
if (deleteQuery != null)
{
deleteQuery.DateRemoved = model.DateRemoved;
ContextPerRequest.CurrentData.SaveChanges();
}
}
}
public EmailPrimaryCare PrimaryCarePendingApprove(string scheduleIds)
{
EmailPrimaryCare emailModel = new EmailPrimaryCare();
emailModel.PrimaryCareCOIList = new List <SendingPrimaryCare>();
emailModel.PrimaryCareAddList = new List <SendingPrimaryCare>();
emailModel.PrimaryCareDeleteList = new List <SendingPrimaryCare>();
emailModel.PrimaryCareEditList = new List <SendingPrimaryCare>();
List <string> listScheduleID = new List <string>();
listScheduleID = scheduleIds.Split(',').ToList();
foreach (var item in listScheduleID)
{
int scheduleHoldID = Convert.ToInt32(item.ToString());
var query = (from primary in ContextPerRequest.CurrentData.PrimaryCareScheduleHolds
join certified in ContextPerRequest.CurrentData.BoardCertifieds on primary.BoardCertifiedID equals certified.BoardCertifiedID
join eligible in ContextPerRequest.CurrentData.BoardEligibles on primary.BoardEligibleID equals eligible.BoardEligibleID
join malpractice in ContextPerRequest.CurrentData.Malpractices on primary.OwnMalPracticeID equals malpractice.MalpracticeID
join specialty in ContextPerRequest.CurrentData.SpecialtyTypes on primary.SpecialtyID equals specialty.SpecialtyTypeID
join employment in ContextPerRequest.CurrentData.EmploymentTypes on primary.ContractorEmployeeID equals employment.EmploymentTypeID
where primary.PrimaryCareScheduleHoldID == scheduleHoldID
select new PrimaryCareHoldViewModel
{
BoardCertifiedDescription = certified.Description,
BoardEligibleDescription = eligible.Description,
EmploymentName = employment.Description,
DateAdded = primary.DateAdded,
DateRemoved = primary.DateRemoved,
FirstName = primary.FirstName,
HoursWorked = primary.HoursWorked,
LastName = primary.LastName,
MemberCoverageID = primary.MemberCoverageID,
OwnMalpracticeDescription = malpractice.Description,
PrimaryCareScheduleHoldID = primary.PrimaryCareScheduleHoldID,
PrimaryCareScheduleID = primary.PrimaryCareScheduleID,
RetroDate = primary.RetroDate,
SpecialtyName = specialty.Description,
BoardCertifiedID = primary.BoardCertifiedID,
BoardEligibleID = primary.BoardEligibleID,
COI = primary.COI,
ContractorEmployeeID = primary.ContractorEmployeeID ?? 0,
EditType = primary.EditType,
OwnMalpracticeID = primary.OwnMalPracticeID ?? 0,
ScheduleStatusID = primary.ScheduleStatusID,
SpecialtyID = primary.SpecialtyID
}).FirstOrDefault();
var queryUpdate = (from prim in ContextPerRequest.CurrentData.PrimaryCareScheduleHolds
where prim.PrimaryCareScheduleHoldID == scheduleHoldID
select prim).FirstOrDefault <PrimaryCareScheduleHold>();
if (query != null && queryUpdate != null)
{
int statusId = query.ScheduleStatusID;
if (statusId == 2 && query.COI == true) // pending and COI is checked.
{
SendingPrimaryCare coiModel = new SendingPrimaryCare();
coiModel.FirstName = query.FirstName;
coiModel.LastName = query.LastName;
coiModel.Title = (from specialty in ContextPerRequest.CurrentData.SpecialtyTypes where specialty.SpecialtyTypeID == query.SpecialtyID select specialty.Description).FirstOrDefault();
emailModel.PrimaryCareCOIList.Add(coiModel);
queryUpdate.ScheduleStatusID = 3;
ContextPerRequest.CurrentData.SaveChanges();
}
if (statusId == 3)
{
queryUpdate.ScheduleStatusID = 5;
ContextPerRequest.CurrentData.SaveChanges();
}
else if (query.ScheduleStatusID == 2) // pending and no COI
{
if (query.EditType == "Add")
{
SendingPrimaryCare addModel = new SendingPrimaryCare();
addModel.FirstName = query.FirstName;
addModel.LastName = query.LastName;
addModel.Title = (from specialty in ContextPerRequest.CurrentData.SpecialtyTypes where specialty.SpecialtyTypeID == query.SpecialtyID select specialty.Description).FirstOrDefault();
addModel.DateOfHire = (query.RetroDate.HasValue == true ? Convert.ToDateTime(query.RetroDate).ToShortDateString() : string.Empty);
addModel.BoardCertified = query.BoardCertifiedDescription;
addModel.BoardEligible = query.BoardEligibleDescription;
addModel.EmploymentType = query.EmploymentName;
addModel.HoursPerWeek = query.HoursWorked.ToString();
addModel.Malpractice = query.OwnMalpracticeDescription;
emailModel.PrimaryCareAddList.Add(addModel);
}
else if (query.EditType == "Edit" && query.COI)
{
SendingPrimaryCare editModel = new SendingPrimaryCare();
editModel.FirstName = query.FirstName;
editModel.LastName = query.LastName;
editModel.Title = (from specialty in ContextPerRequest.CurrentData.SpecialtyTypes where specialty.SpecialtyTypeID == query.SpecialtyID select specialty.Description).FirstOrDefault();
editModel.DateOfHire = (query.RetroDate.HasValue == true ? Convert.ToDateTime(query.RetroDate).ToShortDateString() : string.Empty);
editModel.BoardCertified = query.BoardCertifiedDescription;
editModel.BoardEligible = query.BoardEligibleDescription;
editModel.EmploymentType = query.EmploymentName;
editModel.HoursPerWeek = query.HoursWorked.ToString();
editModel.Malpractice = query.OwnMalpracticeDescription;
emailModel.PrimaryCareEditList.Add(editModel);
}
else if (query.EditType == "Delete")
{
SendingPrimaryCare deleteModel = new SendingPrimaryCare();
deleteModel.FirstName = query.FirstName;
deleteModel.LastName = query.LastName;
deleteModel.Title = (from specialty in ContextPerRequest.CurrentData.SpecialtyTypes where specialty.SpecialtyTypeID == query.SpecialtyID select specialty.Description).FirstOrDefault();
deleteModel.DateOfHire = (query.RetroDate.HasValue == true ? Convert.ToDateTime(query.RetroDate).ToShortDateString() : string.Empty);
deleteModel.BoardCertified = query.BoardCertifiedDescription;
deleteModel.BoardEligible = query.BoardEligibleDescription;
deleteModel.EmploymentType = query.EmploymentName;
deleteModel.HoursPerWeek = query.HoursWorked.ToString();
deleteModel.Malpractice = query.OwnMalpracticeDescription;
deleteModel.DateRemoved = (query.DateRemoved.HasValue == true ? Convert.ToDateTime(query.DateRemoved).ToShortDateString() : string.Empty);
emailModel.PrimaryCareDeleteList.Add(deleteModel);
}
PrimaryCareScheduleHold model = new PrimaryCareScheduleHold
{
BoardCertifiedID = query.BoardCertifiedID,
BoardEligibleID = query.BoardEligibleID,
COI = query.COI,
ContractorEmployeeID = query.ContractorEmployeeID,
DateAdded = query.DateAdded,
DateRemoved = query.DateRemoved,
EditType = query.EditType,
FirstName = query.FirstName,
HoursWorked = query.HoursWorked,
LastName = query.LastName,
MemberCoverageID = query.MemberCoverageID,
OwnMalPracticeID = query.OwnMalpracticeID,
PrimaryCareScheduleID = query.PrimaryCareScheduleID,
RetroDate = query.RetroDate,
ScheduleStatusID = query.ScheduleStatusID,
SpecialtyID = query.SpecialtyID,
UserID = query.UserID
};
// need to transfer records.
TransferScheduleRecords(model);
if (queryUpdate.ScheduleStatusID != 3)
{
queryUpdate.ScheduleStatusID = 5;
}
ContextPerRequest.CurrentData.SaveChanges();
}
}
}
return(emailModel);
}
