public DataTable LoadList()
{
string sql = "Select * from ChuyenBay Where DaXoa=N'Chưa xóa'";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select * from HangVe";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable Search(string diemkhoihanh, string diemden, string date)
{
string sql = string.Format("Select lb.malichbay,hanghangkhong,giokhoihanh,gioketthuc,mahangve,sochocontrong,tinhtrang from LichBay lb,ChuyenBay cb, SoChoTrong sct where lb.MaLichBay = sct.MaLichBay AND lb.MaChuyenBay = cb.MaChuyenBay AND DiemKhoiHanh = N'{0}' AND DiemDen = N'{1}' AND Ngay = '{2}'", diemkhoihanh, diemden, date);
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select * from SoChoConTrong";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select LichLamViec.MaNhanVien, NhanVien.HoTen, LichLamViec.Ngay, LichLamViec.Ca from LichLamViec, NhanVien where LichLamViec.MaNhanVien = NhanVien.MaNhanVien";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select GiaoDich.*, KhachHang.TenKhachHang From GiaoDich, KhachHang Where GiaoDich.MaKhachHang = KhachHang.MaKhachHang";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select * from NhanVien Where TinhTrang!=N'Đã xóa'";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public int Delete(string id)
{
string sql = string.Format("Update NhanVien Set TinhTrang=N'Đã xóa' Where MaNhanVien='{0}'",
id);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(SoChoConTrong SoChoConTrong)
{
string sql = string.Format("Update SoChoConTrong Set MaHangVe='{1}', SoChoConTrong='{2}' Where MaLichBay='{0}'",
SoChoConTrong.MaLichBay, SoChoConTrong.MaHangVe, SoChoConTrong.SoChoTrong);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Insert(SoChoConTrong SoChoConTrong)
{
string sql = string.Format("Insert into LichLamViec(MaLichBay, MaHangVe, SoChoConTrong) Values('{0}','{1}','{2}')",
SoChoConTrong.MaLichBay, SoChoConTrong.MaHangVe, SoChoConTrong.SoChoTrong);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(KhachHang KhachHang)
{
string sql = string.Format("Update KhachHang Set TenKhachHang='{1}', SoDienThoai='{2}', CMND='{3}' Where MaKhachHang='{0}'",
KhachHang.MaKhachHang, KhachHang.TenKhachHang, KhachHang.SoDienThoai, KhachHang.CMND);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(LichLamViec LichLamViec)
{
string sql = string.Format("Update LichLamViec Set Ngay='{1}', Ca='{2}' Where MaNhanVien='{0}'",
LichLamViec.MaNhanVien, LichLamViec.Ngay, LichLamViec.Ca);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Insert(LichLamViec LichLamViec)
{
string sql = string.Format("Insert into LichLamViec(MaNhanVien, Ngay, Ca) Values('{0}','{1}','{2}')",
LichLamViec.MaNhanVien, LichLamViec.Ngay, LichLamViec.Ca);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public DataTable DetailLoad(string id)
{
string sql = string.Format("Select HangVe.*, SoChoTrong.SoChoConTrong From LichBay, HangVe, SoChoTrong Where LichBay.MaLichBay='{0}' and LichBay.MaChuyenBay = HangVe.MaChuyenBay and SoChoTrong.MaHangVe=HangVe.MaHangVe and SoChoTrong.MaLichBay=LichBay.MaLichBay",
id);
var rs = ProcessData.LoadData(sql);
return(rs);
}
public int Update(LichBay LichBay)
{
string sql = string.Format("Update LichBay Set MaChuyenBay='{1}', Ngay='{2}', GioKhoiHanh='{3}', GioKetThuc='{4}', TinhTrang=N'{5}' Where MaLichBay='{0}'",
LichBay.MaLichBay, LichBay.MaChuyenBay, LichBay.Ngay, LichBay.GioKhoiHanh, LichBay.GioKetThuc, LichBay.TinhTrang);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(NhanVien NhanVien)
{
string sql = string.Format("Update NhanVien Set HoTen'{1}', MatKhau='{2}', TinhTrang'{3}', MaNguoiQuanLy='{4}', NgaySinh='{5}', GioiTinh'{6}', ChucVu='{7}', DiaChi='{8}', SoDienThoai='{9}' Where MaNhanVien='{0}'",
NhanVien.MaNhanVien, NhanVien.HoTen, NhanVien.MatKhau, NhanVien.TinhTrang, NhanVien.MaNguoiQuanLy, NhanVien.NgaySinh, NhanVien.GioiTinh, NhanVien.ChucVu, NhanVien.DiaChi, NhanVien.SoDienThoai);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(Ve Ve)
{
string sql = string.Format("Update LichBay Set MaLichBay='{1}', MaHangVe='{2}' Where MaNhanVien='{0}'",
Ve.MaVe, Ve.MaLichBay, Ve.MaHangVe);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Delete(string id)
{
string sql = string.Format("Delete from LichLamViec Where MaVe='{0}'",
id);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Delete(string id)
{
string sql = string.Format("Update ChuyenBay Set DaXoa=N'Đã xóa' Where MaChuyenBay='{0}'",
id);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(HangVe HangVe)
{
string sql = string.Format("Update GiaoDich Set MaHangVe='{1}', MaChuyenBay='{2}', GiaVe='{3}', SoCho='{4}' Where MaGiaoDich={0}",
HangVe.MaHangVe, HangVe.MaChuyenBay, HangVe.GiaVe, HangVe.SoCho);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Insert(HangVe HangVe)
{
string sql = string.Format("Insert into HangVe(MaHangVe, MaChuyenBay, GiaVe, SoCho) Values('{0}','{1}',{2},{3})",
HangVe.MaHangVe, HangVe.MaChuyenBay, HangVe.GiaVe, HangVe.SoCho);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Delete(string id)
{
string sql = string.Format("Delete from ChuyenBay Where MaHangVe={0}",
id);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Delete(string id)
{
string sql = string.Format("Delete from ChiTietGiaoDich Where Id={0}",
id);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(GiaoDich GiaoDich)
{
string sql = string.Format("Update GiaoDich Set SoTienGiaoDich='{1}', ThoiGianGiaoDich='{2}', GiaoDich.MaKhachHang='{3}', MaNhanVien='{4}', SoTaiKhoanChuyenDen='{5}', GiaoDich.MaLichBay='{6}' Where MaGiaoDich={0}",
GiaoDich.MaGiaoDich, GiaoDich.SoTienGiaoDich, GiaoDich.ThoiGianGiaoDich, GiaoDich.MaKhachHang, GiaoDich.MaNhanVien, GiaoDich.SoTaiKhoanChuyenDen, GiaoDich.MaLichBay);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Insert(ChiTietGiaoDich ChiTiet)
{
string sql = string.Format("Insert into ChiTietGiaoDich(MaGiaoDich, MaVe) Values('{0}','{1}')",
ChiTiet.MaGiaoDich, ChiTiet.MaVe);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Update(ChuyenBay ChuyenBay)
{
string sql = string.Format("Update ChuyenBay Set HangHangKhong=N'{1}', DiemKhoiHanh=N'{2}', DiemDen=N'{3}', SoLuongKhach={4} Where MaChuyenBay='{0}'",
ChuyenBay.MaChuyenBay, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public DataTable LoadList(string id)
{
string sql = string.Format("Select Ve.MAVE, LichBay.* "
+ "From GiaoDich, ChiTietGiaoDich, Ve, LichBay "
+ "Where Ve.MaVe=ChiTietGiaoDich.MaVe and GiaoDich.MaGiaoDich = ChiTietGiaoDich.MaGiaoDich "
+ "and GiaoDich.MaKhachHang = '{0}' and LichBay.MaLichBay = Ve.MaLichBay ",
id);
var rs = ProcessData.LoadData(sql);
return(rs);
}
public int Insert(Ve Ve, int amount, string idTran)
{
string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True";
SqlConnection conn = new SqlConnection(path);
string sql = string.Format("Select MAX(MaVe) From Ve");
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
var rd = command.ExecuteReader();
string tmp = "";
if (rd.Read())
{
tmp = rd.GetString(0);
}
conn.Close();
int id = int.Parse(tmp.Remove(0, 1));
int rs = 0;
int temp = id;
for (id++; id <= temp + amount + 1; id++)
{
tmp = "V";
if (id < 10)
{
tmp += "00";
}
else if (id < 100)
{
tmp += "0";
}
tmp += id;
sql = string.Format("Insert into Ve(MaVe, MaLichBay, MahangVe) Values('{0}','{1}','{2}')",
tmp, Ve.MaLichBay, Ve.MaHangVe);
rs += ProcessData.ExecuteNonQuery(sql);
sql = string.Format("Insert into ChiTietGiaoDich(MaGiaoDich, MaVe) values('{0}','{1}')",
idTran, tmp);
rs += ProcessData.ExecuteNonQuery(sql);
}
return(rs);
}
public int Insert(ChuyenBay ChuyenBay)
{
string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True";
SqlConnection conn = new SqlConnection(path);
string sql = string.Format("Select MAX(MaChuyenBay) From ChuyenBay");
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
var rd = command.ExecuteReader();
string tmp = "";
if (rd.Read())
{
tmp = rd.GetString(0);
}
conn.Close();
int id = int.Parse(tmp.Remove(0, 2));
id++;
tmp = "CB";
if (id < 10)
{
tmp += "00";
}
else if (id < 100)
{
tmp += "0";
}
tmp += id;
sql = string.Format("Insert into ChuyenBay(MaChuyenBay, HangHangKhong, DiemKhoiHanh, DiemDen, SoLuongKhach, DaXoa) Values('{0}','{1}',N'{2}',N'{3}','{4}','{5}')",
tmp, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach, ChuyenBay.DaXoa);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
public int Insert(GiaoDich GiaoDich)
{
string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True";
SqlConnection conn = new SqlConnection(path);
string sql = string.Format("Select MAX(MaGiaoDich) From GiaoDich");
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
var rd = command.ExecuteReader();
string tmp = "";
if (rd.Read())
{
tmp = rd.GetString(0);
}
conn.Close();
int id = int.Parse(tmp.Remove(0, 2));
id++;
tmp = "GD";
if (id < 10)
{
tmp += "00";
}
else if (id < 100)
{
tmp += "0";
}
tmp += id;
sql = string.Format("Insert into GiaoDich(MaGiaoDich, SoTienGiaoDich, ThoiGianGIaoDich,MaKhachHang,MaNhanVien,MaLichBay) Values('{0}',{1},'{2}','{3}','{4}','{5}')",
tmp, GiaoDich.SoTienGiaoDich, GiaoDich.ThoiGianGiaoDich, GiaoDich.MaKhachHang, GiaoDich.MaNhanVien, GiaoDich.MaLichBay);
var rs = ProcessData.ExecuteNonQuery(sql);
return(rs);
}
