public List <DetailOrderInformation> DetailJoint()
{
DetailOrderInformation info = new DetailOrderInformation();
using (var context = new RestaurantkuContext())
{
return(this.DetailInfo());
}
}
public List <MenuInformation> MenuInfo()
{
using (var Context = new RestaurantkuContext())
{
return(Context.msmenus.Select(a => new MenuInformation()
{
MenuId = a.menuid,
Name = a.name,
price = a.price,
photo = a.photo,
PhotoPath = a.path
}).ToList());
}
}
public List <DetailOrderInformation> DetailInfo()
{
using (var Context = new RestaurantkuContext())
{
return(Context.detailorders.Select(a => new DetailOrderInformation()
{
detailid = a.detailid,
orderid = a.orderid,
menuid = a.menuid,
qty = a.qty,
total = a.total,
status = a.status
}).ToList());
}
}
public List <HeaderOrderInformation> HeaderInfo()
{
using (var Context = new RestaurantkuContext())
{
return(Context.headorders.Select(a => new HeaderOrderInformation()
{
orderid = a.orderid,
employeeid = a.employeeid,
bank = a.bank,
date = a.date,
memberid = a.memberid,
payment = a.payment
}).ToList());
}
}
public List <EmployeeInformation> GetEmpData()
{
using (var Context = new RestaurantkuContext())
{
return(Context.msemployees.Select(a => new EmployeeInformation()
{
EmployeeId = a.employeeid,
EmployeeEmail = a.email,
EmployeeName = a.name,
EmployeePassword = a.password,
EmployeeeHandPhone = a.handphone,
EmployeePosition = a.position
}).ToList());
}
}
public List <MemberInformation> MemberInfo()
{
using (var Context = new RestaurantkuContext())
{
return(Context.msmembers.Select(a => new MemberInformation()
{
MemberId = a.memberid,
MemberEmail = a.email,
MemberName = a.name,
MemberPassword = a.password,
JoinDate = a.joindate.ToString(),
HandPhone = a.handphone,
BankName = a.BankName,
AccNumber = a.AccNumber,
CCNumber = a.CCNumber,
Address = a.Address,
Deleted = a.Deleted
}).ToList());
}
}
