public void PsychiatryScheduleDelete(PsychiatryDeleteViewModel model) { string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID(); var query = (from psych in ContextPerRequest.CurrentData.PsychiatrySchedules where psych.PsychiatryScheduleID == model.PsychiatryScheduleID select psych).FirstOrDefault(); PsychiatryScheduleHold psychiatry = new PsychiatryScheduleHold { 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, PsychiatryScheduleID = query.PsychiatryScheduleID, RetroDate = query.RetroDate, SpecialtyID = query.SpecialtyID, ScheduleStatusID = 2, UserID = UserId, SpecialtyOther = query.SpecialtyOther }; ContextPerRequest.CurrentData.PsychiatryScheduleHolds.Add(psychiatry); ContextPerRequest.CurrentData.SaveChanges(); }
public void PsychiatryScheduleEdit(PsychiatryViewModel model) { string UserId = BHIP.Model.Helper.Security.GetLoggedInUserID(); PsychiatryScheduleHold psychiatry = new PsychiatryScheduleHold { 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, PsychiatryScheduleID = model.PsychiatryScheduleID, RetroDate = model.RetroDate, SpecialtyID = model.SpecialtyID, COI = model.COI, ScheduleStatusID = 2, UserID = UserId, SpecialtyOther = model.SpecialtyOther }; ContextPerRequest.CurrentData.PsychiatryScheduleHolds.Add(psychiatry); ContextPerRequest.CurrentData.SaveChanges(); }
public void TransferScheduleRecords(PsychiatryScheduleHold model) { if (model.EditType == "Edit") { var query = (from psychiatry in ContextPerRequest.CurrentData.PsychiatrySchedules where psychiatry.PsychiatryScheduleID == model.PsychiatryScheduleID select psychiatry).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.DateAdded = model.DateAdded; query.DateRemoved = model.DateRemoved; ContextPerRequest.CurrentData.SaveChanges(); } } else if (model.EditType == "Add") { PsychiatrySchedule psychiatry = new PsychiatrySchedule { 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 }; ContextPerRequest.CurrentData.PsychiatrySchedules.Add(psychiatry); ContextPerRequest.CurrentData.SaveChanges(); } else if (model.EditType == "Delete") { var deleteQuery = (from psychiatry in ContextPerRequest.CurrentData.PsychiatrySchedules where psychiatry.PsychiatryScheduleID == model.PsychiatryScheduleID select psychiatry).FirstOrDefault(); if (deleteQuery != null) { deleteQuery.DateRemoved = model.DateRemoved; ContextPerRequest.CurrentData.SaveChanges(); } } }
public EmailPsychiatry PsychiatryPendingApprove(string scheduleIds) { EmailPsychiatry emailModel = new EmailPsychiatry(); emailModel.PsychiatryCOIList = new List <SendingPsychiatry>(); emailModel.PsychiatryAddList = new List <SendingPsychiatry>(); emailModel.PsychiatryDeleteList = new List <SendingPsychiatry>(); emailModel.PsychiatryEditList = new List <SendingPsychiatry>(); List <string> listScheduleID = new List <string>(); listScheduleID = scheduleIds.Split(',').ToList(); foreach (var item in listScheduleID) { int scheduleHoldID = Convert.ToInt32(item.ToString()); var query = (from psychiatry in ContextPerRequest.CurrentData.PsychiatryScheduleHolds join certified in ContextPerRequest.CurrentData.BoardCertifieds on psychiatry.BoardCertifiedID equals certified.BoardCertifiedID join eligible in ContextPerRequest.CurrentData.BoardEligibles on psychiatry.BoardEligibleID equals eligible.BoardEligibleID join malpractice in ContextPerRequest.CurrentData.Malpractices on psychiatry.OwnMalpracticeID equals malpractice.MalpracticeID join specialty in ContextPerRequest.CurrentData.SpecialtyTypes on psychiatry.SpecialtyID equals specialty.SpecialtyTypeID join employment in ContextPerRequest.CurrentData.EmploymentTypes on psychiatry.ContractorEmployeeID equals employment.EmploymentTypeID where psychiatry.PsychiatryScheduleHoldID == scheduleHoldID select new PsychiatryScheduleHoldViewModel { BoardCertifiedDescription = certified.Description, BoardEligibleDescription = eligible.Description, EmploymentName = employment.Description, DateAdded = psychiatry.DateAdded, DateRemoved = psychiatry.DateRemoved, FirstName = psychiatry.FirstName, HoursWorked = psychiatry.HoursWorked, LastName = psychiatry.LastName, MemberCoverageID = psychiatry.MemberCoverageID, OwnMalpracticeDescription = malpractice.Description, PsychiatryScheduleHoldID = psychiatry.PsychiatryScheduleHoldID, PsychiatryScheduleID = psychiatry.PsychiatryScheduleID, RetroDate = psychiatry.RetroDate, SpecialtyName = specialty.Description, BoardCertifiedID = psychiatry.BoardCertifiedID ?? 0, BoardEligibleID = psychiatry.BoardEligibleID ?? 0, COI = psychiatry.COI, ContractorEmployeeID = psychiatry.ContractorEmployeeID ?? 0, EditType = psychiatry.EditType, OwnMalpracticeID = psychiatry.OwnMalpracticeID ?? 0, ScheduleStatusID = psychiatry.ScheduleStatusID, SpecialtyID = psychiatry.SpecialtyID ?? 0, SpecialtyOther = psychiatry.SpecialtyOther }).FirstOrDefault(); var queryUpdate = (from psy in ContextPerRequest.CurrentData.PsychiatryScheduleHolds where psy.PsychiatryScheduleHoldID == scheduleHoldID select psy).FirstOrDefault <PsychiatryScheduleHold>(); if (query != null && queryUpdate != null) { int statusId = query.ScheduleStatusID; if (statusId == 2 && query.COI == true) // pending and COI is checked. { SendingPsychiatry coiModel = new SendingPsychiatry(); 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(); 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.PsychiatryCOIList.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") { SendingPsychiatry addModel = new SendingPsychiatry(); 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.PsychiatryAddList.Add(addModel); } else if (query.EditType == "Edit" && query.COI) { SendingPsychiatry editModel = new SendingPsychiatry(); 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.PsychiatryEditList.Add(editModel); } else if (query.EditType == "Delete") { SendingPsychiatry deleteModel = new SendingPsychiatry(); 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.PsychiatryDeleteList.Add(deleteModel); } if (queryUpdate.ScheduleStatusID != 3) { queryUpdate.ScheduleStatusID = 5; ContextPerRequest.CurrentData.SaveChanges(); } PsychiatryScheduleHold model = new PsychiatryScheduleHold { 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, PsychiatryScheduleID = query.PsychiatryScheduleID, RetroDate = query.RetroDate, ScheduleStatusID = query.ScheduleStatusID, SpecialtyID = query.SpecialtyID, UserID = query.UserID }; // need to transfer records. TransferScheduleRecords(model); } } } return(emailModel); }