private void butThem_Click(object sender, EventArgs e)
{
try
{
CT_DICHVU cT_DICHVU = new CT_DICHVU
{
MaDichVu = txtMaDV.Text,
DonViSuDung = Convert.ToInt16(txtSoluong.Text)
};
string maphong = cbbPhongChuaTaoHD.SelectedItem.ToString();
if (txtSoluong.Text == "")
{
MessageBox.Show("Mời nhập số lượng!");
}
else
{
hdbll.Them_1DV(cT_DICHVU);
cbbPhongChuaTaoHD_SelectedIndexChanged(this, e);
dgvDV.DataSource = hdbll.listDv1HD();
cbbPhongChuaTaoHD.Enabled = false;
butLapHD.Enabled = true;
butThem.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Mời Kiểm Tra Lại!");
}
}
public void XoaHD(int mahd, string madv)
{
CT_DICHVU v = ql.CT_DICHVU.Where(x => x.MaHoaDon == mahd && x.MaDichVu == madv).SingleOrDefault();
ql.CT_DICHVU.Remove(v);
ql.SaveChanges();
}
public void SuaDV(string madv, int dvsd)
{
var ud = ql.HOA_DON.OrderByDescending(x => x.MaHoaDon).Take(1).Select(p => p.MaHoaDon).SingleOrDefault();
Object s = ud;
int mahd = (int)s + 1;
CT_DICHVU sua = ql.CT_DICHVU.Where(x => x.MaHoaDon == mahd && x.MaDichVu == madv).SingleOrDefault();
sua.DonViSuDung = dvsd;
ql.SaveChanges();
}
public void XoaDV(string madv)
{
var ud = ql.HOA_DON.OrderByDescending(x => x.MaHoaDon).Take(1).Select(p => p.MaHoaDon).SingleOrDefault();
Object s = ud;
int mahd = (int)s + 1;
CT_DICHVU v = ql.CT_DICHVU.Where(x => x.MaHoaDon == mahd && x.MaDichVu == madv).SingleOrDefault();
ql.CT_DICHVU.Remove(v);
ql.SaveChanges();
}
public void ThemDV(CT_DICHVU dv)
{
var ma = ql.HOA_DON.OrderByDescending(x => x.MaHoaDon).Take(1).Select(p => p.MaHoaDon).SingleOrDefault();
Object s = ma;
int mahd = (int)s;
dv.MaHoaDon = mahd + 1;
ma = (int)s + 1;
ql.CT_DICHVU.Add(dv);
ql.SaveChanges();
}
private void dgvDV_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
object i = dgvDV.SelectedRows[0].Cells[5].Value;
string madv = i.ToString();
CT_DICHVU dv = hdbll.cT(madv);
txtTenDV.Text = dv.DICH_VU.DichVu;
int gia = Convert.ToInt32(dv.DICH_VU.GiaDichVu);
txtDongia.Text = gia + "";
txtMaDV.Text = dv.MaDichVu;
lbDonVi.Text = dv.DICH_VU.QuyCach;
txtSoluong.Text = dv.DonViSuDung.ToString();
butSua.Enabled = true;
butXoaDV.Enabled = true;
butThem.Enabled = false;
}
public void Them_1DV(CT_DICHVU dv)
{
hddal.ThemDV(dv);
}
