private void Nap_Danh_Sach_Kho_Hang()
{
var db = new Data_QLKDataContext(SqlHelper.ConnectionString);
var khoHangs = (from kh in db.KHO_HANGs
select kh).ToList();
var tatCa = new KHO_HANG();
tatCa.Ma_Kho = "all";
tatCa.Ten_Kho = "Tất cả";
//khoHangs.Add(tatCa);
khoHangs.Insert(0, tatCa);
txtKhoHang.Properties.DataSource = khoHangs;
if(khoHangs.Count() > 0)
{
txtKhoHang.EditValue = "all";
}
txtKhoHang_View.BestFitColumns();
}
partial void DeleteKHO_HANG(KHO_HANG instance);
partial void InsertKHO_HANG(KHO_HANG instance);
partial void UpdateKHO_HANG(KHO_HANG instance);
private void btnLuu_Click(object sender, EventArgs e)
{
if (!Check())
{
return;
}
try
{
if (tinh_trang == "them")
{
KHO_HANG kho = new KHO_HANG
{
Ma_Kho = txtMaKho.Text,
Ten_Kho = txtTenKho.Text,
Dia_Chi = txtDiaChi.Text,
Email = txtEmail.Text,
Dien_Thoai = txtDienThoai.Text,
Fax = txtFax.Text,
Di_Dong = txtDiDong.Text,
Thu_Kho = txtThuKho.Text,
Ghi_Chu = txtGhiChu.Text
};
db.KHO_HANGs.InsertOnSubmit(kho);
}
else
{
var kho = (from k in db.KHO_HANGs
where k.Ma_Kho == txtMaKho.Text
select k).FirstOrDefault();
kho.Ma_Kho = txtMaKho.Text;
kho.Ten_Kho = txtTenKho.Text;
kho.Dia_Chi = txtDiaChi.Text;
kho.Email = txtEmail.Text;
kho.Dien_Thoai = txtDienThoai.Text;
kho.Fax = txtFax.Text;
kho.Di_Dong = txtDiDong.Text;
kho.Thu_Kho = txtThuKho.Text;
kho.Ghi_Chu = txtGhiChu.Text;
}
db.SubmitChanges();
RaiseReloadEventHander();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
