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