//load du lieu combobox
public void loaddulieucb(FORM_KHACHHANG f)
{
var sql = data.database().CHUCVUs.ToList();
f.cbb_chucvu.DataSource = sql;
f.cbb_chucvu.DisplayMember = "TENCHUCVU";
f.cbb_chucvu.ValueMember = "TENCHUCVU";
}
public void reset(FORM_KHACHHANG f)
{
f.txt_makh.Text = "";
f.txt_hotenkh.Text = "";
f.txt_emailkh.Text = "";
f.txt_sodthKH.Text = "";
f.cbb_chucvu.Text = "";
}
//tim kiem kh
public void timkiemkh(FORM_KHACHHANG f)
{
if (f.searchkh.Text != "")
{
var sql = data.database().PROC_KHACHHANG().Where(a => a.MAKH == f.searchkh.Text || a.HOTEN_KH == f.searchkh.Text);
if (sql != null)
{
f.gctr_khachhang.DataSource = sql;
}
else
{
XtraMessageBox.Show("Tên khách hàng hoặc mã khách hàng không tồn tại!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Hãy nhập Tên hoặc Mã Khách Hàng Cần tìm", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//edit khách hàng
public void editkhachhang(FORM_KHACHHANG f)
{
if (checker.ktredit(f.txt_makh.Text, f.txt_hotenkh.Text, f.txt_emailkh.Text, f.txt_sodthKH.Text, f.cbb_chucvu.Text) == true)
{
var sql = data.database().CHUCVUs.SingleOrDefault(a => a.TENCHUCVU == f.cbb_chucvu.Text);
var sql_kh = data.database().KHACHHANGs.SingleOrDefault(a => a.MAKH == f.txt_makh.Text);
sql_kh.HOTEN_KH = f.txt_hotenkh.Text;
sql_kh.EMAIL_KH = f.txt_emailkh.Text;
sql_kh.SODTH_KH = f.txt_sodthKH.Text;
sql_kh.MACHUCVU = sql.MACHUCVU;
data.database().SubmitChanges();
DialogResult thongbao = MessageBox.Show("Đã sữa thông tin khách hàng thành công", "Thông báo", MessageBoxButtons.OK);
if (thongbao == DialogResult.OK)
{
loaddulieu(f);
reset(f);
}
}
}
//add khach hàng
public void addkhachhang(FORM_KHACHHANG f)
{
KHACHHANG KH = new KHACHHANG();
if (checker.checker_add_khachang(f.txt_hotenkh.Text, f.txt_emailkh.Text, f.txt_sodthKH.Text, f.cbb_chucvu.Text) == true)
{
var sql = data.database().CHUCVUs.SingleOrDefault(a => a.TENCHUCVU == f.cbb_chucvu.Text);
KH.MAKH = f.txt_makh.Text;
KH.HOTEN_KH = f.txt_hotenkh.Text;
KH.EMAIL_KH = f.txt_emailkh.Text;
KH.SODTH_KH = f.txt_sodthKH.Text;
KH.MACHUCVU = sql.MACHUCVU;
data.database().KHACHHANGs.InsertOnSubmit(KH);
data.database().SubmitChanges();
DialogResult thongbao = MessageBox.Show("Thêm khách hàng thành công!", "Thông báo", MessageBoxButtons.OK);
if (thongbao == DialogResult.OK)
{
loaddulieu(f);
}
}
}
//xoa khach hang
public void xoakhachhang(FORM_KHACHHANG f)
{
if (checker.ktrxoa(f.txt_makh.Text) == true)
{
var sql = data.database().KHACHHANGs.ToList();
foreach (var i in sql)
{
if (i.MAKH == f.txt_makh.Text)
{
data.database().KHACHHANGs.DeleteOnSubmit(i);
data.database().SubmitChanges();
break;
}
}
DialogResult thongbao = MessageBox.Show("Đã xóa thành công", "Thông báo", MessageBoxButtons.OK);
if (thongbao == DialogResult.OK)
{
loaddulieu(f);
reset(f);
}
}
}
private void barLargeButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
{
FORM_KHACHHANG f = new FORM_KHACHHANG();
f.Show();
}
//tạo mới mã khách hàng
public void taomakh(FORM_KHACHHANG f)
{
var sql = data.database().KHACHHANGs.ToList();
f.txt_makh.Text = "KH" + (sql.LongCount() + 1).ToString();
}
//load du lieu vao gridview
public void loaddulieu(FORM_KHACHHANG f)
{
var sql = data.database().PROC_KHACHHANG();
f.gctr_khachhang.DataSource = sql;
}
//xuat file
public void xuatfile(FORM_KHACHHANG f)
{
using (SaveFileDialog saveDialog = new SaveFileDialog())
{
saveDialog.Filter = "Excel (2003)(.xls)|*.xls|Excel (2010) (.xlsx)|*.xlsx |RichText File (.rtf)|*.rtf |Pdf File (.pdf)|*.pdf |Html File (.html)|*.html";
if (saveDialog.ShowDialog() != DialogResult.Cancel)
{
string exportFilePath = saveDialog.FileName;
string fileExtenstion = new FileInfo(exportFilePath).Extension;
switch (fileExtenstion)
{
case ".xls":
f.gv_khachhang.ExportToXls(exportFilePath);
break;
case ".xlsx":
f.gv_khachhang.ExportToXlsx(exportFilePath);
break;
case ".rtf":
f.gv_khachhang.ExportToRtf(exportFilePath);
break;
case ".pdf":
f.gv_khachhang.ExportToPdf(exportFilePath);
break;
case ".html":
f.gv_khachhang.ExportToHtml(exportFilePath);
break;
case ".mht":
f.gv_khachhang.ExportToMht(exportFilePath);
break;
default:
break;
}
if (File.Exists(exportFilePath))
{
try
{
//Try to open the file and let windows decide how to open it.
System.Diagnostics.Process.Start(exportFilePath);
}
catch
{
String msg = "The file could not be opened." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;
MessageBox.Show(msg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
String msg = "The file could not be saved." + Environment.NewLine + Environment.NewLine + "Path: " + exportFilePath;
MessageBox.Show(msg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
