예제 #1
0
        private void create_Click(object sender, RoutedEventArgs e)
        {
            if (!String.IsNullOrEmpty(quantityTxt.Text) && !String.IsNullOrEmpty(foodIdTxt.Text))
            {
                int sr = 0;
                SqlConnection sqlConFill = new SqlConnection(conn);
                SqlCommand cmdFill = new SqlCommand();
                cmdFill.CommandText = "SELECT MAX(serial) FROM orders";
                cmdFill.Connection = sqlConFill;
                sqlConFill.Open();
                SqlDataReader rd1 = cmdFill.ExecuteReader();
                if (rd1.HasRows)
                {
                    rd1.Read();
                    var outputParam = rd1[0];
                    if (!(outputParam is DBNull))
                    {
                        sr = Convert.ToInt32(rd1[0]);
                    }
                    else
                    {
                        sr = 0;
                    }
                    rd1.Close();
                }
                sqlConFill.Close();
                sr = sr + 1;

                SqlConnection sqlConFillck = new SqlConnection(conn);
                SqlCommand cmdFillck = new SqlCommand();
                cmdFillck.CommandText = "SELECT serial FROM orders WHERE foodId=@Id ";
                cmdFillck.Parameters.AddWithValue("@Id", foodIdTxt.Text);
                cmdFillck.Connection = sqlConFillck;
                sqlConFillck.Open();
                SqlDataReader rd = cmdFillck.ExecuteReader();
                String cat = "";
                if (rd.HasRows)
                {
                    rd.Read();
                    cat = cat + rd[0].ToString();
                    rd.Close();
                    sqlConFillck.Close();
                    MessageBox.Show("Item Already Exist at Serial " + cat);
                }

                else
                {
                    sqlConFillck.Close();
                    int p = Convert.ToInt32(priceTxt.Text);
                    int q = Convert.ToInt32(quantityTxt.Text);
                    int tt = p * q;
                    cmdFill.CommandText = "INSERT INTO orders(serial,foodId,foodName,price,quantity,total)VALUES (@serial,@foodId,@foodName,@price,@quantity,@total)";
                    cmdFill.Parameters.AddWithValue("@serial", sr.ToString());
                    cmdFill.Parameters.AddWithValue("@foodId", foodIdTxt.Text);
                    cmdFill.Parameters.AddWithValue("@foodName", foodNameTxt.Text);
                    cmdFill.Parameters.AddWithValue("@price", priceTxt.Text);
                    cmdFill.Parameters.AddWithValue("@quantity", quantityTxt.Text);
                    cmdFill.Parameters.AddWithValue("@total", tt);
                    cmdFill.Connection = sqlConFill;
                    sqlConFill.Open();
                    cmdFill.ExecuteNonQuery();
                    sqlConFill.Close();
                    Billing win2 = new Billing();
                    win2.Show();
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("Quantity field cann't be empty");
            }
        }
예제 #2
0
 private void update_Click(object sender, RoutedEventArgs e)
 {
     if (!String.IsNullOrEmpty(quantityTxt.Text) && !String.IsNullOrEmpty(foodIdTxt.Text))
     {
         SqlConnection sqlConFill = new SqlConnection(conn);
         SqlCommand cmdFill = new SqlCommand();
         int p = Convert.ToInt32(priceTxt.Text);
         int q = Convert.ToInt32(quantityTxt.Text);
         int tt = p * q;
         cmdFill.CommandText = "UPDATE orders SET foodid=@foodId,foodName=@foodName,price=@price,quantity=@quantity,total=@total WHERE serial=@serial";
         cmdFill.Parameters.AddWithValue("@foodId", foodIdTxt.Text);
         cmdFill.Parameters.AddWithValue("@foodName", foodNameTxt.Text);
         cmdFill.Parameters.AddWithValue("@price", priceTxt.Text);
         cmdFill.Parameters.AddWithValue("@quantity", quantityTxt.Text);
         cmdFill.Parameters.AddWithValue("@total", tt);
         cmdFill.Parameters.AddWithValue("@serial", serialTxt.Text);
         cmdFill.Connection = sqlConFill;
         sqlConFill.Open();
         cmdFill.ExecuteNonQuery();
         Billing win2 = new Billing();
         win2.Show();
         this.Close();
     }
     else
     {
         MessageBox.Show("Food Id or Quantity field cann't be empty");
     }
 }
예제 #3
0
        private void delete_Click_1(object sender, RoutedEventArgs e)
        {
            SqlConnection sqlConFill = new SqlConnection(conn);
            SqlCommand cmdFill = new SqlCommand();
            cmdFill.CommandText = "DELETE FROM orders WHERE serial=@serial";
            cmdFill.Parameters.AddWithValue("@serial", serialTxt.Text.ToString());
            cmdFill.Connection = sqlConFill;
            sqlConFill.Open();
            cmdFill.ExecuteNonQuery();
            sqlConFill.Close();

            cmdFill.CommandText = "UPDATE orders SET serial=serial-1 WHERE serial>@upSerial2";
            cmdFill.Parameters.AddWithValue("@upSerial2", serialTxt.Text.ToString());
            cmdFill.Connection = sqlConFill;
            sqlConFill.Open();
            cmdFill.ExecuteNonQuery();
            sqlConFill.Close();

            Billing win2 = new Billing();
            win2.Show();
            this.Close();
        }
예제 #4
0
        private void Print_Click_2(object sender, RoutedEventArgs e)
        {
            System.Windows.Controls.PrintDialog pd = new System.Windows.Controls.PrintDialog();
            if (pd.ShowDialog() != true) return;

            // create a document
            FixedDocument document = new FixedDocument();
            document.DocumentPaginator.PageSize = new Size(pd.PrintableAreaWidth, pd.PrintableAreaHeight);

            // create a page
            FixedPage page1 = new FixedPage();
            page1.Width = document.DocumentPaginator.PageSize.Width;
            page1.Height = document.DocumentPaginator.PageSize.Height;

            //adding header
            TextBlock page2Text = new TextBlock();
            page2Text.Text = "Billing";
            page2Text.FontSize = 20;
            page2Text.Margin = new Thickness(300, 0, 0, 0);
            page1.Children.Add(page2Text);

            //adding date
            TextBlock date11 = new TextBlock();
            date11.FontFamily = new FontFamily("Consolas");
            date11.Text = "Date \t: " + DateTime.Now.ToShortDateString() + "\nTime \t: " + DateTime.Now.ToShortTimeString();
            date11.FontSize = 15;
            date11.Margin = new Thickness(250, 22, 0, 0);
            page1.Children.Add(date11);

            //adding grid
            sp.Children.Remove(lvUsers3);
            lvUsers3.Margin = new System.Windows.Thickness(0, 65, 0, 0);
            page1.Children.Add(lvUsers3);

            //add extra footer data
            int m = Convert.ToInt32(lvUsers3.ActualHeight);
            m = m + 80;
            String one = "Total Food Price \t: " + fTotal.Text + " Tk\nService Charge (" + ser.ToString() + "%)\t: " + ser_charge.Text + " Tk\nDiscount (" + dis.ToString() + "%)\t\t: " + discount.Text + " Tk\nTotal Without VAT \t: " + net_total.Text + " Tk\nVAT (" + tax.ToString() + "%)\t\t: " + tax_charge.Text + " Tk\nTotal With VAT \t: " + total.Text + " Tk";
            TextBlock footer = new TextBlock();
            footer.Text = one;
            footer.FontFamily = new FontFamily("Consolas");
            footer.FontSize = 12;
            footer.Margin = new Thickness(200, m, 0, 0);
            page1.Children.Add(footer);

            // add the page to the document
            PageContent page1Content = new PageContent();
            ((IAddChild)page1Content).AddChild(page1);
            document.Pages.Add(page1Content);
            pd.PrintDocument(document.DocumentPaginator, Title);

            page1.Children.Remove(lvUsers3);
            lvUsers3.Margin = new Thickness(0, 0, 0, 0);
            sp.Children.Add(lvUsers3);

            finalTask();
            goingBack();
            Billing win2 = new Billing();
            win2.Show();
            this.Close();
        }
예제 #5
0
 private void billing_Click(object sender, RoutedEventArgs e)
 {
     Billing win2 = new Billing();
     win2.Show();
     this.Close();
 }