public List <Expanse> GetExpansesByDate(DateTime date)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Expanse.Where(e => e.ExpanseDate.Value.Year == date.Year && e.ExpanseDate.Value.Month == date.Month && e.ExpanseDate.Value.Day == date.Day).ToList());
}
}
public HouseHost GetHostByID(int hostID)
{
using (db = new ApartmentAutomationEntities())
{
return(db.HouseHost.FirstOrDefault(hh => hh.HostID == hostID));
}
}
public House GetHouseByID(int houseID)
{
using (db = new ApartmentAutomationEntities())
{
return(db.House.FirstOrDefault(h => h.HouseID == houseID));
}
}
public Apartment GetApartmentInfo()
{
using (db = new ApartmentAutomationEntities())
{
return(db.Apartment.FirstOrDefault());
}
}
public List <Income> GetIncomesByDate(DateTime date)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Income.Where(i => i.IncomeDate.Value.Year == date.Year && i.IncomeDate.Value.Month == date.Month && i.IncomeDate.Value.Day == date.Day).ToList());
}
}
public Expanse GetExpanseByID(int expanseID)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Expanse.Find(expanseID));
}
}
public List <House> GetHouses()
{
using (db = new ApartmentAutomationEntities())
{
return(db.House.ToList());
}
}
public bool IsAnyPersonRegistered()
{
using (db = new ApartmentAutomationEntities())
{
return(db.Person.Count() != 0 ? true : false);
}
}
public Person GetPersonByTc(string tc)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Person.FirstOrDefault(p => p.PersonTC == tc));
}
}
public Income GetIncomeByID(int incomeID)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Income.Find(incomeID));
}
}
public bool IsPasswordTrue(LoginVM loginVM)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Person.FirstOrDefault(p => p.PersonTC == loginVM.TC).PersonPassword == loginVM.Password ? true : false);
}
}
public bool IsTcTrue(string tc)
{
using (db = new ApartmentAutomationEntities())
{
return(db.Person.First().PersonTC == tc ? true : false);
}
}
public int NewExpanse(Expanse expanse)
{
using (db = new ApartmentAutomationEntities())
{
db.Expanse.Add(expanse);
return(db.SaveChanges());
}
}
public void NewHost(HouseHost houseHost)
{
using (db = new ApartmentAutomationEntities())
{
db.HouseHost.Add(houseHost);
db.SaveChanges();
}
}
public int NewIncome(Income income)
{
using (db = new ApartmentAutomationEntities())
{
db.Income.Add(income);
return(db.SaveChanges());
}
}
public void NewHouse(House house)
{
using (db = new ApartmentAutomationEntities())
{
db.House.Add(house);
db.SaveChanges();
}
}
public void NewApartment(Apartment apartment)
{
using (db = new ApartmentAutomationEntities())
{
db.Apartment.Add(apartment);
db.SaveChanges();
}
}
public int RegisterPerson(Person person)
{
using (db = new ApartmentAutomationEntities())
{
db.Person.Add(person);
return(db.SaveChanges());
}
}
public void RemoveExpanse(int expanseID)
{
using (db = new ApartmentAutomationEntities())
{
Expanse expanseToRemove = db.Expanse.FirstOrDefault(e => e.ExpenseID == expanseID);
db.Expanse.Remove(expanseToRemove);
db.SaveChanges();
}
}
public void RemoveIncome(int incomeID)
{
using (db = new ApartmentAutomationEntities())
{
Income incomeToRemove = db.Income.FirstOrDefault(i => i.IncomeID == incomeID);
db.Income.Remove(incomeToRemove);
db.SaveChanges();
}
}
public void UpdateHouse(House house)
{
using (db = new ApartmentAutomationEntities())
{
House houseToUpdate = db.House.FirstOrDefault(h => h.HouseID == house.HouseID);
houseToUpdate.HouseFloor = house.HouseFloor;
houseToUpdate.HouseNo = house.HouseNo;
houseToUpdate.HouseHostID = house.HouseHostID;
db.SaveChanges();
}
}
public void UpdateApartment(Apartment apartment)
{
using (db = new ApartmentAutomationEntities())
{
Apartment apartmentToUpdate = db.Apartment.FirstOrDefault(a => a.ApartmentID == apartment.ApartmentID);
apartmentToUpdate.ApartmentNo = apartment.ApartmentNo;
apartmentToUpdate.ApartmentName = apartment.ApartmentName;
apartmentToUpdate.ApartmentAddress = apartment.ApartmentAddress;
db.SaveChanges();
}
}
public void UpdatePerson(Person person)
{
using (db = new ApartmentAutomationEntities())
{
Person personToUpdate = db.Person.FirstOrDefault(p => p.PersonID == person.PersonID);
personToUpdate.PersonName = person.PersonName;
personToUpdate.PersonLastName = person.PersonLastName;
personToUpdate.PersonTC = person.PersonTC;
personToUpdate.PersonPassword = person.PersonPassword;
db.SaveChanges();
}
}
public void UpdateIncome(Income income)
{
using (db = new ApartmentAutomationEntities())
{
Income incomeToUpdate = db.Income.FirstOrDefault(i => i.IncomeID == income.IncomeID);
incomeToUpdate.IncomeName = income.IncomeName;
incomeToUpdate.IncomeDescription = income.IncomeDescription;
incomeToUpdate.IncomePrice = income.IncomePrice;
income.IncomeDate = income.IncomeDate;
db.SaveChanges();
}
}
public void UpdateExpanse(Expanse expanse)
{
using (db = new ApartmentAutomationEntities())
{
Expanse expanseToUpdate = db.Expanse.FirstOrDefault(e => e.ExpenseID == expanse.ExpenseID);
expanseToUpdate.ExpenseName = expanse.ExpenseName;
expanseToUpdate.ExpanseDescription = expanse.ExpanseDescription;
expanseToUpdate.ExpansePrice = expanse.ExpansePrice;
expanseToUpdate.ExpanseDate = expanse.ExpanseDate;
db.SaveChanges();
}
}
public void UpdateHost(HouseHost houseHost)
{
using (db = new ApartmentAutomationEntities())
{
HouseHost hostToUpdate = db.HouseHost.FirstOrDefault(hh => hh.HostID == houseHost.HostID);
hostToUpdate.HostName = houseHost.HostName;
hostToUpdate.HostLastName = houseHost.HostLastName;
hostToUpdate.HostPhone = houseHost.HostPhone;
hostToUpdate.HostTC = houseHost.HostTC;
hostToUpdate.HostIsRemoved = false;
db.SaveChanges();
}
}
