public void Update(Tenant tenant)
{
using (var context = new ApartmentContext())
{
context.Entry(tenant).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Create(Apartment appartment)
{
using (var context = new ApartmentContext())
{
context.Apartments.Add(appartment);
context.SaveChanges();
}
}
public void Create(Tenant tenant)
{
using (var context = new ApartmentContext())
{
context.Tenants.Add(tenant);
context.SaveChanges();
}
}
public void Update(Reservation reservation)
{
using (var context = new ApartmentContext())
{
context.Entry(reservation).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Create(Reservation reservation)
{
using (var context = new ApartmentContext())
{
context.Reservations.Add(reservation);
context.SaveChanges();
}
}
public void Create(Homeowner homeowner)
{
using (var context = new ApartmentContext())
{
context.Homeowners.Add(homeowner);
context.SaveChanges();
}
}
private UserController SetupDefaultController()
{
var options = new DbContextOptionsBuilder <ApartmentContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
using (var context = new ApartmentContext(options))
{
context.Users.Add(new User {
Id = 1,
Username = "******",
Password = "******",
PasswordSalt = Convert.FromBase64String("SEfcsflTemzwn2t/MP00Mw=="),
Role = Role.Admin
});
context.Users.Add(new User {
Id = 2,
Username = "******",
Password = "******",
PasswordSalt = Convert.FromBase64String("tYwvfcbNoAFjLOgwhYpGaQ=="),
Role = Role.Realtor
});
context.Users.Add(new User {
Id = 3,
Username = "******",
Password = "******",
PasswordSalt = Convert.FromBase64String("BAV88E56WMdNcAU5y7ZDfw=="),
Role = Role.Client
});
context.SaveChanges();
}
var appSettings = new AppSettings {
Secret = "This is a test Secret string"
};
var appSettingOptions = new Mock <IOptions <AppSettings> >();
appSettingOptions.SetupGet(a => a.Value).Returns(appSettings);
var mapper = new Mock <IMapper>();
var controller = new UserController(
new ApartmentContext(options),
appSettingOptions.Object,
mapper.Object);
return(controller);
}
static void Main(string[] args)
{
//Adding a new person
using (var apartmentContext = new ApartmentContext())
{
Person newPerson = new Person
{
personID = 1,
personName = "Nihil",
personSurname = "Nia"
};
apartmentContext.Persons.Add(newPerson);
apartmentContext.SaveChanges();
}
// Adding debt to an exists person
using (var apartmentContext = new ApartmentContext())
{
Person existsPerson = apartmentContext.Persons.Find(1); //parameter is primary key which is I made it as personID
existsPerson.personDebts.Add(new Debt {
debtID = 1, personID = 123, currentDebt = 1000
});
apartmentContext.SaveChanges();
}
using (var apartmentContext = new ApartmentContext())
{
foreach (var person in apartmentContext.Persons)
{
Console.WriteLine("Person name: " + person.personName);
}
}
Console.ReadLine();
}
public IActionResult Create(ContractViewModel contractView)
{
if (ModelState.IsValid)
{
var contract = new Contract();
contract.ContractNo = contractView.ContractNo;
contract.EngageMonth = contractView.EngageMonth;
contract.ContractValue = contractView.ContractValue;
var customer = new Customer();
customer.CustomerName = contractView.CustomerName;
customer.BirthDay = contractView.BirthDay;
customer.Gender = contractView.Gender;
customer.IdentityCardNo = contractView.IdentityCardNo;
customer.DistrictId = contractView.DistrictId;
customer.ProvinceId = contractView.ProvinceId;
customer.PhoneNo = contractView.PhoneNo;
customer.Email = contractView.Email;
var room = new Room();
room.RoomNo = contractView.RoomNo;
room.RoomTypeId = contractView.RoomTypeId;
room.Price = contractView.Price;
room.Area = contractView.Area;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Provinces = new SelectList(_context.Province, "ProvinceId", "ProvinceName", contractView.ProvinceId);
if (contractView.ProvinceId != null)
{
ViewBag.Districts = new SelectList(_context.District.Where(x => x.ProvinceId == contractView.ProvinceId), "DistrictId", "DistrictName", contractView.DistrictId);
}
ViewBag.RoomTypes = new SelectList(_context.RoomType, "RoomTypeId", "RoomTypeName", contractView.RoomTypeId);
return(View(contractView));
}
private ApartmentController SetupDefaultController()
{
var options = new DbContextOptionsBuilder <ApartmentContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
using (var context = new ApartmentContext(options))
{
context.Users.Add(new User
{
Id = 2,
Username = "******",
Password = "******",
PasswordSalt = Convert.FromBase64String("tYwvfcbNoAFjLOgwhYpGaQ=="),
Role = Role.Realtor
});
context.Apartments.Add(new Apartment
{
Id = 1,
Name = "High living",
Description = "Come see the sights from up on high!",
Rooms = 5,
Area = 2000,
MonthlyPrice = 3540,
Latitude = 30,
Longitude = -95,
RealtorUserId = 2,
IsRented = false,
DateAdded = new DateTime(2020, 05, 31)
});
context.Apartments.Add(new Apartment
{
Id = 2,
Name = "Next to the water",
Description = "Relax with your own private dock.",
Rooms = 2,
Area = 2500,
MonthlyPrice = 1750,
Latitude = 28,
Longitude = -105,
RealtorUserId = 2,
IsRented = true,
DateAdded = new DateTime(2020, 02, 20)
});
context.Apartments.Add(new Apartment
{
Id = 3,
Name = "Low living",
Description = "Stay close to the pulse!",
Rooms = 1,
Area = 500,
MonthlyPrice = 999.99M,
Latitude = 45,
Longitude = -110,
RealtorUserId = 2,
IsRented = false,
DateAdded = new DateTime(2020, 03, 01)
});
context.SaveChanges();
}
var appSettings = new AppSettings {
Secret = "This is a test Secret string"
};
var appSettingOptions = new Mock <IOptions <AppSettings> >();
appSettingOptions.SetupGet(a => a.Value).Returns(appSettings);
var controller = new ApartmentController(
new ApartmentContext(options));
return(controller);
}
// Save
public void Save()
{
_context.SaveChanges();
} // end void Save()