private void button5_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_PRODUCTS myreport = new RPT.RPT_ALL_PRODUCTS();
RPT.FRM_RPT_PRODUCT myform = new RPT.FRM_RPT_PRODUCT();
myform.crystalReportViewer1.ReportSource = myreport;
myform.ShowDialog();
}
private void btnPrintAllProducts_Click(object sender, EventArgs e)
{
RPT.rpt_All_products myRepot = new RPT.rpt_All_products();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewerSingle.ReportSource = myRepot;
myForm.ShowDialog();
}
private void buttonX2_Click_1(object sender, EventArgs e)
{
RPT.rpt_all_product myreport = new RPT.rpt_all_product();
RPT.FRM_RPT_PRODUCT myform = new RPT.FRM_RPT_PRODUCT();
myform.crystalReportViewer1.ReportSource = myreport;
myform.ShowDialog();
}
private void metroButton6_Click(object sender, EventArgs e)
{
RPT.rpt_all_products myReport = new RPT.rpt_all_products();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
}
private void button5_Click(object sender, EventArgs e)
{
RPT.RPT_PRD_SINGLE My_Report = new RPT.RPT_PRD_SINGLE();
My_Report.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = My_Report;
myForm.ShowDialog();
}
private void buttonX2_Click(object sender, EventArgs e)
{
RPT.RPT_PRODUCT_SIGNLE MYREPORT = new RPT.RPT_PRODUCT_SIGNLE();
MYREPORT.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myform = new RPT.FRM_RPT_PRODUCT();
myform.crystalReportViewer1.ReportSource = MYREPORT;
myform.ShowDialog();
}
private void btnPrinAll_Click(object sender, EventArgs e)
{
RPT.rpt_all_categories rpt = new RPT.rpt_all_categories();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.Refresh();
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
private void btnPrintCurrent_Click(object sender, EventArgs e)
{
RPT.rpt_single_category rpt = new RPT.rpt_single_category();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.SetParameterValue("@id", Convert.ToInt32(txtID.Text));
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
private void metroButton5_Click(object sender, EventArgs e)
{
RPT.rpt_prd_single myreport = new RPT.rpt_prd_single();
myreport.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myform = new RPT.FRM_RPT_PRODUCT();
myform.crystalReportViewer1.ReportSource = myreport;
myform.ShowDialog();
}
private void btnPrintSingle_Click(object sender, EventArgs e)
{
RPT.RPT_single_product myReport = new RPT.RPT_single_product();
myReport.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myFrom = new RPT.FRM_RPT_PRODUCT();
myFrom.crystalReportViewerSingle.ReportSource = myReport;
myFrom.ShowDialog();
}
private void PrintAllCateg_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_CATEGORIES rpt = new RPT.RPT_ALL_CATEGORIES();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.Refresh();
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
RPT.Year report = new RPT.Year();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
frm.crystalReportViewer1.ReportSource = report;
frm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void button6_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
RPT.rpt_all_products myReport = new RPT.rpt_all_products();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void button1_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_DATE_CUSTOMER rpt = new RPT.RPT_ALL_DATE_CUSTOMER();
rpt.SetParameterValue("@id_takseet", this.DGV_TAKSEET.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT MY_FORM = new RPT.FRM_RPT_PRODUCT();
MY_FORM.crystalReportViewer1.ReportSource = rpt;
MY_FORM.ShowDialog();
}
private void BTM_PRINT_SINGLE_Click(object sender, EventArgs e)
{
RPT.RPT_SINGLE_CATEGORY rpt = new RPT.RPT_SINGLE_CATEGORY();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.SetParameterValue("@ID", Convert.ToInt32(TXT_ID.Text));
//rpt.Refresh();
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
private void btnprint_Click(object sender, EventArgs e)
{
int ID_SHOP = Convert.ToInt32(DGVSHOP.CurrentRow.Cells[0].Value);
RPT.RPT_SHOP REPORT = new RPT.RPT_SHOP();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(SHOP.GET_SHOP_DETAILS(ID_SHOP));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
}
private void buttonX2_Click(object sender, EventArgs e)
{
int ID_SHOP = Convert.ToInt32(shop.GET_LAST_SHOP_FOR_PRINT().Rows[0][0]);
RPT.RPT_SHOP REPORT = new RPT.RPT_SHOP();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(shop.GET_SHOP_DETAILS(ID_SHOP));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
}
private void BTM_PRINT_BILL_Click(object sender, EventArgs e)
{
//get last order to print it
int order_id = Convert.ToInt32(ORDER.GET_LAST_ORDER_ID_for_print().Rows[0][0]);
RPT.RPT_ORDER REPORT = new RPT.RPT_ORDER();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(ORDER.GET_ORDER_DETAILS(Convert.ToInt32(order_id)));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
}
private void button5_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
RPT.rpt_prd_single myReport = new RPT.rpt_prd_single {
};
myReport.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void buttonX6_Click(object sender, EventArgs e)
{
RPT.rptAllCategories rpt1 = new RPT.rptAllCategories();
//RPT.RPT_ALL_CATEGORIES rpt = new RPT.RPT_ALL_CATEGORIES();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
//rpt.Refresh();
rpt1.Refresh();
//frm.crystalReportViewer1.ReportSource = rpt;
frm.crystalReportViewer1.ReportSource = rpt1;
frm.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
int order_ID = Convert.ToInt32(dgvOrders.CurrentRow.Cells[0].Value);
RPT.rpt_orders report = new RPT.rpt_orders();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
report.SetDataSource(order.GetOrderDetails(order_ID));
frm.crystalReportViewer1.ReportSource = report;
frm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void btnprint_Click_1(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
int ID_ORDER = Convert.ToInt32(ORDER.GET_LAST_ORDER_FOR_PRINT().Rows[0][0]);
RPT.RPT_ORDER REPORT = new RPT.RPT_ORDER();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(ORDER.GET_ORDER_DETAILS(ID_ORDER));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
this.Cursor = Cursors.Default;
}
private void button_print_Click_1(object sender, EventArgs e)
{
// get the last order3
// this.Cursor = Cursors.WaitCursor;
int Order_ID = Convert.ToInt32(order.GET_last_ORDER().Rows[0][0]);
RPT.RPT_ORDERS Report = new RPT.RPT_ORDERS();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
Report.SetDataSource(order.GET_ORDER_DETAILS(Order_ID));
frm.crystalReportViewer1.ReportSource = Report;
frm.ShowDialog();
// this.Cursor = Cursors.Default;
}
private void btnPrint_Click(object sender, EventArgs e)
{
//get The last order
this.Cursor = Cursors.WaitCursor;
int order_ID = Convert.ToInt32(order.GET_LAST_ORDER_FOR_PRINT().Rows[0][0]);
RPT.rpt_orders report = new RPT.rpt_orders();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
report.SetDataSource(order.GetOrderDetails(order_ID));
frm.crystalReportViewer1.ReportSource = report;
frm.ShowDialog();
this.Cursor = Cursors.Default;
}
private void BTM_PRINT_Click(object sender, EventArgs e)
{
try
{
int order_id = Convert.ToInt32(DGV_ORDERS.CurrentRow.Cells[0].Value);
RPT.RPT_ORDER REPORT = new RPT.RPT_ORDER();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(order.GET_ORDER_DETAILS(Convert.ToInt32(order_id)));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
}
catch
{
}
}
private void PrintCurrentCateg_Click(object sender, EventArgs e)
{
RPT.RPT_SINGLE_CATEGORY rpt = new RPT.RPT_SINGLE_CATEGORY();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.SetParameterValue("@id", Convert.ToInt32(textID.Text)); //this to insert id from combox
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
btnAdd.Enabled = false;
btnNew.Enabled = true;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
PrintCurrentCateg.Enabled = false;
ExportToExcelCurrent.Enabled = false;
}
private void button4_Click(object sender, EventArgs e)
{
RPT.RPT_TO_SINGLE myreport = new RPT.RPT_TO_SINGLE(); //نسخة من التقرير او الريبورت
// ارسال قيمة البراميتر بحيث يقوم بعرض منتوج واحد وهو المححد ف datagridview
myreport.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT MYFORM = new RPT.FRM_RPT_PRODUCT(); // هذا من اجل الوصول لواجة الكريستال
MYFORM.crystalReportViewer1.ReportSource = myreport;
MYFORM.ShowDialog();
btn_update.Enabled = false;
btn_delete.Enabled = false;
btn_print.Enabled = false;
btn_add.Enabled = true;
}
private void BTM_PRINT_Click(object sender, EventArgs e)
{
DateTime dtValue;
dtValue = dateTimePicker1.Value; // load your date & time into this variable
string montht = dtValue.ToString("MM");
string yearrr = dtValue.ToString("yyyy");
//MessageBox.Show("month :" + montht + " year :" + yearrr);
RPT.RPT_PRINT_DETAILS_MONTH REPORT = new RPT.RPT_PRINT_DETAILS_MONTH();
RPT.FRM_RPT_PRODUCT FRM = new RPT.FRM_RPT_PRODUCT();
REPORT.SetDataSource(CUST.get_all_information_toprint(montht.ToString(), yearrr.ToString()));
FRM.crystalReportViewer1.ReportSource = REPORT;
FRM.ShowDialog();
}
private void btnPrinAll_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
RPT.rpt_all_categories rpt = new RPT.rpt_all_categories();
RPT.FRM_RPT_PRODUCT frm = new RPT.FRM_RPT_PRODUCT();
rpt.Refresh();
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
this.Cursor = Cursors.Default;
}
catch {
MessageBox.Show("الرجاء تحديث المعلومات", "تنبية", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
RPT.WEB myReport = new RPT.WEB();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myReport.SetParameterValue("@ID_ORDER", Convert.ToInt32(textBox1.Text));
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
this.Cursor = Cursors.Default;
prd.DeleteProductWeb(Convert.ToInt32(textBox1.Text));
this.dgvOrdersWeb.DataSource = prd.GetOrderDetailsWeb1();
}
catch {
MessageBox.Show("قم بتحديد الفاتورة ", "تنبية", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Cursor = Cursors.Default;
}
}
private void button6_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_PRD myReport = new RPT.RPT_ALL_PRD();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
}
private void button5_Click(object sender, EventArgs e)
{
RPT.RPT_PRD_SINGLE myReport = new RPT.RPT_PRD_SINGLE();
myReport.SetParameterValue("@ID", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
}