public static List <Product> ProductId(int id)
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Products.Where(p => p.ProductID == id).ToList());
}
}
public static Admin AdminLogin(Admin model)
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Admin.FirstOrDefault(a => a.Email == model.Email && a.Password == a.Password));
}
}
public static List <Customer> CustomerList()
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Customers.ToList());
}
}
public static List <Product> GetAllForHome()
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Products.ToList());
}
}
public static Customer GetCustomer(Customer customer)
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Customers.FirstOrDefault(c => c.Email == customer.Email));
}
}
public static void Add(Customer model)
{
using (YemekDBContext db = new YemekDBContext())
{
db.Customers.Add(model);
db.SaveChanges();
}
}
public static void Add(Concent model)
{
using (YemekDBContext db = new YemekDBContext())
{
db.Concents.Add(model);
db.SaveChanges();
}
}
public static void DeleteMenu(int id)
{
using (YemekDBContext db = new YemekDBContext())
{
var result = db.Menu.FirstOrDefault(m => m.MenuID == id);
result.IsDelete = true;
db.SaveChanges();
}
}
static void Main(string[] args)
{
using (YemekDBContext db = new YemekDBContext())
{
Product pr = new Product();
pr.ProductName = "Baklava";
pr.ProductPrice = 4;
pr.ProductType = ProductType.Dessert;
db.Products.Add(pr);
db.SaveChanges();
}
}
public ActionResult Login(Admin model)
{
using (YemekDBContext db = new YemekDBContext())
{
var result = AdminRepo.AdminLogin(model);
if (result != null)
{
FormsAuthentication.SetAuthCookie(model.Email, true);
return(RedirectToAction("Add", "Admin"));
}
return(View());
}
}
public ActionResult Delete(int id)
{
//var result=MenuRepo.DeleteMenu(id);
// var model = MenuRepo.AdminMenuList(id);
//return RedirectToAction("Home", "Admin");
using (YemekDBContext db = new YemekDBContext())
{
var result = db.Menu.FirstOrDefault(m => m.MenuID == id);
result.IsDelete = true;
db.SaveChanges();
return(RedirectToAction("AdminMenuList", new { menuDate = result.Datetime }));
}
}
public static void AddMenu(Product product)
{
using (YemekDBContext db = new YemekDBContext())
{
Menu menu = new Menu()
{
ProductID = product.ProductID,
Datetime = DateTime.Today
};
db.Menu.Add(menu);
db.SaveChanges();
}
}
public static List <ViewMail> Menu()
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Menu.Where(m => m.Datetime == DateTime.Today && m.IsDelete == false)
.Select(m => new ViewMail
{
Sifre = "Hakan123.",
GondericiMail = "*****@*****.**",
GonderilecekMail = m.Product.ProductName,
Konu = "Yemek Listesi"
}).ToList());
}
}
public static List <ViewMenu> AdminMenuList(DateTime datetime)
{
using (YemekDBContext db = new YemekDBContext())
{
return(db.Menu.Where(m => m.Datetime == datetime && m.IsDelete == false)
.Select(m => new ViewMenu
{
ProductID = m.ProductID,
MenuID = m.MenuID,
Datetime = m.Datetime,
ProductName = m.Product.ProductName,
ProductPrice = m.Product.ProductPrice,
ProductType = m.Product.ProductType
}).ToList());
}
}
