public int insertCorePatient(PatientDTO newPatient) { int flagInsert = new PATIENTTableAdapter().insertPatientQuery( newPatient.IdPassport, newPatient.FullName, newPatient.Birthday, newPatient.HealthStatus ); return(flagInsert); }
public int updateCorePatient(PatientDTO originalPatient) { int flagUpdate = new PATIENTTableAdapter().updatePatientQuery( originalPatient.IdPassport, originalPatient.FullName, originalPatient.Birthday, originalPatient.HealthStatus, originalPatient.IdPatient ); return(flagUpdate); }
private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = Properties.Settings.Default.DBPersonalClinicConnectionStringReport; conn.Open(); DBPersonalClinicDataSetReport.PATIENTDataTable tbl = new PATIENTTableAdapter().GetDataByIdPassport(tbxidPassportPatient.Text); rvPatient.ProcessingMode = ProcessingMode.Local; rvPatient.LocalReport.ReportPath = "D:\\repository\\appdesk-personal-clinic\\appdesk_personal_clinic\\presentation_layer\\reportPatient.rdlc"; if (tbl.Rows.Count > 0) { ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "DataSetReportPatient"; reportDataSource.Value = tbl; rvPatient.LocalReport.DataSources.Clear(); rvPatient.LocalReport.DataSources.Add(reportDataSource); rvPatient.RefreshReport(); } conn.Close(); }
public PersonalClinicDataSet.PATIENTDataTable getCoreDataTarget(string contentSearch) { PersonalClinicDataSet.PATIENTDataTable tblPatient = new PATIENTTableAdapter().GetDataByContentSearch(contentSearch); return(tblPatient); }
public PersonalClinicDataSet.PATIENTDataTable getData() { PersonalClinicDataSet.PATIENTDataTable tblPatient = new PATIENTTableAdapter().GetData(); return(tblPatient); }