public void UpdateDatCho(DAT_CHO datcho)
{
var query = (from c in _dataContext.DAT_CHOs
where c.MaDatCho == datcho.MaDatCho
select c).Single();
query.MaChoNgoi = datcho.MaChoNgoi;
query.MaChuyenXe = datcho.MaChuyenXe;
query.TinhTrang = datcho.TinhTrang;
_dataContext.SubmitChanges();
}
protected void GridView_TUYENXE_SelectedIndexChanged(object sender, EventArgs e)
{
// Insert nhung chuyen moi dua theo tuyen da chon
// Ngay mai
DateTime ngaymai = DateTime.Now;
ngaymai = ngaymai.AddDays(1);
GridViewRow row = GridView_TUYENXE.SelectedRow;
iMaTuyenXe = Convert.ToInt32(row.Cells[1].Text);
var tuyenxe = (from x in db.TUYEN_XEs
where x.MaTuyenXe == iMaTuyenXe
select x).Single();
CHUYEN_XE cx;
int iMaChuyenXe;
DAT_CHO dc;
DateTime KhoiHanh;
int i;
// Chuyen dau tien
cx = new CHUYEN_XE();
// Tinh thoi gian khoi hanh
KhoiHanh = ngaymai;
KhoiHanh = KhoiHanh.AddHours((double)tuyenxe.ThoiGianBatDau);
cx.KhoiHanh = KhoiHanh;
cx.MaTuyenXe = iMaTuyenXe;
cx.TinhTrang = 1;// Chua khoi hanh
cx.DuKienDen = KhoiHanh.AddHours((double)tuyenxe.ThoiGianDi);
cx.LuongTaiXe = (float)tuyenxe.LuongTaiXe;
cx.GiaVe = (float)tuyenxe.GiaVe;
cx.SoLuongMuaVe = 0; // So luong mua ve ban dau
db.CHUYEN_XEs.InsertOnSubmit(cx);
db.SubmitChanges();
// Lay ma chuyen vua insert
iMaChuyenXe = (from y in db.CHUYEN_XEs
select y.MaChuyenXe).Max();
// Insert DAT_CHO
// Lay tat ca cho ngoi
var listChoNgoi = (from cn in db.CHO_NGOIs
select cn);
foreach (CHO_NGOI cn in listChoNgoi)
{
dc = new DAT_CHO();
dc.MaChoNgoi = cn.MaChoiNgoi;
dc.MaChuyenXe = iMaChuyenXe;
dc.TinhTrang = 1; // Chua dat cho
db.DAT_CHOs.InsertOnSubmit(dc);
db.SubmitChanges();
}
// Chuyen tiep theo
for (i = 1; i < tuyenxe.SoLuongChuyen; i++)
{
cx = new CHUYEN_XE();
// Tinh thoi gian khoi hanh
KhoiHanh = KhoiHanh.AddHours((double)tuyenxe.TanSuatChuyen);
cx.KhoiHanh = KhoiHanh;
cx.MaTuyenXe = iMaTuyenXe;
cx.TinhTrang = 1;// Chua khoi hanh
cx.DuKienDen = KhoiHanh.AddHours((double)tuyenxe.ThoiGianDi);
cx.LuongTaiXe = (float)tuyenxe.LuongTaiXe;
cx.GiaVe = (float)tuyenxe.GiaVe;
cx.SoLuongMuaVe = 0; // So luong mua ve ban dau
db.CHUYEN_XEs.InsertOnSubmit(cx);
db.SubmitChanges();
// Lay ma chuyen vua insert
iMaChuyenXe = (from y in db.CHUYEN_XEs
select y.MaChuyenXe).Max();
// Insert DAT_CHO
foreach (CHO_NGOI cn in listChoNgoi)
{
dc = new DAT_CHO();
dc.MaChoNgoi = cn.MaChoiNgoi;
dc.MaChuyenXe = iMaChuyenXe;
dc.TinhTrang = 1; // Chua dat cho
db.DAT_CHOs.InsertOnSubmit(dc);
db.SubmitChanges();
}
}
var chuyenxe = (from x in db.CHUYEN_XEs
where x.MaTuyenXe == iMaTuyenXe && x.KhoiHanh > DateTime.Now
select x);
GridView_CHUYENXE.DataSource = chuyenxe;
GridView_CHUYENXE.DataBind();
GridView_TUYENXE.SelectedRow.Visible = false;
}
public void UpdateDatCho(DAT_CHO datcho)
{
_datchoDao.UpdateDatCho(datcho);
}
public void InsertDatCho(DAT_CHO datcho)
{
_dataContext.DAT_CHOs.InsertOnSubmit(datcho);
_dataContext.SubmitChanges();
}
public void InsertDatCho(DAT_CHO datcho)
{
_datchoDao.InsertDatCho(datcho);
}
