public List <Staff> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Staffs.ToList());
}
}
public List <ProductViewModel> Products()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
var products = new List <ProductViewModel>();
var result = from a in db.Products
join tt in db.Categories on a.CategoryID equals tt.CategoryID
select new
{
a.ProductID,
a.CategoryID,
a.ProductName,
a.Price,
a.Status,
a.ProductImage,
tt.CategoryName
};
foreach (var urun in result)
{
products.Add(new ProductViewModel
{
ProductID = urun.ProductID,
CategoryID = urun.CategoryID,
ProductName = urun.ProductName,
Price = urun.Price,
Status = urun.Status,
CategoryName = urun.CategoryName,
ProductImage = urun.ProductImage
});
}
return(products);
}
}
public List <ProductOrderViewModel> ProductOrders()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
var orders = new List <ProductOrderViewModel>();
var result = from a in db.ProductOrders
join tt in db.Products on a.ProductID equals tt.ProductID
select new
{
a.OrderID,
a.ProductID,
a.TableID,
a.ProductPiece,
a.OrderNote,
a.OrderStatus,
tt.ProductName
};
foreach (var productorder in result)
{
orders.Add(new ProductOrderViewModel
{
OrderID = productorder.OrderID,
ProductID = productorder.ProductID,
ProductPiece = productorder.ProductPiece,
OrderStatus = productorder.OrderStatus,
ProductName = productorder.ProductName,
TableID = productorder.TableID
});
}
return(orders);
}
}
public Product Get(string productname)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Products.FirstOrDefault(x => x.ProductName == productname));
}
}
public List <Reservation> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Reservations.ToList());
}
}
public List <Title> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Titles.ToList());
}
}
public List <Product> GetCategoryProducts(int categoryid)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Products.Where(x => x.CategoryID == categoryid).ToList());
}
}
public Staff GetByUsername(string text)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Staffs.FirstOrDefault(x => x.UserName == text));
}
}
public List <ProductOrder> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.ProductOrders.ToList());
}
}
public List <Customer> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Customers.ToList());
}
}
public Addition GetByPrice(int price)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Additions.FirstOrDefault(a => a.TotalPrice == price));
}
}
public Customer Get(int id)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Customers.FirstOrDefault(x => x.CustomerID == id));
}
}
public Staff Get(int id)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Staffs.Find(id));
}
}
public List <Category> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Categories.ToList());
}
}
public Reservation Get(int id)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Reservations.FirstOrDefault(x => x.ReservationID == id));
}
}
public Table GetTable(int TableId)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Tables.Find(TableId));
}
}
public Product Get(int id)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Products.Find(id));
}
}
public List <AccountPayment> GetAll()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.AccountPayments.ToList());
}
}
public Staff GetUserr(string username, string pass) //Kullancı Adına Göre Bilgileri Çağırmak için Oluşturduk.
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Staffs.Where(s => s.UserName == username && s.Password == pass).FirstOrDefault());
}
}
public void Insert(Table t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Tables.Add(t);
db.SaveChanges();
}
}
public void Insert(ProductOrder t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.ProductOrders.Add(t);
db.SaveChanges();
}
}
public void Insert(Customer t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Customers.Add(t);
db.SaveChanges();
}
}
public void Insert(AccountPayment t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.AccountPayments.Add(t);
db.SaveChanges();
}
}
public StaffState GetUser(string uname, string pass)//Kullanıcının Olup Olmadığını Kontrol Etmek İçin Oluşturduk.
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
return(db.Staffs.Where(s => s.UserName == uname && s.Password == pass).FirstOrDefault()
!= null ? StaffState.UserExists : StaffState.UserNotExists);
}
}
public void Insert(Staff t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Staffs.Add(t);
db.SaveChanges();
}
}
public void Insert(Reservation t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Reservations.Add(t);
db.SaveChanges();
}
}
public void Update(Addition t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Additions.Attach(t);
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public List <string> GetTable()
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
var table = db.Tables.Select(p => p.TableID.ToString()).ToList();
table.Insert(0, "Seçiniz...");
return(table);
}
}
public void Update(ProductOrder t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.ProductOrders.Attach(t);
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Delete(Reservation t)
{
using (RestoranDBEntities db = new RestoranDBEntities())
{
db.Reservations.Attach(t);
db.Entry(t).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
