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