void Application_PreRequestHandlerExecute(object sender, EventArgs e)
{
thuctaptotnghiepDbContext db = new thuctaptotnghiepDbContext();
var job = db.DangTinViecLams.Where(x => x.Ngayhethangjob != null && x.Tinhtrang != -2 && x.Ngayhethangjob.Value <= DateTime.Now).ToList();
if (job.Count() > 0)
{
job.ForEach(x => x.Tinhtrang = -2);
db.SaveChanges();
}
}
protected void Session_Start(object sender, EventArgs e)
{
thuctaptotnghiepDbContext db = new thuctaptotnghiepDbContext();
var allow = db.LuotTruyCaps.FirstOrDefault();
if (allow == null)
{
allow = new LuotTruyCap();
allow.today = 0;
allow.total = 0;
db.LuotTruyCaps.Add(allow);
}
if (allow.datetoday == null)
{
allow.datetoday = DateTime.Now;
if (allow.today == null)
{
allow.today = 1;
allow.total += 1;
}
else
{
allow.today += 1;
allow.total += 1;
}
}
else if (allow.datetoday.Value.Date == DateTime.Now.Date)
{
allow.today += 1;
allow.total += 1;
}
else
{
allow.datetoday = DateTime.Now;
allow.today = 1;
allow.total += 1;
}
db.SaveChanges();
}
public async Task <ActionResult> ExternalLoginCallback(string returnUrl)
{
string callback = returnUrl;
thuctaptotnghiepDbContext db = new thuctaptotnghiepDbContext();
var loginInfo = await AuthenticationManager.GetExternalLoginInfoAsync();
if (loginInfo == null)
{
return(RedirectToAction("Login"));
}
// Sign in the user with this external login provider if the user already has a login
var user = db.UngViens.Where(x => x.EmailDN == loginInfo.Email).FirstOrDefault();
//var user = await UserManager.FindAsync(loginInfo.Login);
if (user == null)
{
UngVien uv = new UngVien();
uv.Ten = loginInfo.DefaultUserName;
uv.EmailDN = loginInfo.Email;
uv.EmailLH = loginInfo.Email;
uv.Ngaydangky = DateTime.Now;
uv.Ngaycapnhat = DateTime.Now;
uv.Loaitaikhoan = 2;
uv.Tinhtrang = 1;
uv.vaitro = 1;
uv.Namkinhnghiem = 0;
db.UngViens.Add(uv);
db.SaveChanges();
var user1 = db.UngViens.Where(x => x.EmailDN == uv.EmailDN).FirstOrDefault();
//Directory.CreateDirectory(Server.MapPath("~/Profile_upload/" + user1.MAUV + ""));
Session["Member"] = new Member()
{
MAUV = user1.MAUV, Ten = uv.Ten, EmailDN = uv.EmailDN, Loaitaikhoan = uv.Loaitaikhoan
};
//return RedirectToAction("Profile", "Member");
if (callback == null || callback == "")
{
return(RedirectToAction("Profile", "Member"));
}
else
{
return(Redirect(callback));
}
}
else
{
if (user.Tinhtrang == 0)
{
TempData["Error"] = "Tài khoản của bạn đang tạm khóa vui lòng liên hệ với chúng tôi";
return(Redirect(callback));
}
if (user.Tinhtrang == -1)
{
TempData["Error"] = "Tài khoản của bạn hiện không đăng nhập được, vui lòng liên hệ với chúng tôi";
return(Redirect(callback));
}
if (user.vaitro == 1 && user.Tinhtrang == 1)
{
Session["Member"] = new Member()
{
MAUV = user.MAUV, Hovatendem = user.Hovatendem, Ten = user.Ten, EmailDN = user.EmailDN, Loaitaikhoan = user.Loaitaikhoan,
};
// If the user does not have an account, then prompt the user to create an account
if (callback == null)
{
return(RedirectToAction("Profile", "Member"));
}
else
{
return(Redirect(callback));
}
}
else if (user.vaitro == 2 && user.Tinhtrang == 1)
{
Session["Admin"] = new UngVien()
{
MAUV = user.MAUV, EmailDN = user.EmailDN, Hovatendem = user.Hovatendem, Ten = user.Ten, Loaitaikhoan = user.Loaitaikhoan, vaitro = user.vaitro
};
Session["SESSIONFILEPATH"] = "~/Content/Uploaded";
if (callback != null && callback != "")
{
return(Redirect(callback));
}
else
{
return(Redirect("~/Admin"));
}
}
else if (user.vaitro == 3)
{
Session["Supper"] = new UngVien()
{
MAUV = user.MAUV, EmailDN = user.EmailDN, Hovatendem = user.Hovatendem, Ten = user.Ten, Loaitaikhoan = user.Loaitaikhoan, vaitro = user.vaitro
};
Session["SESSIONFILEPATH"] = "~/Content/Uploaded";
if (callback != null && callback != "")
{
return(Redirect(callback));
}
else
{
return(Redirect("~/Admin"));
}
}
return(Redirect("/"));
}
}
public LoginMember()
{
Context = new thuctaptotnghiepDbContext();
}
