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);
}
