private void flatButton1_Click(object sender, EventArgs e)
        {
            this.Close();
            Bills1 b = new Bills1();

            b.Show();
        }
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            this.Close();
            Bills1 cc = new Bills1();

            cc.Show();
        }
        private void قائمةالفواتيرToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
            Bills1 bl = new Bills1();

            bl.Show();
        }
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            string           sql  = "data source = Data.db";
            SQLiteConnection conn = new SQLiteConnection(sql);

            conn.Open();
            string        query_del = "delete from Bills_Bills";
            SQLiteCommand cmd       = new SQLiteCommand(query_del, conn);

            cmd.ExecuteNonQuery();
            conn.Close();

            this.Close();
            Bills1 b = new Bills1();

            b.Show();
        }
 private void flatButton4_Click(object sender, EventArgs e)
 {
     if (metroTextBox7.Text == string.Empty)
     {
         MessageBox.Show("لم يتم تحديد تاريخ للفاتورة يرجى التحديد وشكرا", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
     else
     {
         string           sql  = "data source = Data.db";
         SQLiteConnection conn = new SQLiteConnection(sql);
         conn.Open();
         string        query_save1 = "insert into Bills2 (Bills_id,Bills_members_name,Bills_date,Bills_sum) values(@Bills_id,@Bills_members_name,@Bills_date,@Bills_sum)";
         SQLiteCommand cmd1        = new SQLiteCommand(query_save1, conn);
         cmd1.Parameters.AddWithValue("@Bills_id", Convert.ToInt64(metroTextBox6.Text));
         cmd1.Parameters.AddWithValue("@Bills_members_name", metroComboBox1.Text);
         cmd1.Parameters.AddWithValue("@Bills_date", metroTextBox7.Text);
         cmd1.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox8.Text));
         cmd1.ExecuteNonQuery();
         conn.Close();
         for (int i = 0; i < dataGridView1.Rows.Count; i++)
         {
             conn.Open();
             string        query_save2 = "insert into Bills (Bills_id,Bills_members_name,Bills_pharm_name,Bills_pharm_ghram,Bills_pharm_quan,Bills_unit,Bills_pharm_price,Bills_count,Bills_date,Bills_sum) values(@Bills_id,@Bills_members_name,@Bills_pharm_name,@Bills_pharm_ghram,@Bills_pharm_quan,@Bills_unit,@Bills_pharm_price,@Bills_count,@Bills_date,@Bills_sum)";
             SQLiteCommand cmd2        = new SQLiteCommand(query_save2, conn);
             cmd2.Parameters.AddWithValue("@Bills_id", Convert.ToInt64(metroTextBox6.Text));
             cmd2.Parameters.AddWithValue("@Bills_members_name", metroComboBox1.Text);
             cmd2.Parameters.AddWithValue("@Bills_pharm_name", dataGridView1.Rows[i].Cells[0].Value.ToString());
             cmd2.Parameters.AddWithValue("@Bills_pharm_ghram", dataGridView1.Rows[i].Cells[1].Value.ToString());
             cmd2.Parameters.AddWithValue("@Bills_pharm_quan", Convert.ToInt64(dataGridView1.Rows[i].Cells[2].Value.ToString()));
             cmd2.Parameters.AddWithValue("@Bills_unit", dataGridView1.Rows[i].Cells[3].Value.ToString());
             cmd2.Parameters.AddWithValue("@Bills_pharm_price", Convert.ToInt64(dataGridView1.Rows[i].Cells[4].Value));
             cmd2.Parameters.AddWithValue("@Bills_count", Convert.ToInt64(dataGridView1.Rows[i].Cells[5].Value.ToString()));
             cmd2.Parameters.AddWithValue("@Bills_date", metroTextBox7.Text);
             cmd2.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox8.Text));
             cmd2.ExecuteNonQuery();
             conn.Close();
         }
         MessageBox.Show("/تم الحفظ دون الطباعة/اذا اردت الطباعة راجع الفواتير وشكرا", "حفظ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         this.Close();
         Bills1 b = new Bills1();
         b.Show();
     }
 }
        private void flatButton5_Click(object sender, EventArgs e)
        {
            if (metroTextBox4.Text == "0")
            {
                MessageBox.Show("لايمكن الحفظ لأن مبلغ الفاتورة= 0 /n هناك تغييرات لم تقم بحفظها يرجى التحديث ثم معاودة الحفظ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                if (metroTextBox3.Text == string.Empty)
                {
                    MessageBox.Show("يرجى أدخال تاريخ التعديل وشكرا", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    string           sql1  = "data source = Data.db";
                    SQLiteConnection conn1 = new SQLiteConnection(sql1);
                    conn1.Open();
                    string        query_save1 = "update Bills2 set Bills_date=@Bills_date,Bills_date_update=@Bills_date_update,Bills_sum=@Bills_sum where Bills_id = '" + Convert.ToInt64(metroTextBox1.Text) + "'";
                    SQLiteCommand cmd1        = new SQLiteCommand(query_save1, conn1);
                    cmd1.Parameters.AddWithValue("@Bills_date", metroTextBox5.Text);
                    cmd1.Parameters.AddWithValue("@Bills_date_update", metroTextBox3.Text);
                    cmd1.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox4.Text));
                    cmd1.ExecuteNonQuery();

                    string        query_save3 = "update Bills set Bills_date_update=@Bills_date_update,Bills_sum=@Bills_sum,Bills_date=@Bills_date where Bills_id = '" + Convert.ToInt64(metroTextBox1.Text) + "'";
                    SQLiteCommand cmd3        = new SQLiteCommand(query_save3, conn1);
                    cmd3.Parameters.AddWithValue("@Bills_sum", Convert.ToInt64(metroTextBox4.Text));
                    cmd3.Parameters.AddWithValue("@Bills_date_update", metroTextBox3.Text);
                    cmd3.Parameters.AddWithValue("@Bills_date", metroTextBox5.Text);
                    cmd3.ExecuteNonQuery();
                    conn1.Close();

                    MessageBox.Show("تم تعديل محتويات الفاتورة", "تعديل", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    this.Close();
                    Bills1 b = new Bills1();
                    b.Show();
                }
            }
        }