public ActionResult XacThucDangNhap(USER model)
{
if (!ModelState.IsValidField("USERNAME") && !ModelState.IsValidField("PASSWORD"))
{
ViewBag.PreviousPage = "Trang Chủ";
ViewBag.PreviousAction = "TrangChu";
ViewBag.PreviousController = "FrontEnd";
return(View("DangNhap", model));
}
else
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
USER getUser = (from user in DBEntities.USERs
where user.USERNAME == model.USERNAME && user.PASSWORD == model.PASSWORD
select user).FirstOrDefault <USER>();
if (getUser != null)
{
Session["userID"] = getUser.USER_ID;
Session["userName"] = getUser.USERNAME;
Session["userRole"] = getUser.ROLE_ID;
return(RedirectToAction("TrangChu", "FrontEnd"));
}
else
{
ViewBag.PreviousPage = "Trang Chủ";
ViewBag.PreviousAction = "TrangChu";
ViewBag.PreviousController = "FrontEnd";
ViewBag.Error = "Tài khoản hoặc mật khẩu không đúng !";
return(View("DangNhap", model));
}
}
}
}
public int layUserIdTuFacebookID(string facebookID)
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
int getID = (from user in DBEntities.USERs
where user.FACEBOOK_ID == facebookID
select user.USER_ID).FirstOrDefault <int>();
return(getID);
}
}
public USER layUserTuUserID(int userID)
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
USER getUser = (from user in DBEntities.USERs
where user.USER_ID == userID
select user).FirstOrDefault <USER>();
return(getUser);
}
}
//de em check ben em xai gi
public PROFILE layProfileTuUserID(int userID)
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
PROFILE getProfile = (from profile in DBEntities.PROFILEs
where profile.PROFILE_ID == userID
select profile).FirstOrDefault <PROFILE>();
return(getProfile);
}
}
// GET: FrontEnd
public ActionResult TrangChu()
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
Dictionary <int, string> stringCategory = new Dictionary <int, string>();
List <JOB_CATEGORY> jobCategory = (from category in DBEntities.JOB_CATEGORY select category).ToList();
foreach (JOB_CATEGORY category in jobCategory)
{
stringCategory.Add(category.CATEGORY_ID, category.CATEGORY_NAME);
}
ViewBag.stringCategory = stringCategory;
}
return(View());
}
public ActionResult DangKy()
{
ViewBag.PreviousPage = "Trang Chủ";
ViewBag.PreviousAction = "TrangChu";
ViewBag.PreviousController = "FrontEnd";
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
List <ROLE> roleList = (from role in DBEntities.ROLEs
where role.ROLE_ID == 2 || role.ROLE_ID == 3
select role).ToList();
SelectList resultList = new SelectList(roleList, "ROLE_ID", "ROLE_NAME");
ViewBag.RoleList = resultList;
return(View());
}
}
public bool dangKyUserFacebook(string facebookID, Dictionary <string, string> fbInfo)
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
using (var DBTransactions = DBEntities.Database.BeginTransaction())
{
try
{
USER newUser = new USER();
var generateID = (from user in DBEntities.USERs
orderby user.USER_ID descending
select user.USER_ID).Take(1).SingleOrDefault();
newUser.FACEBOOK_ID = facebookID;
newUser.USERNAME = facebookID + (generateID + 1);
newUser.PASSWORD = facebookID + "2019group21dotnetNLUHashing";
newUser.PASSWORDAGAIN = facebookID + "2019group21dotnetNLUHashing";
DateTime dateTime = DateTime.UtcNow.Date;
newUser.JOINED_DATE = dateTime.ToString("MM/dd/yyyy");
newUser.GMAIL_ID = Convert.ToString(generateID + 1);
newUser.USER_STATUS = (byte)1;
newUser.ROLE_ID = byte.Parse(fbInfo["roleID"]);
DBEntities.USERs.Add(newUser);
// tao xong user , tien hanh tao profile
PROFILE newProfile = new PROFILE();
newProfile.FIRST_NAME = fbInfo["fbFirstName"];
newProfile.LAST_NAME = fbInfo["fbLastName"];
newProfile.ADDRESS = fbInfo["fbHometown"];
newProfile.BIRTHDAY = fbInfo["fbBirthday"];
newProfile.EMAIL = fbInfo["fbEmail"];
newProfile.SEX = fbInfo["fbGender"];
DBEntities.PROFILEs.Add(newProfile);
DBEntities.SaveChanges();
DBTransactions.Commit();
return(true);
}
catch (Exception)
{
DBTransactions.Rollback();
DBEntities.Database.ExecuteSqlCommand("USE PartTimeJob;DECLARE @lastIdent int;SET @lastIdent = (SELECT TOP 1 USER_ID FROM[USER] ORDER BY USER_ID DESC);IF @lastIdent IS NULL BEGIN SET @lastIdent=1;END;DBCC CHECKIDENT('dbo.USER',RESEED,@lastIdent);");
DBEntities.Database.ExecuteSqlCommand("USE PartTimeJob;DECLARE @lastIdent int;SET @lastIdent = (SELECT TOP 1 PROFILE_ID FROM[PROFILE] ORDER BY PROFILE_ID DESC);IF @lastIdent IS NULL BEGIN SET @lastIdent=1;END;DBCC CHECKIDENT('dbo.PROFILE',RESEED,@lastIdent);");
return(false);
}
}
}
}
public bool kiemTraFacebookID(string facebookID)
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
string getFacebookID = (from user in DBEntities.USERs
where user.FACEBOOK_ID == facebookID
select user.FACEBOOK_ID).FirstOrDefault <string>();
if (getFacebookID != null)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult XacThucDangKy(USER model)
{
{
if (!ModelState.IsValid)
{
ViewBag.PreviousPage = "Trang Chủ";
ViewBag.PreviousAction = "TrangChu";
ViewBag.PreviousController = "FrontEnd";
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
List <ROLE> roleList = (from role in DBEntities.ROLEs
where role.ROLE_ID == 2 || role.ROLE_ID == 3
select role).ToList();
SelectList resultList = new SelectList(roleList, "ROLE_ID", "ROLE_NAME");
ViewBag.RoleList = resultList;
return(View("DangKy", model));
}
}
else
{
using (var DBEntities = new PartTimeJobEntitiesEntities())
{
using (var DBTransactions = DBEntities.Database.BeginTransaction())
{
USER getUser = (from user in DBEntities.USERs
where user.USERNAME == model.USERNAME
select user).FirstOrDefault <USER>();
if (getUser != null)
{
ViewBag.PreviousPage = "Trang Chủ";
ViewBag.PreviousAction = "TrangChu";
ViewBag.PreviousController = "FrontEnd";
List <ROLE> roleList = (from role in DBEntities.ROLEs
where role.ROLE_ID == 2 || role.ROLE_ID == 3
select role).ToList();
SelectList resultList = new SelectList(roleList, "ROLE_ID", "ROLE_NAME");
ViewBag.RoleList = resultList;
ViewBag.UsernameError = "Tài khoản này đã có người sử dụng";
return(View("DangKy", model));
}
else
{
try
{
USER newUser = model;
var generateID = (from user in DBEntities.USERs
orderby user.USER_ID descending
select user.USER_ID).Take(1).SingleOrDefault();
newUser.FACEBOOK_ID = Convert.ToString(generateID + 1);
newUser.GMAIL_ID = Convert.ToString(generateID + 1);
newUser.USER_STATUS = (byte)1;
DateTime dateTime = DateTime.UtcNow.Date;
newUser.JOINED_DATE = dateTime.ToString("MM/dd/yyyy");
DBEntities.USERs.Add(newUser);
// tao xong user , tien hanh tao profile
PROFILE newProfile = new PROFILE();
DBEntities.PROFILEs.Add(newProfile);
DBEntities.SaveChanges();
DBTransactions.Commit();
TempData["Message"] = "Chúc mừng tài khoản " + newUser.USERNAME + " đã đăng ký thành công !";
return(RedirectToAction("TrangChu", "FrontEnd"));
}catch (Exception)
{
DBTransactions.Rollback();
DBEntities.Database.ExecuteSqlCommand("USE PartTimeJob;DECLARE @lastIdent int;SET @lastIdent = (SELECT TOP 1 USER_ID FROM[USER] ORDER BY USER_ID DESC);IF @lastIdent IS NULL BEGIN SET @lastIdent=1;END;DBCC CHECKIDENT('dbo.USER',RESEED,@lastIdent);");
DBEntities.Database.ExecuteSqlCommand("USE PartTimeJob;DECLARE @lastIdent int;SET @lastIdent = (SELECT TOP 1 PROFILE_ID FROM[PROFILE] ORDER BY PROFILE_ID DESC);IF @lastIdent IS NULL BEGIN SET @lastIdent=1;END;DBCC CHECKIDENT('dbo.PROFILE',RESEED,@lastIdent);");
TempData["Message"] = "Có lỗi xảy ra trong hệ thống, vui lòng thử lại sau";
return(RedirectToAction("TrangChu", "FrontEnd"));
}
}
}
}
}
}
}
