private void Button3_Click(object sender, EventArgs e)
{
if (cmbDsDichVu.SelectedIndex < 0)
{
return;
}
DTO.DTO_DichVu dv = GetCurDV();
List <String> d = new List <String>();
foreach (DataGridViewRow x in dtDV.Rows)
{
if (x.Cells[0].Value != null)
{
d.Add(x.Cells[0].Value.ToString().Trim());
}
}
if (d.Contains(dv.MA_DICH_VU.Trim()))
{
MessageBox.Show("Dịch vụ đã có trong bảng.");
return;
}
DTO.DTO_DatDichVu ddv = new DTO.DTO_DatDichVu();
ddv.MA_TIEC_CUOI = cmbMaTiecCuoi.Text;
ddv.MA_DICH_VU = dv.MA_DICH_VU;
ddv.SO_LUONG = numericUpDown1.Text;
bool state = BUS.BUS_DatTiecCuoi.themDatDichVu(ddv);
if (!state)
{
MessageBox.Show("Lỗi thêm dịch vụ.");
}
HienThiDsDichVu(cmbMaTiecCuoi.Text);
}
private void Button4_Click(object sender, EventArgs e)
{
String maDV = dtDV.Rows[dtDV.CurrentCell.RowIndex].Cells[0].Value.ToString().Trim();
DTO.DTO_DatDichVu ddv = new DTO.DTO_DatDichVu();
ddv.MA_TIEC_CUOI = cmbMaTiecCuoi.Text;
ddv.MA_DICH_VU = maDV;
BUS_DatTiecCuoi.xoaDatDichVu(ddv);
HienThiDsDichVu(cmbMaTiecCuoi.Text);
}
public static bool xoaDatDichVu(DTO.DTO_DatDichVu s)
{
String sql = String.Format(@"DELETE FROM DAT_DICH_VU WHERE MA_TIEC_CUOI = '{0}' AND MA_DICH_VU = '{1}'",
s.MA_TIEC_CUOI, s.MA_DICH_VU);
Console.WriteLine(sql);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}
public static bool themDatDichVu(DTO.DTO_DatDichVu s)
{
String sql = String.Format(@"INSERT INTO DAT_DICH_VU (MA_TIEC_CUOI, MA_DICH_VU, SO_LUONG) VALUES ('{0}','{1}',{2})",
s.MA_TIEC_CUOI, s.MA_DICH_VU, s.SO_LUONG);
Console.WriteLine(sql);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}