public IHttpActionResult HuyVeXe(string _vexeId)
{
try
{
using (var db = new DB())
{
VeXe veXe = db.VeXes.FirstOrDefault(x => x.vexeId == _vexeId);
if (veXe.matrangthaive == 0)
{
veXe.matrangthaive = 3;
}
string machuyenxe = veXe.machuyenxe;
IEnumerable <ChiTietVeXe> list = db.ChiTietVeXes.Where <ChiTietVeXe>(p => p.vexeId == veXe.vexeId);
List <string> maghes = new List <string>();
foreach (ChiTietVeXe ct in list)
{
Database.TrangThaiGhe trangthaighe = db.TrangThaiGhes.SingleOrDefault(p => (p.maghe == ct.maghe) && (p.machuyenxe == machuyenxe));
trangthaighe.trangthai = 0;
}
db.SaveChanges();
return(Ok());
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
//Lay du lieu de cap nhat
private VeXe GetData()
{
VeXe data = null;
if (lbMaVe.Text != "")
{
data = VeXe.VeXe_Single(lbMaVe.Text);
}
else
{
data = new VeXe();
}
data.HoTen = txtHoVaTen.Text;
string gt = "";
if (RadioButtonNam.Checked)
{
gt = "Nam";
}
else
{
gt = "Nữ";
}
data.GioiTinh = gt;
data.Tuoi = int.Parse(txtTuoi.Text);
data.DiaChi = txtDiaChi.Text;
data.SoDT = txtSoDT.Text;
data.NgayXuatBen = DateTime.Parse(txtNgayThangXuatBen.Text);
data.TrangThaiVeXe = CheckBoxTrangThaiVeXe.Checked;
data.MaTG = Convert.ToInt32(DropDownListThoiGian.SelectedValue);
data.MaTuyen = Convert.ToInt32(DropDownListTuyenDiTuyenDen.SelectedValue);
data.MaXe = Convert.ToInt32(DropDownListLoaiXe.SelectedValue);
data.MaTKKH = lbUsername.Text;
return(data);
}
public void TestAddAndDelete()
{
VeXe t1 = new VeXe("VX005", "HCM-HN-001", "HK002", 750000);
Assert.AreEqual(true, manager.add(t1));
Assert.AreEqual(false, manager.add(t1));
Assert.AreEqual(true, manager.delete("VX005"));
}
private void LoadTuyenDiTuyenDen()
{
DropDownListTuyenDiTuyenDen.DataValueField = "MaTuyen";
DropDownListTuyenDiTuyenDen.DataTextField = "BenDiBenDen";
DropDownListTuyenDiTuyenDen.DataSource = TuyenDi.ListTuyenDi();
DropDownListTuyenDiTuyenDen.DataBind();
//
DropDownListLoaiXe.DataValueField = "MaXe";
DropDownListLoaiXe.DataTextField = "KieuiXe";
DropDownListLoaiXe.DataSource = LoaiXe.LoaiXe_DropDownList();
DropDownListLoaiXe.DataBind();
//
DropDownListThoiGian.DataValueField = "MaTG";
DropDownListThoiGian.DataTextField = "GioXuatBen";
DropDownListThoiGian.DataSource = ThoiGian.ThoiGian_DropDownList();
DropDownListThoiGian.DataBind();
//
string stringId = Request.QueryString["Id"] ?? "";
if (stringId != "")
{
//Lay ve xe theo ID
VeXe data = VeXe.VeXe_Single(stringId);
if (data == null)
{
Response.Redirect("~/Datve.aspx");
}
//Dua du lieu vao fomr de cap nhat
lbMaVe.Text = data.MaVe.ToString();
txtHoVaTen.Text = data.HoTen;
//string gt = "";
if (data.GioiTinh == "Nam")
{
RadioButtonNam.Checked = true;
}
else
{
RadioButtonNu.Checked = true;
}
//gt = data.GioiTinh;
txtTuoi.Text = data.Tuoi.ToString();
txtDiaChi.Text = data.DiaChi;
txtSoDT.Text = data.SoDT;
txtNgayThangXuatBen.Text = data.NgayXuatBen.ToShortDateString();
CheckBoxTrangThaiVeXe.Checked = data.TrangThaiVeXe;
DropDownListThoiGian.SelectedValue = data.MaTG.ToString();
DropDownListTuyenDiTuyenDen.SelectedValue = data.MaTuyen.ToString();
DropDownListLoaiXe.SelectedValue = data.MaXe.ToString();
lbUsername.Text = data.MaTKKH;
}
}
public void TestUpdate()
{
VeXe t1 = new VeXe("VX005", "HCM-HN-001", "HK002", 750000);
manager.add(t1);
VeXe t2 = new VeXe("VX005", "HCM-HN-001", "HK004", 750000);
Assert.AreEqual(true, manager.update(t2));
Assert.AreEqual(true, manager.update(t1));
Assert.AreEqual(true, manager.delete("VX005"));
}
protected void btDelte_Click(object sender, EventArgs e)
{
string stringId = Request.Form["Id"] ?? "";
if (stringId != "")
{
foreach (string item in stringId.Split(','))
{
VeXe.Delete(item);
LoadControl();
}
}
}
public IHttpActionResult DetailVeXe(string _vexeId)
{
try
{
using (var db = new DB())
{
VeXe veXe = db.VeXes.FirstOrDefault(x => x.vexeId == _vexeId);
return(Ok(new
{
ve = new
{
veXe.vexeId,
veXe.khachhangId,
veXe.KhachHang.hoten,
veXe.ChuyenXe.machuyenxe,
veXe.TrangThaiVeXe.tentrangthai,
veXe.TrangThaiVeXe.matrangthaive,
veXe.sokhach,
diemdon = db.DiemTrungChuyens.FirstOrDefault(y => y.madiemtrungchuyen == veXe.madiemtrungchuyendon).tendiemtrungchuyen,
diemtra = db.DiemTrungChuyens.FirstOrDefault(y => y.madiemtrungchuyen == veXe.madiemtrungchuyentra).tendiemtrungchuyen,
ngaydat = veXe.ngaydat.Value.ToString("dd/MM/yyyy HH:mm"),
veXe.ChiTietVeXes.FirstOrDefault().sodienthoaikhach,
veXe.tongtien
},
chitietves = veXe.ChiTietVeXes.Select(y => new
{
y.maghe
}),
khachhang = new
{
veXe.KhachHang.hoten,
tendoituong = veXe.KhachHang.DoiTuong == null ? "Thành viên" : veXe.KhachHang.DoiTuong.tendoituong,
veXe.KhachHang.diachi,
veXe.KhachHang.sodienthoai,
veXe.KhachHang.email,
veXe.KhachHang.gioitinh,
veXe.KhachHang.diemtichluy
}
}));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult ThanhToanVeXe(string _vexeId)
{
try
{
using (var db = new DB())
{
VeXe veXe = db.VeXes.FirstOrDefault(x => x.vexeId == _vexeId);
if (veXe.matrangthaive == 0)
{
veXe.matrangthaive = 1;
}
veXe.KhachHang.diemtichluy += int.Parse(veXe.tongtien);
db.SaveChanges();
return(Ok());
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
protected void btDangKy_Click(object sender, EventArgs e)
{
string bendibenden = DropDownListTuyenDiTuyenDen.SelectedItem.Text;
string thoigian = DropDownListThoiGian.SelectedValue;
string maxe = DropDownListLoaiXe.SelectedValue;
CaptchaControlDatVe.ValidateCaptcha(txtCapchaDangky.Text.Trim().ToLower());
if (CaptchaControlDatVe.UserValidated)
{
if (Page.IsValid)
{
bool result = false;
VeXe data = GetData();
if (data.MaVe > 0)
{
if (TuyenDi.TuyenDi_SelectWhereSoKhop(bendibenden, thoigian, maxe) != 0)
{
result = VeXe.Update(data);
if (result)
{
//Response.Redirect("~/Listvexe.aspx");
PanelThongTinVe.Visible = true;
lbSoLuongVeWhere.Visible = true;
int resultCount = VeXe.VeXe_CountWhere(txtNgayThangXuatBen.Text, DropDownListThoiGian.SelectedValue.ToString(), DropDownListTuyenDiTuyenDen.SelectedValue.ToString(), DropDownListLoaiXe.SelectedValue.ToString());
// lbSoLuongVeWhere.Text = "<script>alert(" + resultCount+")</script>";
lbBenDiBenDen.Text = DropDownListTuyenDiTuyenDen.SelectedItem.Text;
lbNgayXuatBen.Text = data.NgayXuatBen.ToShortDateString().ToString();
lbThoiGian.Text = DropDownListThoiGian.SelectedItem.Text;;
lbLoaiXe.Text = DropDownListLoaiXe.SelectedItem.Text;
lbSoLuongVeWhere.Text = "" + resultCount;
ResetForm();
lbTuyenDiTonTai.Text = "";
HyperLinkBangGiaVe.Text = "";
}
}
else
{
lbTuyenDiTonTai.Text = "Tuyến đi không tồn tại. Xin qúy khách vui lòng xem lại ";
HyperLinkBangGiaVe.Text = "bảng giá vé";
}
}
else
{
if (TuyenDi.TuyenDi_SelectWhereSoKhop(bendibenden, thoigian, maxe) != 0)
{
result = VeXe.Add(data);
if (result)
{
//Response.Redirect("~/Listvexe.aspx");
PanelThongTinVe.Visible = true;
lbSoLuongVeWhere.Visible = true;
int resultCount = VeXe.VeXe_CountWhere(txtNgayThangXuatBen.Text, DropDownListThoiGian.SelectedValue.ToString(), DropDownListTuyenDiTuyenDen.SelectedValue.ToString(), DropDownListLoaiXe.SelectedValue.ToString());
// lbSoLuongVeWhere.Text = "<script>alert(" + resultCount+")</script>";
lbBenDiBenDen.Text = DropDownListTuyenDiTuyenDen.SelectedItem.Text;
lbNgayXuatBen.Text = data.NgayXuatBen.ToShortDateString().ToString();
lbThoiGian.Text = DropDownListThoiGian.SelectedItem.Text;;
lbLoaiXe.Text = DropDownListLoaiXe.SelectedItem.Text;
lbSoLuongVeWhere.Text = "" + resultCount;
ResetForm();
lbTuyenDiTonTai.Text = "";
HyperLinkBangGiaVe.Text = "";
}
}
else
{
lbTuyenDiTonTai.Text = "Tuyến đi không tồn tại. Xin qúy khách vui lòng xem lại ";
HyperLinkBangGiaVe.Text = "bảng giá vé";
}
}
}
}
else
{
lbResult.Text = "Nhập sai mã bảo vệ";
}
}
private void LoadControl()
{
RepeaterListVeXe.DataSource = VeXe.VeXe_SlectAcountKH(lbAcountDangNhap.Text);
RepeaterListVeXe.DataBind();
}
public IHttpActionResult Post([FromBody] DatXe datXe)
{
try
{
using (var db = new DB())
{
using (var transaction = db.Database.BeginTransaction())
{
DateTime dateTimeNow = DateTime.Now;
KhachHang khachHang = db.KhachHangs.FirstOrDefault(x => x.sodienthoai == datXe.khachhang.sodienthoai);
string khachhangid = DataHelper.RandomString(20);
if (khachHang != null)
{
khachHang.hoten = datXe.khachhang.hoten;
khachHang.email = datXe.khachhang.email;
khachHang.gioitinh = datXe.khachhang.gioitinh;
khachHang.diachi = datXe.khachhang.diachi;
khachhangid = khachHang.khachhangId;
}
else
{
datXe.khachhang.madoituong = "DTDEFAULT";
datXe.khachhang.diemtichluy = 0;
while (db.KhachHangs.FirstOrDefault(x => x.khachhangId == khachhangid) != null)
{
khachhangid = DataHelper.RandomString(20);
}
datXe.khachhang.khachhangId = khachhangid;
datXe.khachhang.matkhau = Encode.MD5(datXe.khachhang.sodienthoai);
db.KhachHangs.Add(datXe.khachhang);
}
db.SaveChanges();
string vexeid = DataHelper.RandomString(20);
while (db.VeXes.FirstOrDefault(x => x.vexeId == vexeid) != null)
{
vexeid = DataHelper.RandomString(20);
}
VeXe veXe = new VeXe()
{
vexeId = vexeid,
machuyenxe = datXe.machuyenxe,
khachhangId = khachhangid,
matrangthaive = 0,
sokhach = datXe.ghes.Count,
madiemtrungchuyendon = datXe.madiemtrungchuyendon,
madiemtrungchuyentra = datXe.madiemtrungchuyentra,
ngaydat = dateTimeNow,
tongtien = datXe.tongtien.ToString()
};
db.VeXes.Add(veXe);
db.SaveChanges();
string maxe = db.ChuyenXes.FirstOrDefault(x => x.machuyenxe == datXe.machuyenxe).maxe;
datXe.ghes.ForEach(x =>
{
Database.TrangThaiGhe trangThaiGhe = db.TrangThaiGhes.FirstOrDefault(y => (y.maghe == maxe + "_" + x) && y.machuyenxe == datXe.machuyenxe);
if (trangThaiGhe != null)
{
trangThaiGhe.trangthai = 1;
}
string chitietvexeid = DataHelper.RandomString(20);
while (db.ChiTietVeXes.FirstOrDefault(y => y.chitietvexeId == chitietvexeid) != null)
{
chitietvexeid = DataHelper.RandomString(20);
}
db.ChiTietVeXes.Add(new ChiTietVeXe()
{
chitietvexeId = chitietvexeid,
vexeId = veXe.vexeId,
tenhanhkhach = datXe.khachhang.hoten,
sodienthoaikhach = datXe.khachhang.sodienthoai,
maghe = maxe + "_" + x,
doituong = "DTDEFAULT"
});
});
db.SaveChanges();
transaction.Commit();
return(Ok());
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
