public void xoa_vemaybay(string id) { VEMAYBAY x = layOnevemaybay(id); db.VEMAYBAYs.Remove(x); db.SaveChanges(); }
public void Return_ticket(string iddv) { DATVE dv = layOnedatve(iddv); VEMAYBAY v = layOneVeMayBay(dv.idVe); v.TrangThai = "Còn vé"; db.DATVEs.Remove(dv); db.SaveChanges(); }
public void sua_vemaybay(VEMAYBAY vmb) { string[] idcb = vmb.idChuyenBay.Split(' '); string[] idlv = vmb.idLoaiVe.Split(' '); VEMAYBAY x = layOnevemaybay(vmb.idVe); x.idChuyenBay = idcb[0]; x.idLoaiVe = idlv[0]; x.SoKgHanhLy = vmb.SoKgHanhLy; x.GiaVe = vmb.GiaVe; db.SaveChanges(); }
public void dat_ve_login(DATVE dv) { DateTime date = DateTime.Now; string iddatve = Content.RandomString(12); dv.idDatVe = iddatve; dv.NgayDatVe = date; VEMAYBAY vedangdat = db.VEMAYBAYs.First(m => m.idVe == dv.idVe); vedangdat.TrangThai = "Hết vé"; db.SaveChanges(); db.DATVEs.Add(dv); db.SaveChanges(); }
public void dat_ve_nologin(DATVEKOLOGIN cb) { DateTime date = DateTime.Now; string iduser = Content.RandomString(8); cb.idUser2 = iduser; cb.NgayDat2 = date; VEMAYBAY vedangdat = db.VEMAYBAYs.First(m => m.idVe == cb.idVe); vedangdat.TrangThai = "Hết vé"; db.SaveChanges(); db.DATVEKOLOGINs.Add(cb); db.SaveChanges(); }
public void them_vemaybay(VEMAYBAY vmb) { int soVe = int.Parse(vmb.idVe); string[] idmb = vmb.idChuyenBay.Split(' '); vmb.idChuyenBay = idmb[0]; vmb.TrangThai = "Còn vé"; for (int i = 0; i < soVe; i++) { VEMAYBAY x = new VEMAYBAY(); string idvemb = Content.RandomString(9); x.idVe = idvemb + i; x.idChuyenBay = vmb.idChuyenBay; x.SoKgHanhLy = vmb.SoKgHanhLy; x.GiaVe = vmb.GiaVe; x.TrangThai = vmb.TrangThai; if (i < 3) //0-16 { x.idLoaiVe = "lv004"; } else if (i >= 3 && i < 5) //17-39 { x.idLoaiVe = "lv003"; } else if (i >= 5 && i < 8) //40-71 { x.idLoaiVe = "lv002"; } else //72-... { x.idLoaiVe = "lv001"; } db.VEMAYBAYs.Add(x); db.SaveChanges(); } }