private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
btnPrintBill.Visible = true;
btnMail.Visible = true;
//int i = dataGridView1.CurrentRow.Index;
hoadDonXuat hdx = db.hoadDonXuats.Where(s => s.maHDX == dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()).FirstOrDefault();
//tranferId.id = hdx.maHDX;
//hd = hdx.maHDX;
khachHang kh = db.khachHangs.Where(s => s.maKH == hdx.maKH).FirstOrDefault();
txtCusName.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
txtCusPhone.Text = kh.sdt.ToString();
txtCusAddress.Text = kh.diaChi.ToString();
txtCusEmail.Text = kh.email.ToString();
txtBillid.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
txtBillDate.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
txtBillStatus.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
txtStaffName.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
txtBillPrice.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
}
}
//Sửa thông tin khách hàng
public void updateCustomer(eCustomer cus)
{
khachHang custemp = db.khachHangs.Where(x => x.maKH.Equals(cus.CustomerID)).FirstOrDefault();
// Cập nhật dữ liệu
custemp.maKH = cus.CustomerID;
custemp.tenKH = cus.CustomerName;
custemp.diaChi = cus.Address;
custemp.phone = cus.Phone;
db.SubmitChanges();
}
//Xóa khách hàng khỏi database
public bool deleteCustomer(string id)
{
khachHang cus = db.khachHangs.Where(x => x.maKH == id).FirstOrDefault();
if (cus != null)
{
db.khachHangs.DeleteOnSubmit(cus);
db.SubmitChanges(); //cập nhật việc xóa vào CSDL
return(true); //xóa thành công
}
return(false);
}
public void delete(khachHang k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_delete_khachHang", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maKH", k.MaKH));
cmd.ExecuteNonQuery();
closeC();
}
private void button2_Click(object sender, EventArgs e)
{
khachHang k = new khachHang();
k.MaKH = dg_khachhang.Rows[dg_khachhang.CurrentRow.Index].Cells[0].Value.ToString();
if (dg_donthuoc.RowCount == 0)
{
t.delete(k);
load();
}
else
{
MessageBox.Show("Không thể xóa");
}
}
public void insert(khachHang k)
{
openC();
SqlCommand cmd = new SqlCommand("sp_insert_khachHang", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maKH", k.MaKH));
cmd.Parameters.Add(new SqlParameter("@tenKH", k.TenKH));
cmd.Parameters.Add(new SqlParameter("@soDT", k.SoDT));
cmd.ExecuteNonQuery();
closeC();
}
private void SuaKhachHang()
{
if (tblDiachi.Text == "" || tblKhachhang.Text == "" || tblEmail.Text == "" || tblSdt.Text == "")
{
MessageBox.Show("Bạn phải chọn một dòng để sửa");
return;
}
khachHang kh = db.khachHangs.Single(item => item.ID == int.Parse(tblId.Text));
kh.TenKhachHang = tblKhachhang.Text;
kh.SoDienthoai = int.Parse(tblSdt.Text);
kh.DiaChi = tblDiachi.Text;
kh.Email = tblEmail.Text;
db.SubmitChanges();
MessageBox.Show("Sửa thành công");
}
private void ThemKhachHang()
{
if (tblKhachhang.Text == "" || tblDiachi.Text == "" || tblEmail.Text == "" || tblSdt.Text == "")
{
MessageBox.Show("Chưa nhập đủ thông tin");
return;
}
khachHang kh = new khachHang();
kh.TenKhachHang = tblKhachhang.Text;
kh.DiaChi = tblDiachi.Text;
kh.SoDienthoai = int.Parse(tblSdt.Text);
kh.NgaySinh = DateTime.Parse(pdNgay.Text);
kh.Email = tblEmail.Text;
db.khachHangs.InsertOnSubmit(kh);
db.SubmitChanges();
MessageBox.Show("Thêm thành công");
}
//Nhập khách hàng mới vào database
public int insertCustomer(eCustomer cus)
{
if (checkIDExist(cus.CustomerID))
{
return(0);
}
khachHang custemp = new khachHang();
custemp.maKH = cus.CustomerID;
custemp.tenKH = cus.CustomerName;
custemp.diaChi = cus.Address;
custemp.phone = cus.Phone;
db.khachHangs.InsertOnSubmit(custemp);
db.SubmitChanges();
return(1);
}
private void datagrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int rowindex = datagrid.SelectedIndex;
if (rowindex == -1)
{
return;
}
else
{
khachHang kh = (khachHang)datagrid.SelectedItem;
tblKhachhang.Text = kh.TenKhachHang;
tblDiachi.Text = kh.DiaChi;
tblSdt.Text = kh.SoDienthoai.ToString();
tblEmail.Text = kh.Email;
tblId.Text = kh.ID.ToString();
pdNgay.Text = kh.NgaySinh.ToString();
}
}
private void XoaKhachHang()
{
try
{
if (tblDiachi.Text == "" || tblKhachhang.Text == "" || tblEmail.Text == "" || tblSdt.Text == "")
{
MessageBox.Show("Bạn phải chọn một dòng để xóan");
return;
}
khachHang kh = db.khachHangs.Single(item => item.ID == int.Parse(tblId.Text));
db.khachHangs.DeleteOnSubmit(kh);
db.SubmitChanges();
MessageBox.Show("Xóa thanh công");
}
catch (Exception)
{
MessageBox.Show("Không được xóa");
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
switch (function)
{
case 1:
{
string gt = "";
if (rdbMale.Checked)
{
gt = "Nam";
}
else
{
gt = "Nữ";
}
if (txtAddress.Text == "" || txtEmail.Text == "" || txtName.Text == "" || txtPhone.Text == "")
{
MessageBox.Show("Please fill all information");
}
else
{
int ma = 1;
string id = "";
var kh = from u in db.khachHangs select u;
if (kh.Count() == 0)
{
id = "KH" + ma;
db.KH_Ins(id, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text);
}
else if (kh.Count() > 0)
{
kh.OrderByDescending(s => s.maKH).FirstOrDefault();
var kh2 = db.khachHangs.OrderByDescending(s => s.maKH).FirstOrDefault();
ma = Convert.ToInt32(kh2.maKH.ToString().Substring(2)) + 1;
id = "KH" + ma;
db.KH_Ins(id, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text);
}
Uc_Customer_Load(sender, e);
}
}
break;
case 2:
{
db.KH_Del(txtID.Text);
Uc_Customer_Load(sender, e);
}
break;
case 3:
{
string gt = "";
if (rdbMale.Checked)
{
gt = "Nam";
}
else
{
gt = "Nữ";
}
khachHang kh = db.khachHangs.Where(s => s.maKH.Equals(txtID.Text)).FirstOrDefault();
if (kh == null)
{
return;
}
else
{
db.KH_Up(txtID.Text, txtName.Text, gt, dtpBirthday.Value, txtEmail.Text, txtAddress.Text, txtPhone.Text);
Uc_Customer_Load(sender, e);
}
}
break;
case 4:
{
string gt = "";
if (rdbMale.Checked)
{
gt = "Nam";
}
else
{
gt = "Nữ";
}
if (chbName.Checked == true && chbSex.Checked == true && chbBirthday.Checked == true)
{
var kh = from u in db.khachHangs
where u.tenKH == txtName.Text &&
u.gioiTinh == gt && u.ngSinh == dtpBirthday.Value
select u;
dgvCustomers.DataSource = kh;
}
else if (chbName.Checked == true && chbSex.Checked == true)
{
var kh = from u in db.khachHangs
where u.tenKH == txtName.Text && u.gioiTinh == gt
select u;
dgvCustomers.DataSource = kh;
}
else if (chbName.Checked == true && chbBirthday.Checked == true)
{
var kh = from u in db.khachHangs
where u.tenKH == txtName.Text && u.ngSinh == dtpBirthday.Value
select u;
dgvCustomers.DataSource = kh;
}
else if (chbSex.Checked == true && chbBirthday.Checked == true)
{
var kh = from u in db.khachHangs
where u.gioiTinh == gt && u.ngSinh == dtpBirthday.Value
select u;
dgvCustomers.DataSource = kh;
}
else if (chbName.Checked == true)
{
var kh = from u in db.khachHangs
where u.tenKH == txtName.Text
select u;
dgvCustomers.DataSource = kh;
}
else if (chbSex.Checked == true)
{
var kh = from u in db.khachHangs
where u.gioiTinh == gt
select u;
dgvCustomers.DataSource = kh;
}
else if (chbBirthday.Checked == true)
{
var kh = from u in db.khachHangs
where u.ngSinh == dtpBirthday.Value
select u;
dgvCustomers.DataSource = kh;
}
else
{
var kh = from u in db.khachHangs
where u.maKH == txtID.Text
select u;
dgvCustomers.DataSource = kh;
}
}
break;
}
}
private void btn_ok_Click(object sender, EventArgs e)
{
switch (f.button)
{
case "insert":
if (txt_mkh.Text != "")
{
if (!check(txt_mkh.Text))
{
themdl();
f.load_donthuoc();
}
else
{
MessageBox.Show("Đã tồn tại mã khách hàng");
}
}
else
{
MessageBox.Show("Không để trống mã khách hàng");
}
break;
case "update":
suadl();
f.load_donthuoc();
break;
}
void themdl()
{
khachHang t = new khachHang();
t.MaKH = txt_mkh.Text.ToString();
t.TenKH = txt_tenkh.Text.ToString();
t.SoDT = txtsdt.Text.ToString();
khachhang.insert(t);
f.load();
this.Close();
}
void suadl()
{
khachHang t = new khachHang();
t.MaKH = txt_mkh.Text.ToString();
t.TenKH = txt_tenkh.Text.ToString();
t.SoDT = txtsdt.Text.ToString();
khachhang.update(t);
f.load();
this.Close();
}
bool check(string manv)
{
bool c = false;
// true = tồn tại
DataGridView d;
d = f.dg_khachhang;
// MessageBox.Show(f.dg_khachhang.Rows[0].Cells[0].Value.ToString());
for (int i = 0; i < d.RowCount; i++)
{
if (manv == f.dg_khachhang.Rows[i].Cells[0].Value.ToString().Trim())
{
c = true;
break;
}
}
return(c);
}
}
public void delete(khachHang k)
{
kh.delete(k);
}
public void update(khachHang k)
{
kh.update(k);
}
public void insert(khachHang k)
{
kh.insert(k);
}
