public static bool InsertSanBay(SanBay sanBay) { string cmdText = string.Format("INSERT INTO SANBAY(TenSB) VALUES (N'{0}')", sanBay.TenSB); bool insert = DataProvider.ExecuteNonQuery(cmdText); return(insert); }
public static bool UpdateSanBay(SanBay sanBay) { string cmdText = string.Format("UPDATE SANBAY SET TenSB = N'{0}' WHERE MaSB = {1}", sanBay.TenSB, sanBay.maSB); bool update = DataProvider.ExecuteNonQuery(cmdText); return(update); }
public async Task <IActionResult> Edit(string SanBayId, [Bind("SanBayId,TenSanBay")] SanBay sanBay) { if (SanBayId != sanBay.SanBayId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(sanBay); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SanBayExists(sanBay.SanBayId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(sanBay)); }
public async Task <IActionResult> Edit(int id, [Bind("id_SanBay,TenSanBay,MaSanBay,id_DiaDiem,LePhi")] SanBay sanBay) { if (id != sanBay.id_SanBay) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(sanBay); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SanBayExists(sanBay.id_SanBay)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["id_DiaDiem"] = new SelectList(_context.DiaDiem, "id_DiaDiem", "id_DiaDiem", sanBay.id_DiaDiem); return(View(sanBay)); }
private void btnLuupanel_Click(object sender, EventArgs e) { int n = listViewSB.Items.Count; if (n == 0) { lbTBThemSB.Visible = true; lbTBThemSB.ForeColor = Color.Red; lbTBThemSB.Text = "Vui lòng thêm ít nhất một sân bay"; return; } SanBay[] sanbay = new SanBay[n]; for (int i = 0; i < n; i++) { sanbay[i] = new SanBay { MaSanBay = listViewSB.Items[i].SubItems[0].Text, TenSanBay = listViewSB.Items[i].SubItems[1].Text }; } if (bllSB.InsertSanBay(sanbay, n)) { lbTBThemSB.Visible = true; lbTBThemSB.ForeColor = Color.Green; lbTBThemSB.Text = "Thêm thông tin sân bay thành công"; SetEmptyTextBoxSB(); listViewSB.Items.Clear(); GetDataSanBay(); } }
public static bool DeleteSanBay(SanBay sanBay) { string cmdText = string.Format("DELETE FROM SANBAY WHERE MaSB = {0})", sanBay.maSB); bool delete = DataProvider.ExecuteNonQuery(cmdText); return(delete); }
public void CapNhapSanBay(SanBay tuyenbay) { string query = ""; Dictionary <string, object> parameters = new Dictionary <string, object>(); ExecuteNonQuery(query, parameters); }
public void ThemSanBay(SanBay sanbay) { string query = "INSERT INTO SANBAY VALUES (N'@MaSanBay',N'@TenSanBay')"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters["@MaSanBay"] = sanbay.MaSanBay; parameters["@TenSanBay"] = sanbay.TenSanBay; ExecuteNonQuery(query, parameters); }
private SanBay SetInfoSanBayFromGridView() { SanBay sb = new SanBay { MaSanBay = dgvSanBay.Rows[IndexSB].Cells["dgvcolMaSanBay"].Value.ToString(), TenSanBay = dgvSanBay.Rows[IndexSB].Cells["dgvcolTenSanBay"].Value.ToString() }; return(sb); }
public ActionResult Create(SanBay collection) { if (ModelState.IsValid) { _dbContext.SanBay.Add(collection); _dbContext.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View()); }
public async Task <IActionResult> Create([Bind("SanBayId,TenSanBay")] SanBay sanBay) { if (ModelState.IsValid) { _context.Add(sanBay); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(sanBay)); }
public async Task <IActionResult> Create([Bind("id_SanBay,TenSanBay,MaSanBay,id_DiaDiem,LePhi")] SanBay sanBay) { if (ModelState.IsValid) { _context.Add(sanBay); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["id_DiaDiem"] = new SelectList(_context.DiaDiem, "id_DiaDiem", "id_DiaDiem", sanBay.id_DiaDiem); return(View(sanBay)); }
public static SanBay GetSanBay(int MaSB) { string cmdText = String.Format("select * from SANBAY Where MaSB={0}", MaSB); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { SanBay sb = new SanBay((int)dt.Rows[0]["MaSB"], dt.Rows[0]["TenSB"].ToString()); return(sb); } return(null); }
private void btnTimKiem_Click(object sender, EventArgs e) { BUL_SanBay bUL_SanBay = new BUL_SanBay(); if (txtTraCuu.Text != "") { SanBay sb = new SanBay(txtTraCuu.Text); dGVtraCuuSanBay.DataSource = bUL_SanBay.getTimKiemSanBay(sb); } else { xemdulieu(); } }
public ActionResult Edit(SanBay model) { try { var oldItem = _dbContext.SanBay.Find(model.ID); oldItem.ID = model.ID; oldItem.Code = model.Code; oldItem.Name = model.Name; _dbContext.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public static List <SanBay> GetSanBaysExcept(TuyenBay tb) { string cmdText = String.Format("select * from SANBAY where MaSB not in ({0},{1})", tb.SBDi.maSB, tb.SBDen.maSB); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <SanBay> sanBays = new List <SanBay>(); for (int i = 0; i < dt.Rows.Count; i++) { SanBay sb = new SanBay((int)dt.Rows[i]["MaSB"], dt.Rows[i]["TenSB"].ToString()); sanBays.Add(sb); } return(sanBays); } return(null); }
public static List <SanBay> GetSanBays() { string cmdText = @"select * from SANBAY"; DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <SanBay> sanBays = new List <SanBay>(); for (int i = 0; i < dt.Rows.Count; i++) { SanBay sb = new SanBay((int)dt.Rows[i]["MaSB"], dt.Rows[i]["TenSB"].ToString()); sanBays.Add(sb); } return(sanBays); } return(null); }
public static List <SanBay> SearchTenSB(string tenSB) { string cmdText = String.Format("select * from SANBAY where TenSB like N'%{0}%'", tenSB); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <SanBay> sanBays = new List <SanBay>(); for (int i = 0; i < dt.Rows.Count; i++) { SanBay sb = new SanBay((int)dt.Rows[i]["MaSB"], dt.Rows[i]["TenSB"].ToString()); sanBays.Add(sb); } return(sanBays); } return(null); }
public static List <SanBay> GetSanBaysTo(int maSBDen) { string cmdText = String.Format("select * from SANBAY inner join TUYENBAY on MaSB = MaSBDi where maSBDen = {0}", maSBDen); DataTable dt = DataProvider.ExecuteReader(cmdText); if (dt != null && dt.Rows.Count > 0) { List <SanBay> sanBays = new List <SanBay>(); for (int i = 0; i < dt.Rows.Count; i++) { SanBay sb = new SanBay((int)dt.Rows[i]["MaSB"], dt.Rows[i]["TenSB"].ToString()); sanBays.Add(sb); } return(sanBays); } return(null); }
public SanBay GetInfo1SanBay(string MaSB) { string sql = "select * from SANBAY where MaSanBay ='" + MaSB + "'"; DataTable dt = GetData(sql); if (dt == null) { return(null); } SanBay sb = new SanBay { MaSanBay = MaSB, TenSanBay = dt.Rows[0][1].ToString() }; return(sb); }
private void btnXacNhan_Click(object sender, EventArgs e) { BUL_SanBay bUL_SanBay = new BUL_SanBay(); if (txtMaSB.Text != "" && txtTenSB.Text != "") { SanBay sb = new SanBay(txtMaSB.Text, txtTenSB.Text); if (bUL_SanBay.themSanBay(sb)) { MessageBox.Show("Thêm thành công"); dGVthemSanBay.DataSource = bUL_SanBay.getSanBay(); // refresh datagridview } else { MessageBox.Show("Đã có lỗi xảy ra", "Lỗi"); } } else { MessageBox.Show("Xin hãy nhập đầy đủ"); } }
private void btnSua_Click(object sender, EventArgs e) { BUL_SanBay bUL_SanBay = new BUL_SanBay(); if (txtMaSB.Text != "") { SanBay sb = new SanBay(txtMaSB.Text, txtTenSB.Text); if (bUL_SanBay.suaSanBay(sb)) { MessageBox.Show("Sửa thành công"); xemdulieu(); addbinding(); } else { MessageBox.Show("Đã có lỗi xảy ra", "Lỗi"); } } else { MessageBox.Show("Kiểm tra lại"); } }
public static bool InsertSanBay(SanBay sanBay) { return(DAL_SanBay.InsertSanBay(sanBay)); }
public void ShowData1SanBay() { SanBay sb = bllSB.GetInfo1SanBay(MaSanBay); dgvSanBay.Rows[IndexSB].Cells["dgvcolTenSanBay"].Value = sb.TenSanBay; }
public void ThemSanBay(SanBay sanbay) { quanly.ThemSanBay(sanbay); }
public void CapNhapSanBay(SanBay sanbay) { quanly.CapNhapSanBay(sanbay); }
public static bool UpdateSanBay(SanBay sb) { return(DAL_SanBay.UpdateSanBay(sb)); }
public bool themSanBay(SanBay sB) { Ultilies ultilies = new Ultilies(); return(ultilies.themSanBay(sB)); }
public bool xoaSanBay(SanBay sB) { Ultilies ultilies = new Ultilies(); return(ultilies.xoaSanBay(sB)); }
public DataTable getTimKiemSanBay(SanBay sB) { Ultilies ultilies = new Ultilies(); return(ultilies.GetDataTimKiemSB(sB)); }