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