Exemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                DBManager     manager    = new DBManager();
                SqlConnection connection = manager.Connection();
                String        query      = "select * from Temp_Sell_Counter";
                SqlCommand    command    = new SqlCommand(query, connection);
                connection.Open();
                List <TempSell> tempSells = new List <TempSell>();
                SqlDataReader   reader    = command.ExecuteReader();
                while (reader.Read())
                {
                    int      id         = Convert.ToInt16(reader[0]);
                    string   bookname   = reader[1].ToString();
                    string   writer     = reader[2].ToString();
                    string   edition    = reader[3].ToString();
                    string   type       = reader[4].ToString();
                    string   print      = reader[5].ToString();
                    int      quantity   = Convert.ToInt16(reader[6]);
                    double   unitpirce  = Convert.ToDouble(reader[7]);
                    double   total      = Convert.ToDouble(reader[8]);
                    double   pay        = Convert.ToDouble(reader[9]);
                    double   due        = Convert.ToDouble(reader[10]);
                    int      memoNumber = Convert.ToInt16(reader[11]);
                    TempSell aSell      = new TempSell();
                    aSell.Id         = id;
                    aSell.BookName   = bookname;
                    aSell.WriterName = writer;
                    aSell.Edition    = edition;
                    aSell.Type       = type;
                    aSell.Print      = print;
                    aSell.Quantity   = quantity;
                    aSell.Unitprice  = unitpirce;
                    aSell.Total      = total;
                    aSell.Pay        = pay;
                    aSell.Due        = due;
                    aSell.Memonumber = memoNumber;
                    tempSells.Add(aSell);
                }

                connection.Close();
                SellReprotUI sellReprot = new SellReprotUI(tempSells);
                sellReprot.ShowDialog();
                System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                SqlCommand command1;
                String     deletequery = "delete from Temp_Sell_Counter";
                if (dialog == DialogResult.Yes)
                {
                    command1 = new SqlCommand(deletequery, connection);
                    connection.Open();
                    command1.ExecuteNonQuery();

                    string que = "DBCC CHECKIDENT (Temp_Sell_Counter,Reseed,0)";
                    command1 = new SqlCommand(que, connection);
                    command1.ExecuteNonQuery();
                    string que1 = "set identity_insert Temp_Sell_Counter on";
                    command1 = new SqlCommand(que1, connection);
                    command1.ExecuteNonQuery();

                    string insQuery = "insert into Memo_Counter values(@date)";
                    command1 = new SqlCommand(insQuery, connection);
                    command1.Parameters.Clear();
                    command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
                    command1.ExecuteNonQuery();
                    memoNumver = GetLastMemoNumber();
                }
                else if (dialog == DialogResult.No)
                {
                    System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?",
                                                                                "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog1 == DialogResult.Yes)
                    {
                        sellReprot = new SellReprotUI(tempSells);
                        sellReprot.ShowDialog();
                        connection.Open();
                        command1 = new SqlCommand(deletequery, connection);
                        command1.ExecuteNonQuery();
                        string que = "DBCC CHECKIDENT (Temp_Sell_Counter,Reseed,0)";
                        command1 = new SqlCommand(que, connection);
                        command1.ExecuteNonQuery();
                        string que1 = "set identity_insert Temp_Sell_Counter on";
                        command1 = new SqlCommand(que1, connection);
                        command1.ExecuteNonQuery();

                        string insQuery = "insert into Memo_Counter values(@date)";
                        command1 = new SqlCommand(insQuery, connection);
                        command1.Parameters.Clear();
                        command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
                        command1.ExecuteNonQuery();
                        memoNumver = GetLastMemoNumber();

                        DialogResult d2 = MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                        if (d2 == DialogResult.Yes)
                        {
                            this.Close();
                        }
                        else if (d2 == DialogResult.No)
                        {
                        }
                    }
                    else if (dialog1 == DialogResult.No)
                    {
                        this.Close();
                    }
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                DBManager manager = new DBManager();
                SqlConnection connection = manager.Connection();
                String query = "select * from Temp_Sell_Counter";
                SqlCommand command = new SqlCommand(query, connection);
                connection.Open();
                List<TempSell> tempSells = new List<TempSell>();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    int id = Convert.ToInt16(reader[0]);
                    string bookname = reader[1].ToString();
                    string writer = reader[2].ToString();
                    string edition = reader[3].ToString();
                    string type = reader[4].ToString();
                    string print = reader[5].ToString();
                    int quantity = Convert.ToInt16(reader[6]);
                    double unitpirce = Convert.ToDouble(reader[7]);
                    double total = Convert.ToDouble(reader[8]);
                    double pay = Convert.ToDouble(reader[9]);
                    double due = Convert.ToDouble(reader[10]);
                    int memoNumber = Convert.ToInt16(reader[11]);
                    TempSell aSell = new TempSell();
                    aSell.Id = id;
                    aSell.BookName = bookname;
                    aSell.WriterName = writer;
                    aSell.Edition = edition;
                    aSell.Type = type;
                    aSell.Print = print;
                    aSell.Quantity = quantity;
                    aSell.Unitprice = unitpirce;
                    aSell.Total = total;
                    aSell.Pay = pay;
                    aSell.Due = due;
                    aSell.Memonumber = memoNumber;
                    tempSells.Add(aSell);
                }

                connection.Close();
                SellReprotUI sellReprot = new SellReprotUI(tempSells);
                sellReprot.ShowDialog();
                System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                SqlCommand command1;
                String deletequery = "delete from Temp_Sell_Counter";
                if (dialog == DialogResult.Yes)
                {

                    command1 = new SqlCommand(deletequery, connection);
                    connection.Open();
                    command1.ExecuteNonQuery();

                    string que = "DBCC CHECKIDENT (Temp_Sell_Counter,Reseed,0)";
                    command1 = new SqlCommand(que, connection);
                    command1.ExecuteNonQuery();
                    string que1 = "set identity_insert Temp_Sell_Counter on";
                    command1 = new SqlCommand(que1, connection);
                    command1.ExecuteNonQuery();

                    string insQuery = "insert into Memo_Counter values(@date)";
                    command1 = new SqlCommand(insQuery, connection);
                    command1.Parameters.Clear();
                    command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
                    command1.ExecuteNonQuery();
                    memoNumver = GetLastMemoNumber();
                }
                else if (dialog == DialogResult.No)
                {
                    System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?",
                        "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dialog1 == DialogResult.Yes)
                    {
                        sellReprot = new SellReprotUI(tempSells);
                        sellReprot.ShowDialog();
                        connection.Open();
                        command1 = new SqlCommand(deletequery, connection);
                        command1.ExecuteNonQuery();
                        string que = "DBCC CHECKIDENT (Temp_Sell_Counter,Reseed,0)";
                        command1 = new SqlCommand(que, connection);
                        command1.ExecuteNonQuery();
                        string que1 = "set identity_insert Temp_Sell_Counter on";
                        command1 = new SqlCommand(que1, connection);
                        command1.ExecuteNonQuery();

                        string insQuery = "insert into Memo_Counter values(@date)";
                        command1 = new SqlCommand(insQuery, connection);
                        command1.Parameters.Clear();
                        command1.Parameters.AddWithValue("@date", DateTime.Now.Date);
                        command1.ExecuteNonQuery();
                        memoNumver = GetLastMemoNumber();

                        DialogResult d2 = MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                        if (d2 == DialogResult.Yes)
                        {
                            this.Close();
                        }
                        else if (d2 == DialogResult.No)
                        {
                           
                        }

                    }
                    else if (dialog1 == DialogResult.No)
                    {
                        this.Close();
                    }
                }
            }
            catch (Exception exception)
            {
                
                  MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
           
        }