public List <Customer> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.Customers.Where(c => c.isDeleted == false).ToList());
}
}
public List <TypeRoom> FindAllActive()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.TypeRooms.Where(t => t.isDeleted == false).ToList());
}
}
public List <Role> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.Roles.ToList());
}
}
public List <Customer> FindAllCustomerBooking()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.Customers.Where(c => c.isDeleted == false && c.isBooking.Equals("booking")).ToList());
}
}
public List <CardBookRoom> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.CardBookRooms.Include("Customer").Include("Room").ToList());
}
}
public List <TypeRoom> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
return(entities.TypeRooms.ToList());
}
}
public void Add(Role model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
entities.Roles.Add(model);
entities.SaveChanges();
}
}
public Bill FindById(int id)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Bills.FirstOrDefault(e => e.Id == id);
return((item != null) ? item : null);
}
}
public void Add(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
entities.TypeRooms.Add(model);
entities.SaveChanges();
}
}
public void Add(Customer model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
entities.Customers.Add(model);
entities.SaveChanges();
}
}
public void Delete(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.TypeRooms.FirstOrDefault(e => e.Id == model.Id);
entities.TypeRooms.Remove(item);
entities.SaveChanges();
}
}
public void Delete(Role model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var role = entities.Roles.FirstOrDefault(e => e.Id == model.Id);
entities.Roles.Remove(role);
entities.SaveChanges();
}
}
public void Delete(Customer model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var Customer = entities.Customers.FirstOrDefault(e => e.Id == model.Id);
entities.Customers.Remove(Customer);
entities.SaveChanges();
}
}
public List <PHONG> LoadAllPhong()
{
try
{
db = new QuanLyKhachSanDbContext();
return(db.PHONGs.ToList());
}
catch (Exception ex)
{
return(null);
}
}
public List <Employee> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
List <Employee> Employees = entities.Employees.Where(r => r.isDeleted == false).Include("Role").ToList();
foreach (Employee item in Employees)
{
Console.WriteLine("======>>>>>>>>> type Employee name: " + $"{item.Fullname}" + ": " + $"{item.Role.Name}");
}
return(Employees);
}
}
public List <Room> FindAll()
{
using (var entities = new QuanLyKhachSanDbContext())
{
List <Room> rooms = entities.Rooms.Where(r => r.isDeleted == false).Include("TypeRoom").ToList();
foreach (Room item in rooms)
{
Console.WriteLine("======>>>>>>>>> type room name: " + $"{item.NameRoom}" + ": " + $"{item.TypeRoom.Price}");
}
return(rooms);
}
}
public Role FindRoleIdByName(string nameRole)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Roles.Where(r => r.isDeleted == false).FirstOrDefault(e => e.Name.Equals(nameRole));
if (item != null)
{
return(item);
}
return(null);
}
}
public Customer FindById(int id)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Customers.FirstOrDefault(e => e.Id == id);
if (item != null)
{
return(item);
}
return(null);
}
}
public Room FindById(int id)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Rooms.Where(r => r.isDeleted == false).Include("TypeRoom").FirstOrDefault(e => e.Id == id);
if (item != null)
{
return(item);
}
return(null);
}
}
public Customer findCustomerBooking()
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Customers.Where(c => c.isDeleted == false && c.isBooking.Equals("booking")).FirstOrDefault();
if (item != null)
{
return(item);
}
return(null);
}
}
public CardBookRoom FindById(int id)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.CardBookRooms.Include("Customer").Include("Room").FirstOrDefault(e => e.Id == id);
if (item != null)
{
return(item);
}
return(null);
}
}
public void UpdateIsDeleted(Customer model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Customers.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
item.isDeleted = true;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void Update(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.TypeRooms.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
item.Id = model.Id;
item.NameTypeRoom = model.NameTypeRoom;
item.Price = model.Price;
item.NumberOfCustomer = model.NumberOfCustomer;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void Update(Role model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var role = entities.Roles.FirstOrDefault(e => e.Id == model.Id);
if (role != null)
{
role.Id = model.Id;
role.Name = model.Name;
role.Description = model.Description;
entities.Entry(role).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void UpdateNotPass(Employee model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Employees.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
item.Id = model.Id;
item.Fullname = model.Fullname;
item.Email = model.Email;
item.RoleId = model.RoleId;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void Update(Customer model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var Customer = entities.Customers.FirstOrDefault(e => e.Id == model.Id);
if (Customer != null)
{
Customer.Id = model.Id;
Customer.IDNumber = model.IDNumber;
Customer.NameCustomer = model.NameCustomer;
/*Customer.Address = model.Address;*/
Customer.TypeCustomer = model.TypeCustomer;
/* Customer.isBooking = model.isBooking;*/
entities.Entry(Customer).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void Update(Room model)
{
Console.WriteLine("id room in service update: " + model.Id);
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.Rooms.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
//item.Id = model.Id;
item.NameRoom = model.NameRoom;
item.Note = model.Note;
item.TypeRoomId = model.TypeRoomId;
item.Status = model.Status;
item.isDeleted = model.isDeleted;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public void Update(CardBookRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.CardBookRooms.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
//item.Id = model.Id;
item.CustomerId = model.CustomerId;
item.DateBookRoom = model.DateBookRoom;
item.DateReturnRoom = model.DateReturnRoom;
item.CountCustomers = model.CountCustomers;
item.RoomId = model.RoomId;
item.isDelete = model.isDelete;
item.PriceBookRoom = model.PriceBookRoom;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
