private void LoginButton_Click(object sender, EventArgs e)
{
using (var Context = new GrandHotelContext())
{
var Login = (from s in Context.Employees where s.Username == UsernameTextBox.Text && s.Password == PasswordTextBox.Text select s).FirstOrDefault <Employee>();
if (Login.Job.Name == "Housekeeper")
{
var Go = new FrontOfficeMainForm();
this.Hide();
Go.Show();
}
else if (Login.Job.Name == "Housekeeper Supervisor")
{
var Go = new HousekeeperSupervisorForm();
this.Hide();
Go.Show();
}
else if (Login.Job.Name == "Admin")
{
var Go = new AdminForm();
this.Hide();
Go.Show();
}
else if (Login.Job.Name == "Front Office")
{
var Go = new FrontOfficeMainForm();
this.Hide();
Go.Show();
}
}
}
public List <CleaningRoomInformation> CRRepository()
{
using (GrandHotelContext Context = new GrandHotelContext())
{
return(Context.CleaningRooms.Select(a => new CleaningRoomInformation()
{
CleaningRoomId = a.CleaningRoomId,
EmployeeId = a.EmployeeId,
Date = a.Date
}).ToList());
}
}
public AccountController(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
IEmailSender emailSender,
ILogger <AccountController> logger,
GrandHotelContext context)
{
_userManager = userManager;
_signInManager = signInManager;
_emailSender = emailSender;
_logger = logger;
_context = context;
}
public List <CleaningRoomItemInformation> CRIRepository()
{
using (GrandHotelContext Context = new GrandHotelContext())
{
return(Context.CleaningRoomItems.Select(a => new CleaningRoomItemInformation()
{
CleaningRoomDetailId = a.CleaningRoomDetailId,
CleaningRoomItemId = a.CleaningRoomItemId,
ItemId = a.ItemId,
Qty = a.Qty,
Status = a.Status
}).ToList());
}
}
public ManageController(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
IEmailSender emailSender,
ILogger <ManageController> logger,
UrlEncoder urlEncoder,
GrandHotelContext context)
{
_userManager = userManager;
_signInManager = signInManager;
_emailSender = emailSender;
_logger = logger;
_urlEncoder = urlEncoder;
_context = context;
}
public List <CleaningRoomDetailInformation> CRDetailRepository()
{
using (GrandHotelContext Context = new GrandHotelContext())
{
return(Context.CleaningRoomDetails.Select(a => new CleaningRoomDetailInformation()
{
CleaningRoomDetailId = a.CleaningRoomDetailId,
CleaningRoomId = a.CleaningRoomId,
RoomId = a.RoomId,
StartDateTime = a.StartDateTime,
FinishDateTime = a.FinishDateTime,
Note = a.Note,
StatusCleaning = a.StatusCleaning
}).ToList());
}
}
private void LoadData()
{
using (GrandHotelContext Context = new GrandHotelContext())
{
var GetData = Context.RoomTypes.ToList <RoomType>();
var BindData = from s in Context.RoomTypes select new
{
s.Name,
s.Capacity,
s.RoomPrice
};
dataGridView1.DataSource = BindData.ToList();
dataGridView1.Columns[0].HeaderText = "Name";
dataGridView1.Columns[1].HeaderText = "Capacity";
dataGridView1.Columns[2].HeaderText = "Room Price";
}
}
private void LoadData()
{
using (var Context = new GrandHotelContext())
{
var GetData = from s in Context.Items
select new
{
s.Name,
s.RequestPrice,
s.CompensationFee
};
datagridv.DataSource = GetData.ToList();
}
datagridv.Columns[0].HeaderText = "Name";
datagridv.Columns[1].HeaderText = "Request Price";
datagridv.Columns[2].HeaderText = "Compensation Fee";
}
public LoginData(GrandHotelContext db)
{
this.db = db;
}
public ChambresController(GrandHotelContext context)
{
_context = context;
}
public ClientData(GrandHotelContext db)
{
this.db = db;
}
public ClientsController(GrandHotelContext context)
{
_context = context;
}
public ReservationData(GrandHotelContext db)
{
this.db = db;
}
public ReservationsController(GrandHotelContext context)
{
_context = context;
}
public FacturesController(GrandHotelContext context)
{
_context = context;
}
public FacturesController(GrandHotelContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public ClientsController(GrandHotelContext context, UserManager <ApplicationUser> userManager)
{
_userManager = userManager;
_context = context;
}
public ChambreData(GrandHotelContext db)
{
this.db = db;
chambre = new Chambre();
}
public FactureData(GrandHotelContext db)
{
this.db = db;
}
public AddData(GrandHotelContext db)
{
this.db = db;
}
