private void dgvKhachHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
int r = dgvKhachHang.CurrentRow.Index;
lbMaKH.Text = dgvKhachHang.Rows[r].Cells[0].Value.ToString();
txtTen.Text = dgvKhachHang.Rows[r].Cells[1].Value.ToString();
txtEmail.Text = dgvKhachHang.Rows[r].Cells[2].Value.ToString();
txtDiaChi.Text = dgvKhachHang.Rows[r].Cells[3].Value.ToString();
txtSoDienThoai.Text = dgvKhachHang.Rows[r].Cells[4].Value.ToString();
lbDiemTichLuy.Text = dgvKhachHang.Rows[r].Cells[5].Value.ToString();
KhachHang KH = dt.KhachHangs.Where(s => s.Ma == Convert.ToInt32(lbMaKH.Text)).FirstOrDefault();
LoaiKH Loai = dt.LoaiKHs.Where(s => s.Ma == KH.Ma_LoaiKH).FirstOrDefault();
lbThanhVien.Text = Loai.Ten;
lbMaKH.Visible = true;
lbDiemTichLuy.Visible = true;
lbThanhVien.Visible = true;
txtTen.Enabled = false;
txtSoDienThoai.Enabled = false;
txtDiaChi.Enabled = false;
txtEmail.Enabled = false;
btnThem.Enabled = true;
btnSua.Enabled = true;
btnLuu.Enabled = false;
btnHuy.Enabled = true;
}
private void btnLoaiKH_Click(object sender, EventArgs e)
{
frmLoaiKhachHang LoaiKH = null;
if (LoaiKH == null || LoaiKH.IsDisposed)
{
LoaiKH = new frmLoaiKhachHang();
}
LoaiKH.ShowDialog();
}
public static void Them(LoaiKH entity)
{
String sql = "INSERT INTO LoaiKhachHang(MaLoaiKH, TenLoaiKH, MucGiam) VALUES(@MaLoaiKH, @TenLoaiKH, @MucGiam)";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", entity.MaLoaiKH);
Command.Parameters.AddWithValue("@TenLoaiKH", entity.TenLoaiKH);
Command.Connection.Open();
Command.ExecuteNonQuery();
Command.Connection.Close();
}
public static void Sua(LoaiKH entity)
{
String sql = "UPDATE LoaiKhachHang SET TenLoaiKH = @TenLoaiKH WHERE MaLoaiKH = @MaLoaiKH";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", entity.MaLoaiKH);
Command.Parameters.AddWithValue("@TenLoaiKH", entity.TenLoaiKH);
Command.Connection.Open();
Command.ExecuteNonQuery();
Command.Connection.Close();
}
public static void Sua(LoaiKH entity)
{
String sql = "UPDATE LoaiKhachHang SET TenLoaiKH = @TenLoaiKH WHERE MaLoaiKH = @MaLoaiKH";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", entity.MaLoaiKH);
Command.Parameters.AddWithValue("@TenLoaiKH", entity.TenLoaiKH);
Command.Connection.Open();
Command.ExecuteNonQuery();
Command.Connection.Close();
}
public static void Them(LoaiKH entity)
{
String sql = "INSERT INTO LoaiKhachHang(MaLoaiKH, TenLoaiKH, MucGiam) VALUES(@MaLoaiKH, @TenLoaiKH, @MucGiam)";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", entity.MaLoaiKH);
Command.Parameters.AddWithValue("@TenLoaiKH", entity.TenLoaiKH);
Command.Connection.Open();
Command.ExecuteNonQuery();
Command.Connection.Close();
}
public static List <LoaiKH> TimTheoSql(String sql)
{
SqlCommand command = new SqlCommand(sql, DB.Connection);
command.Connection.Open();
SqlDataReader Reader = command.ExecuteReader();
var DSLoaiKH = new List <LoaiKH>();
while (Reader.Read())
{
var LoaiKH = new LoaiKH
{
MaLoaiKH = Convert.ToString(Reader["MaLoaiKH"]),
TenLoaiKH = Convert.ToString(Reader["TenLoaiKH"])
};
DSLoaiKH.Add(LoaiKH);
}
command.Connection.Close();
return(DSLoaiKH);
}
public static List<LoaiKH> TimTheoSql(String sql)
{
SqlCommand command = new SqlCommand(sql, DB.Connection);
command.Connection.Open();
SqlDataReader Reader = command.ExecuteReader();
var DSLoaiKH = new List<LoaiKH>();
while (Reader.Read())
{
var LoaiKH = new LoaiKH
{
MaLoaiKH = Convert.ToString(Reader["MaLoaiKH"]),
TenLoaiKH = Convert.ToString(Reader["TenLoaiKH"])
};
DSLoaiKH.Add(LoaiKH);
}
command.Connection.Close();
return DSLoaiKH;
}
public static LoaiKH Tim(String MaLoaiKH)
{
String sql = "SELECT * FROM LoaiKhachHang WHERE MaLoaiKH = @MaLoaiKH";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", MaLoaiKH);
Command.Connection.Open();
SqlDataReader Reader = Command.ExecuteReader();
if (Reader.Read())
{
var LoaiKH = new LoaiKH
{
MaLoaiKH = Convert.ToString(Reader["MaLoaiKH"]),
TenLoaiKH = Convert.ToString(Reader["TenLoaiKH"]),
};
return(LoaiKH);
}
Command.Connection.Close();
return(null);
}
public static LoaiKH Tim(String MaLoaiKH)
{
String sql = "SELECT * FROM LoaiKhachHang WHERE MaLoaiKH = @MaLoaiKH";
SqlCommand Command = new SqlCommand(sql, DB.Connection);
Command.Parameters.AddWithValue("@MaLoaiKH", MaLoaiKH);
Command.Connection.Open();
SqlDataReader Reader = Command.ExecuteReader();
if (Reader.Read())
{
var LoaiKH = new LoaiKH
{
MaLoaiKH = Convert.ToString(Reader["MaLoaiKH"]),
TenLoaiKH = Convert.ToString(Reader["TenLoaiKH"]),
};
return LoaiKH;
}
Command.Connection.Close();
return null;
}
private void FormLapHoaDon_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'sanPham_FormLapHoaDon.SanPham' table. You can move, or remove it, as needed.
this.sanPhamTableAdapter.Fill(this.sanPham_FormLapHoaDon.SanPham);
// TODO: This line of code loads data into the 'mauSac_FormLapHoaDon.MauSac' table. You can move, or remove it, as needed.
this.mauSacTableAdapter.Fill(this.mauSac_FormLapHoaDon.MauSac);
// TODO: This line of code loads data into the 'size_FormLapHoaDon.Size' table. You can move, or remove it, as needed.
this.sizeTableAdapter.Fill(this.size_FormLapHoaDon.Size);
// TODO: This line of code loads data into the 'sanPham_FormLapHoaDon.SanPham' table. You can move, or remove it, as needed.
this.sanPhamTableAdapter.Fill(this.sanPham_FormLapHoaDon.SanPham);
if (FormKiemTraKhachHang.TTKHC.Ma == 0)
{
MaKH = FormKhachHangMoi.TTKHM.Ma;
}
else if (FormKhachHangMoi.TTKHM.Ma == 0)
{
MaKH = FormKiemTraKhachHang.TTKHC.Ma;
}
var r = from s in dt.HDXuats select s.Ma;
if (r.Count() == 0)
{
lbMaHD.Text = "1";
}
else if (r.Count() != 0)
{
lbMaHD.Text = Convert.ToString(Convert.ToInt32(r.Max().ToString()) + 1);
}
KhachHang KH = dt.KhachHangs.Where(s => s.Ma == MaKH).FirstOrDefault();
lbTenKH.Text = KH.Ten;
lbSoDienThoai.Text = KH.SoDienThoai;
LoaiKH Loai = dt.LoaiKHs.Where(s => s.Ma == KH.Ma_LoaiKH).FirstOrDefault();
lbThanhVien.Text = Loai.Ten;
cbbSP.DisplayMember = "Ten";
cbbSP.ValueMember = "Ma";
cbbSP.DataSource = dt.SanPhams;
SanPham sp = dt.SanPhams.Where(s => s.Ma == Convert.ToInt32(cbbSP.SelectedValue)).FirstOrDefault();
cbbSize.DisplayMember = "TenSize";
cbbSize.ValueMember = "Ma";
cbbSize.DataSource = dt.cbbSize(sp.Ma_LoaiSP);
cbbMau.DisplayMember = "TenMau";
cbbMau.ValueMember = "Ma";
cbbMau.DataSource = dt.MauSacs;
cbbSP.Enabled = false;
cbbSize.Enabled = false;
cbbMau.Enabled = false;
btnThem.Enabled = true;
btnLuu.Enabled = false;
btnHuy.Enabled = true;
txtSoLuong.ResetText();
lbThanhTien.Text = "0";
txtSoLuong.Enabled = false;
lbTren.Visible = false;
lbSoLuongTon.Visible = false;
lbDonGia.Visible = false;
lbThanhTien.Visible = false;
lbThanhTien.Visible = false;
TTMHDX.Ma = Convert.ToInt32(lbMaHD.Text);
dgvSanPham.AutoGenerateColumns = false;
dgvSanPham.DataSource = dt.SanPhams;
}
