public ActionResult DeleteConfirmed(string id)
{
Sales_Management sales_Management = db.Sales_Management.Find(id);
db.Sales_Management.Remove(sales_Management);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
Product_Management product_Management = db.Product_Management.Find(id);
Inventory_Control inventory_Control = db.Inventory_Control.Find(id);
Sales_Management sales_Management = db.Sales_Management.Find(id);
db.Product_Management.Remove(product_Management);
db.Inventory_Control.Remove(inventory_Control);
db.Sales_Management.Remove(sales_Management);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Sales_Management/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sales_Management sales_Management = db.Sales_Management.Find(id);
if (sales_Management == null)
{
return(HttpNotFound());
}
return(View(sales_Management));
}
public ActionResult Edit([Bind(Include = "ID,商品名,単価,販売価格,産地")] Product_Management product_Management)
{
if (ModelState.IsValid)
{
db.SaveChanges();
Models.Inventory_Control inventory_Control = new Inventory_Control();
Models.Sales_Management sales_Management = new Sales_Management();
db.Entry(product_Management).State = EntityState.Modified;
inventory_Control.ID = product_Management.ID;
sales_Management.ID = product_Management.ID;
inventory_Control.商品名 = product_Management.商品名;
sales_Management.商品名 = product_Management.商品名;
inventory_Control.単価 = product_Management.単価;
sales_Management.販売価格 = product_Management.販売価格;
inventory_Control.総個数 = (from inventory in db.Inventory_Control
where inventory.ID == product_Management.ID
select inventory.総個数).Single();
inventory_Control.総額 = (from inventory in db.Inventory_Control
where inventory.ID == product_Management.ID
select inventory.総額).Single();
inventory_Control.登録日時 = (from inventory in db.Inventory_Control
where inventory.ID == product_Management.ID
select inventory.登録日時).Single();
sales_Management.販売個数 = (from sales in db.Sales_Management
where sales.ID == product_Management.ID
select sales.販売個数).Single();
sales_Management.合計金額 = (from sales in db.Sales_Management
where sales.ID == product_Management.ID
select sales.合計金額).Single();
sales_Management.登録日時 = (from sales in db.Sales_Management
where sales.ID == product_Management.ID
select sales.登録日時).Single();
db.Entry(inventory_Control).State = EntityState.Modified;
db.Entry(sales_Management).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product_Management));
}
public ActionResult Create([Bind(Include = "ID,商品名,単価,販売価格,産地")] Product_Management product_Management)
{
if (ModelState.IsValid)
{
Models.Inventory_Control inventory_Control = new Inventory_Control();
Models.Sales_Management sales_Management = new Sales_Management();
db.Inventory_Control.Add(inventory_Control);
db.Product_Management.Add(product_Management);
db.Sales_Management.Add(sales_Management);
inventory_Control.ID = product_Management.ID;
sales_Management.ID = product_Management.ID;
inventory_Control.商品名 = product_Management.商品名;
sales_Management.商品名 = product_Management.商品名;
inventory_Control.単価 = product_Management.単価;
sales_Management.販売価格 = product_Management.販売価格;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product_Management));
}
public ActionResult Edit([Bind(Include = "ID,商品名,販売価格,販売個数,合計金額,登録日時")] Sales_Management sales_Management)
{
if (ModelState.IsValid)
{
db.Entry(sales_Management).State = EntityState.Modified;
sales_Management.ID = (from sales in db.Product_Management
where sales.ID == sales_Management.ID
select sales.ID).Single();
sales_Management.商品名 = (from sales in db.Product_Management
where sales.ID == sales_Management.ID
select sales.商品名).Single();
sales_Management.販売価格 = (from sales in db.Product_Management
where sales.ID == sales_Management.ID
select sales.販売価格).Single();
sales_Management.合計金額 = sales_Management.販売価格 * sales_Management.販売個数;
sales_Management.登録日時 = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sales_Management));
}
