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