public static void AddEmployee(DataSurfContext context, Employee model) { Models.TempWorksDB.Employee result = context.Employee.FirstOrDefault(result => result.employeeId == model.employeeId); bool addRec = false; if (result == null) { addRec = true; result = new Models.TempWorksDB.Employee(); } result.employeeId = model.employeeId; result.firstName = model.firstName; result.lastName = model.lastName; result.isActive = model.isActive; result.isAssigned = model.isAssigned; result.emailAddress = model.emailAddress; result.postalCode = model.postalCode; result.phoneNumber = string.IsNullOrEmpty(model.cellPhoneNumber) ? model.phoneNumber : model.cellPhoneNumber; result.branchName = model.branch; result.hasResumeOnFile = model.hasResumeOnFile; result.emailAddress = model.emailAddress; result.governmentPersonalId = model.governmentPersonalId; if (addRec) { context.Employee.Add(result); } else { context.Employee.Update(result); } }
public static void AddEventRecord(DataSurfContext context, CovidTestEvents model) { CovidTestEvents result = context.CovidTestEvents.FirstOrDefault(result => result.SignupID == model.SignupID); if (result == null) { result = new CovidTestEvents(); result.SignupID = model.SignupID; result.startdate = model.startdate; result.enddate = model.enddate; result.Title = model.Title; result.TotalSlots = model.TotalSlots; result.FilledSlots = model.FilledSlots; context.CovidTestEvents.Add(result); } else { result.startdate = model.startdate; result.enddate = model.enddate; result.Title = model.Title; result.TotalSlots = model.TotalSlots; result.FilledSlots = model.FilledSlots; context.CovidTestEvents.Update(result); } context.SaveChangesAsync(); }
public static bool AddAssignment(DataSurfContext context, Models.TempWorks.Assignment model) { Models.TempWorksDB.Assignment result = context.Assignment.FirstOrDefault(result => result.assignmentId == model.assignmentId); bool addRec = false; if (result == null) { addRec = true; result = new Models.TempWorksDB.Assignment(); } result.assignmentId = model.assignmentId; result.activeStatus = model.activeStatus; result.assignmentStatus = model.assignmentStatus; result.assignmentStatusId = model.assignmentStatusId; result.billRate = Convert.ToDecimal(model.billRate); result.branchId = model.branchId; result.branchName = model.branchName; result.customerId = model.customerId; result.customerName = model.customerName; result.departmentName = model.departmentName; result.employeeId = model.employeeId; result.endDate = DateTime.Parse(String.IsNullOrEmpty(model.endDate) ? "01/01/1900" : model.endDate); result.expectedEndDate = DateTime.Parse(String.IsNullOrEmpty(model.expectedEndDate) ? "01/01/1900" : model.expectedEndDate); result.firstName = model.firstName; result.isActive = model.isActive; result.isDeleted = model.isDeleted; result.isTimeclockOrder = model.isTimeclockOrder; result.jobOrderId = model.jobOrderId; result.jobTitle = model.jobTitle; result.lastName = model.lastName; result.middleName = model.middleName; result.originalStartDate = DateTime.Parse(String.IsNullOrEmpty(model.originalStartDate) ? "01/01/1900" : model.originalStartDate); result.payRate = Convert.ToDecimal(model.payRate); result.performanceNote = model.performanceNote; result.startDate = DateTime.Parse(String.IsNullOrEmpty(model.startDate) ? "01/01/1900" : model.startDate); result.supervisor = model.supervisor; result.supervisorContactInfo = model.supervisorContactInfo; if (addRec) { context.Assignment.Add(result); } else { context.Assignment.Update(result); } // context.SaveChanges(); return(true); }
public static Models.CovidTestJson GetCovidJson(DataSurfContext context, Models.CovidTestSearch search) { Models.CovidTestJson json = MapModels(GetCovidRecord(context, search)); Models.CovidQuestionsModel questions = context.CovidQuestions.FirstOrDefault(results => results.CovidTestId == Convert.ToInt32(json.CovidtestId)); if (questions != null) { json.covid_in_household = questions.covid_in_household == false ? "No" : "Yes"; json.covid_positive = questions.covid_positive == false ? "No" : "Yes"; json.covid_recovered = questions.covid_recovered == false ? "No" : "Yes"; json.had_covid_contact = questions.had_covid_contact == false ? "No" : "Yes"; json.was_at_covid_risk_location = questions.was_at_covid_risk_location == false ? "No" : "Yes"; json.traveled_outside_us = questions.traveled_outside_us == false ? "No" : "Yes"; } return(json); }
public static bool AddBranch(DataSurfContext context, Models.TempWorks.Branch model) { Models.TempWorksDB.Branch result = context.Branch.FirstOrDefault(result => result.BranchId == model.BranchId); bool addRec = false; if (result == null) { addRec = true; result = new Models.TempWorksDB.Branch(); } result.BranchId = model.BranchId; result.BranchFullName = model.BranchFullName; result.BranchName = model.BranchName; result.PhoneNumber = model.PhoneNumber; result.IsActive = model.IsActive; result.HierId = model.HierId; result.Employer = model.Employer; result.EmployerId = model.EmployerId; result.EmailAddress = model.EmailAddress; Models.TempWorksDB.Address add = new Models.TempWorksDB.Address() { Street1 = model.Address.Street1, Street2 = model.Address.Street2, PostalCode = model.Address.PostalCode, Country = model.Address.Country, Municipality = model.Address.Municipality, Region = model.Address.Region, AttentionTo = model.Address.AttentionTo }; result.AddressId = AddAddress(context, add); if (addRec) { context.Branch.Add(result); } else { context.Branch.Update(result); } context.SaveChanges(); return(true); }
public static Models.CovidTestDBModel GetCovidRecord(DataSurfContext context, Models.CovidTestSearch search) { Models.CovidTestDBModel model = null; Int32 ID = 0; if (string.IsNullOrEmpty(search.CovidTestId)) { ID = 0; } else { ID = Convert.ToInt32(search.CovidTestId); } if (ID != 0) { model = context.CovidTests.FirstOrDefault(results => results.CovidtestId == ID); if (model == null) { model = context.CovidTests.FirstOrDefault(results => results.patient_first_name == search.patient_first_name && results.patient_last_name == search.patient_last_name //&& results.patient_zip_code == search.patient_zip_code && results.patient_email == search.patient_email); } if (model != null) { return(model); } } else { model = context.CovidTests.FirstOrDefault(results => results.patient_first_name == search.patient_first_name && results.patient_last_name == search.patient_last_name //&& results.patient_zip_code == search.patient_zip_code && results.patient_email == search.patient_email); return(model); } return(null); }
public static Models.CovidTestJson GetCovidRecord(DataSurfContext context, int ID) { try { Models.CovidTestDBModel model = null; model = context.CovidTests.FirstOrDefault(result => result.CovidtestId == ID); if (model == null) { model = context.CovidTests.FirstOrDefault(result => result.AppointmentID == ID); } if (model == null) { return(null); } Models.CovidTestJson json = MapModels(model); Models.CovidQuestionsModel questions = null; questions = context.CovidQuestions.FirstOrDefault(result => result.CovidTestId == model.CovidtestId); if (questions != null) { json.covid_in_household = questions.covid_in_household == false ? "No" : "Yes"; json.covid_positive = questions.covid_positive == false ? "No" : "Yes"; json.covid_recovered = questions.covid_recovered == false ? "No" : "Yes"; json.had_covid_contact = questions.had_covid_contact == false ? "No" : "Yes"; json.was_at_covid_risk_location = questions.was_at_covid_risk_location == false ? "No" : "Yes"; json.traveled_outside_us = questions.traveled_outside_us == false ? "No" : "Yes"; } return(json); } catch (Exception ex) { return(null); } }
//public void InitializeAsync(IServiceProvider service, Models.CovidTestJson model) //{ // AddCovidRecord(service.GetRequiredService<DataSurfContext>(), model); //} public static bool AddGeniueSignup(DataSurfContext context, Models.CovidTestGenieJSon model) { Models.CovidTestDBModel find = context.CovidTests.FirstOrDefault(rec => rec.patient_first_name == model.firstname && rec.patient_last_name == model.lastname && rec.patient_email == model.email); if (find != null) // we don't want to override the record in this case { return(false); } find = new CovidTestDBModel(); find.patient_email = model.email; find.patient_first_name = model.firstname; find.patient_last_name = model.lastname; find.patient_phone_number = model.phone; find.patient_schedule_date = DateTime.Parse(model.startdatestring); find.time_slot = model.time_slot; find.AppointmentID = Convert.ToInt32(model.itemnumberid); find.consent_date = DateTime.MinValue; context.CovidTests.Add(find); context.SaveChanges(); return(true); }
public static int AddAddress(DataSurfContext context, DataLayer.Models.TempWorksDB.Address model) { if (String.IsNullOrEmpty(model.Street1)) { return(0); } Models.TempWorksDB.Address result = context.Address.FirstOrDefault(result => result.Street1 == model.Street1 && result.PostalCode == model.PostalCode); bool addRec = false; if (result == null) { addRec = true; result = new Models.TempWorksDB.Address(); } result.Street1 = model.Street1; result.Street2 = model.Street2; result.PostalCode = model.PostalCode; result.Region = model.Region; result.Municipality = model.Municipality; result.AttentionTo = model.AttentionTo; result.Country = model.Country; if (addRec) { context.Address.Add(result); } else { context.Address.Update(result); } context.SaveChanges(); return(result.AddressId); }
public static bool AddCustomer(DataSurfContext context, DataLayer.Models.TempWorks.Customer model) { Models.TempWorksDB.Customer result = context.Customer.FirstOrDefault(results => results.CustomerId == model.CustomerId); bool addRec = false; if (result == null) { addRec = true; result = new Models.TempWorksDB.Customer(); } result.CustomerId = model.CustomerId; result.CustomerName = model.CustomerName; result.CustomerStatus = model.CustomerStatus; result.CustomerStatusId = model.CustomerStatusId; result.DateActivated = DateTime.Parse(model.DateActivated); result.DepartmentName = model.DepartmentName; //result.ParentCustomerId = model.ParentCustomerId; result.RootCustomerId = model.RootCustomerId; Models.TempWorksDB.Address add = new Models.TempWorksDB.Address(); add.Street1 = model.BillingAddress.Street1; add.Street2 = model.BillingAddress.Street2; add.PostalCode = model.BillingAddress.PostalCode; add.Municipality = model.BillingAddress.Municipality; add.Region = model.BillingAddress.Region; add.AttentionTo = model.BillingAddress.AttentionTo; add.Country = model.BillingAddress.Country; result.BillingAddressID = AddAddress(context, add); add.Street1 = model.WorksiteAddress.Street1; add.Street2 = model.WorksiteAddress.Street2; add.Municipality = model.WorksiteAddress.Municipality; add.PostalCode = model.WorksiteAddress.PostalCode; add.Region = model.WorksiteAddress.Region; add.AttentionTo = model.WorksiteAddress.AttentionTo; add.Country = model.WorksiteAddress.Country; result.WorksiteAddressID = AddAddress(context, add); result.BranchId = model.BranchId; result.BranchName = model.BranchName; if (addRec) { context.Customer.Add(result); } else { context.Customer.Update(result); } context.SaveChanges(); return(true); }
public static bool AddCovidRecord(DataSurfContext context, Models.CovidTestJson model) { Models.CovidTestSearch search = new Models.CovidTestSearch(); if (!string.IsNullOrEmpty(model.AppointmentID)) { search.CovidTestId = model.AppointmentID; } else { search.CovidTestId = model.CovidtestId; } search.patient_first_name = model.patient_first_name; search.patient_last_name = model.patient_last_name; search.patient_email = model.patient_email; Models.CovidTestDBModel save = null; save = GetCovidRecord(context, search); //Models.CovidTestDBModel save = new Models.CovidTestDBModel(); if (save == null) { save = new Models.CovidTestDBModel(); save.AppointmentID = 0; save.CovidtestId = 0; } save.appointmentLocationID = 0; save.sample_collection_date = DateTime.UtcNow; save.patient_first_name = model.patient_first_name; save.patient_last_name = model.patient_last_name; save.patient_phone_number = model.patient_phone_number; save.patient_sex = model.patient_sex; save.patient_state = model.patient_state; save.patient_city = model.patient_city; save.patient_street_address = model.patient_street_address; save.patient_zip_code = model.patient_zip_code; save.patient_bill_city = model.patient_bill_city; save.patient_bill_name = model.patient_bill_name; save.patient_bill_state = model.patient_bill_state; save.patient_bill_street = model.patient_bill_street; save.patient_bill_zip = model.patient_bill_zip; save.patient_date_of_birth = Convert.ToDateTime(model.patient_date_of_birth); save.patient_email = model.patient_email; save.sample_1_container_barcode = model.sample_1_container_barcode; save.identifier = model.sample_1_container_barcode; save.sample_1_collected_by = "Maricopa Technician"; save.sample_1_container_type = "TUBE"; save.identifier = model.sample_1_container_barcode; save.sample_1_state_position = "A01"; save.test_panel_code = "IDT-COVID-19"; save.sample_1_identifier = "CLINTEST01"; save.num_samples = 1; save.provider_npi = "1639369036"; save.institutional_bill_name = model.institutional_bill_name; save.primary_insurance_id_number = model.primary_insurance_id_number; save.primary_insurance_insurance_provider = model.primary_insurance_insurance_provider; save.primary_insurance_relationship_to_insured = model.primary_insurance_relationship_to_insured; save.bill_type = string.IsNullOrEmpty(save.primary_insurance_insurance_provider) ? "Institutional Bill" : "Insurance"; save.patient_bill_phone_number = model.patient_bill_phone_number; save.provider_account = model.provider_account; save.SSN = model.SSN; save.identification = model.identification; save.last_mod_dt = DateTime.Now; save.consent_date = model.patient_consent.ToLower() == "yes" ? DateTime.Now:DateTime.MinValue; if (save.CovidtestId == 0) { context.CovidTests.Add(save); } else { context.CovidTests.Update(save); } Models.CovidQuestionsModel questions = context.CovidQuestions.FirstOrDefault(result => result.CovidTestId == save.CovidtestId); if (questions == null) { questions = new Models.CovidQuestionsModel(); questions.CovidTestId = save.CovidtestId; questions.covid_in_household = model.covid_in_household == "Yes" ? true:false; questions.traveled_outside_us = model.traveled_outside_us == "Yes" ? true : false; questions.covid_positive = model.covid_positive == "Yes" ? true: false; questions.covid_recovered = model.covid_recovered == "Yes" ? true: false; questions.had_covid_contact = model.had_covid_contact == "Yes" ? true : false; questions.was_at_covid_risk_location = model.was_at_covid_risk_location == "Yes" ? true : false; context.CovidQuestions.Add(questions); } else { questions.CovidTestId = save.CovidtestId; questions.covid_in_household = model.covid_in_household == "Yes" ? true : false; questions.traveled_outside_us = model.traveled_outside_us == "Yes" ? true : false; questions.covid_positive = model.covid_positive == "Yes" ? true : false; questions.covid_recovered = model.covid_recovered == "Yes" ? true : false; questions.had_covid_contact = model.had_covid_contact == "Yes" ? true : false; questions.was_at_covid_risk_location = model.was_at_covid_risk_location == "Yes" ? true : false; context.CovidQuestions.Update(questions); } context.SaveChangesAsync(); return(true); }
public static Models.CovidTestEvents GetCovidTestEvents(DataSurfContext context, int ID) { CovidTestEvents results = context.CovidTestEvents.FirstOrDefault(results => results.SignupEventId == ID); return(results); }