public void TransferScheduleRecords(OtherScheduleHold model)
{
if (model.EditType == "Edit")
{
var query = (from other in ContextPerRequest.CurrentData.OtherSchedules
where other.OtherScheduleID == model.OtherScheduleID
select other).FirstOrDefault();
if (query != null)
{
query.BoardCertifiedID = model.BoardCertifiedID;
query.BoardEligibleID = model.BoardEligibleID;
query.ContractorEmployeeID = model.ContractorEmployeeID;
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;
query.SpecialtyOther = model.SpecialtyOther;
query.DateAdded = model.DateAdded;
query.DateRemoved = model.DateRemoved;
ContextPerRequest.CurrentData.SaveChanges();
}
}
else if (model.EditType == "Add")
{
OtherSchedule other = new OtherSchedule
{
BoardCertifiedID = model.BoardCertifiedID,
BoardEligibleID = model.BoardEligibleID,
ContractorEmployeeID = model.ContractorEmployeeID,
DateAdded = model.DateAdded,
FirstName = model.FirstName,
HoursWorked = model.HoursWorked,
LastName = model.LastName,
MemberCoverageID = model.MemberCoverageID,
OwnMalpracticeID = model.OwnMalpracticeID,
RetroDate = model.RetroDate,
SpecialtyID = model.SpecialtyID,
SpecialtyOther = model.SpecialtyOther
};
ContextPerRequest.CurrentData.OtherSchedules.Add(other);
ContextPerRequest.CurrentData.SaveChanges();
}
else if (model.EditType == "Delete")
{
var deleteQuery = (from other in ContextPerRequest.CurrentData.OtherSchedules
where other.OtherScheduleID == model.OtherScheduleID
select other).FirstOrDefault();
if (deleteQuery != null)
{
deleteQuery.DateRemoved = model.DateRemoved;
ContextPerRequest.CurrentData.SaveChanges();
}
}
}
public void OtherScheduleDelete(OtherScheduleDeleteViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
var query = (from ot in ContextPerRequest.CurrentData.OtherSchedules
where ot.OtherScheduleID == model.OtherScheduleID
select ot).FirstOrDefault();
OtherScheduleHold other = new OtherScheduleHold
{
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,
OtherScheduleID = query.OtherScheduleID,
RetroDate = query.RetroDate,
SpecialtyID = query.SpecialtyID,
ScheduleStatusID = 2,
UserID = UserId,
SpecialtyOther = query.SpecialtyOther
};
ContextPerRequest.CurrentData.OtherScheduleHolds.Add(other);
ContextPerRequest.CurrentData.SaveChanges();
}
public void OtherScheduleEdit(OtherScheduleViewModel model)
{
string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID();
OtherScheduleHold other = new OtherScheduleHold
{
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,
OtherScheduleID = model.OtherScheduleID,
RetroDate = model.RetroDate,
SpecialtyID = model.SpecialtyID,
COI = model.COI,
ScheduleStatusID = 2,
UserID = UserId,
SpecialtyOther = model.SpecialtyOther
};
ContextPerRequest.CurrentData.OtherScheduleHolds.Add(other);
ContextPerRequest.CurrentData.SaveChanges();
}
public EmailOtherSchedule OtherSchedulePendingApprove(string scheduleIds)
{
EmailOtherSchedule emailModel = new EmailOtherSchedule();
emailModel.OtherScheduleCOIList = new List <SendingOtherSchedule>();
emailModel.OtherScheduleAddList = new List <SendingOtherSchedule>();
emailModel.OtherScheduleDeleteList = new List <SendingOtherSchedule>();
emailModel.OtherScheduleEditList = new List <SendingOtherSchedule>();
List <string> listScheduleID = new List <string>();
listScheduleID = scheduleIds.Split(',').ToList();
foreach (var item in listScheduleID)
{
int scheduleHoldID = Convert.ToInt32(item.ToString());
var query = (from other in ContextPerRequest.CurrentData.OtherScheduleHolds
join certified in ContextPerRequest.CurrentData.BoardCertifieds on other.BoardCertifiedID equals certified.BoardCertifiedID
join eligible in ContextPerRequest.CurrentData.BoardEligibles on other.BoardEligibleID equals eligible.BoardEligibleID
join malpractice in ContextPerRequest.CurrentData.Malpractices on other.OwnMalpracticeID equals malpractice.MalpracticeID
//join specialty in ContextPerRequest.CurrentData.SpecialtyTypes on other.SpecialtyID equals specialty.SpecialtyTypeID
join employment in ContextPerRequest.CurrentData.EmploymentTypes on other.ContractorEmployeeID equals employment.EmploymentTypeID
where other.OtherScheduleHoldID == scheduleHoldID
select new OtherScheduleHoldViewModel
{
BoardCertifiedDescription = certified.Description,
BoardEligibleDescription = eligible.Description,
EmploymentName = employment.Description,
DateAdded = other.DateAdded,
DateRemoved = other.DateRemoved,
FirstName = other.FirstName,
HoursWorked = other.HoursWorked,
LastName = other.LastName,
MemberCoverageID = other.MemberCoverageID,
OwnMalpracticeDescription = malpractice.Description,
OtherScheduleHoldID = other.OtherScheduleHoldID,
OtherScheduleID = other.OtherScheduleID,
RetroDate = other.RetroDate,
//SpecialtyName = specialty.Description,
BoardCertifiedID = other.BoardCertifiedID ?? 0,
BoardEligibleID = other.BoardEligibleID ?? 0,
COI = other.COI,
ContractorEmployeeID = other.ContractorEmployeeID ?? 0,
EditType = other.EditType,
OwnMalpracticeID = other.OwnMalpracticeID ?? 0,
ScheduleStatusID = other.ScheduleStatusID,
//SpecialtyID = other.SpecialtyID ?? 0,
SpecialtyOther = other.SpecialtyOther
}).FirstOrDefault();
var queryUpdate = (from oth in ContextPerRequest.CurrentData.OtherScheduleHolds
where oth.OtherScheduleHoldID == scheduleHoldID
select oth).FirstOrDefault <OtherScheduleHold>();
if (query != null && queryUpdate != null)
{
int statusId = query.ScheduleStatusID;
if (statusId == 2 && query.COI == true) // pending and COI is checked.
{
SendingOtherSchedule coiModel = new SendingOtherSchedule();
coiModel.FirstName = query.FirstName;
coiModel.LastName = query.LastName;
coiModel.Title = (from specialty in ContextPerRequest.CurrentData.SpecialtyTypes select specialty.Description).FirstOrDefault();
coiModel.DateOfHire = (query.RetroDate.HasValue == true ? Convert.ToDateTime(query.RetroDate).ToShortDateString() : string.Empty);
coiModel.BoardCertified = query.BoardCertifiedDescription;
coiModel.BoardEligible = query.BoardEligibleDescription;
coiModel.EmploymentType = query.EmploymentName;
coiModel.HoursPerWeek = query.HoursWorked.ToString();
coiModel.Malpractice = query.OwnMalpracticeDescription;
emailModel.OtherScheduleCOIList.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" && query.COI)
{
SendingOtherSchedule addModel = new SendingOtherSchedule();
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.OtherScheduleAddList.Add(addModel);
}
else if (query.EditType == "Edit" && query.COI)
{
SendingOtherSchedule editModel = new SendingOtherSchedule();
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.OtherScheduleEditList.Add(editModel);
}
else if (query.EditType == "Delete")
{
SendingOtherSchedule deleteModel = new SendingOtherSchedule();
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.OtherScheduleDeleteList.Add(deleteModel);
}
if (queryUpdate.ScheduleStatusID != 3)
{
queryUpdate.ScheduleStatusID = 5;
ContextPerRequest.CurrentData.SaveChanges();
}
OtherScheduleHold model = new OtherScheduleHold
{
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,
OtherScheduleID = query.OtherScheduleID,
RetroDate = query.RetroDate,
ScheduleStatusID = query.ScheduleStatusID,
SpecialtyID = query.SpecialtyID,
SpecialtyOther = query.SpecialtyOther,
UserID = query.UserID
};
// need to transfer records.
TransferScheduleRecords(model);
}
}
}
return(emailModel);
}