static void Main(string[] args)
{
northwindEntities db1 = new northwindEntities();
northwindEntities db2 = new northwindEntities();
//Categories can be added simultaneously
for (int i = 0; i < 10; i++)
{
db1.Categories.Add(new Category()
{
CategoryName = "NewCategory" + i
});
db2.Categories.Add(new Category()
{
CategoryName = "NewCategory" + i
});
db1.SaveChanges();
db2.SaveChanges();
}
//Editin same entry
var firstEntry = db1.Categories.Where((x) => x.CategoryName == "NewCategory0").First();
firstEntry.CategoryName = "Lol";
var sameEntry = db2.Categories.Where(x => x.CategoryName == "NewCategory0").First();
db2.Categories.Remove(sameEntry);
//Removing an entry before editing it throws an exception
//db2.SaveChanges();
db1.SaveChanges();
}
public void InsertNewItem(OrderedDictionary newValues)
{
Category category = new Category();
LoadNewValues(category, newValues);
dataBase.Categories.Add(category);
dataBase.SaveChanges();
}
public ActionResult Create([Bind(Include = "ContactID,ContactType,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Extension,Fax,HomePage,PhotoPath,Photo")] Contacts contacts)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contacts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contacts));
}
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 = "CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax")] Customers customers)
{
if (ModelState.IsValid)
{
db.Customers.Add(customers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customers));
}
public ActionResult Create([Bind(Include = "EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Photo,Notes,ReportsTo,PhotoPath")] emp_apu emp_apu)
{
if (ModelState.IsValid)
{
db.emp_apu.Add(emp_apu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(emp_apu));
}
public ActionResult Edit([Bind(Include = "ShipperID, CompanyName, Phone, RegionID")] Shippers shipper) //haetaan ShipperID jne kentät...? tämä jäi vähän hämäräksi
{
if (ModelState.IsValid)
{
db.Entry(shipper).State = EntityState.Modified;
db.SaveChanges();
ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", shipper.RegionID);
return(RedirectToAction("Index"));
}
return(View(shipper));
}
[ValidateAntiForgeryToken] //Katso https://go.microsoft.com/fwlink/?LinkId=317598
public ActionResult Edit([Bind(Include = "ShipperID,CompanyName,Phone,RegionID")] Shippers shipper)
{
if (ModelState.IsValid)
{
entities.Entry(shipper).State = EntityState.Modified;
entities.SaveChanges();
ViewBag.RegionID = new SelectList(entities.Region, "RegionID", "RegionDescription", shipper.RegionID);
return(RedirectToAction("Index"));
}
return(View(shipper));
}
public ActionResult Create(string CustomerID, string CompanyName, string ContactName, string ContactTitle, string Country, string City, string Region, string Address, string PostalCode, string Phone, string Fax)
{
bool isError = false;
if (string.IsNullOrWhiteSpace(CustomerID))
{
ModelState.AddModelError("CustomerID", "客戶編號為必填");
isError = true;
}
else
{
ModelState.AddModelError("CustomerID", "");
}
if (string.IsNullOrWhiteSpace(CompanyName))
{
ModelState.AddModelError("CompanyName", "公司名稱為必填");
isError = true;
}
else
{
ModelState.AddModelError("CompanyName", "");
}
if (isError)
{
return(View());
}
Customers cust = new Customers();
cust.CustomerID = CustomerID;
cust.CompanyName = CompanyName;
cust.ContactName = ContactName;
cust.ContactTitle = ContactTitle;
cust.Country = Country;
cust.City = City;
cust.Region = Region;
cust.Address = Address;
cust.PostalCode = PostalCode;
cust.Phone = Phone;
cust.Fax = Fax;
db.Customers.Add(cust);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
ViewBag.Message = "新增資料發生錯誤：" + ex.Message;
return(View());
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,ReportsTo")] Employees employees)
{
if (ModelState.IsValid)
{
db.Employees.Add(employees);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReportsTo = new SelectList(db.Employees, "EmployeeID", "LastName", employees.ReportsTo);
return(View(employees));
}
public ActionResult Create([Bind(Include = "ShipperID,RegionID,CompanyName,Phone")] Shippers shippers)
{
if (ModelState.IsValid)
{
db.Shippers.Add(shippers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", shippers.RegionID);
return(View(shippers));
}
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.Model.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([Bind(Include = "OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry")] Orders orders)
{
if (ModelState.IsValid)
{
db.Orders.Add(orders);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CompanyName", orders.CustomerID);
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", orders.EmployeeID);
ViewBag.ShipVia = new SelectList(db.Shippers, "ShipperID", "CompanyName", orders.ShipVia);
return(View(orders));
}
static void InsertOrder(string customerID, DateTime orderDate, string address, params Tuple <int, int>[] products)
{
Order newOrder = new Order()
{
CustomerID = customerID,
OrderDate = orderDate,
ShipAddress = address
};
var insertedOrder = db.Orders.Add(newOrder);
foreach (var prod in products)
{
Order_Detail newDetail = new Order_Detail()
{
OrderID = insertedOrder.OrderID,
ProductID = prod.Item1,
Quantity = (short)prod.Item2
};
db.Order_Details.Add(newDetail);
}
db.SaveChanges();
}
public ActionResult Duzenle(Products model)
{
if (!ModelState.IsValid)
{
ModelState.AddModelError("", "Hatalı bir işlemi başarısız");
return(View(model));
}
var db = new northwindEntities();
var urun = db.Products.Find(model.ProductID);
if (urun == null)
{
return(RedirectToAction("Index", "Home"));
}
try
{
urun.ProductName = model.ProductName;
urun.UnitPrice = model.UnitPrice;
urun.UnitsInStock = model.UnitsInStock;
urun.Discontinued = model.Discontinued;
urun.CategoryID = model.CategoryID;
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("", "Güncelle işlemi başarısız");
return(View(model));
}
//return View(model);
return(RedirectToAction("Duzenle", new { id = urun.ProductID }));
}
public ActionResult Edit([Bind(Include = "ShipperID, CompanyName, Phone, RegionID")] Shippers shipperi)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("login", "home"));
}
else
{
if (ModelState.IsValid)
{
db.Entry(shipperi).State = EntityState.Modified;
db.SaveChanges();
ViewBag.RegionID = new SelectList(db.Region, "RegionID", "RegionDescription", shipperi.RegionID);
return(RedirectToAction("Index"));
}
return(View(shipperi));
}
}
public static bool InsertCustomer(int customerId, string companyName, string contactName, string country, string phone)
{
Customer newCustomer = new Customer()
{
CustomerID = Convert.ToString(customerId),
CompanyName = companyName,
ContactName = contactName,
Country = country,
Phone = phone
};
db.Customers.Add(newCustomer);
if (db.SaveChanges() == 1)
{
return(true);
}
return(false);
}
// POST api/values
public void Post(Book value)
{
Book book = value;
northwindEntities context = new northwindEntities();
Product product = new Product();
product.ProductName = book.title;
context.Products.Add(product);
context.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
Product p = new Product()
{
ProductName = TextBox1.Text,
UnitPrice = decimal.Parse(TextBox2.Text),
UnitsInStock = short.Parse(TextBox3.Text),
CategoryID = Convert.ToInt32(DropDownList1.SelectedValue)
};
db.Products.Add(p);
db.SaveChanges();
Response.Redirect("SelectData.aspx");
}
public ActionResult Yeni(Products model)
{
var urun = new Products()
{
ProductName = model.ProductName,
UnitPrice = model.UnitPrice,
Discontinued = model.Discontinued,
CategoryID = model.CategoryID,
UnitsInStock = model.UnitsInStock
};
try
{
var db = new northwindEntities();
db.Products.Add(urun);
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
return(RedirectToAction("Duzenle", new { id = urun.ProductID }));
}