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