private void Button1_Click(object sender, EventArgs e)
{
List <(String, String)> ds = new List <(String, String)>();
foreach (DataGridViewRow x in dtMA.Rows)
{
if (x.Cells["id"].Value != null)
{
ds.Add((x.Cells["id"].Value.ToString(), x.Cells["note"].Value.ToString()));
}
}
foreach ((string x, string y) in ds)
{
DTO.DTO_DatMonAn dma = new DTO.DTO_DatMonAn();
dma.MA_TIEC_CUOI = cmbMaTiecCuoi.Text;
dma.MA_MON_AN = x;
dma.GHI_CHU = y;
bool state = BUS.BUS_DatTiecCuoi.themDatMonAn(dma);
if (!state)
{
MessageBox.Show("Lỗi thêm món:" + x);
}
}
}
private void BttThemMA_Click(object sender, EventArgs e)
{
if (cmbDsMonAn.SelectedIndex < 0)
{
return;
}
DTO.DTO_MonAn ma = GetCurMA();
List <String> d = new List <String>();
foreach (DataGridViewRow x in dtMA.Rows)
{
if (x.Cells[0].Value != null)
{
d.Add(x.Cells[0].Value.ToString().Trim());
}
}
if (d.Contains(ma.MA_MON_AN.Trim()))
{
MessageBox.Show("Món ăn đã có trong bảng.");
return;
}
DTO.DTO_DatMonAn dma = new DTO.DTO_DatMonAn();
dma.MA_TIEC_CUOI = cmbMaTiecCuoi.Text;
dma.MA_MON_AN = ma.MA_MON_AN;
dma.GHI_CHU = tbGhiChuMA.Text;
bool state = BUS.BUS_DatTiecCuoi.themDatMonAn(dma);
if (!state)
{
MessageBox.Show("Lỗi thêm món ăn.");
}
HienThiDsMonAn(cmbMaTiecCuoi.Text);
}
private void Button2_Click(object sender, EventArgs e)
{
DTO.DTO_MonAn ma = GetCurMATB();
DTO.DTO_DatMonAn dma = new DTO.DTO_DatMonAn();
dma.MA_TIEC_CUOI = cmbMaTiecCuoi.Text;
dma.MA_MON_AN = ma.MA_MON_AN;
BUS_DatTiecCuoi.xoaDatMonAn(dma);
HienThiDsMonAn(cmbMaTiecCuoi.Text);
}
public static bool xoaDatMonAn(DTO.DTO_DatMonAn s)
{
String sql = String.Format(@"DELETE FROM DAT_MON_AN WHERE MA_TIEC_CUOI = '{0}' AND MA_MON_AN = '{1}'",
s.MA_TIEC_CUOI, s.MA_MON_AN);
Console.WriteLine(sql);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}
public static bool themDatMonAn(DTO.DTO_DatMonAn s)
{
String sql = String.Format(@"INSERT INTO DAT_MON_AN (MA_TIEC_CUOI, MA_MON_AN, GHI_CHU) VALUES ('{0}','{1}','{2}')",
s.MA_TIEC_CUOI, s.MA_MON_AN, s.GHI_CHU);
Console.WriteLine(sql);
if (DatabaseHelper.ExcuteSql(sql) > 0)
{
return(true);
}
return(false);
}
