protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "SelectItem")
{
GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)];
iMaChuyenXe = Convert.ToInt32(row.Cells[4].Text);
TRAVEL_WEBDataContext db = new TRAVEL_WEBDataContext();
PHAN_HOI_KHACH_HANG phkh = new PHAN_HOI_KHACH_HANG();
phkh.NgayDang = DateTime.Now;
phkh.NoiDung = tbThongTinPhanHoi.Text;
//phkh.Duyet = 2;
db.PHAN_HOI_KHACH_HANGs.InsertOnSubmit(phkh);
db.SubmitChanges();
var x = from y in db.PHAN_HOI_KHACH_HANGs select y.MaPhanHoi;
PHAN_HOI ph = new PHAN_HOI();
ph.MaChuyen = iMaChuyenXe;
ph.MaPhanHoiKhach = x.Max();
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
}
}
protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isChecked;
int iMaChuyenXe;
int iSoLuong = GridView1.Rows.Count;
for (int i = 0; i < iSoLuong; i++)
{
row = GridView1.Rows[i];
isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text);
// Them PhanHoi
PHAN_HOI ph = new PHAN_HOI();
ph.MaPhanHoiKhach = iMaPhanHoiKhach;
ph.MaChuyen = iMaChuyenXe;
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
((CheckBox)row.FindControl("chkSelect")).Checked = false;
// Update
PHAN_HOI_KHACH_HANG phkh = (from x in db.PHAN_HOI_KHACH_HANGs
where x.MaPhanHoi == iMaPhanHoiKhach
select x).Single();
phkh.Duyet = 2;
db.SubmitChanges();
}
}
GridView_PHANHOI.DataBind();
}
protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isChecked;
int iMaChuyenXe;
int iSoLuong = GridView1.Rows.Count;
for (int i = 0; i < iSoLuong; i++)
{
row = GridView1.Rows[i];
isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text);
// Them o PHANHOIKHACHHANG
PHAN_HOI_KHACH_HANG phkh = new PHAN_HOI_KHACH_HANG();
phkh.NoiDung = TextBox1.Text;
phkh.NgayDang = DateTime.Now;
phkh.Duyet = 2; // da duyet
db.PHAN_HOI_KHACH_HANGs.InsertOnSubmit(phkh);
db.SubmitChanges();
// Them PhanHoi
PHAN_HOI ph = new PHAN_HOI();
ph.MaPhanHoiKhach = phkh.MaPhanHoi;
ph.MaChuyen = iMaChuyenXe;
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
((CheckBox)row.FindControl("chkSelect")).Checked = false;
}
}
}
protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isCheckedDatCho;
bool isCheckedBanVe;
int iMaDatCho;
for (int i = 0; i < GridView_DATCHO.Rows.Count; i++)
{
row = GridView_DATCHO.Rows[i];
iMaDatCho = Convert.ToInt32(row.Cells[3].Text);
var dc = (from x in db.DAT_CHOs where x.MaDatCho == iMaDatCho select x).Single();
isCheckedDatCho = ((CheckBox)row.FindControl("chkSelect_DatCho")).Checked;
if (isCheckedDatCho)
{
dc.TinhTrang = 2;
}
isCheckedBanVe = ((CheckBox)row.FindControl("chkSelect_BanVe")).Checked;
if (isCheckedBanVe)
{
dc.TinhTrang = 3;
}
db.SubmitChanges();
}
GridView_DATCHO.DataBind();
}
protected void updateImage(Binary imageData, int id)
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var img = (from i in context.IMAGE_STOREs where i.Id == id select i).Single();
img.Image = imageData;
context.SubmitChanges();
}
protected int insertImage(Binary imageData)
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
IMAGE_STORE img = new IMAGE_STORE();
img.Image = imageData;
context.IMAGE_STOREs.InsertOnSubmit(img);
context.SubmitChanges();
return(img.Id);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "SelectItem")
{
GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)];
int iMaChuyenXe = Convert.ToInt32(row.Cells[4].Text);
var x = (from y in db.PHAN_HOI_KHACH_HANGs where y.MaPhanHoi == DetailsView1.PageIndex select y).Single();
//x.Duyet = 2;
db.SubmitChanges();
PHAN_HOI ph = new PHAN_HOI();
ph.MaChuyen = iMaChuyenXe;
ph.MaPhanHoiKhach = DetailsView1.PageIndex;
db.PHAN_HOIs.InsertOnSubmit(ph);
db.SubmitChanges();
}
}
protected void GridView_TAIXE_SelectedIndexChanged(object sender, EventArgs e)
{
int iMaTaiXe;
GridViewRow row = GridView_TAIXE.SelectedRow;
iMaTaiXe = Convert.ToInt32(row.Cells[1].Text);
var xe = (from x in db.XEs
where x.MaXe == iMaXe
select x).Single();
xe.MaTaiXe = iMaTaiXe;
db.SubmitChanges();
GridView_XE.DataBind();
GridView_TAIXE.DataBind();
}
public static void ConvertPlainPasswordToHashPasswordInAllUsers()
{
TRAVEL_WEBDataContext datacontext = new TRAVEL_WEBDataContext();
var taikhoans = from t in datacontext.TAI_KHOANs select t;
foreach (TAI_KHOAN tk in taikhoans)
{
tk.Salt = CryptographicHelper.CreateSalt();
if (String.IsNullOrEmpty(tk.Password))
{
tk.Password = Membership.GeneratePassword(10, 3);
}
tk.Password = CryptographicHelper.CreatePasswordHash(tk.Password, tk.Salt);
}
datacontext.SubmitChanges();
}
public override string ResetPassword(string username, string answer)
{
string newPassword = "";
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
//newPassword = CryptographicHelper.GenerateKey();
newPassword = Membership.GeneratePassword(10, 3);
TAI_KHOAN tk = user.Single();
tk.Password = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt);
dataContext.SubmitChanges();
}
return(newPassword);
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
oldPassword = CryptographicHelper.CreatePasswordHash(oldPassword, tk.Salt);
newPassword = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt);
if (oldPassword == tk.Password && oldPassword != newPassword)
{
tk.Password = newPassword;
dataContext.SubmitChanges();
return(true);
}
}
return(false);
}
protected void GridView_TAIXE_SelectedIndexChanged(object sender, EventArgs e)
{
int iMaTaiXe;
GridViewRow row = GridView_TAIXE.SelectedRow;
iMaTaiXe = Convert.ToInt32(row.Cells[1].Text);
// Cap nhat lai chuyen xe da phan cong
var chuyenxe = (from x in db.CHUYEN_XEs
where x.MaChuyenXe == iMaChuyenXe
select x).Single();
chuyenxe.MaTaiXe = iMaTaiXe;
db.SubmitChanges();
//Load lai du lieu
GridView_CHUYENXE.DataSource = db.ChuyenXeChuaPhanCong();
GridView_CHUYENXE.DataBind();
GridView_TAIXE.DataSource = null;
GridView_TAIXE.DataBind();
}
protected void Button_OK_Click(object sender, EventArgs e)
{
GridViewRow row;
bool isChecked;
int iMaChuyenXe;
for (int i = 0; i < GridView_CHUYENXE.Rows.Count; i++)
{
row = GridView_CHUYENXE.Rows[i];
iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text);
var dc = (from x in db.CHUYEN_XEs where x.MaChuyenXe == iMaChuyenXe select x).Single();
isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
dc.TinhTrang = 3;
dc.ThoiGianDenTram = DateTime.Now;
}
db.SubmitChanges();
}
GridView_CHUYENXE.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
//if (IsPostBack)
{
// Postback : được hiểu là khi user click vào Upload hoặc Submit
// Vấn đề là button Submit : có handler là javascript (bắt buộc) nên không gọi vào sự kiện Click ở Server được => cần gom lại vào xử lý trong PageLoad luôn
string strGioiThieu = rteGioiThieu.Text;
Binary banner, slogan, logo;
bool bInsertNew = true;
banner = getUploadImage(uploadBanner, sttBanner);
slogan = getUploadImage(uploadSlogan, sttSlogan);
logo = getUploadImage(uploadLogo, sttLogo);
// Tương tự cho các hình khác
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var thongtincongtys = from t in context.THONG_TIN_CONG_Ties select t;
var thongtincongty = new THONG_TIN_CONG_TY();
if (thongtincongtys.Count() > 0)
{
bInsertNew = false;
thongtincongty = thongtincongtys.First();
}
if (banner != null)
{
if (thongtincongty.Banner == null)
{
thongtincongty.Banner = insertImage(banner);
}
else
{
updateImage(banner, (int)thongtincongty.Banner);
}
}
if (slogan != null)
{
if (thongtincongty.Slogan == null)
{
thongtincongty.Slogan = insertImage(slogan);
}
else
{
updateImage(slogan, (int)thongtincongty.Slogan);
}
}
if (logo != null)
{
if (thongtincongty.Logo == null)
{
thongtincongty.Logo = insertImage(logo);
}
else
{
updateImage(logo, (int)thongtincongty.Logo);
}
}
if (strGioiThieu != null)
{
thongtincongty.TinTucGioiThieu = strGioiThieu;
}
if (bInsertNew == true)
{
context.THONG_TIN_CONG_Ties.InsertOnSubmit(thongtincongty);
}
context.SubmitChanges();
}
int bannerId, sloganId, logoId;
string gioithieuHTML;
getThongTin(out bannerId, out sloganId, out logoId, out gioithieuHTML);
//imgBanner.ImageUrl = getImageURL(bannerId);
//imgSlogan.ImageUrl = getImageURL(sloganId);
//imgLogo.ImageUrl = getImageURL(logoId);
rteGioiThieu.Text = gioithieuHTML;
}
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;
}