Пример #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (click == 0)
            {
                Save();
                click += 1;
            }
            else
            {
                if (MessageBox.Show("تم الحفظ بالفعل , هل تريد طباعة الفاتورة ؟ ", "الحفظ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    try
                    {
                        Report.invoice    rpt = new Report.invoice();
                        Report.ReportForm frm = new Report.ReportForm();
                        rpt.SetDataSource(order.printinvoice(Convert.ToInt32(this.txtID.Text)));
                        frm.crystalReportViewer1.ReportSource = rpt;

                        frm.ShowDialog();
                        //frm.crystalReportViewer1.PrintReport();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
        private void btnPrint_Click(object sender, EventArgs e)
        {
            try
            {
                Report.invoice    rpt = new Report.invoice();
                Report.ReportForm frm = new Report.ReportForm();
                rpt.SetDataSource(order.printinvoice(Convert.ToInt32(this.txtID.Text)));
                frm.crystalReportViewer1.ReportSource = rpt;

                frm.ShowDialog();
                //frm.crystalReportViewer1.PrintReport();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #3
0
        public void Save()
        {
            try
            {
                txtID.Text = order.getIDforInvoice().Rows[0][0].ToString();
                int rAmount; int.TryParse(txtAmountReceived.Text, out rAmount);
                int total; int.TryParse(txtTotal.Text, out total);
                if (txtName.Text == string.Empty)
                {
                    MessageBox.Show("الرجاء ادخال اسم الزبون");
                }
                else if (txtAmountReceived.Text == string.Empty)
                {
                    MessageBox.Show("الرجاء ادخال المبلغ الواصل");
                }
                else if ((totalMoney - rAmount) == 0) // If the invoice is paid
                {
                    //insert the informations of invoive
                    order.add_order(Convert.ToInt32(txtCusID.Text), txtID.Text, txtNote.Text, Convert.ToDouble(txtTotal.Text),
                                    Convert.ToDouble(rAmount), "YES", bunifuDatepicker1.Value, "Service");

                    //insert the detiles of invoive
                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                    {
                        order.add_order_detail(Convert.ToInt32(0), dataGridView1.Rows[i].Cells[0].Value.ToString(), txtID.Text
                                               , Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value), Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value)
                                               , Convert.ToDouble(dataGridView1.Rows[i].Cells[3].Value)
                                               );
                    }

                    if (MessageBox.Show("تم الحفظ بنجاح هل تريد طباعة الفاتورة ", "الطباعه", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            Report.invoice    rpt = new Report.invoice();
                            Report.ReportForm frm = new Report.ReportForm();
                            rpt.SetDataSource(order.printinvoice(Convert.ToInt32(this.txtID.Text)));
                            frm.crystalReportViewer1.ReportSource = rpt;

                            frm.ShowDialog();
                            //frm.crystalReportViewer1.PrintReport();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
                //if there are debt
                else if ((totalMoney - rAmount) > 1)
                {
                    //insert the informations of invoive
                    order.add_order(Convert.ToInt32(txtCusID.Text), txtID.Text, txtNote.Text, Convert.ToDouble(txtTotal.Text),
                                    Convert.ToDouble(rAmount), "NO", bunifuDatepicker1.Value, "Service");

                    //insert the detiles of invoive
                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                    {
                        order.add_order_detail(Convert.ToInt32(0), dataGridView1.Rows[i].Cells[0].Value.ToString(), txtID.Text
                                               , Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value), Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value)
                                               , Convert.ToDouble(dataGridView1.Rows[i].Cells[3].Value)
                                               );
                    }

                    BL.debtClass debt = new BL.debtClass();
                    debt.add_debt_detail(txtID.Text, Convert.ToInt32(txtCusID.Text)
                                         , Convert.ToDouble(totalMoney - rAmount));


                    if (MessageBox.Show("تم حفظ الفاتورة و الدين هل تريد طباعة الفاتورة", "الطباعه", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            Report.invoice    rpt = new Report.invoice();
                            Report.ReportForm frm = new Report.ReportForm();
                            rpt.SetDataSource(order.printinvoice(Convert.ToInt32(this.txtID.Text)));
                            frm.crystalReportViewer1.ReportSource = rpt;

                            frm.ShowDialog();
                            //frm.crystalReportViewer1.PrintReport();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }



                //// set Seasonal_revenue from invoice

                //rpt.set_Seasonal_revenue_from_invoice(totalMoney);

                //// coumput Prices of articles

                //for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                //{

                //    Seasonal_disbursements += Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value) *
                //        Convert.ToDouble(rpt.get_purchasing_price(Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value)).Rows[0][0]);

                //}
                //// set Seasonal_disbursements
                //rpt.set_seasonal_disbursements_invo_sal_dis(Seasonal_disbursements);
                //Seasonal_disbursements = 0.0;


                BL.CashBox.Months mnth = new BL.CashBox.Months();
                mnth.set_new_month();
                DataTable LastMonth           = mnth.sel_last_month();
                BL.CashBox.BoxInsertion insrt = new BL.CashBox.BoxInsertion();
                insrt.SetCash(Convert.ToInt32(txtAmountReceived.Text), "Service", this.bunifuDatepicker1.Value, this.txtID.Text,
                              LastMonth.Rows[0][0].ToString());

                txtID.Text = order.getIDforInvoice().Rows[0][0].ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Пример #4
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                int rAmount; int.TryParse(txtAmountReceived.Text, out rAmount);
                int total; int.TryParse(txtTotal.Text, out total);
                if (txtName.Text == string.Empty)
                {
                    MessageBox.Show("الرجاء ادخال اسم الزبون");
                }
                else if (txtAmountReceived.Text == string.Empty)
                {
                    MessageBox.Show("الرجاء ادخال المبلغ الواصل");
                }
                else if ((totalMoney - rAmount) == 0) // If the invoice is paid
                {
                    //insert the informations of invoive
                    ord.add_order(Convert.ToInt32(txtCusID.Text), txtID.Text, txtNote.Text, Convert.ToDouble(txtTotal.Text),
                                  Convert.ToDouble(rAmount), "YES", bunifuDatepicker1.Value);

                    //insert the detiles of invoive
                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                    {
                        ord.add_order_detail(Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value), dataGridView1.Rows[i].Cells[1].Value.ToString(), Convert.ToInt32(txtID.Text)
                                             , Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value), Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value)
                                             , Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value)
                                             );
                    }

                    if (MessageBox.Show("تم الحفظ بنجاح هل تريد طباعة الفاتورة ", "الطباعه", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            Report.invoice    rpt = new Report.invoice();
                            Report.ReportForm frm = new Report.ReportForm();
                            rpt.SetDataSource(ord.printinvoice(Convert.ToInt32(
                                                                   ord.getLastInvoiceForPrint().Rows[0][0])));
                            frm.crystalReportViewer1.ReportSource = rpt;

                            frm.ShowDialog();
                            //frm.crystalReportViewer1.PrintReport();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
                //if there are debt
                else if ((totalMoney - rAmount) > 1)
                {
                    //insert the informations of invoive
                    ord.add_order(Convert.ToInt32(txtCusID.Text), txtID.Text, txtNote.Text, Convert.ToDouble(txtTotal.Text),
                                  Convert.ToDouble(rAmount), "NO", bunifuDatepicker1.Value);

                    //insert the detiles of invoive
                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                    {
                        ord.add_order_detail(Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value), dataGridView1.Rows[i].Cells[1].Value.ToString(), Convert.ToInt32(txtID.Text)
                                             , Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value), Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value)
                                             , Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value)
                                             );
                    }

                    BL.debtClass debt = new BL.debtClass();
                    debt.add_debt_detail(Convert.ToInt32(txtID.Text), Convert.ToInt32(txtCusID.Text)
                                         , Convert.ToDouble(totalMoney - rAmount));


                    if (MessageBox.Show("تم حفظ الفاتورة و الدين هل تريد طباعة الفاتورة", "الطباعه", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            Report.invoice    rpt = new Report.invoice();
                            Report.ReportForm frm = new Report.ReportForm();
                            rpt.SetDataSource(ord.printinvoice(Convert.ToInt32(
                                                                   ord.getLastInvoiceForPrint().Rows[0][0])));
                            frm.crystalReportViewer1.ReportSource = rpt;

                            frm.ShowDialog();
                            //frm.crystalReportViewer1.PrintReport();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }



                // set Seasonal_revenue from invoice

                rpt.set_Seasonal_revenue_from_invoice(totalMoney);

                // coumput Prices of articles

                for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                {
                    Seasonal_disbursements += Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value) *
                                              Convert.ToDouble(rpt.get_purchasing_price(Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value)).Rows[0][0]);
                }
                // set Seasonal_disbursements
                rpt.set_seasonal_disbursements_invo_sal_dis(Seasonal_disbursements);
                Seasonal_disbursements = 0.0;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }