public ActionResult Edit(OrderViewModel model)
{
Orders view = db.Orders.Find(model.OrderID);
view.OrderDate = model.OrderDate;
view.RequiredDate = model.RequiredDate;
view.ShippedDate = model.ShippedDate;
view.ShipVia = model.ShipVia;
view.Freight = model.Freight;
view.ShipName = model.ShipName;
view.ShipAddress = model.ShipAddress;
view.ShipCity = model.ShipCity;
view.ShipRegion = model.ShipRegion;
view.ShipPostalCode = model.ShipPostalCode;
view.ShipCountry = model.ShipCountry;
view.EmployeeID = model.EmployeeID;
//view.LastName = model.Employees?.LastName;
view.CustomerID = model.CustomerID;
//view.CompanyName = model.Customers?.CompanyName;
ViewBag.CompanyName = new SelectList((from c in db.Customers select new { CustomerID = c.CustomerID, CompanyName = c.CompanyName }), "CustomerID", "CompanyName", null);
ViewBag.LastName = new SelectList((from e in db.Employees select new { EmployeeID = e.EmployeeID, LastName = e.LastName }), "EmployeeID", "LastName", null);
ViewBag.ShipVia = new SelectList((from o in db.Orders select new { OrderID = o.OrderID, ShipVia = o.ShipVia }), "OrderID ", "ShipVia", null);
db.SaveChanges();
return(View("Index"));
}//edit
public ActionResult Create([Bind(Include = "SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage")] Suppliers suppliers)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(suppliers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(suppliers));
}
public ActionResult Create([Bind(Include = "CategoryID,CategoryName,Description,Picture")] Categories categories)
{
if (ModelState.IsValid)
{
db.Categories.Add(categories);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categories));
}
public ActionResult Create([Bind(Include = "LoginID,UserName,PassWord,LoginErrorMessage")] Login login)
{
if (ModelState.IsValid)
{
db.Login.Add(login);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(login));
}
public ActionResult Create([Bind(Include = "ShipperID,CompanyName,Phone")] Shippers shippers)
{
if (ModelState.IsValid)
{
db.Shippers.Add(shippers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(shippers));
}
public ActionResult Create([Bind(Include = "TerritoryID,TerritoryDescription,RegionID")] Territories territories)
{
if (ModelState.IsValid)
{
db.Territories.Add(territories);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", territories.RegionID);
return(View(territories));
}
public ActionResult Create([Bind(Include = "OrderID,ProductID,UnitPrice,Quantity,Discount")] Order_Details order_Details)
{
if (ModelState.IsValid)
{
db.Order_Details.Add(order_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderID = new SelectList(db.Orders, "OrderID", "CustomerID", order_Details.OrderID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductName", order_Details.ProductID);
return(View(order_Details));
}
public ActionResult Create([Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued")] Products products)
{
if (ModelState.IsValid)
{
db.Products.Add(products);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", products.CategoryID);
ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", products.SupplierID);
return(View(products));
}
public ActionResult Create(CustomerViewModel model)
{
NorthwindDataEntities db = new NorthwindDataEntities();
Customers view = new Customers();
view.CustomerID = model.CustomerID;
view.CompanyName = model.CompanyName;
view.ContactName = model.ContactName;
view.ContactTitle = model.ContactTitle;
view.Address = model.Address;
view.City = model.City;
view.Region = model.Region;
view.PostalCode = model.PostalCode;
view.Country = model.Country;
view.Phone = model.Phone;
view.Fax = model.Fax;
db.Customers.Add(view);
//ViewBag.ReportsTo = new SelectList((from e in db.Employees select new { EmployeeID = e.EmployeeID, ReportsTo = e.ReportsTo }), "EmployeeID", "ReportsTo", null);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult Update(Customers cust)
{
NorthwindDataEntities entities = new NorthwindDataEntities();
string id = cust.CustomerID;
bool OK = false;
// onko kyseessä muokkaus vai uuden lisääminen?
if (id == "(uusi)")
{
// kyseessä on uuden asiakkaan lisääminen, kopioidaan kentät
Customers dbItem = new Customers()
{
CustomerID = cust.CompanyName.Substring(0, 5).Trim().ToUpper(), //luodaan CustomerID CompanyNamen 5:stä ensimmäisesta kirjaimesta isoilla kirjaimilla
CompanyName = cust.CompanyName,
Address = cust.Address,
City = cust.City
};
// tallennus tietokantaan
entities.Customers.Add(dbItem);
entities.SaveChanges();
OK = true;
}
else
{
// muokkaus, haetaan id:n perusteella riviä tietokannasta
Customers dbItem = (from c in entities.Customers
where c.CustomerID == id
select c).FirstOrDefault();
if (dbItem != null)
{
dbItem.CompanyName = cust.CompanyName;
dbItem.Address = cust.Address;
dbItem.City = cust.City;
// tallennus tietokantaan
entities.SaveChanges();
OK = true;
}
}
entities.Dispose();
return(Json(OK, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(EmployeesViewModel model)
{
Employees view = db.Employees.Find(model.EmployeeID);
view.LastName = model.LastName;
view.FirstName = model.FirstName;
view.Title = model.Title;
view.TitleOfCourtesy = model.TitleOfCourtesy;
view.BirthDate = model.BirthDate;
view.HireDate = model.HireDate;
view.Address = model.Address;
view.City = model.City;
view.Region = model.Region;
view.PostalCode = model.PostalCode;
view.Country = model.Country;
view.HomePhone = model.HomePhone;
view.Extension = model.Extension;
//view.Photo = model.Photo;
view.Notes = model.Notes;
view.ReportsTo = model.ReportsTo;
//view.PhotoPath = model.PhotoPath;
//if (cus.PinCodes == null)
//{
// PinCodes pic = new PinCodes();
// pic.PinCode = model.PinCode;
// //usr.Password = "******";
// pic.Customers = cus;
// db.PinCodes.Add(pic);
//}
//else
//{
// PinCodes pic = cus.PinCodes.FirstOrDefault();
// if (pic != null)
// {
// pic.PinCode = model.PinCode;
// }
//}
ViewBag.ReportsTo = new SelectList((from e in db.Employees select new { EmployeeID = e.EmployeeID, ReportsTo = e.ReportsTo }), "EmployeeID", "ReportsTo", null);
db.SaveChanges();
return(View("Index"));
}//edit
public ActionResult Edit(CustomerViewModel model)
{
Customers view = db.Customers.Find(model.CustomerID);
view.CustomerID = model.CustomerID;
view.CompanyName = model.CompanyName;
view.ContactName = model.ContactName;
view.ContactTitle = model.ContactTitle;
view.Address = model.Address;
view.City = model.City;
view.Region = model.Region;
view.PostalCode = model.PostalCode;
view.Country = model.Country;
view.Phone = model.Phone;
view.Fax = model.Fax;
db.SaveChanges();
return(View("Index"));
}//edit
public ActionResult Create(OrderViewModel model)
{
NorthwindDataEntities db = new NorthwindDataEntities();
Orders view = new Orders();
view.OrderDate = model.OrderDate;
view.RequiredDate = model.RequiredDate;
view.ShippedDate = model.ShippedDate;
view.ShipVia = model.ShipVia;
view.Freight = model.Freight;
view.ShipName = model.ShipName;
view.ShipAddress = model.ShipAddress;
view.ShipCity = model.ShipCity;
view.ShipRegion = model.ShipRegion;
view.ShipPostalCode = model.ShipPostalCode;
view.ShipCountry = model.ShipCountry;
view.EmployeeID = model.EmployeeID;
//view.LastName = model.Employees?.LastName;
view.CustomerID = model.CustomerID;
//view.CompanyName = model.Customers?.CompanyName;
ViewBag.CompanyName = new SelectList((from c in db.Customers select new { CustomerID = c.CustomerID, CompanyName = c.CompanyName }), "CustomerID", "CompanyName", null);
ViewBag.LastName = new SelectList((from e in db.Employees select new { EmployeeID = e.EmployeeID, LastName = e.LastName }), "EmployeeID", "LastName", null);
ViewBag.ShipVia = new SelectList((from o in db.Orders select new { OrderID = o.OrderID, ShipVia = o.ShipVia }), "OrderID ", "ShipVia", null);
db.Orders.Add(view);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create
public ActionResult DeleteCustomer(string id)
{
NorthwindDataEntities entities = new NorthwindDataEntities();
// etsitään id:n perusteella asiakasrivi kannasta
bool OK = false;
Customers dbItem = (from c in entities.Customers
where c.CustomerID == id
select c).FirstOrDefault();
if (dbItem != null)
{
// tietokannasta poisto
entities.Customers.Remove(dbItem);
entities.SaveChanges();
OK = true;
}
entities.Dispose();
return(Json(OK, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(EmployeesViewModel model)
{
NorthwindDataEntities db = new NorthwindDataEntities();
Employees view = new Employees();
view.LastName = model.LastName;
view.FirstName = model.FirstName;
view.Title = model.Title;
view.TitleOfCourtesy = model.TitleOfCourtesy;
view.BirthDate = model.BirthDate;
view.HireDate = model.HireDate;
view.Address = model.Address;
view.City = model.City;
view.Region = model.Region;
view.PostalCode = model.PostalCode;
view.Country = model.Country;
view.HomePhone = model.HomePhone;
view.Extension = model.Extension;
//view.Photo = model.Photo;
view.Notes = model.Notes;
view.ReportsTo = model.ReportsTo;
//view.PhotoPath = model.PhotoPath;
ViewBag.ReportsTo = new SelectList((from e in db.Employees select new { EmployeeID = e.EmployeeID, ReportsTo = e.ReportsTo }), "EmployeeID", "ReportsTo", null);
db.Employees.Add(view);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
}
return(RedirectToAction("Index"));
}//create