public Kitchen()
{
InitializeComponent();
DTO = new KitchenDTO();
sqlCon = new SqlConnection("Data Source=DESKTOP-63Q74F5;Initial Catalog=Project;Integrated Security=True");
cmd = new SqlCommand();
}
public KitchenDTO GetbyID(int id)
{
KitchenDTO kitchenDTO = new KitchenDTO();
var item = dbcontext.Kitchens.Where(x => x.Kitchen_ID == id).FirstOrDefault();
kitchenDTO.Kitchen_ID = item.Kitchen_ID;
kitchenDTO.Kitchen_Name = item.Kitchen_Name;
return(kitchenDTO);
}
public void Create(KitchenDTO kitchenDTO)
{
Kitchen kitchen = new Kitchen();
kitchen.Kitchen_ID = kitchenDTO.Kitchen_ID;
kitchen.Kitchen_Name = kitchenDTO.Kitchen_Name;
dbcontext.Entry(kitchen).State = EntityState.Added;
dbcontext.SaveChanges();
}
public void Edit(KitchenDTO kitchenDTO)
{
Kitchen kitchen = new Kitchen();
if (kitchenDTO.Kitchen_ID > 0)
{
kitchen.Kitchen_ID = kitchenDTO.Kitchen_ID;
kitchen.Kitchen_Name = kitchenDTO.Kitchen_Name;
dbcontext.Entry(kitchen).State = EntityState.Modified;
dbcontext.SaveChanges();
}
}
public List <KitchenDTO> GetKitchens()
{
List <KitchenDTO> kitchenlistDTO = new List <KitchenDTO>();
var room = dbcontext.Kitchens.ToList();
if (room != null)
{
foreach (var item in room)
{
KitchenDTO kitchen = new KitchenDTO();
kitchen.Kitchen_ID = item.Kitchen_ID;
kitchen.Kitchen_Name = item.Kitchen_Name;
kitchenlistDTO.Add(kitchen);
}
}
return(kitchenlistDTO);
}
public ActionResult Edit(KitchenDTO kitchenDTO)
{
_db.Edit(kitchenDTO);
return(RedirectToAction("Index"));
}
public ActionResult Create(KitchenDTO kitchenDTO)
{
_db.Create(kitchenDTO);
return(RedirectToAction("Index"));
}
public void Edit(KitchenDTO kitchenDTO)
{
_db.Edit(kitchenDTO);
}
public void Create(KitchenDTO kitchenDTO)
{
_db.Create(kitchenDTO);
}
