public FormPhieuDichVu_AddUpd(PhieuDichVu_DTO phieudv)
{
InitializeComponent();
comboBox_MaKhachHang.DataSource = phiedichvu_bus.LayDSMaKhachHang();
comboBox_MaKhachHang.ValueMember = "MaKH";
comboBox_MaKhachHang.DisplayMember = "TenKH";
//this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
//
txtSoPhieudv.Text = phieudv.SoPhieuDV.ToString();
comboBox_MaKhachHang.SelectedValue = phieudv.MaKH;
dtPicker_NgayDangKy.Value = DateTime.Parse(phieudv.NgayDangKy);
dtPicker_NgayGiao.Value = DateTime.Parse(phieudv.NgayGiao);
txtDiaChi.Text = phieudv.DiaChi;
txtTongTien.Text = phieudv.TongTien.ToString();
comboBox_TinhTrang.SelectedValue = phieudv.TinhTrang.ToString();
btnThem.Enabled = false;
//
comboBox_TinhTrang.DisplayMember = "Text";
comboBox_TinhTrang.ValueMember = "Value";
var items = new[] {
new { Text = "Chưa duyệt", Value = 0 },
new { Text = "Đã duyệt", Value = 1 }
};
comboBox_TinhTrang.DataSource = items;
}
public void PhieuDichVu_Upd(PhieuDichVu_DTO pbh)
{
var obj = vbdq.PHIEUDICHVUs.Single(x => x.SoPhieuDV == pbh.SoPhieuDV);
obj.MaKH = pbh.MaKH;
obj.NgayDangKy = DateTime.Parse(pbh.NgayDangKy.ToString());
obj.NgayGiao = DateTime.Parse(pbh.NgayGiao.ToString());
obj.DiaChi = pbh.DiaChi;
obj.TongTien = Decimal.Parse(pbh.TongTien.ToString());
obj.TinhTrang = Int32.Parse(pbh.TinhTrang.ToString());
vbdq.SubmitChanges();
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
PhieuDichVu_DTO phieudv = new PhieuDichVu_DTO();
phieudv.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
phieudv.MaKH = Int16.Parse(comboBox_MaKhachHang.SelectedValue.ToString());
phieudv.NgayDangKy = dtPicker_NgayDangKy.Value.ToShortDateString();
phieudv.NgayGiao = dtPicker_NgayGiao.Value.ToShortDateString();
phieudv.DiaChi = txtDiaChi.Text;
phieudv.TongTien = Decimal.Parse(txtTongTien.Text);
phieudv.TinhTrang = Int32.Parse(comboBox_TinhTrang.SelectedValue.ToString());
phiedichvu_bus.PhieuDichVu_Upd(phieudv);
this.Close();
}
public void PhieuDichVu_Add(PhieuDichVu_DTO pbh)
{
PHIEUDICHVU obj = new PHIEUDICHVU();
obj.SoPhieuDV = pbh.SoPhieuDV;
obj.MaKH = pbh.MaKH;
obj.NgayDangKy = DateTime.Parse(pbh.NgayDangKy.ToString());
obj.NgayGiao = DateTime.Parse(pbh.NgayGiao.ToString());
obj.DiaChi = pbh.DiaChi;
obj.TongTien = Decimal.Parse(pbh.TongTien.ToString());
obj.TinhTrang = Int16.Parse(pbh.TinhTrang.ToString());
vbdq.PHIEUDICHVUs.InsertOnSubmit(obj);
vbdq.SubmitChanges();
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
try
{
PhieuDichVu_DTO phieudv = new PhieuDichVu_DTO();
if (txtSoPhieudv.Text.CompareTo("") != 0)
{
phieudv.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
}
else
{
phieudv.SoPhieuDV = 0;
}
if (txtMaKhachHang.Text.CompareTo("") != 0)
{
phieudv.MaKH = Int16.Parse(txtMaKhachHang.Text);
}
else
{
phieudv.MaKH = 0;
}
phieudv.TenKH = txtTenKH.Text;
//phieudv.MaKH = txtTenTho.Text; //ngay dk
//ngay giao
phieudv.DiaChi = txtDiaChi.Text;
if (txtTongTien.Text.CompareTo("") != 0)
{
phieudv.TongTien = Decimal.Parse(txtTongTien.Text);
}
else
{
phieudv.TongTien = 0;
}
//tinh trang
dataGridView.DataSource = phieudichvu_bus.Search(phieudv);
}
catch (FormatException ex) { }
catch (Exception ex2) { }
}
public List <PhieuDichVu_DTO> Search(PhieuDichVu_DTO phieu)
{
var list = (from phieudv in vbdq.PHIEUDICHVUs join p in vbdq.KHACHHANGs on phieudv.MaKH equals p.MaKH
where (phieudv.SoPhieuDV == phieu.SoPhieuDV || phieu.SoPhieuDV == 0) &&
(phieudv.MaKH == phieu.MaKH || phieu.MaKH == 0) &&
(p.TenKh.Contains(phieu.TenKH)) &&
(phieudv.DiaChi.Contains(phieu.DiaChi)) &&
(phieudv.TongTien == phieu.TongTien || phieu.TongTien == 0)
select new PhieuDichVu_DTO
{
SoPhieuDV = phieudv.SoPhieuDV,
MaKH = phieudv.MaKH,
TenKH = p.TenKh,
NgayDangKy = phieudv.NgayDangKy.ToString(),
NgayGiao = phieudv.NgayGiao.ToString(),
DiaChi = phieudv.DiaChi,
TongTien = Decimal.Parse(phieudv.TongTien.ToString()),
TinhTrang = Int32.Parse(phieudv.TinhTrang.ToString())
});
return(list.ToList());
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtSoPhieudv.Text.CompareTo("") == 0)
{
MessageBox.Show("Vui lòng chọn dòng dữ liệu muốn Sửa !");
}
else
{
PhieuDichVu_DTO phieudv = new PhieuDichVu_DTO();
phieudv.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
phieudv.MaKH = Int16.Parse(txtMaKhachHang.Text);
phieudv.NgayDangKy = txtNgayDangKy.Text;
phieudv.NgayGiao = txtNgayGiao.Text;
phieudv.DiaChi = txtDiaChi.Text;
phieudv.TongTien = Decimal.Parse(txtTongTien.Text);
phieudv.TinhTrang = Int32.Parse(txtTinhTrang.Text);
FormPhieuDichVu_AddUpd form = new FormPhieuDichVu_AddUpd(phieudv);
DialogResult dr = form.ShowDialog();
dataGridView.DataSource = phieudichvu_bus.LayTatCa();
}
}
