public static async Task <List <RealEstateOfficeMvc.Domain.FavouriteRealEstate> > ListOfFavourites() { using (var context = new RealEstateOfficeContext()) { return(await context.FavouriteRealEstates.ToListAsync()); } }
public async Task <IActionResult> AddUser() { string email = HttpContext.Request.Form["email"]; string name = HttpContext.Request.Form["Name"]; string surname = HttpContext.Request.Form["Surname"]; string login = HttpContext.Request.Form["Login"]; string password = HttpContext.Request.Form["Password"]; string userTyp = HttpContext.Request.Form["userTyp"]; using (var context = new RealEstateOfficeContext()) { var usr = new Domain.User(); usr.Emailaddress = email; usr.Name = name; usr.Surname = surname; usr.Login = login; usr.Password = UserDatabaseContext.codePassword(password); usr.UserType = Convert.ToInt32(userTyp); context.Add(usr); await context.SaveChangesAsync(); } return(RedirectToAction("Index", "Users")); }
public static void AddToDatabase(RealEstateOfficeMvc.Domain.Image image) { using (var context = new RealEstateOfficeContext()) { context.Images.Add(image); context.SaveChanges(); } }
public async static Task <RealEstateOfficeMvc.Domain.User> GetUserAsync(int id) { RealEstateOfficeMvc.Domain.User user = null; using (var context = new RealEstateOfficeContext()) { user = await(context.Users.SingleAsync(x => x.Id == id)); } return(user); }
public static async Task <List <RealEstateOfficeMvc.Domain.Image> > GetImagesAsync(int id) { List <RealEstateOfficeMvc.Domain.Image> imageList = new List <RealEstateOfficeMvc.Domain.Image>(); using (var context = new RealEstateOfficeContext()) { imageList = await context.Images.Where(x => x.RealEstateId == id).ToListAsync(); } return(imageList); }
public async Task <IActionResult> Unlike() { int realestateid = Convert.ToInt32(HttpContext.Request.Form["realestateid"]); using (var context = new RealEstateOfficeContext()) { var unlike = context.FavouriteRealEstates.Single(x => x.RealEstateId == realestateid); context.Remove(unlike); await context.SaveChangesAsync(); } return(RedirectToAction("Index", "Favourite")); }
public IActionResult RemoveUser() { string userid = HttpContext.Request.Form["userid"]; int userToDelete = Convert.ToInt32(userid); using (var context = new RealEstateOfficeContext()) { context.Remove(context.Users.Single(u => u.Id == userToDelete)); context.SaveChanges(); } return(RedirectToAction("Index", "Users")); }
public async Task <IActionResult> RemoveRealEstate() { string realestateid = HttpContext.Request.Form["realestateid"]; if (!int.TryParse(realestateid, out var id)) { //error } using (var context = new RealEstateOfficeContext()) { context.Remove(context.RealEstates.Single(r => r.Id == id)); await context.SaveChangesAsync(); } return(Redirect("/Home/Index/1")); }
public async Task <IActionResult> Like() { var number = Convert.ToInt32(HttpContext.Request.Form["realestateid"]); var userid = Convert.ToInt32(HttpContext.Session.GetString("SESSIONLOGINID")); var favourite = new FavouriteRealEstate(); favourite.UserId = userid; favourite.RealEstateId = number; using (var context = new RealEstateOfficeContext()) { context.FavouriteRealEstates.Add(favourite); await context.SaveChangesAsync(); } return(RedirectToAction("Index", "Favourite")); }
public async Task <IActionResult> EditUser(RealEstateOfficeMvc.Domain.User user) { int id = Convert.ToInt32((HttpContext.Request.Form["userid"])); using (var context = new RealEstateOfficeContext()) { var usr = context.Users.Single(x => x.Id == id); usr.Login = user.Login; usr.Name = user.Name; usr.Surname = user.Surname; usr.Emailaddress = user.Emailaddress; usr.UserType = user.UserType; await context.SaveChangesAsync(); } return(RedirectToAction("Index", "Users")); }
public async Task <IActionResult> SaveEditedEstate() { int id = Convert.ToInt32(HttpContext.Request.Form["id"]); using (var context = new RealEstateOfficeContext()) { var realEstate = context.RealEstates.Single(r => r.Id == id); realEstate.Price = Convert.ToDecimal(HttpContext.Request.Form["Price"]); realEstate.Area = Convert.ToInt32(HttpContext.Request.Form["Area"]); realEstate.Roomamount = Convert.ToInt32(HttpContext.Request.Form["RoomsAmount"]); realEstate.Ownername = HttpContext.Request.Form["OwnerName"]; realEstate.Ownersurname = HttpContext.Request.Form["OwnerSurname"]; realEstate.City = HttpContext.Request.Form["City"]; realEstate.Street = HttpContext.Request.Form["Street"]; realEstate.EstateAddress = HttpContext.Request.Form["EstateAddress"]; realEstate.Modificationdate = DateTime.Now; realEstate.Typeofrealestate = Convert.ToInt32(HttpContext.Request.Form["realestateType"]); await context.SaveChangesAsync(); } return(Redirect("/Home/Index/1")); }
public async Task <IActionResult> AddRealEstate() { bool isFormCorrect = true; if (!int.TryParse(HttpContext.Request.Form["realestateType"], out var realEstateType)) { isFormCorrect = false; } if (!decimal.TryParse(HttpContext.Request.Form["Price"], out var price)) { isFormCorrect = false; } if (!int.TryParse(HttpContext.Request.Form["Area"], out var area)) { isFormCorrect = false; } if (!int.TryParse(HttpContext.Request.Form["RoomsAmount"], out var roomsAmount)) { isFormCorrect = false; } string ownerName = HttpContext.Request.Form["OwnerName"]; if (String.IsNullOrEmpty(ownerName)) { isFormCorrect = false; } string ownerSurname = HttpContext.Request.Form["OwnerSurname"]; if (String.IsNullOrEmpty(ownerSurname)) { isFormCorrect = false; } string city = HttpContext.Request.Form["City"]; if (String.IsNullOrEmpty(city)) { isFormCorrect = false; } string street = HttpContext.Request.Form["Street"]; if (String.IsNullOrEmpty(street)) { isFormCorrect = false; } string estateAddress = HttpContext.Request.Form["EstateAddress"]; if (String.IsNullOrEmpty(estateAddress)) { isFormCorrect = false; } if (isFormCorrect == false) { return(RedirectToAction("Index", "RealEstate")); //tymczasowo, powinien być error } DateTime dt = DateTime.Now; dt.ToShortDateString(); using (var context = new RealEstateOfficeContext()) { var realest = new Domain.RealEstate(); realest.Typeofrealestate = realEstateType; realest.Price = price; realest.Area = area; realest.Roomamount = roomsAmount; realest.Ownername = ownerName; realest.Ownersurname = ownerSurname; realest.City = city; realest.Street = street; realest.EstateAddress = estateAddress; realest.Creationdate = dt; realest.Modificationdate = dt; context.RealEstates.Add(realest); await context.SaveChangesAsync(); } return(Redirect("/Home/Index/1")); }