public List <ChiTietChuyenDi> getAll(string maChuyenDi)
{
String sql = "select * from ChiTietChuyenDi where maChuyenDi = @maChuyenDi";
SqlParameter p1 = new SqlParameter("@maChuyenDi", maChuyenDi);
SqlParameter[] param = { p1 };
DataTable table = manager.executeQuery(sql, param);
List <ChiTietChuyenDi> list = new List <ChiTietChuyenDi>();
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
string benXeTrungGian = (string)row["benXeTrungGian"];
int thoiGianDung = (int)row["thoiGianDung"];
string ghiChu = (string)row["ghiChu"];
ChiTietChuyenDi c = new ChiTietChuyenDi(maChuyenDi, benXeTrungGian, thoiGianDung, ghiChu);
list.Add(c);
}
return(list);
}
private void addChiTietChuyenDi(ChiTietChuyenDi m)
{
try
{
bool kq = chiTietChuyenDiDB.add(m);
if (kq)
{
loadData();
ClearInput();
}
else
{
MessageBox.Show("Them ko thanh cong");
}
}
catch (Exception e)
{
if (e.Message.Contains("UNIQUE"))
{
MessageBox.Show("Email trung lap");
}
else
{
MessageBox.Show("Khong the thuc hien duoc: " + e.Message);
}
}
}
private void Display(ChiTietChuyenDi c)
{
cbbMaChuyenDi.Text = c.MaChuyenDi;
cbbBenXeTrungGian.Text = c.BenXeTrungGian;
txtThoiGianDung.Text = c.ThoiGianDung.ToString();
txtGhiChu.Text = c.GhiChu;
setEditMode(true);
}
public bool update(ChiTietChuyenDi c)
{
String sql = "update ChiTietChuyenDi set thoiGianDung = @thoiGianDung, ghiChu = @ghiChu where maChuyenDi = @maChuyenDi and benXeTrungGian = @benXeTrungGian";
SqlParameter p1 = new SqlParameter("@maChuyenDi", c.MaChuyenDi);
SqlParameter p2 = new SqlParameter("@benXeTrungGian", c.BenXeTrungGian);
SqlParameter p3 = new SqlParameter("@thoiGianDung", c.ThoiGianDung);
SqlParameter p4 = new SqlParameter("@ghiChu", c.GhiChu);
SqlParameter[] param = { p1, p2, p3, p4 };
return(manager.executeUpdate(sql, param));
}
private void gridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
int row = e.RowIndex;
if (row < 0 || row >= list.Count)
{
return;
}
ChiTietChuyenDi c = list[row];
Display(c);
}
private void btnAdd_Click(object sender, EventArgs e)
{
string maChuyenDi = cbbMaChuyenDi.Text.Trim();
string benXeTrungGian = cbbBenXeTrungGian.Text.Trim();
int thoiGianDung = Convert.ToInt32(txtThoiGianDung.Text.Trim());
string ghiChu = txtGhiChu.Text.Trim();
ChiTietChuyenDi m = new ChiTietChuyenDi(maChuyenDi, benXeTrungGian, thoiGianDung, ghiChu);
list.Add(m);
gridView.DataSource = null;
gridView.DataSource = list;
addChiTietChuyenDi(m);
}
public bool add(ChiTietChuyenDi c)
{
try
{
String sql = "insert into ChiTietChuyenDi values(@maChuyenDi, @benXeTrungGian, @thoiGianDung, @ghiChu)";
SqlParameter p1 = new SqlParameter("@maChuyenDi", c.MaChuyenDi);
SqlParameter p2 = new SqlParameter("@benXeTrungGian", c.BenXeTrungGian);
SqlParameter p3 = new SqlParameter("@thoiGianDung", c.ThoiGianDung);
SqlParameter p4 = new SqlParameter("@ghiChu", c.GhiChu);
SqlParameter[] param = { p1, p2, p3, p4 };
return(manager.executeUpdate(sql, param));
}
catch (Exception e)
{
return(false);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!isInputValid())
{
return;
}
string maChuyenDi = cbbMaChuyenDi.Text.Trim();
string benXeTrungGian = cbbBenXeTrungGian.Text.Trim();
int thoiGianDung = Convert.ToInt32(txtThoiGianDung.Text.Trim());
string ghiChu = txtGhiChu.Text.Trim();
DialogResult result = MessageBox.Show("Ban co muon cap nhat " + maChuyenDi, "Cap nhat thong tin ", MessageBoxButtons.YesNo);
if (result != DialogResult.Yes)
{
return;
}
ChiTietChuyenDi m = new ChiTietChuyenDi(maChuyenDi, benXeTrungGian, thoiGianDung, ghiChu);
bool ketQua = chiTietChuyenDiDB.update(m);
// thong bao
if (ketQua)
{
MessageBox.Show("Cap nhat thanh cong");
}
else
{
MessageBox.Show("Cap nhat ko thanh cong");
}
list = chiTietChuyenDiDB.getAll(cbbMaChuyenDi.Text);
gridView.DataSource = null;
gridView.DataSource = list;
}