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