public ActionResult ChangeInfo(FormCollection data) { var accountID = data["accountID"]; var name = data["nameUser"]; var birthday = DateTime.Parse(data["birthday"]); var phone = data["phone"]; var sex = Int32.Parse(data["sex"]); var province = Int32.Parse(data["province"]); var district = Int32.Parse(data["district"]); using (var db = new QLTroEntities()) { Info accInfo = db.Infoes.SingleOrDefault(p => p.AccountID.Equals(accountID)); if (accInfo != null) { accInfo.Name = name; accInfo.Birthday = birthday; accInfo.Phone = phone; if (sex == 1) { accInfo.Sex = true; } else { accInfo.Sex = false; } accInfo.ProvinceID = province; accInfo.DistrictID = district; db.SaveChanges(); return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } } return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); }
public ActionResult CheckVerfiticationCode(string email, string code) { var timeCurrent = DateTime.Now.TimeOfDay; using (var db = new QLTroEntities()) { var ec = db.ConfirmEmails.SingleOrDefault(p => p.Email.Equals(email)); var t = timeCurrent.TotalSeconds - ec.Time.Value.TotalSeconds; var verfiticationCode = ec.VerificationCode; if (t > 900) { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } else { if (verfiticationCode.Equals(code)) { return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } } } }
public ActionResult Login(string userInput, string passwordInput) { //var StatusLogin = false; Account account = new Account(); using (var db = new QLTroEntities()) { account = db.Accounts.SingleOrDefault(p => p.AccountID.ToLower().Equals(userInput.ToLower()) && p.Password.Equals(passwordInput)); if (account != null && account.AccountStatusID == 1) { account.Password = ""; Session["account"] = account; var address = db.Infoes.SingleOrDefault(p => p.AccountID == account.AccountID); var districtName = db.Districts.SingleOrDefault(p => p.DistrictID == address.DistrictID).DistrictName; Session["address"] = address; Session["districtName"] = districtName; } } if (account.Role == 0) { return(RedirectToAction("AllAccount", controllerName: "Admin")); } else if (account.Role == 1) { return(RedirectToAction("AllPost", "User")); } else { return(RedirectToAction("ChangeInfo", "Account")); } }
public static string GetName(int criteriaID) { var result = string.Empty; using (var db = new QLTroEntities()) { result = db.Criteria.SingleOrDefault(p => p.CriteriaID == criteriaID).CriteriaName; } return(result); }
public ActionResult SignUp() { var listProvince = new List <Province>(); using (var db = new QLTroEntities()) { listProvince = db.Provinces.OrderBy(c => c.ProvinceName).ToList(); } return(View(listProvince)); }
public static string getTotalPost() { var s = string.Empty; using (var db = new QLTroEntities()) { s = db.Posts.Where(p => p.PostStatus == false).ToList().Count().ToString(); } return(s); }
public static SearchResult CreatePost(int postID) { SearchResult searchResult = new SearchResult(); using (var db = new QLTroEntities()) { searchResult = SearchResult.CreateSearchResult(postID); if (searchResult != null) { } } return(null); }
public ActionResult CheckEmailExist(string email) { using (var db = new QLTroEntities()) { var emailConfirm = db.ConfirmEmails.SingleOrDefault(p => p.Email.Equals(email)); if (emailConfirm != null) { return(Json(new { success = true, exist = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = true, exist = false }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult CheckCurrentPassword(string accountID, string currentPassword) { using (var db = new QLTroEntities()) { Account account = db.Accounts.SingleOrDefault(p => p.AccountID.Equals(accountID) && p.Password.Equals(currentPassword)); if (account != null) { return(Json(new { success = true, result = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, result = false }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult CheckExist(string accountId) { using (var db = new QLTroEntities()) { var account = db.Accounts.FirstOrDefault(p => p.AccountID.Equals(accountId)); if (account == null) { return(Json(new { success = true, result = false })); } else { return(Json(new { success = true, result = true })); } } }
public static List <string> getListImage(int?motelID) { List <string> listResult = new List <string>(); using (var db = new QLTroEntities()) { var listImage = db.Images.Where(p => p.MotelID == motelID).ToList(); foreach (var item in listImage) { var url = item.Url.ToString(); listResult.Add(url); } } return(listResult); }
public static List <SearchResult> CreateListSearchResult() { var listPost = new List <Post>(); var listSearchResult = new List <SearchResult>(); using (var db = new QLTroEntities()) { listPost = db.Posts.ToList(); } foreach (var post in listPost) { listSearchResult.Add(CreateSearchResult(post.PostID)); } return(listSearchResult); }
public ActionResult ChangePassWord(FormCollection data) { Account account = null; var acountID = data["accountID"]; var oldPassword = data["currentPassword"]; var newpassword = data["newPassword"]; using (var db = new QLTroEntities()) { account = db.Accounts.Single(p => p.AccountID.Equals(acountID) && p.Password.Equals(oldPassword)); account.Password = newpassword; db.SaveChanges(); } account.Password = ""; Session["account"] = account; return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult SignUp(FormCollection data) { var accountId = data["accountId"]; var password = data["password"]; var userName = data["userName"]; DateTime birthDate = DateTime.Parse(data["birthDate"]); var address = data["address"]; var phone = data["phone"]; var email = data["email"]; var city = data["city"]; var district = data["district"]; bool sex = true; if (data["sex"].Equals("1")) { sex = true; } else { sex = false; } int role = 0; if (data["role"].Equals("1")) { role = 1; } else { role = 2; } using (var db = new QLTroEntities()) { db.Accounts.Add(new Account() { AccountID = accountId, AccountStatusID = 1, Password = password, Role = role }); db.Infoes.Add(new Info() { AccountID = accountId, Name = userName, Sex = sex, Birthday = birthDate, Phone = phone, Email = email, ProvinceID = Int32.Parse(city), DistrictID = Int32.Parse(district) }); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public ActionResult ResetPassword(string accountID) { var newpass = RandomHelper.RandomNewPassword(); var email = string.Empty; using (var db = new QLTroEntities()) { var account = db.Accounts.Single(p => p.AccountID.Equals(accountID)); var accountInfo = db.Infoes.Single(p => p.AccountID.Equals(accountID)); email = accountInfo.Email; account.Password = newpass; db.SaveChanges(); string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/Mail/templateEmail.html")); content = content.Replace("{{content}}", "Mật khẩu mới của bạn là: " + newpass); MailHelper.sendMail(email, "Lấy lại mật khẩu", content); } return(Json(new { success = true, result = email }, JsonRequestBehavior.AllowGet)); }
public HomeModel CreateHomeModel() { List <Province> listProvince = new List <Province>(); List <Criterion> listCriterion = new List <Criterion>(); using (var db = new QLTroEntities()) { listProvince = db.Provinces.ToList(); listCriterion = db.Criteria.ToList(); } HomeModel homeModel = new HomeModel() { ListCriteria = listCriterion, ListProvince = listProvince }; return(homeModel); }
private List <PostViewModel> CreateListPostViewModel(List <SearchResult> listPosts) { List <PostViewModel> list = new List <PostViewModel>(); using (var db = new QLTroEntities()) { if (listPosts != null && listPosts.Count > 0) { foreach (var item in listPosts) { list.Add(new PostViewModel() { Post = item, ImageList = GetImage.getListImage(item.MotelID) }); } } } return(list); }
public static List <PostViewModel> CreateListPostViewModel(int provinceID, int districtID) { List <PostViewModel> list = new List <PostViewModel>(); using (var db = new QLTroEntities()) { var searchResult = SearchResult.CreateListSearchResult().Where(p => p.ProvinceID == provinceID && p.DistrictID == districtID && p.AccountStatus == 1 && p.PostStatus == true).ToList(); if (searchResult != null && searchResult.Count > 0) { foreach (var item in searchResult) { list.Add(new PostViewModel() { Post = item, ImageList = GetImage.getListImage(item.MotelID) }); } } } return(list); }
public ActionResult EmailConfirm(string email) { using (var db = new QLTroEntities()) { // Create Verifition Code var verfiticationCode = Helpers.RandomHelper.RandomVerificationCode().ToString(); ConfirmEmail emC = new ConfirmEmail() { Email = email, Time = DateTime.Now.TimeOfDay, VerificationCode = verfiticationCode }; db.ConfirmEmails.Add(emC); db.SaveChanges(); string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/Mail/templateEmail.html")); content = content.Replace("{{content}}", "Mã xác minh của bạn là: " + verfiticationCode + "<br><br>Mã xác minh có hiệu lực trong vòng 15 phút!"); MailHelper.sendMail(email, "Xác minh tài khoản Email", content); return(Json(new { success = true, exist = true }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ChangeInfo() { Account account = new Account(); if (Session["account"] == null) { return(RedirectToAction("Index", "Home")); } else { account = Session["account"] as Account; ChangeInfoModel changeInfoModel = new ChangeInfoModel(); using (var db = new QLTroEntities()) { var info = db.Infoes.SingleOrDefault(p => p.AccountID.Equals(account.AccountID)); changeInfoModel.InfoAccount = info; changeInfoModel.ProvinceAccount = db.Provinces.SingleOrDefault(p => p.ProvinceID == info.ProvinceID); changeInfoModel.DistrictAccount = db.Districts.SingleOrDefault(p => p.DistrictID == info.DistrictID); } return(View(changeInfoModel)); } }
public ActionResult CheckAccount(string userInput, string passwordInput) { using (var db = new QLTroEntities()) { Account account = db.Accounts.SingleOrDefault(p => p.AccountID.Equals(userInput) && p.Password.Equals(passwordInput)); if (account == null) { return(Json(new { success = true, result = false, locked = false })); } else { if (account.AccountStatusID == 2) { return(Json(new { success = true, result = true, locked = true })); } else { return(Json(new { success = true, result = true, locked = false })); } } } }
public DiscoverViewModel CreateDiscoverViewModel() { //load new post var q = from s in SearchResult.CreateListSearchResult() orderby s.PostDate descending select s; var listNewPosts = CreateListPostViewModel(q.ToList()); //load most view q = from s in SearchResult.CreateListSearchResult() orderby s.PostView descending select s; var listMostView = CreateListPostViewModel(q.ToList()); //load Cheapest q = from s in SearchResult.CreateListSearchResult() orderby s.Price ascending select s; var listPostsCheapest = CreateListPostViewModel(q.ToList()); //load post in month var month = DateTime.Now.Month; var year = DateTime.Now.Year; var listResult = SearchResult.CreateListSearchResult().Where(p => p.PostDate.Value.Month == month && p.PostDate.Value.Year == year).OrderBy(p => p.PostDate).ToList(); var listViewInMonth = CreateListPostViewModel(listResult).ToList(); var db = new QLTroEntities(); var discover = new DiscoverViewModel() { ListProvince = db.Provinces.ToList(), ListMostView = listMostView, ListNewPosts = listNewPosts, ListPostsCheapest = listPostsCheapest, ListPostsInMonth = listViewInMonth }; return(discover); }
public static SearchResult CreateSearchResult(int postID) { var acc = new Account(); var post = new Post(); var motel = new MotelRoom(); var info = new Info(); var province = new Province(); var district = new District(); var ward = new Ward(); List <int> listCriteria = new List <int>(); using (var db = new QLTroEntities()) { post = db.Posts.SingleOrDefault(p => p.PostID == postID); motel = db.MotelRooms.SingleOrDefault(p => p.MotelID == post.MotelID); info = db.Infoes.SingleOrDefault(p => p.AccountID.Equals(motel.AccountID)); acc = db.Accounts.SingleOrDefault(p => p.AccountID.Equals(motel.AccountID)); province = db.Provinces.SingleOrDefault(p => p.ProvinceID == motel.ProvinceID); district = db.Districts.SingleOrDefault(p => p.DistrictID == motel.DistrictID); ward = db.Wards.SingleOrDefault(p => p.WardID == motel.WardID); var list = db.MotelRooms.SingleOrDefault(p => p.MotelID == motel.MotelID).Criteria.ToList(); foreach (var item in list) { listCriteria.Add(item.CriteriaID); } } var searchResult = new SearchResult() { AccountID = motel.AccountID, AccountStatus = acc.AccountStatusID, PostID = post.PostID, PostTitle = post.PostTitle, PostDate = post.PostDate, PostView = post.PostView, MotelID = post.MotelID, Description = post.Description, PostStatus = post.PostStatus, Acreage = motel.Acreage, Price = motel.Price, ProvinceID = motel.ProvinceID, DistrictID = motel.DistrictID, WardID = motel.WardID, StatusID = motel.StatusID, Address = motel.Address, MaxPeople = motel.MaxPeople, ListCriteriaID = listCriteria, Name = info.Name, Sex = info.Sex, Birthday = info.Birthday, Phone = info.Phone, Email = info.Email, ProvinceName = province.ProvinceName, DistrictName = district.DistrictName, WardName = ward.WardName, Latitude = ward.Latitude, Longitude = ward.Longitude }; return(searchResult); }