private void LoadTokens() { //this.dgvTokens.Rows.Clear(); patients = new PatientBLL().GetPatientLabTestDetail(); this.dgvTokens.DataSource = null; this.dgvTokens.DataSource = patients; for (int i = 0; i < dgvTokens.Columns.Count; i++) { if (dgvTokens.Columns[i].Name != "TokenNumber" && dgvTokens.Columns[i].Name != "TokenDate") { dgvTokens.Columns[i].Visible = false; } else { dgvTokens.Columns[i].Width = 80; } } //for (int j = 0; j < patients.Count; j++) //{ // object[] values = { patients[j].TokenNumber, patients[j].TokenDate.ToShortDateString() }; // this.dgvTokens.Rows.Add(values); // List<LabTest> labs = new InjectionLabTestBLL().GetLabTestAssigned(patients[j]); // if (labs.Count > 0) // { // patients[j].LabTests = labs.Where(unperformed=>unperformed .IsTestPerformed == false).ToList<LabTest>(); // } //} if (patients.Count > 0) { pr = patients[0]; DataGridViewPopulate(pr); } }
private void PrintPreview(bool preview, PatientRegistration pr) { string BranchName = ConfigurationManager.AppSettings["Name"].ToString(); string BranchAddress = ConfigurationManager.AppSettings["Address"].ToString(); prt = new DsPatientRegistration.PatientRegistrationDataTable(); object[] values = { 0, pr.TokenDate, pr.TokenMonthYear, pr.TokenNumber, pr.Patient.FirstName, pr.Patient.LastName, pr.Patient.NIC, pr.Patient.Address, pr.TokenType, pr.CashReceived, pr.Room.Name, pr.Patient.RegistrationNumber, pr.Patient.RegistrationDate }; prt.LoadDataRow(values, true); rptTokenReceipt crp = new rptTokenReceipt(); crp.SetDataSource((DataTable)prt); crp.SetParameterValue("Duplicate", PrintDuplicate); crp.SetParameterValue("Name", BranchName); crp.SetParameterValue("Address", BranchAddress); FrmReportViewer frmViewer = new FrmReportViewer(); frmViewer.crystalReportViewer1.ReportSource = crp; if (preview) { frmViewer.ShowDialog(); } else { //frmViewer.crystalReportViewer1.RefreshReport(); frmViewer.crystalReportViewer1.PrintReport(); } PrintDuplicate = false; }
public bool SaveLabTestRemarks(PatientRegistration pr, LabTestRemarks Remarks) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.Transaction = tran; cmd.CommandText = "Update LabTestPerformed set Remarks='" + Remarks.Remarks + "',TestPerformed = " + Remarks.IsTestPerformed + " where TokenNumber=" + pr.TokenNumber + " and TokenDate='" + pr.TokenDate.ToShortDateString() + "' and TokenMonthYear=" + pr.TokenMonthYear + " and LabTestID=" + Remarks.LabTest.LabTestId; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public bool PatientChecked(PatientRegistration pr) { try { string update = "Update PatientRegistration set Checked = " + true + " where TokenMonthYear=" + pr.TokenMonthYear + " and TokenNumber=" + pr.TokenNumber; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(update, con); cmd.Transaction = tran; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public bool LabTestAssigned(PatientRegistration pr, List <LabTest> labs) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(); cmd.Connection = con; cmd.Transaction = tran; foreach (LabTest lab in labs) { //cmd.CommandText = "insert into LabTestPerformed (TokenDate,TokenMonthYear,TokenNumber,LabTestID,TestPerformed) values('" + pr.TokenDate.ToString("MM/dd/yyyy") + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + "," + lab.LabTestId + "," + 0 + ")"; cmd.CommandText = "insert into LabTestPerformed (TokenDate,TokenMonthYear,TokenNumber,LabTestID,TestPerformed,Room,DrName) values('" + pr.TokenDate.ToString("MM/dd/yyyy") + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + "," + lab.LabTestId + "," + 0 + ",'" + pr.Room.Name + "','" + pr.Room.LabelName + "')"; cmd.ExecuteNonQuery(); } tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public List <PatientRegistration> GetPatientLabTestDetail() { try { string select = "select distinct TokenNumber,TokenDate,TokenMonthYear from LabTestPerformed ltp where TestPaid=1 and TestPerformed = 0"; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); cmd = new OleDbCommand(); cmd.CommandText = select; cmd.CommandType = CommandType.Text; cmd.Connection = con; dr = cmd.ExecuteReader(); while (dr.Read()) { PatientRegistration pr = new PatientRegistration(); pr.TokenDate = Convert.ToDateTime(dr["TokenDate"]); pr.TokenMonthYear = Convert.ToInt64(dr["TokenMonthYear"]); pr.TokenNumber = Convert.ToInt64(dr["TokenNumber"]); roomPatients.Add(pr); } dr.Close(); return(roomPatients); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public int GetNextTokenNumber(Room r) { PatientRegistration pr = new PatientRegistration(); try { string select = "select min(tokenNumber) from patientregistration where TokenMonthYear=" + System.DateTime.Today.Month.ToString() + System.DateTime.Today.Year.ToString() + " and Room='" + r.Name + "' and Checked=" + false; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); cmd = new OleDbCommand(select, con); if (DBNull.Value != (cmd.ExecuteScalar())) { int NextTokenNumber = Convert.ToInt32(cmd.ExecuteScalar()); return(NextTokenNumber); } else { return(0); } } catch (Exception ex) { throw ex; } }
public bool MedicineCanceled(PatientRegistration pr, LabTest medicine) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); string delete = "delete from MedicineIssuedByDoc where TokenDate='" + pr.TokenDate + "' and TokenMonthYear=" + pr.TokenMonthYear + " and TokenNumber=" + pr.TokenNumber + " and ID=" + medicine.MedicineIssuedSerialID; cmd = new OleDbCommand(); cmd.Connection = con; cmd.Transaction = tran; cmd.CommandText = delete; cmd.ExecuteNonQuery(); cmd.CommandText = "insert into MedicineIssued_Canceled(TokenDate,TokenMonthYear,TokenNumber,MedicineID,DosePerDay,MedicineCanceled) values('" + pr.TokenDate + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + "," + medicine.LabTestId + "," + medicine.TimesADay + ",1)"; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public bool PatientChecked(PatientRegistration pr, List <LabTest> medicines) { try { string update = "Update PatientRegistration set Checked = " + 1 + " where TokenMonthYear=" + pr.TokenMonthYear + " and TokenNumber=" + pr.TokenNumber; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(update, con); cmd.Transaction = tran; cmd.ExecuteNonQuery(); foreach (LabTest med in medicines) { cmd.CommandText = "insert into MedicineIssuedByDoc (TokenDate,TokenMonthYear,TokenNumber,MedicineID,DosePerDay,Room,DrName) values('" + pr.TokenDate.ToString("MM/dd/yyyy") + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + "," + med.LabTestId + "," + med.TimesADay + ",'" + pr.Room.Name + "','" + pr.Room.LabelName + "')"; cmd.ExecuteNonQuery(); } tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public bool SavePatientToken(PatientRegistration pr) { try { string insert = "Insert Into PatientRegistration(TokenDate,TokenMonthYear,TokenNumber,PatientFirstName,PatientLastName" + ",PatientNIC,PatientAddress,PatientType,TokenAmount,Room,PatientRegistrationNumber,PatientRegistrationDate) " + "values (#" + pr.TokenDate + "#," + pr.TokenMonthYear + "," + pr.TokenNumber + ",'" + pr.Patient.FirstName + "','" + pr.Patient.LastName + "','" + pr.Patient.NIC + "','" + pr.Patient.Address + "','" + pr.TokenType.ToString() + "'," + (int)pr.TokenType + ",'" + pr.Room.Name + "','" + pr.Patient.RegistrationNumber + "',#" + pr.Patient.RegistrationDate + "#)"; con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); cmd = new OleDbCommand(insert, con); cmd.Transaction = tran; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public bool LabTestCanceled(PatientRegistration pr, LabTest medicine) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); string delete = "delete from LabTestPerformed where TokenDate='" + pr.TokenDate + "' and TokenMonthYear=" + pr.TokenMonthYear + " and TokenNumber=" + pr.TokenNumber + " and LabTestID=" + medicine.LabTestId; cmd = new OleDbCommand(delete, con); cmd.Transaction = tran; // cmd.ExecuteNonQuery(); cmd.CommandText = "insert into LabTestPerformed_Canceled(TokenDate,TokenMonthYear,TokenNumber,LabTestID,TestCanceled) values('" + pr.TokenDate + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + "," + medicine.LabTestId + ",1)"; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
public ActionResult CreatePatient(Patient patient) { try { var userId = Request.IsAuthenticated ? UserId : Guid.Empty; var roles = new string[] { HospitalManagementSystem.Models.Constants.Roles.PATIENT }; var registerHelper = new RegisterHelper(userId, patient.Person, roles); registerHelper.Register(); if (!registerHelper.Response.Item1) { patient.Person.Error = registerHelper.Response.Item2; return(View(patient)); } //PatientRegistration.Register(new Patient() { PersonId = patient.Person.Id });int personId = porter.Person.Id; int personId = patient.Person.Id; patient.PersonId = personId; patient.Person = null; PatientRegistration.Register(patient); return(RedirectToAction("RegisterSuccess", "Account", new { statusMessage = registerHelper.Response.Item2 })); } catch { return(View()); } }
private MongoCollection <PatientRegistration> Createpatient(PatientRegistration patient, MongoDatabase mongoDatabase) { MongoCollection <PatientRegistration> patientRegistration = mongoDatabase.GetCollection <PatientRegistration>("PatientRegistration"); patientRegistration.Insert(patient); return(patientRegistration); }
public void GivenPatientWhenRegisteringThenPersistToDb() { HospitalManagementSystemContext HospitalManagementSystemContext = EntityFrameworkMock.Create <HospitalManagementSystemContext>(); TypeFactory.RegisterInstance(HospitalManagementSystemContext); Patient patient = new Patient(); patient.PersonId = 1; patient.Person.Id = 1; patient.Person.FirstName = "Vusi"; patient.Person.Surname = "Khoza"; patient.Person.IdNumber = "1234"; IPatientRepository patientRepository = new PatientRepository(); IPatientRegistration patientRegistration = new PatientRegistration(patientRepository); patientRegistration.Register(patient); IPatientRetriever patientRetriever = new PatientRetriever(patientRepository); patientRetriever.Retrieve(patient.Person.IdNumber); Assert.IsNotNull(patientRetriever.Patient); Assert.AreEqual(patient.Person.Id, patientRetriever.Patient.Person.Id); Assert.AreEqual(patient.Person.FirstName, patientRetriever.Patient.Person.FirstName); Assert.AreEqual(patient.Person.Surname, patientRetriever.Patient.Person.Surname); }
private void dgvTokens_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgvTokens.RowCount > 0) { pr = patients[e.RowIndex]; DataGridViewPopulate(pr); } }
private void PopulatePatientDetails(PatientRegistration pr) { this.txtPatientName.Text = pr.Patient.FirstName + " " + pr.Patient.LastName; this.txtPatientRegistrationNumber.Text = pr.Patient.RegistrationNumber; this.txtPatientDetails.Text += "CNIC #:" + pr.Patient.NIC + Environment.NewLine; this.txtPatientDetails.Text += "Address :" + pr.Patient.Address + Environment.NewLine; this.txtPatientDetails.Text += "Type :" + pr.TokenType.ToString() + Environment.NewLine; }
public ActionResult EditPatientInfo(PatientRegistration model, string patientId) { MongoCollection <PatientRegistration> patientRegistration = database().GetCollection <PatientRegistration>("PatientRegistration"); var query = Query.EQ("_id", ObjectId.Parse(patientId)); var update = Update.Set("Email", model.Email).Set("Password", model.Password); patientRegistration.Update(query, update); return(RedirectToAction("ListPatients", "Doctors")); }
private void NextTokenData() { long nextTokenNumber = pbll.GetNextTokenNumber(CurrentRoom); pr = pbll.GetPatientDetail(nextTokenNumber, CurrentRoom); this.lblCurrentTokenNumber.Text = nextTokenNumber.ToString("0000"); PopulatePatientDetails(pr); // comm.WriteDataWithoutDisplay("*" + this.lblCurrentTokenNumber.Text + "#"); }
private void tsSave_Click(object sender, EventArgs e) { PatientRegistration pr = new PatientRegistration(); try { // pr.TokenDate = System.DateTime.Today; pr.TokenDate = System.DateTime.Now; int num = 0; List <InjectionLabTest> ilt = new List <InjectionLabTest>(); ilt = new InjectionLabTestBLL().GetTokenNum(pr.TokenDate); pr.TokenNumber = Convert.ToInt64(this.lblCurrentTokenNumber.Text.Trim()); // pr.TokenNumber = ilt[0].TokenNumber+1; pr.TokenType = (rbGeneral.Checked) ? TokenType.General : (rbPoor.Checked) ? TokenType.Poor : TokenType.Private; //pr.TokenType = (rbGeneral.Checked) ? TokenType.General : TokenType.Private;------------------->>>>>>>>> pr.CashReceived = Convert.ToDouble(this.txtCashRecieved.Text.Trim()); pr.Patient.FirstName = this.txtPatientFirstName.Text; pr.Patient.LastName = this.txtPatientLastName.Text; pr.Patient.NIC = this.txtPatientCNIC.Text; pr.Patient.Age = Convert.ToInt16(this.txtPatientAge.Text); pr.Patient.Mobile = this.txtPatientMobile.Text; pr.Patient.RegistrationDate = this.dtpPatientRegistrationDate.Value.Date; pr.Patient.RegistrationNumber = this.txtPateintRegistrationNumber.Text; pr.Patient.Address = this.txtPatientAddress.Text; pr.TokenMonthYear = Convert.ToInt64(DateTime.Today.Month.ToString() + DateTime.Today.Year.ToString()); string BranchCode = ConfigurationManager.AppSettings["BranchCode"].ToString(); pr.Patient.RegistrationNumber = BranchCode; pr.TokenBy = IsLoginUser; if (this.lstRooms.SelectedItem != null) { pr.Room = (Room)this.lstRooms.SelectedItem; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Patient Registration Data"); } try { if (pbll.SavePatientToken(pr)) { PrintPreview(false, pr); GetNextTokenNumber(); NewPatient(); MessageBox.Show("Patient Registered Successfully", "Token Granted"); this.txtPatientFirstName.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Save Patient Registration Error"); } // } }
private void RegisterPatient_Click(object sender, EventArgs e) { this.Hide(); PatientRegistration patientView = new PatientRegistration(); radiantDentalPracticePresenter.registerPatient(patientView); patientView.ShowDialog(); this.Close(); }
private void dgvTokens_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgvTokens.RowCount > 0) { pr = patients[e.RowIndex]; long nextTokenNumber = pr.TokenNumber; PopulatePatientDetails(pr); CurrentAdmission.PatientRegistration = pr; } }
private void toolStripButton2_Click(object sender, EventArgs e) { frm.doctor = true; frm.ShowDialog(); if (frm.pr != null) { prCancel = frm.pr; PopulateExistingToken(); } }
private void btnOk_Click(object sender, EventArgs e) { if (Reprint == true) { Int64 tNo = 0, mYNo = 0; Int64.TryParse(txtTokenNo.Text, out tNo); InjectionLabTestBLL inLabBll = new InjectionLabTestBLL(); PatientRegistration pr = inLabBll.GetPatientRegistration(new PatientRegistration(tNo, Convert.ToInt64(dateTimePicker1.Value.Month + "" + dateTimePicker1.Value.Year))); if (pr.Patient.RegistrationNumber != null && pr.Patient.RegistrationNumber != "") { this.pr = pr; this.Close(); } else { MessageBox.Show("Invalid token no. for selected month and year"); txtTokenNo.Text = "0"; } } else { Int64 tNo = 0, mYNo = 0; Int64.TryParse(txtTokenNo.Text, out tNo); InjectionLabTestBLL inLabBll = new InjectionLabTestBLL(); InjectionLabTest inLb = inLabBll.GetInjectionLabTest(new InjectionLabTest(tNo, Convert.ToInt64(dateTimePicker1.Value.Month + "" + dateTimePicker1.Value.Year))); if (inLb.Patient.RegistrationNumber != null && inLb.Patient.RegistrationNumber != "") { this.inLb = inLb; this.Close(); } else { MessageBox.Show("Invalid token no. for selected month and year"); } } if (doctor) { Int64 tNo = 0, mYNo = 0; Int64.TryParse(txtTokenNo.Text, out tNo); InjectionLabTestBLL inLabBll = new InjectionLabTestBLL(); InjectionLabTest inLb = inLabBll.GetInjectionLabTest(new InjectionLabTest(tNo, Convert.ToInt32(dateTimePicker1.Value.Month + "" + dateTimePicker1.Value.Year))); PatientRegistration pr = inLabBll.GetPatientRegistration(new PatientRegistration(tNo, Convert.ToInt32(dateTimePicker1.Value.Month + "" + dateTimePicker1.Value.Year))); if (pr.Patient.RegistrationNumber != null && pr.Patient.RegistrationNumber != "") { this.pr = pr; this.inLb = inLb; this.Close(); } else { MessageBox.Show("Invalid token no. for selected month and year"); txtTokenNo.Text = "0"; } } }
private void btnThirdExistingToken_Click(object sender, EventArgs e) { frm3rd = new FrmExistingToken(); frm3rd.Reprint = true; frm3rd.ShowDialog(); if (frm3rd.pr != null) { prCancel = frm3rd.pr; PopulateExistingToken3rd(); } }
private void NextTokenData() { rbOneDay.Checked = true; lstLabTest.Items.Clear(); lstLabTestId.Items.Clear(); long nextTokenNumber = pbll.GetNextTokenNumber(CurrentRoom); pr = pbll.GetPatientDetail(nextTokenNumber, CurrentRoom); this.lblCurrentTokenNumber.Text = nextTokenNumber.ToString("00000"); PopulatePatientDetails(pr); // comm.WriteDataWithoutDisplay("*" + this.lblCurrentTokenNumber.Text + "#"); }
public ActionResult AddPatient(PatientRegistration patient) { var db = database(); patient.DoctorId = ((CustomPrincipal)HttpContext.User).UserId; var patientid = ReadPatientRegisterationTable(db).FindAll().Select(s => s.DoctorId == patient.DoctorId).Count(); patient.PatientId = "PA" + patient.DoctorId + patientid; Createpatient(patient, db); return(RedirectToAction("ListPatients", "Doctors")); }
public ActionResult AddPatient(PatientRegistration patient) { var db = database(); patient.DoctorId = ((CustomPrincipal)HttpContext.User).UserId; var patientid = ReadPatientRegisterationTable(db).FindAll().Count(); patient.PatientId = "PA" + patientid.ToString("D4"); Createpatient(patient, db); this.AddToastMessage("Patient Created", "Add New Patient", ToastType.Info); return(RedirectToAction("ListPatients", "Doctors")); }
private void dgvTokens_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgvTokens.RowCount > 0) { pr = patients[e.RowIndex]; long nextTokenNumber = pr.TokenNumber; this.lblCurrentTokenNumber.Text = nextTokenNumber.ToString("00000"); //this.lblToDate.Text = pr.TokenDate.ToShortDateString(); this.lblToDate.Text = pr.TokenDate.ToShortDateString(); PopulatePatientDetails(pr); this.lbxLabTest.Items.Clear(); LoadLabTests(pr); } }
private void LoadLabTests(PatientRegistration pr) { this.lbxLabTest.Items.Clear(); List <LabTest> labs = new InjectionLabTestBLL().GetLabTestAssigned(pr); pr.LabTests = labs; if (pr.LabTests.Count > 0) { foreach (LabTest lbt in pr.LabTests) { this.lbxLabTest.Items.Add(lbt); } } }
public bool SavePatientToken(PatientRegistration pr) { try { con = new OleDbConnection(); this.readconfile = new ReadConfigFile(); con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile); con.Open(); tran = con.BeginTransaction(); int VID = 0; cmd = new OleDbCommand("Select Max(tokennumber) From patientregistration where TokenMonthYear=" + pr.TokenMonthYear + "", con); cmd.Transaction = tran; if (DBNull.Value != (cmd.ExecuteScalar())) { VID = Convert.ToInt32(cmd.ExecuteScalar()); pr.TokenNumber = VID + 1; } else { pr.TokenNumber = 1; } pr.Patient.RegistrationNumber = pr.TokenNumber + "" + pr.TokenMonthYear + "" + pr.Patient.RegistrationNumber; string insert = "Insert Into PatientRegistration(TokenDate,TokenMonthYear,TokenNumber,PatientFirstName,PatientLastName,PatientNIC" + ",PatientAge,PatientMobile,PatientAddress,PatientType,TokenAmount,Room,PatientRegistrationNumber,PatientRegistrationDate,Shift,TokenBy,DrName) " + "values ('" + pr.TokenDate.ToString("MM/dd/yyyy HH:mm:ss") + "'," + pr.TokenMonthYear + "," + pr.TokenNumber + ",'" + pr.Patient.FirstName + "','" + pr.Patient.LastName + "','" + pr.Patient.NIC + "'," + pr.Patient.Age + ",'" + pr.Patient.Mobile + "','" + pr.Patient.Address + "','" + pr.TokenType.ToString() + "'," + (int)pr.TokenType + ",'" + pr.Room.Name + "','" + pr.Patient.RegistrationNumber + "','" + pr.Patient.RegistrationDate.ToString("MM/dd/yyyy") + "'," + new ShiftDAL().GetActiveShiftCode().ID + "," + pr.TokenBy.Userno + ",'" + pr.Room.LabelName + "' )"; cmd = new OleDbCommand(insert, con); cmd.Transaction = tran; cmd.ExecuteNonQuery(); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { con.Close(); } }
private void btnNewPatientReg_Click(object sender, RoutedEventArgs e) { PatientRegistration register = new PatientRegistration(this.HomeWindow); register.Show(); this.Close(); }