Exemple #1
0
        private void buttom_confirm_Click(object sender, EventArgs e)
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand("select TinhTrang from HoaDonMua where MaHDMua=@mahd", conn);

            cmd.Parameters.AddWithValue("@mahd", id.Text);
            SqlDataReader r = cmd.ExecuteReader();

            if (r.Read())
            {
                if ((string)r["TinhTrang"] == "Chưa xác nhận")
                {
                    if (idemp != idngnhan.Text && idngnhan.Text.Length != 0)
                    {
                        Confirm f = new Confirm("MB_DIRECTOR");
                        f.ShowDialog();
                        if (f.DialogResult == DialogResult.OK)
                        {
                            DateTime date = DateTime.Today;
                            day2.Text   = date.Day.ToString();
                            month2.Text = date.Month.ToString();
                            year2.Text  = date.Year.ToString();

                            r.Close();
                            cmd.CommandText = "update HoaDonMua set TinhTrang=@tt,NguoiNhan=@ngnhan,NgayNhan=@day where MaHDMua=@mahd";
                            cmd.Parameters.Clear();
                            cmd.Parameters.AddWithValue("@mahd", id.Text);
                            cmd.Parameters.AddWithValue("@tt", "Đã xác nhận");
                            cmd.Parameters.AddWithValue("@day", month2.Text + "/" + day2.Text + "/" + year2.Text);
                            cmd.Parameters.AddWithValue("@ngnhan", idemp);
                            cmd.ExecuteNonQuery();
                            tinhtrang.Text = "Đã xác nhận";
                            idngnhan.Text  = idemp;
                            ngnhan.Text    = name;

                            DataRow[] rows = dt.Select("MaHDMua = '" + id.Text + "'");
                            for (int i = 0; i < rows.Length; i++)
                            {
                                rows[i]["TinhTrang"] = "Đã xác nhận";
                                rows[i]["NguoiNhan"] = idemp;
                            }

                            error.Text                    = "Confirm success!";
                            buttom_change.Enabled         = false;
                            buttom_change.BackgroundImage = Image.FromFile(@"Image\buttom_change3.png");
                            buttom_confirm.Visible        = false;
                            buttom_unconfirm.Visible      = true;

                            conn.Close();
                            //Cập nhật kho hàng
                            SqlDataAdapter adapter = new SqlDataAdapter("select * from ChiTietHoaDonMua where MaHDMua='" + id.Text + "'", conn);
                            DataTable      dtsp    = new DataTable();
                            adapter.Fill(dtsp);
                            adapter.Dispose();
                            conn.Open();
                            foreach (DataRow row in dtsp.Rows)
                            {
                                cmd.CommandText = "update SanPham set SLTon=SLTon+" + (int)row["SLMua"] + ",GiaMua=" + (int)row["GiaMua"] + "where MaSP='" + (string)row["MaSP"] + "'";
                                cmd.ExecuteNonQuery();
                            }
                            conn.Close();
                        }
                    }
                    else
                    {
                        DateTime date = DateTime.Today;
                        day2.Text   = date.Day.ToString();
                        month2.Text = date.Month.ToString();
                        year2.Text  = date.Year.ToString();

                        r.Close();
                        cmd.CommandText = "update HoaDonMua set TinhTrang=@tt,NguoiNhan=@ngnhan,NgayNhan=@day where MaHDMua=@mahd";
                        cmd.Parameters.Clear();
                        cmd.Parameters.AddWithValue("@mahd", id.Text);
                        cmd.Parameters.AddWithValue("@tt", "Đã xác nhận");
                        cmd.Parameters.AddWithValue("@day", month2.Text + "/" + day2.Text + "/" + year2.Text);
                        cmd.Parameters.AddWithValue("@ngnhan", idemp);
                        cmd.ExecuteNonQuery();
                        tinhtrang.Text = "Đã xác nhận";
                        idngnhan.Text  = idemp;
                        ngnhan.Text    = name;

                        DataRow[] rows = dt.Select("MaHDMua = '" + id.Text + "'");
                        for (int i = 0; i < rows.Length; i++)
                        {
                            rows[i]["TinhTrang"] = "Đã xác nhận";
                            rows[i]["NguoiNhan"] = idemp;
                        }

                        error.Text                    = "Confirm success!";
                        buttom_change.Enabled         = false;
                        buttom_change.BackgroundImage = Image.FromFile(@"Image\buttom_change3.png");
                        buttom_confirm.Visible        = false;
                        buttom_unconfirm.Visible      = true;

                        conn.Close();
                        //Cập nhật kho hàng
                        SqlDataAdapter adapter = new SqlDataAdapter("select * from ChiTietHoaDonMua where MaHDMua='" + id.Text + "'", conn);
                        DataTable      dtsp    = new DataTable();
                        adapter.Fill(dtsp);
                        adapter.Dispose();
                        conn.Open();
                        foreach (DataRow row in dtsp.Rows)
                        {
                            cmd.CommandText = "update SanPham set SLTon=SLTon+" + (int)row["SLMua"] + ",GiaMua=" + (int)row["GiaMua"] + "where MaSP='" + (string)row["MaSP"] + "'";
                            cmd.ExecuteNonQuery();
                        }
                        conn.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Hóa đơn này đã được xác nhận!", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            r.Close();
            conn.Close();
        }