private void btnGetPayPrescription_Click(object sender, EventArgs e)
{
DBPersonalClinicDataSetReport.PRESCRIPTIONDataTable tbl1 = new PRESCRIPTIONTableAdapter().GetDataByIdPatient(Convert.ToInt32(tbxidPayPrescription.Text));
string idPre = tbl1.Rows[0]["idPrescription"].ToString();
DBPersonalClinicDataSetReport.DETAIL_PRESCRIPTIONDataTable tbl2 = new DETAIL_PRESCRIPTIONTableAdapter().GetDataByIdPrescription(Convert.ToInt32(idPre));
rvPayPrescription.ProcessingMode = ProcessingMode.Local;
rvPayPrescription.LocalReport.ReportPath = "D:\\repository\\appdesk-personal-clinic\\appdesk_personal_clinic\\presentation_layer\\payPrescription.rdlc";
if (tbl1.Rows.Count > 0 && tbl1.Rows.Count > 0)
{
ReportDataSource reportDataSource1 = new ReportDataSource();
reportDataSource1.Name = "DataSetPayPrescription";
reportDataSource1.Value = tbl1;
ReportDataSource reportDataSource2 = new ReportDataSource();
reportDataSource2.Name = "DataSetPayDetailPre";
reportDataSource2.Value = tbl2;
rvPayPrescription.LocalReport.DataSources.Clear();
rvPayPrescription.LocalReport.DataSources.Add(reportDataSource1);
rvPayPrescription.LocalReport.DataSources.Add(reportDataSource2);
rvPayPrescription.RefreshReport();
}
return;
}
public int insertCorePrescription(PrescriptionDTO newPrescription)
{
int flagInsert = new PRESCRIPTIONTableAdapter().insertPrescriptionQuery(
newPrescription.IdPatient,
newPrescription.ConclusionMedical,
newPrescription.Price,
newPrescription.DayTime
);
return(flagInsert);
}
public int updateCorePrescription(PrescriptionDTO originalPrescription)
{
int flagUpdate = new PRESCRIPTIONTableAdapter().updatePrescriptionQuery(
originalPrescription.IdPatient,
originalPrescription.ConclusionMedical,
originalPrescription.Price,
originalPrescription.DayTime,
originalPrescription.IdPrescription
);
return(flagUpdate);
}
private void btnCreateReportPrescription_Click(object sender, EventArgs e)
{
DBPersonalClinicDataSetReport.PRESCRIPTIONDataTable tblPre = new PRESCRIPTIONTableAdapter().GetDataByTime(dtpTimePrescription.Value.Month);
rvPrescription.ProcessingMode = ProcessingMode.Local;
rvPrescription.LocalReport.ReportPath = "D:\\repository\\appdesk-personal-clinic\\appdesk_personal_clinic\\presentation_layer\\reportPrescription.rdlc";
if (tblPre.Rows.Count > 0)
{
ReportDataSource reportDataSource1 = new ReportDataSource();
reportDataSource1.Name = "DataSetPrescriptionRP";
reportDataSource1.Value = tblPre;
rvPrescription.LocalReport.DataSources.Clear();
rvPrescription.LocalReport.DataSources.Add(reportDataSource1);
rvPrescription.RefreshReport();
}
}
public PersonalClinicDataSet.PRESCRIPTIONDataTable getCoreDataTarget(string contentSearch)
{
PersonalClinicDataSet.PRESCRIPTIONDataTable tblPrescription = new PRESCRIPTIONTableAdapter().GetDataByContentSearch(Convert.ToInt32(contentSearch));
return(tblPrescription);
}
public PersonalClinicDataSet.PRESCRIPTIONDataTable getData()
{
PersonalClinicDataSet.PRESCRIPTIONDataTable tblPrescription = new PRESCRIPTIONTableAdapter().GetData();
return(tblPrescription);
}
