protected void getThongTin(out int banner, out int slogan, out int logo, out string gioithieu)
{
gioithieu = "";
banner = slogan = logo = -1;
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)
{
thongtincongty = thongtincongtys.First();
}
if (thongtincongty.Banner != null)
{
banner = (int)thongtincongty.Banner;
}
if (thongtincongty.Slogan != null)
{
slogan = (int)thongtincongty.Slogan;
}
if (thongtincongty.Logo != null)
{
logo = (int)thongtincongty.Logo;
}
if (thongtincongty.TinTucGioiThieu != null)
{
gioithieu = thongtincongty.TinTucGioiThieu;
}
}
protected void DetailsView1_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
FileUpload fileUpload = (FileUpload)((DetailsView)sender).FindControl("fileUpload");
Label sttUpload = (Label)((DetailsView)sender).FindControl("sttImageUpload");
Binary imageBinary = ImageHelper.getUploadImage(fileUpload, sttUpload);
if (imageBinary != null)
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var hinhanh = (from tx in context.TRAM_XEs where tx.MaTramXe == int.Parse((string)e.Keys["MaTramXe"].ToString()) select tx.HinhAnh).Single();
if (hinhanh == null || hinhanh < 1)
{
e.NewValues["HinhAnh"] = ImageHelper.insertImage(imageBinary);
}
else
{
ImageHelper.updateImage(imageBinary, (int)hinhanh);
}
}
DetailsView detail = (DetailsView)sender;
DropDownList ddlNhanViens = (DropDownList)detail.FindControl("ddlNhanViens");
e.NewValues["MaTruongTram"] = ddlNhanViens.SelectedValue;
}
protected void ldsChuyenXe_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
if (maChuyenXe < 0)
{
e.Cancel = true;
return;
}
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
IQueryable <CHUYEN_XE> chuyenXeQuery = dataContext.CHUYEN_XEs;
var chuyenXes = from chuyenXe in chuyenXeQuery
where chuyenXe.MaChuyenXe == maChuyenXe
select new
{
MaChuyenXe = chuyenXe.MaChuyenXe,
HinhAnhXe = chuyenXe.NHAN_VIEN.XEs.Single().LOAI_XE.HinhAnh,
MaTaiXe = chuyenXe.MaTaiXe,
TenTaiXe = chuyenXe.NHAN_VIEN.HoTen,
KhoiHanh = chuyenXe.KhoiHanh,
DuKienDen = ((DateTime)chuyenXe.KhoiHanh).AddHours((double)chuyenXe.TUYEN_XE.ThoiGianDi),
GiaVe = chuyenXe.GiaVe,
SoChoTrong = chuyenXe.DAT_CHOs.Count(dt => dt.TINH_TRANG_DAT_CHO.TenTinhTrangDatCho == "Chưa đặt")
};
if (chuyenXes.Count() == 1)
{
e.Result = chuyenXes;
}
else
{
e.Cancel = true;
}
}
public Stream ShowEmpImage(int id)
{
MemoryStream stream = null;
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var imageList = (from img in context.IMAGE_STOREs where img.Id == id select img);
// Lấy image từ CSDL ra, nếu chưa có thì dùng ảnh mặc định
if (imageList.Count() == 0)
{
stream = GetDefaultImageStream();
}
else
{
var image = imageList.Single();
if (image.Image == null)
{
stream = GetDefaultImageStream();
}
else
{
stream = new MemoryStream(image.Image.ToArray());
}
}
return(stream);
}
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 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();
}
public override string[] GetAllRoles()
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var roles = from role in dataContext.LOAI_TAI_KHOANs
select role.TenLoaiTaiKhoan;
return(roles.ToArray());
}
protected void ldsTenLuongNhanVien_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var nvQuery = dataContext.NHAN_VIENs.Join(dataContext.TAI_KHOANs, c => c.MaNhanVien, o => o.MaNhanVien,
(c, o) => new { c.HoTen, o.Username, c.LuongTrongThang }).
Where(q => q.Username.ToString() == Page.User.Identity.Name.ToString());
e.Result = nvQuery;
}
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 LinqDataSource2_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
IQueryable <CHUYEN_XE> chuyenXeQuery = dataContext.CHUYEN_XEs;
/*chuyenXeQuery = chuyenXeQuery.Where(
* c => c.KhoiHanh >= DateTime.Today && c.KhoiHanh <= DateTime.Today.AddDays(1)
* );*/
if (ddlTramDi.SelectedItem.Text != "All")
{
chuyenXeQuery = chuyenXeQuery.Where(
c => c.TUYEN_XE.MaTramDi.ToString() == ddlTramDi.SelectedValue);
}
if (ddlTramDen.SelectedItem.Text != "All")
{
chuyenXeQuery = chuyenXeQuery.Where(
c => c.TUYEN_XE.MaTramDen.ToString() == ddlTramDen.SelectedValue);
}
bool bAdvanceSearch = (bool)Session["AdvanceSearch"];
if (bAdvanceSearch)
{
DateTime khoiHanhMin = getTimeToday(tbKhoiHanhMin.Text);
DateTime khoiHanhMax = getTimeToday(tbKhoiHanhMax.Text);
int soChoTrongMin = int.MinValue;
try
{
soChoTrongMin = int.Parse(tbSoChoTrongMin.Text);
}
catch (FormatException ex)
{
soChoTrongMin = int.MinValue;
}
if (khoiHanhMin != DateTime.MinValue && khoiHanhMax != DateTime.MinValue && soChoTrongMin >= 0)
{
chuyenXeQuery = chuyenXeQuery.Where(
c => c.KhoiHanh >= khoiHanhMin && c.KhoiHanh <= khoiHanhMax &&
c.DAT_CHOs.Count > soChoTrongMin);
}
}
var chuyenXes = from chuyenXe in chuyenXeQuery
select new
{
chuyenXe.MaChuyenXe,
chuyenXe.KhoiHanh,
DuKienDen = ((DateTime)chuyenXe.KhoiHanh).AddHours((double)chuyenXe.TUYEN_XE.ThoiGianDi),
chuyenXe.GiaVe,
SoChoTrong = chuyenXe.DAT_CHOs.Count(dt => dt.TINH_TRANG_DAT_CHO.TenTinhTrangDatCho == "Chưa đặt")
};
e.Result = chuyenXes;
}
protected void OnGridViewRowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (String.IsNullOrEmpty((string)e.NewValues["Password"]))
{
e.NewValues["Password"] = e.OldValues["Password"];
}
else
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
var salt = (from tk in context.TAI_KHOANs where tk.MaTaiKhoan == int.Parse(e.Keys["MaTaiKhoan"].ToString()) select tk.Salt).Single();
e.NewValues["Password"] = CryptographicHelper.CreatePasswordHash((string)e.NewValues["Password"], salt);
}
}
protected void Page_Load(object sender, EventArgs e)
{
TRAVEL_WEBDataContext context = new TRAVEL_WEBDataContext();
if (context.THONG_TIN_CONG_Ties.Count() == 0)
{
divNoiDungGioiThieu.InnerHtml = "không có thông tin giới thiệu";
}
else
{
var thongtincongty = context.THONG_TIN_CONG_Ties.First();
divNoiDungGioiThieu.InnerHtml = thongtincongty.TinTucGioiThieu;
}
}
//---------------------------------------------------------
//phan he tai xe
protected void ldsDanhSachPhanHoi_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var nvQuery = dataContext.NHAN_VIENs.Join(dataContext.TAI_KHOANs, c => c.MaNhanVien, o => o.MaNhanVien,
(c, o) => new { c.MaNhanVien, o.Username }).
Where(q => q.Username.ToString() == Page.User.Identity.Name.ToString()).
Join(dataContext.PHAN_HOIs, c => c.MaNhanVien, o => o.MaNhanVien,
(c, o) => new { c.MaNhanVien, o.MaPhanHoi }).
Join(dataContext.PHAN_HOI_KHACH_HANGs, c => c.MaPhanHoi, o => o.MaPhanHoi,
(c, o) => new { o.NoiDung, o.NgayDang }).
OrderByDescending(c => c.NgayDang).Take(5);
e.Result = nvQuery;
}
protected void GridView1_DataBinding(object sender, EventArgs e)
{
int month = int.Parse(dlstThang.SelectedValue);
int year = int.Parse(dlstNam.SelectedValue);
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var query = (from c in dataContext.CHUYEN_XEs
join t in dataContext.TUYEN_XEs on c.MaTuyenXe equals t.MaTuyenXe
where (c.MaTaiXe.Equals(_maNhanVien) &&
c.KhoiHanh.Value.Month == month &&
c.KhoiHanh.Value.Year == year)
select new { MaChuyen = c.MaChuyenXe, TramDi = t.TRAM_XE1.TenTramXe, TramDen = t.TRAM_XE.TenTramXe }).Distinct();
GridView1.DataSource = query;
GridView1.DataKeyNames = new string[] { "MaChuyen" };// xác định cột khóa chính
}
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();
}
//*** DataSource nằm trong DataBind là để dùng Dynamicdata Gridviewpager ***//
// -nếu không Gridviewpager không nhận được datasource
// Chọn các chuyến mà tài xế này sẽ phục vụ
// (Các chuyến chưa khởi hành)
protected void GridView1_DataBinding(object sender, EventArgs e)
{
int month = int.Parse(dlstThang_SapChay.SelectedValue);
int year = int.Parse(dlstNam_SapChay.SelectedValue);
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var query = (from c in dataContext.CHUYEN_XEs
join t in dataContext.TUYEN_XEs on c.MaTuyenXe equals t.MaTuyenXe
where (c.MaTaiXe.Equals(_maNhanVien) &&
c.TINH_TRANG_CHUYEN_XE.TenTinhTrangChuyen.ToLower().Equals("chưa khởi hành") &&
c.KhoiHanh.Value.Month == month &&
c.KhoiHanh.Value.Year == year)
select new { MaChuyen = c.MaChuyenXe, TramDi = t.TRAM_XE1.TenTramXe, TramDen = t.TRAM_XE.TenTramXe, KhoiHanh = c.KhoiHanh }).Distinct();
grdSapChay.DataSource = query;
}
public override bool ValidateUser(string username, string password)
{
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();
if (tk.Password.Equals(CryptographicHelper.CreatePasswordHash(password, tk.Salt)))
{
return(true);
}
}
return(false);
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
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();
int userID = tk.MaTaiKhoan;
string email = tk.Email;
bool isLockedOut = false;
return(new CustomMembershipUser(username, userID, email, isLockedOut));
}
return(null);
}
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);
}
//Trả về vai trò và mã nhân viên
public override string[] GetRolesForUser(string username)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username.Equals(username)
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
var loaitk = from l in dataContext.LOAI_TAI_KHOANs
where l.MaLoaiTaiKhoan == tk.LoaiTaiKhoan
select l;
if (loaitk.Count() == 1)
{
LOAI_TAI_KHOAN ltk = loaitk.Single();
return(new string[] { ltk.TenLoaiTaiKhoan, tk.MaNhanVien.ToString() });
}
}
return(new string[] { "", "" });
}
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 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 Page_Init(object sender, EventArgs e)
{
DynamicDataManager1.RegisterControl(DetailsView1);
db = new TRAVEL_WEBDataContext();
}
