private void button1_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
rptCustomers rpt = new rptCustomers();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
SIS_DBDataSet myDS = new SIS_DBDataSet();
//The DataSet you created.
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT * from Customer order by CustomerName";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
frmCustomersReport frm = new frmCustomersReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
rptCustomers rpt = new rptCustomers();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
SIS_DBDataSet myDS = new SIS_DBDataSet();
//The DataSet you created.
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT * from Customer order by CustomerName";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
frmCustomersReport frm = new frmCustomersReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button11_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
var rpt = new rptSales();
cmd = new OleDbCommand();
var myDA = new OleDbDataAdapter();
var myDS = new SIS_DBDataSet();
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT Sales.InvoiceNo, Sales.InvoiceDate, Sales.CustomerID, Sales.SubTotal, Sales.VATPercentage, Sales.VATAmount, Sales.GrandTotal, Sales.TotalPayment,Sales.PaymentDue, Sales.Remarks, Customer.CustomerID AS Expr1, Customer.CustomerName, Customer.Address, Customer.Landmark, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.MobileNo, Customer.FaxNo, Customer.Email, Customer.Notes FROM (Sales INNER JOIN Customer ON Sales.CustomerID = Customer.CustomerID) Where InvoiceDate between #" + DateTimePicker2.Text + "# And #" + DateTimePicker1.Text + "# and PaymentDue > 0 order by InvoiceDate desc";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Sales");
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
var frm = new frmSalesReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button10_Click(object sender, EventArgs e)
{
try
{
if (cmbCustomerName.Text == "")
{
MessageBox.Show("Please select Customer name", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbCustomerName.Focus();
return;
}
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
rptSales rpt = new rptSales();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
SIS_DBDataSet myDS = new SIS_DBDataSet();
//The DataSet you created.
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT Sales.InvoiceNo, Sales.InvoiceDate, Sales.CustomerID, Sales.SubTotal, Sales.VATPercentage, Sales.VATAmount, Sales.GrandTotal, Sales.TotalPayment,Sales.PaymentDue, Sales.Remarks, Customer.CustomerID AS Expr1, Customer.CustomerName, Customer.Address, Customer.Landmark, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.MobileNo, Customer.TIN, Customer.Email, Customer.Notes FROM (Sales INNER JOIN Customer ON Sales.CustomerID = Customer.CustomerID) where Customername='" + cmbCustomerName.Text + "' order by CustomerName,InvoiceDate";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Sales");
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
frmSalesReport frm = new frmSalesReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button10_Click(object sender, EventArgs e)
{
try
{
if (cmbCustomerName.Text == "")
{
MessageBox.Show("Please select Customer name", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbCustomerName.Focus();
return;
}
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
rptSales rpt = new rptSales();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
SIS_DBDataSet myDS = new SIS_DBDataSet();
//The DataSet you created.
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT Sales.InvoiceNo, Sales.InvoiceDate, Sales.CustomerID, Sales.SubTotal, Sales.VATPercentage, Sales.VATAmount, Sales.GrandTotal, Sales.TotalPayment,Sales.PaymentDue, Sales.Remarks, Customer.CustomerID AS Expr1, Customer.CustomerName, Customer.Address, Customer.Landmark, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.MobileNo, Customer.FaxNo, Customer.Email, Customer.Notes FROM (Sales INNER JOIN Customer ON Sales.CustomerID = Customer.CustomerID) where Customername='" + cmbCustomerName.Text + "' order by CustomerName,InvoiceDate";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Sales");
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
frmSalesReport frm = new frmSalesReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button11_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
var rpt = new rptSales();
cmd = new OleDbCommand();
var myDA = new OleDbDataAdapter();
var myDS = new SIS_DBDataSet();
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT Sales.InvoiceNo, Sales.InvoiceDate, Sales.CustomerID, Sales.SubTotal, Sales.VATPercentage, Sales.VATAmount, Sales.GrandTotal, Sales.TotalPayment,Sales.PaymentDue, Sales.Remarks, Customer.CustomerID AS Expr1, Customer.CustomerName, Customer.Address, Customer.Landmark, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.MobileNo, Customer.FaxNo, Customer.Email, Customer.Notes FROM (Sales INNER JOIN Customer ON Sales.CustomerID = Customer.CustomerID) Where InvoiceDate between #" + DateTimePicker2.Text + "# And #" + DateTimePicker1.Text + "# and PaymentDue > 0 order by InvoiceDate desc";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Sales");
myDA.Fill(myDS, "Customer");
rpt.SetDataSource(myDS);
var frm = new frmSalesReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
