public IHttpActionResult getPatientResult() { PatientBO patientBO = new PatientBO(); var patientDtl = patientBO.getPatientDetails(); return(Ok(new { result = patientDtl })); }
public void SendAppCancelledEmail(List <AppointmentBO> cancelledAppts) { try { foreach (var p in cancelledAppts) { PatientBO pat = new PatientBO(); pat.pid = p.paitent_ID; PatientBLLFactory patientBBLFactory = new PatientBLLFactory(); var details = (patientBBLFactory.CreatePatientBLL().GetPatientBLL().CreatePatientDAL().GetPatientDetialsByID(pat)); foreach (var e in details) { MailMessage mailMessage = new MailMessage("*****@*****.**", e.emailID); // Specify the email body mailMessage.Body = "Dear Patient Your appointment with doctor" + p.doctorName + "and appointment Number" + p.appointment_ID + "and date" + p.appointment_Date + "is cancelled, Kindly reschedule it."; mailMessage.Subject = "Appointment Cancelled"; SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587); smtpClient.Credentials = new System.Net.NetworkCredential() { UserName = "******", Password = "******" }; smtpClient.EnableSsl = true; smtpClient.Send(mailMessage); } } } catch (Exception ex) { } }
//Method to deactivate patient account, with string return type public string DeactivatePatient_DAL(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Patient patient = objHmsDataContext.Patients.SingleOrDefault(id => id.Patient_ID == patientBO.pid); patient.IsActive = false; objHmsDataContext.SubmitChanges(); return("Account Deactivated Successfully"); } } catch (Exception e) { return("Unable to deactive please try again"); } }
public IEnumerable <PatientBO> GetPatientDetialsByID(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } IEnumerable <PatientBO> patientInfo = objHmsDataContext.Patients.Where(pat => (pat.Patient_ID == patientBO.pid)) .Select(p => new PatientBO { firstName = p.First_Name, lastName = p.Last_Name, address = p.Address, phone = p.Phone, emailID = p.Email_ID, pwd = p.Password, gender = p.Gender, dateOfBirth = p.DateOfBirth, patientType = ConvertStingToPatType(p), pid = p.Patient_ID, isActive = p.IsActive }).ToArray(); return(patientInfo); } } catch (Exception e) { return(null); } }
public IEnumerable <TreatmentRoomBO> GetRoomsRecordsByPatID(PatientBO pat) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } IEnumerable <TreatmentRoomBO> treatmentRoom; treatmentRoom = objHmsDataContext.TreatmentRoom_Records .Join(objHmsDataContext.Patients, t => t.Patient_ID, p => p.Patient_ID, (t, p) => new TreatmentRoomBO { patient_ID = t.Patient_ID, timings = Convert.ToString(t.Timings), isBooked = t.IsBooked, date = t.DateOfJoin, room_ID = t.Room_ID, appointment_ID = t.Appointment_ID, PatientFirstName = p.First_Name }).Where(t => (t.patient_ID == pat.pid)).ToArray(); return(treatmentRoom); } } catch (Exception e) { IEnumerable <TreatmentRoomBO> trmntRoomBO = null; return(trmntRoomBO); } }
//Method to Activate Patient Account public string ActivatePatient_DAL(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Patient patient1 = objHmsDataContext.Patients.SingleOrDefault(id => id.Patient_ID == patientBO.pid); patient1.IsActive = true; objHmsDataContext.SubmitChanges(); Patient patient2 = objHmsDataContext.Patients.SingleOrDefault(id => id.Patient_ID == patientBO.pid); return(" Account Activated"); } } catch (Exception e) { return("Unable To Activate Account Try again later"); } }
//Method to insert patient details into patient table, with return type patient Business object public PatientBO InsertPatientDetails_DAL(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } { Patient patient = new Patient(); Patient obj_patient = ConvertBOToPatient(patient, patientBO); obj_patient.IsActive = true; objHmsDataContext.Patients.InsertOnSubmit(obj_patient); objHmsDataContext.SubmitChanges(); Patient newPatient = objHmsDataContext.Patients.SingleOrDefault(pat => pat.Email_ID == patientBO.emailID); PatientBO new_Patient = ConvertPatientToBO(newPatient); return(new_Patient); } } } catch (Exception e) { PatientBO patient_BO = new PatientBO(); return(patient_BO); } }
//Method to update patient details SecurityQuestion, with string return type public string UpdatePatientDetails_DAL(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext objHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (objHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { objHmsDataContext.Connection.Open(); } Patient patient = objHmsDataContext.Patients.SingleOrDefault(pat => (pat.Patient_ID == patientBO.pid || pat.Email_ID == patientBO.emailID)); Patient updatedpatient = AssignUpdates(patient, patientBO); objHmsDataContext.SubmitChanges(); return("Successfullly Updated"); } } catch { return(""); } }
public void FillByGivenGuNoGUYearReturnsPatientNotNull() { dataContext.Patient_Info.Add(GetTestPatient()); PatientBO patient = new PatientBO(); patient.FillBy(1, 2015); Assert.IsNotNull(patient); }
public void FillByGivenGuNoGUYearReturnsNoRecordException() { dataContext.Patient_Info.Add(GetTestPatient()); PatientBO patient = new PatientBO(); patient.FillBy(0, 2015); }
//Funtion to assign updates from patientBO to Patient public Patient AssignUpdates(Patient patient, PatientBO patientBO) { if (!string.IsNullOrEmpty(patientBO.pwd)) { patient.Password = patientBO.pwd; } if (!string.IsNullOrEmpty(patientBO.firstName)) { patient.First_Name = patientBO.firstName; } if (!string.IsNullOrEmpty(patientBO.lastName)) { patient.Last_Name = patientBO.lastName; } if (!string.IsNullOrEmpty(patientBO.address)) { patient.Address = patientBO.address; } if (!string.IsNullOrEmpty(patientBO.phone)) { patient.Phone = patientBO.phone; } if (!string.IsNullOrEmpty(patientBO.securityQn)) { patient.Security_Question = patientBO.securityQn; } if (!string.IsNullOrEmpty(patientBO.securityAns)) { patient.Security_Answer = patientBO.securityAns; } if (!string.IsNullOrEmpty(patientBO.gender)) { patient.Gender = patientBO.gender; } if ((patientBO.dateOfBirth != DateTime.MinValue)) { patient.DateOfBirth = patientBO.dateOfBirth; } if (!string.IsNullOrEmpty(Convert.ToString(patientBO.patientType))) { patient.Patient_Type = Convert.ToString(patientBO.patientType); } if (patientBO.isActive != patient.IsActive) { patient.IsActive = patientBO.isActive; } return(patient); }
//Convert Patient to PatientBO public PatientBO ConvertPatientToBO(Patient patient) { PatientBO patientBO = new PatientBO(patient.Patient_ID, patient.First_Name, patient.Last_Name, patient.Email_ID, patient.Password, patient.DateOfBirth, patient.Security_Question, patient.Security_Answer, patient.Phone, patient.Address, patient.Gender, patient.IsActive, ConvertStingToPatType(patient)); return(patientBO); }
public DataTable PatientDisplay(PatientBO pbo) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from patient where NHSRegNum = " + pbo.NHSRegNum + ";"; return(pdt.ExeReader(cmd)); }
// PUT: api/Patient/5 //Put action with int and patient Business object as input parameter, string as return type public string Put(int id, [FromBody] PatientBO patientUpdates) { PatientBLLFactory patientBLLFactory = new PatientBLLFactory(); string result = patientBLLFactory.CreatePatientBLL().UpdatePatientBLL().CreatePatientDAL().UpdatePatientDetails_DAL(patientUpdates); return(result); }
public string PatientValidateEmail(string text) { PatientBLLFactory patient = new PatientBLLFactory(); PatientBO pat = new PatientBO(); pat.emailID = text; return(patient.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().ValidateEmailPatient_DAL(pat)); }
protected void Button1_Click(object sender, EventArgs e) { PatientBO patientbo = new PatientBO(); GridView1.VirtualItemCount = patientbo.Count(x => x.HealthCardNo.Contains(TextBox1.Text.Trim())); GridView1.DataSource = patientbo.Find(x => x.HealthCardNo.Contains(TextBox1.Text.Trim()), 0, GridView1.PageSize) .ToList(); GridView1.DataBind(); Button1.Enabled = true; }
protected void Page_Load(object sender, EventArgs e) { PatientBO patientbo = new PatientBO(); if (!IsPostBack) { this.ReportViewer1.LocalReport.ReportPath = "PatientType/Patient.rdlc"; this.ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", patientbo.GetAll())); this.ReportViewer1.LocalReport.Refresh(); } }
public string UserForgotPassword(Person _person) { var result = ""; if (_person.pid == 1) { AdministratorBLLFactory admin = new AdministratorBLLFactory(); AdministratorBO adminBO = new AdministratorBO(); adminBO.emailID = _person.emailID; result = admin.CreateAdministratorBLL().ValidateAdminBLL().CreateAdminstratorDAL().ValidateEmailAdmin_DAL(_person.emailID); } else if (_person.pid == 2) { PatientBLLFactory patient = new PatientBLLFactory(); PatientBO patientBO = new PatientBO(); patientBO.emailID = _person.emailID; result = patient.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().ValidateEmailPatient_DAL(patientBO); } else if (_person.pid == 3) { DoctorBLLFactory doctor = new DoctorBLLFactory(); DoctorBO doctorBO = new DoctorBO(); doctorBO.emailID = _person.emailID; result = doctor.CreateDoctorBLL().ValidateDoctorBLL().CreateDoctorDAL().ValidateEmailDoctor_DAL(doctorBO); } else if (_person.pid == 4) { NurseBLLFactory nurse = new NurseBLLFactory(); NurseBO nurseBO = new NurseBO(); nurseBO.emailID = _person.emailID; result = nurse.CreateNurseBLL().ValidateNurse().CreateNurseDAL().ValidateNurse_DAL(nurseBO); } else if (_person.pid == 5) { LabInchargeBLLFactory incharge = new LabInchargeBLLFactory(); LabInchargeBO inchargeBO = new LabInchargeBO(); inchargeBO.emailID = _person.emailID; result = incharge.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().ValidateLabIncharge_DAL(inchargeBO); } if ((result) != "false" && result != "" && result != null) { EmailController email = new EmailController(); email.SendForgotPasswordEmail(result, _person.emailID); return("Sent Password to Email"); } else { return("User Do not exist"); } }
// GET: api/Patient/7001 //Get action which accepts int and string as parameters and patient business object as return type public PatientBO Get(int id, string userPwd) { PatientBO patient_BO = new PatientBO(); patient_BO.pid = id; patient_BO.pwd = userPwd; PatientBLLFactory patientBBLFactory = new PatientBLLFactory(); patient_BO = patientBBLFactory.CreatePatientBLL().GetPatientBLL().CreatePatientDAL().GetPatientDetials_DAL(patient_BO); return(patient_BO); }
public IEnumerable <PatientBO> UpdatePatient_DAL(PatientBO updatePatientDetails) { PatientDAL patientDAL = new PatientDAL(); var result = patientDAL.UpdatePatientDetails_DAL(updatePatientDetails); if (result != "") { return(GetAllPatients_DAL()); } //IEnumerable<PatientBO> emptyPatientsBO = ; return(null); }
public IEnumerable <ReportBO> GetAllReportsByPatient(PatientBO pat) { ReportBO reportBO = new ReportBO(); //reportBO.report_ID = id; reportBO.patient_ID = pat.pid; ReportBLLFactory rprtBLLFactory = new ReportBLLFactory(); IEnumerable <ReportBO> rprtBO = rprtBLLFactory.CreateReportBLL().GetReportBLL().CreateReportDAL().GetPatientReports_DAL(pat.pid); return(rprtBO); }
private void ddPatientIdPopulate() { // List<NoteType> noteTypeList = new List<NoteType>(); PatientBO patientBO = new PatientBO(); List <SelectListItemBase> dataList = new List <SelectListItemBase>(); dataList = patientBO.GetAllSelect(s => new SelectListItemBase { Text = s.LastName + " " + s.FirstName, Id = s.PatientId }); ddPatientId.DataSource = dataList; ddPatientId.DataTextField = "Text"; ddPatientId.DataValueField = "Id"; ddPatientId.DataBind(); }
public string RegisterNewUser(PatientBO patientDetails) { PatientBO patient_BO = new PatientBO(); PatientBLLFactory patientBLLFactory = new PatientBLLFactory(); PatientBO patientID = patientBLLFactory.CreatePatientBLL().InsertNewPatientBLL().CreatePatientDAL().InsertPatientDetails_DAL(patientDetails); if (patientID.pid != 0) { return("Your new User ID " + Convert.ToString(patientID.pid) + "- Login Using this UserID"); } return("Email ID is already Used by other User, try using other EmailID"); }
public string GetUserName(int id) { string response = "No Name"; if (id > 3000 && id < 4000) { NurseBO nurseBo = new NurseBO(); nurseBo.pid = id; NurseBLLFactory validatenurseBLLFactory = new NurseBLLFactory(); var NurseDetails = validatenurseBLLFactory.CreateNurseBLL().ValidateNurse().CreateNurseDAL().GetAllNurses_DAL().Where(d => d.pid == id).FirstOrDefault(); return(NurseDetails.firstName); } else if (id > 4000 && id < 5000) { LabInchargeBO inchargeBo = new LabInchargeBO(); inchargeBo.pid = id; LabInchargeBLLFactory validateInchargeBLLFacotry = new LabInchargeBLLFactory(); var inchargeDetails = validateInchargeBLLFacotry.CreateLabInchargeBLL().ValidateLabInchargeBLL().CreateLabInchargeDAL().GetAllLabInchargeDetials_DAL().Where(d => d.pid == id).FirstOrDefault(); return(inchargeDetails.firstName); } else if (id > 5000 && id < 6000) { DoctorBO doctorBO = new DoctorBO(); doctorBO.pid = id; DoctorBLLFactory doctorBLLFactory = new DoctorBLLFactory(); return(doctorBLLFactory.CreateDoctorBLL().ValidateDoctorBLL().CreateDoctorDAL().GetDoctorDetails_DAL(doctorBO).firstName); } else if (id > 6000 && id < 7000) { AdministratorBO adminBO = new AdministratorBO(); adminBO.pid = id; AdministratorBLLFactory adminBLLFactory = new AdministratorBLLFactory(); return(adminBLLFactory.CreateAdministratorBLL().ValidateAdminBLL().CreateAdminstratorDAL().GetAdminDetailsByID_DAL(adminBO).firstName); } else if (id > 7000 && id < 8000) { PatientBO patientBO = new PatientBO(); patientBO.pid = id; PatientBLLFactory patientBLLFactory = new PatientBLLFactory(); return(patientBLLFactory.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().GetPatientDetialsByID(patientBO).FirstOrDefault().firstName); } return(response); }
//Converts PatientBO to Patient public Patient ConvertBOToPatient(Patient patient, PatientBO patientBO) { patient.First_Name = patientBO.firstName; patient.Last_Name = patientBO.lastName; patient.Patient_ID = patientBO.pid; patient.Email_ID = patientBO.emailID; patient.Password = patientBO.pwd; patient.Address = patientBO.address; patient.Phone = patientBO.phone; patient.Gender = patientBO.gender; patient.DateOfBirth = patientBO.dateOfBirth; patient.Security_Question = patientBO.securityQn; patient.Security_Answer = patientBO.securityAns; patient.Patient_Type = Convert.ToString(patientBO.patientType); patient.IsActive = patientBO.isActive; return(patient); }
//Method to check if emailID is already used, with string return type public string CheckAvailability_DAL(PatientBO patientBO) { try { using (HospitalManagementSystemDataContext ObjHmsDataContext = new HospitalManagementSystemDataContext(Utils.ConnectionString)) { if (ObjHmsDataContext.Connection.State == System.Data.ConnectionState.Closed) { ObjHmsDataContext.Connection.Open(); } var emailID = (from patients in ObjHmsDataContext.Patients select patients.Email_ID == patientBO.emailID).SingleOrDefault(); //If emailId = true then Email_ID is already used return(emailID.ToString()); } } catch { return("EmailID Validation failed"); } }
// DELETE: api/Patient/5 //Delete action which accpets patient business object as input parameter and string as return type public string Delete(PatientBO details) { PatientBLLFactory patientBLLFactory = new PatientBLLFactory(); PatientBO patientBO = new PatientBO(); patientBO.pid = 7002; patientBO.emailID = "*****@*****.**"; patientBO.pwd = "karthik123"; string deactivateResult = patientBLLFactory.CreatePatientBLL().DeActivatePatientBLL().CreatePatientDAL().DeactivatePatient_DAL(patientBO); string activateResult = patientBLLFactory.CreatePatientBLL().ActivatePatientBLL().CreatePatientDAL().ActivatePatient_DAL(patientBO); string validateResult = patientBLLFactory.CreatePatientBLL().ValidatePatientBLL().CreatePatientDAL().ValidatePatient_DAL(patientBO); string checkAvailability = patientBLLFactory.CreatePatientBLL().CheckEmailAvailabilityBLL().CreatePatientDAL().CheckAvailability_DAL(patientBO); return(""); }
public void MapDatabaseValueToObjectGivenPatientInfoObjectMapsValueCorrectly() { PatientBO resultData = new PatientBO(); Patient_Info actualData = GetTestPatient(); resultData.MapDatabaseValueToObject(actualData); Assert.AreEqual(actualData.Gu_No, resultData.GUNo); Assert.AreEqual(actualData.Gu_Year, resultData.GUYear); Assert.AreEqual(actualData.Salutation, resultData.Salutation); Assert.AreEqual(actualData.Patient_Name, resultData.PatientName); Assert.AreEqual(actualData.At_Post, resultData.AtPost); Assert.AreEqual(actualData.Town, resultData.Town); Assert.AreEqual(actualData.District, resultData.District); Assert.AreEqual(actualData.State, resultData.State); Assert.AreEqual(actualData.Phone, resultData.PhoneNumber); Assert.AreEqual(actualData.Mobile, resultData.Mobile); Assert.AreEqual(actualData.Age_Yr, resultData.AgeYear); Assert.AreEqual(actualData.Age_Mnth, resultData.AgeMonths); Assert.AreEqual((SexEnum)actualData.Sex, resultData.Sex); Assert.AreEqual(actualData.Occupation, resultData.Occupation); }
protected void btCreateNewP_Click(object sender, EventArgs e) { if (ModelState.IsValid) { PatientBO PatientBO = new PatientBO(); Patient newPatient = new Patient(); string hcpFirstName = txtPFirstName.Text.Trim(); if (!string.IsNullOrEmpty(hcpFirstName)) { newPatient.FirstName = hcpFirstName; newPatient.LastName = txtPLastName.Text.Trim(); newPatient.HealthCardNo = txtPHealthCardNo.Text.Trim(); newPatient.Address1 = txtPAddress1.Text.Trim(); newPatient.Address2 = txtPAddress2.Text.Trim(); newPatient.HomePhone = txtPHomePhone.Text.Trim(); newPatient.CellPhone = txtPCellPhone.Text.Trim(); newPatient.DateOfBirth = DateTime.Parse(txtPDateOfBirth.Text.Trim()); newPatient.Active = cbPActive.Checked; newPatient.DateEntered = DateTime.Now; newPatient.UserIdEntered = 0; PatientBO.Add(newPatient); PatientBO.Save(); txtPFirstName.Text = ""; cbPActive.Checked = false; // lblMasterStatus //this.Master.ActionStatusMessage = string msg = string.Format("Patient {0} created.", hcpFirstName); Response.Redirect("~/PatientType/PatientList.aspx?msg=" + msg); } else { string str = string.Format("First Name field Can't be empty."); lblMsg.Text = str; return; } } }
protected void btUpdateP_Click(object sender, EventArgs e) { if (Page.IsPostBack) { PatientBO PatientBO = new PatientBO(); DataLayer.Patient editPatient = new Patient(); int PatientId = Convert.ToInt32(Session["PrimaryKeyPatient"]); editPatient = PatientBO.Get(PatientId); if (editPatient == null) { string str = string.Format("Patient Type with Id {0} not found for Update.", PatientId); return; } string PFirstName = txtPFirstName.Text.Trim(); if (!string.IsNullOrEmpty(PFirstName)) { editPatient.FirstName = PFirstName; editPatient.Active = cbPActive.Checked; editPatient.DateEntered = DateTime.Now; editPatient.UserIdEntered = 0; PatientBO.Edit(editPatient); PatientBO.Save(); txtPFirstName.Text = ""; cbPActive.Checked = false; string msg = string.Format("Patient {0} Updated.", PFirstName); Response.Redirect("~/PatientType/PatientList.aspx?msg=" + msg); } else { string str = string.Format("First Name field Can't be empty."); lblMsg.Text = str; return; } } }
public void FillByGivenGuNoGUYearReturnsNoRecordException() { dataContext.Patient_Info.Add(GetTestPatient()); PatientBO patient = new PatientBO(); patient.FillBy(0,2015); }