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); }