private void btnPrint_Click(object sender, EventArgs e)
{
string filterStudent = "";
string filterSalesPerson = "";
HelpFilter hp = new HelpFilter();
if (!this.txtStudent.Text.Trim().Equals(""))
{
filterStudent = "a.SStudentId = '" + this.txtStudent.Text.Trim() + "'";
}
else
{
filterStudent = hp.Get_Filter("a.SStudentId", DS_StudentRight);
}
if (!this.txtRepCode.Text.Trim().Equals(""))
{
filterSalesPerson = "e.SRepCode = '" + this.txtRepCode.Text.Trim() + "'";
}
else
{
filterSalesPerson = hp.Get_Filter("e.SRepCode", DS_SalesPersonRight);
}
//validate
if (!filterStudent.Trim().Equals(""))
{
filterStudent = " and " + filterStudent;
}
if (!filterSalesPerson.Trim().Equals(""))
{
filterSalesPerson = " and " + filterSalesPerson;
}
string filterDate = " where a.DDate>='" + txtDateFrom.Value.ToShortDateString() + "' and a.DDate <= '" + txtDateTo.Value.ToShortDateString() + "'";
DatabaseConnection dbCon = new DatabaseConnection();
string cQuery = "Select a.SRefNo,a.DAddDate as DDate,c.SName,iif(SRepName is null,'NONE',SRepName) as SRepName,b.NAlloAmount,"
+ " a.SAddUser from File_PaymentH a "
+ " inner join File_PaymentD b on a.SRefNo = b.SRefNo inner join File_Student c on a.SStudentId = c.SStudentId "
+ " left join File_InvoiceH e on b.SInvNo = e.SRefNo left join File_SalesPerson d on d.SRepCode = e.SRepCode "
+ filterDate + " " + filterStudent + " " + filterSalesPerson;
DataSet Payment_ListingDataSet = dbCon.Get_ReportData(cQuery, "DT_PaymentListing");
Report_View newReport = new Report_View(GlobalVariables.ReportPath + "Rpt_Payment_Listing.rpt", Payment_ListingDataSet, "Payment Listing");
if (Payment_ListingDataSet.Tables[0].Rows.Count > 0)
{
newReport.ShowInTaskbar = false;
newReport.ShowDialog();
}
else
{
MessageBox.Show("No Data To Print");
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
HelpFilter hp = new HelpFilter();
string filterStudent = "";
string filterCourse = "";
string filterSalesPerson = "";
if (!this.txtStudent.Text.Trim().Equals(""))
{
filterStudent = "a.SStudentId = '" + this.txtStudent.Text.Trim() + "'";
}
else
{
filterStudent = hp.Get_Filter("a.SStudentId", DS_StudentRight);
}
if (!this.txtCourse.Text.Trim().Equals(""))
{
filterCourse = "b.SCourseCode = '" + this.txtCourse.Text.Trim() + "'";
}
else
{
filterCourse = hp.Get_Filter("b.SCourseCode", DS_CourseRight);
}
if (!this.txtRepCode.Text.Trim().Equals(""))
{
filterSalesPerson = "e.SRepCode = '" + this.txtRepCode.Text.Trim() + "'";
}
else
{
filterSalesPerson = hp.Get_Filter("e.SRepCode", DS_SalesPersonRight);
}
//validate
if (!filterStudent.Trim().Equals(""))
{
filterStudent = " and " + filterStudent;
}
if (!filterCourse.Trim().Equals(""))
{
filterCourse = " and " + filterCourse;
}
if (!filterSalesPerson.Trim().Equals(""))
{
filterSalesPerson = " and " + filterSalesPerson;
}
DatabaseConnection dbCon = new DatabaseConnection();
string cQuery = "select a.SRefNo,a.DDate,a.SStudentId,d.SName,b.SCourseCode,c.SCourseName,b.NAmount,"
+ "b.NDiscount,iif(SRepName is null, 'NONE', SRepName) as SRepName,a.SAddUser,a.DAddDate from "
+ " File_InvoiceH a inner join File_InvoiceD b on a.SRefNo = b.SRefNo inner join File_Course c on "
+ "b.SCourseCode = c.SCourseCode inner join File_Student d on d.SStudentId = a.SStudentId "
+ "left join File_SalesPerson e on e.SRepCode = a.SRepCode where a.DDate>='" + txtDateFrom.Value.ToShortDateString() + "' "
+ " and a.DDate<='" + txtDateTo.Value.ToShortDateString() + "' " + filterStudent + " "
+ filterCourse + " " + filterSalesPerson;
DataSet Invoice_ListingDataSet = dbCon.Get_ReportData(cQuery, "DT_InvoiceListing");
if (Invoice_ListingDataSet.Tables[0].Rows.Count > 0)
{
Report_View newReport = new Report_View(GlobalVariables.ReportPath + "Rpt_Invoice_Listing.rpt", Invoice_ListingDataSet, "Invoice Listing");
newReport.ShowInTaskbar = false;
newReport.ShowDialog();
}
else
{
MessageBox.Show("No Data To Print");
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
HelpFilter hp = new HelpFilter();
string filterStudent = "";
string filterCourse = "";
if (!this.txtStudent.Text.Trim().Equals(""))
{
filterStudent = "a.SStudentId = '" + this.txtStudent.Text.Trim() + "'";
}
else
{
filterStudent = hp.Get_Filter("a.SStudentId", DS_StudentRight);
}
if (!this.txtCourse.Text.Trim().Equals(""))
{
filterCourse = "c.SCourseCode = '" + this.txtCourse.Text.Trim() + "'";
}
else
{
filterCourse = hp.Get_Filter("c.SCourseCode", DS_CourseRight);
}
//validate
if (!filterStudent.Trim().Equals(""))
{
filterStudent = " and " + filterStudent;
}
if (!filterCourse.Trim().Equals(""))
{
filterCourse = " and " + filterCourse;
}
string filterDate = " and a.DDate>='" + txtDateFrom.Value.ToShortDateString() + "' and a.DDate <= '" + txtDateTo.Value.ToShortDateString() + "'";
DatabaseConnection dbCon = new DatabaseConnection();
string cQuery;
if (this.radioButton1.Checked)
{
cQuery = "Select c.SCourseCode,SCourseName,a.SStudentId,SName,STelNo,SMobileNo,SEmail "
+ " from File_InvoiceH a,File_InvoiceD e, File_Student b,File_Course c where "
+ " a.SStudentId = b.SStudentId and c.SCourseCode = e.SCourseCode and a.SRefNo = e.SRefNo "
+ " and a.NBalanceAmount > 0 " + filterDate + " " + filterStudent + " " + filterCourse;
}
else
{
cQuery = "Select c.SCourseCode,SCourseName,a.SStudentId,SName,STelNo,SMobileNo,SEmail "
+ " from File_InvoiceH a,File_InvoiceD e, File_Student b,File_Course c where "
+ " a.SStudentId = b.SStudentId and c.SCourseCode = e.SCourseCode and a.SRefNo = e.SRefNo "
+ filterDate + " " + filterStudent + " " + filterCourse;
}
DataSet Student_CourseDataSet = dbCon.Get_ReportData(cQuery, "DT_StudentCourse");
Report_View newReport = new Report_View(GlobalVariables.ReportPath + "Rpt_Student_Course.rpt", Student_CourseDataSet, "Invoice Listing");
if (Student_CourseDataSet.Tables[0].Rows.Count > 0)
{
newReport.ShowInTaskbar = false;
newReport.ShowDialog();
}
else
{
MessageBox.Show("No Valid Data To Print");
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
HelpFilter hp = new HelpFilter();
string filterStudent = "";
string filterCourse = "";
if (!this.txtStudent.Text.Trim().Equals(""))
{
filterStudent = "a.SStudentId = '" + this.txtStudent.Text.Trim() + "'";
}
else
{
filterStudent = hp.Get_Filter("a.SStudentId", DS_StudentRight);
}
if (!this.txtCourse.Text.Trim().Equals(""))
{
filterCourse = "c.SCourseCode = '" + this.txtCourse.Text.Trim() + "'";
}
else
{
filterCourse = hp.Get_Filter("c.SCourseCode", DS_CourseRight);
}
//validate
if (!filterStudent.Trim().Equals(""))
{
filterStudent = " and " + filterStudent;
}
if (!filterCourse.Trim().Equals(""))
{
filterCourse = " and " + filterCourse;
}
string filterDate = " and a.DDate='" + txtDateFrom.Value.ToShortDateString() + "' ";
DatabaseConnection dbCon = new DatabaseConnection();
string cQuery = "Select SRefNo,DDate,SName,SMobileNo from File_PaymentH a,File_Student b "
+ " where a.SStudentId = b.SStudentId " + filterDate + filterStudent + filterCourse;
DataSet Student_PaymentDataSet = dbCon.Get_ReportData(cQuery, "DT_StudentPayment");
Report_View newReport = new Report_View(GlobalVariables.ReportPath + "Rpt_Student_Payment.rpt", Student_PaymentDataSet, "Student Payment Listing");
if (Student_PaymentDataSet.Tables[0].Rows.Count > 0)
{
newReport.ShowInTaskbar = false;
newReport.ShowDialog();
//Email
DialogResult dRes = MessageBox.Show("Do You Want To Email This Report?", "Confirm", MessageBoxButtons.YesNo);
if (dRes == DialogResult.Yes)
{
string studentId = this.txtStudent.Text.Trim();
SendEmail newMail = new SendEmail("Rpt_Student_Payment.pdf", newReport, studentId);
newMail.ShowInTaskbar = false;
newMail.ShowDialog();
}
}
else
{
MessageBox.Show("No Valid Data To Print");
}
}