public ActionResult FindUser(AuthModel model)
{
using (var db = new DalilakDatabaseEntities1())
{
var loged_user = db.Users.Where(m => m.Username == model.user.Username && m.Password == model.user.Password).FirstOrDefault();
if (loged_user != null)
{
//logged in
//goto suggeset
var identity = new ClaimsIdentity(new[] {
new Claim(ClaimTypes.Name, loged_user.Id.ToString())
},
"ApplicationCookie");
var ctx = Request.GetOwinContext();
var authManager = ctx.Authentication;
authManager.SignIn(identity);
return(RedirectToAction("Index", "Suggeset"));
}
else
{
//incorrect in username or password
ViewBag.ErrorMessage = "Incorrect username or password";
return(View("Login"));
}
}
}
public static List <Database.Area> LoadAreas()
{
using (var db = new DalilakDatabaseEntities1())
{
return(db.Areas.ToList());
}
}
public ActionResult AddLocation(LocationModel model)
{
using (var db = new DalilakDatabaseEntities1())
{
}
return(View());
}
public static List <Database.Category> LoadCategories()
{
using (var db = new DalilakDatabaseEntities1())
{
return(db.Categories.OrderBy(m => m.MenuOrder).ToList());
}
}
public ActionResult SaveUser(AuthModel model)
{
using (var db = new DalilakDatabaseEntities1())
{
db.Users.Add(model.user);
db.SaveChanges();
}
return(View("Login"));
}
public ActionResult SaveSuggeset(SuggesetModel model)
{
using (var db = new DalilakDatabaseEntities1())
{
model.suggeset.FK_UserID = long.Parse(User.Identity.Name);
db.Suggestes.Add(model.suggeset);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Map(long loc)
{
LocationModel model = new LocationModel();
using (var db = new DalilakDatabaseEntities1())
{
model.location = db.Locations.Where(m => m.Id == loc).FirstOrDefault();
}
return(View(model));
}
public ActionResult Index()
{
using (var db = new DalilakDatabaseEntities1())
{
ViewBag.cats = db.Categories.Select(m => new SelectListItem()
{
Text = m.CategoryName, Value = m.CategoryName
}).ToList();
}
return(View());
}
//public ActionResult LoadCategories(long areaId)
//{
// return View();
//}
public ActionResult loadlocations(long catId, long areaId)
{
LocationModel model = new LocationModel();
using (var db = new DalilakDatabaseEntities1())
{
var cat = db.Categories.Where(m => m.Id == catId).FirstOrDefault();
if (cat.CategoryName == "Companies")
{
return(View("Company", db.Companies.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Drug Addiction Recovery")
{
return(View("DrugAddictionRecoveryVilla", db.DrugAddictionRecoveryVillas.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Emergency Phone Number")
{
return(View("EmergencyPhoneNumber", db.EmergencyPhoneNumbers.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Football Curts")
{
return(View("FootballCurt", db.FootballCourts.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Gas Stations & Services ")
{
return(View("GasStations", db.GasStations.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Hospitals")
{
return(View("Hospitals", db.Hospitals.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Pharmacies")
{
return(View("Pharmacies", db.Pharmacies.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
else if (cat.CategoryName == "Restaurants")
{
return(View("Restaurants", db.Restaurants.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList()));
}
//model.Locations = db.Locations.Where(m => m.FK_Category == catId && m.FK_AreaId == areaId).ToList();
}
return(View(model));
}
public ActionResult Search(string Keyword, string category)
{
//var category = "Restaurants";
//LocationModel model = new LocationModel();
string lower_search = Keyword.ToLower();
using (var db = new DalilakDatabaseEntities1())
{
//if (category == "Restaurants")
//{
// var locatoin_list = db.Restaurants.Where(m =>
// (string.IsNullOrEmpty(lower_search)) ||
// (m.LocationName.ToLower().Contains(lower_search))).ToList();
// model.Locations = locatoin_list;
//}
if (category == "Companies")
{
var model = db.Companies.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.CompanyName.ToLower().Contains(lower_search))).ToList();
return(View("Company", model));
}
else if (category == "Drug Addiction Recovery")
{
var model = db.DrugAddictionRecoveryVillas.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.DrugAddictionRecoveryVillaName.ToLower().Contains(lower_search))).ToList();
return(View("DrugAddictionRecoveryVilla", model));
}
else if (category == "Emergency Phone Number")
{
var model = db.EmergencyPhoneNumbers.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.EmergencyPhoneNumberName.ToLower().Contains(lower_search))).ToList();
return(View("EmergencyPhoneNumber", model));
}
else if (category == "Football Curts")
{
var model = db.FootballCourts.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.FootballCourtName.ToLower().Contains(lower_search))).ToList();
return(View("FootballCurt", model));
}
else if (category == "Gas Stations & Services ")
{
var model = db.GasStations.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.GasStationName.ToLower().Contains(lower_search))).ToList();
return(View("GasStations", model));
}
else if (category == "Hospitals")
{
var model = db.Hospitals.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.HospitalName.ToLower().Contains(lower_search))).ToList();
return(View("Hospitals", model));
}
else if (category == "Pharmacies")
{
var model = db.Pharmacies.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.PharmacyName.ToLower().Contains(lower_search))).ToList();
return(View("Pharmacies", model));
}
else if (category == "Restaurants")
{
var model = db.Restaurants.Where(m =>
(string.IsNullOrEmpty(lower_search)) ||
(m.RestaurantsName.ToLower().Contains(lower_search))).ToList();
return(View("Restaurants", model));
}
}
return(View("loadlocations"));
}
