public override void InitSample(string connectionString)
{
if (context != null)
{
context.Dispose();
}
context = CreateContext(connectionString);
}
public static bool AgregarUsuario(USERS persona, Security personaSecurity)
{
NorthwindEntities contexto = null;
//NorthwindEntities contexto2 = null;
try
{
contexto = new NorthwindEntities();
contexto.sp_Proyecto_InsertarUsuario(persona.Identificacion, persona.Nombre, persona.Primer_Apellido, persona.Segundo_Apellido, persona.Fecha_nacimiento, persona.Telefono, persona.Correo, persona.Direccion, persona.CREATEDATE);
contexto.sp_Proyecto_InsertarUsuarioSecurity(persona.Identificacion, personaSecurity.Nombre_Usuario, personaSecurity.clave, personaSecurity.TIPO_USUARIO, personaSecurity.Token);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (contexto != null)
{
contexto.Dispose();
}
}
}
public static bool AgregarPedido(Pedidos Pedidos)
{
NorthwindEntities contexto = null;
try
{
contexto = new NorthwindEntities();
contexto.Pedidos.Add(Pedidos);
contexto.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (contexto != null)
{
contexto.Dispose();
}
}
}
protected override void DisposeCore()
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
static void Main(string[] args)
{
Customers customer = new Customers();
customer.CustomerID = "NIDE";
customer.ContactName = "niky";
customer.Phone = "0883";
customer.Address = "test";
customer.City = "test";
customer.CompanyName = "test";
customer.ContactTitle = "test";
customer.Country = "test";
customer.Fax = "test";
customer.Phone = "test";
customer.PostalCode = "test";
customer.Region = "test";
DAOClass.Insert(customer);
NorthwindEntities database = new NorthwindEntities();
var customerToModifyAndDelete = (from p in database.Customers where p.CustomerID == "NIDE" select p).First();
database.Dispose();
customerToModifyAndDelete.ContactName = "Nikolay";
customerToModifyAndDelete.Phone = "088340";
DAOClass.Modify(customerToModifyAndDelete.CustomerID, customerToModifyAndDelete);
DAOClass.Delete(customerToModifyAndDelete.CustomerID);
}
public static bool AgregarVenta(SALES venta)
{
NorthwindEntities contexto = null;
try
{
contexto = new NorthwindEntities();
contexto.SALES.Add(venta);
contexto.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (contexto != null)
{
contexto.Dispose();
}
}
}
public void Dispose()
{
if (isDisposed == false)
{
_dbContext?.Dispose();
isDisposed = true;
}
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public virtual void Reset()
{
if (entities != null)
{
entities.Dispose();
}
Initialize();
}
public ActionResult Index2()
{
NorthwindEntities db = new NorthwindEntities(); //Uusi ilmentymä tietokannasta nimellä db
List <Products> model = db.Products.ToList(); //Lista nimeltä model, joka ottaa vastaan Products kategoriaan kuuluvia rivejä, jotka sijoitetaan db oliosta listana.
db.Dispose(); //Suljetaan tietokanta yhteys
return(View(model)); //Palautetaan näkymälle lista model.
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
_unitOfWork.Dispose();
_context.Dispose();
}
base.Dispose(disposing);
}
public ActionResult Index2()
{
NorthwindEntities entities = new NorthwindEntities();
List <Products> model = entities.Products.ToList();
entities.Dispose();
return(View(model));
}
public List <string> GetProducts()
{
List <string> products = null;
DataCache dataCache = null;
if (this.enableCache)
{
try
{
dataCache = cacheFactory.GetDefaultCache();
products = dataCache.Get("products") as List <string>;
if (products != null)
{
products[0] = "(from cache)";
return(products);
}
}
catch (DataCacheException ex)
{
if (ex.ErrorCode != DataCacheErrorCode.RetryLater)
{
throw;
}
// ignore temporary failures
}
}
NorthwindEntities context = new NorthwindEntities();
try
{
var query = from product in context.Products
select product.ProductName;
products = query.ToList();
}
finally
{
if (context != null)
{
context.Dispose();
}
}
products.Insert(0, "(from data source)");
if (this.enableCache && dataCache != null)
{
dataCache.Add("products", products, TimeSpan.FromSeconds(30));
}
return(products);
}
[Route("api/Values/OrderCount")] //reitin määritys
public int OrderCount()
{
//tietokantayhteys alustaminen
NorthwindEntities entities = new NorthwindEntities();
//paikallinen muuttuja, joka laskee tilausten lkm:n Orders-taulusta
int orderCount = entities.Orders.Count();
//vapautetaan muisti, tietokantayhteyden sulkeminen
entities.Dispose();
//palautetaan tulos
return(orderCount);
}
protected virtual void Dispose(bool disposing)
{
if (!_disposed)
{
if (disposing)
{
if (_db != null)
{
_db.Dispose();
}
}
_disposed = true;
}
}
// GET: Customer
public ActionResult Index()
{
ViewBag.OmaTieto = "ABC123";
NorthwindEntities entities = new NorthwindEntities();
//muodostetaan asiakastaulun tiedoista model-niminen lista ja pyydetään entities-oliosta Customers-entities-kokoelmasta
//kokonaisuutena listaksi
List <Customers> model = entities.Customers.ToList();
entities.Dispose();
//palautetaan näkymälle model-olio
return(View(model));
}
public ActionResult Update(Customers cust)
{
NorthwindEntities entities = new NorthwindEntities();
string id = cust.CustomerID;
bool OK = false;
//onko kyseessä uusi lisäys vai vanhan muokkaus
if (id == "(uusi)")
{
//uuden lisääminen eli kopioidaan kentät
Customers dbItem = new Customers()
{
//otetaan CompanyNamesta Substring funktiolla 5 ensimmäistä merkkiä, jos loppuu
//välilyöntiin tehdään Trim()
CustomerID = cust.CompanyName.Substring(0, 5).Trim().ToUpper(),
CompanyName = cust.CompanyName,
Address = cust.Address,
City = cust.City
};
//tallennetaan uusi lisäys tietokantaan
entities.Customers.Add(dbItem);
entities.SaveChanges();
OK = true;
}
else
{
//muokkaus eli haetaan id:n perusteella rivi tietokannasta
Customers dbItem = (from c in entities.Customers
where c.CustomerID == id
select c).FirstOrDefault();
//tallennetaan vain ne tiedot joita käyttäjä on voinut muokata
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));
}
// GET: Products
public ActionResult Index()
{
if (Session["UserName"] == null) //näyttää NavBarissa (in) / (out) -tiedon, pitää lisätä jokaisen controllerin indexiin, jos halutaan näkyvän niissä
{
ViewBag.LoggedStatus = "Out";
return(RedirectToAction("login", "home")); //tämä vie ensin login-ruutuun
}
else
{
ViewBag.LoggedStatus = "In";
NorthwindEntities entities = new NorthwindEntities();
List <Products> model = entities.Products.ToList();
entities.Dispose();
return(View(model));
}
}
// GET: Sales
public ActionResult Index()
{
NorthwindEntities entities = new NorthwindEntities();
try
{
//muodostetaan lista asiakkaista
List <Customers> model = entities.Customers.ToList();
//palautetaan lista näkymänä
return(View(model));
}
finally
{
//resurssien vapautus
entities.Dispose();
}
}
public static void Main()
{
NorthwindEntities connection = new NorthwindEntities();
NorthwindEntities anotherConnection = new NorthwindEntities();
Customer anton = connection.Customers.Where(cust => cust.CustomerID == "ANTON").FirstOrDefault();
Customer antonio = anotherConnection.Customers.Where(cust => cust.CustomerID == "ANTON").FirstOrDefault();
anton.Region = "BG";
antonio.Region = "GR";
connection.SaveChanges();
anotherConnection.SaveChanges();
connection.Dispose();
anotherConnection.Dispose();
}
public JsonResult GetList()
{
NorthwindEntities entities = new NorthwindEntities();
// List<Customers> model = entities.Customers.ToList();
//muodostetaan näkymäluokka, joka halutaan välittää Ajaxin kautta
var model = (from c in entities.Customers
select new
{
CustomerID = c.CustomerID,
CompanyName = c.CompanyName,
Address = c.Address,
City = c.City
}).ToList();
string json = JsonConvert.SerializeObject(model);
entities.Dispose();
return(Json(json, JsonRequestBehavior.AllowGet));
}
[Route("api/Values/LastNOrders/{id:int}")] //reitin määritys
public List <string> LastNOrders(int id) //käytetään parametrina int, koska AppStart/WebApiConfigissa routeTemplate: "api/{controller}/{id}",
{
//tietokantayhteys alustaminen
NorthwindEntities entities = new NorthwindEntities();
//muuttujan alustus
int numberOfOrdersToReturn = id;
//lista-muuttuja, joka lajittelee tulokset tilauspäivän mukaan laskevasti
//Orders -taulusta ja palauttaa niistä 5 Take-funktiolla
List <Orders> lastOrders = (from o in entities.Orders
orderby o.OrderDate descending
select o).Take(numberOfOrdersToReturn).ToList();
//pyydetään Orders-taulun tiedoista pelkästään CompanyName asiakastaulun kautta
List <string> customerNames = lastOrders.Select(o => o.Customers.CompanyName).ToList();
//vapautetaan muisti, tietokantayhteyden sulkeminen
entities.Dispose();
//palautetaan tulos
return(customerNames);
}
public ActionResult DeleteFromJQuery(string id)
{
NorthwindEntities db = new NorthwindEntities();
int iid = int.Parse(id);
// etsitään id:n perusteella asiakasrivi kannasta
bool OK = false;
Orders dbItem = (from o in db.Orders
where o.OrderID == iid
select o).FirstOrDefault();
if (dbItem != null)
{
// tietokannasta poisto
db.Orders.Remove(dbItem);
db.SaveChanges();
OK = true;
}
db.Dispose();
return(Json(OK, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(string id)
{
NorthwindEntities entities = new NorthwindEntities();
// 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 List <string> GetProducts()
{
List <string> products = null;
NorthwindEntities context = new NorthwindEntities();
try
{
var query = from product in context.Products
select product.ProductName;
products = query.ToList();
}
finally
{
if (context != null)
{
context.Dispose();
}
}
return(products);
}
public static void Main(string[] args)
{
var firstDbContext = new NorthwindEntities();
var secondDbContext = new NorthwindEntities();
var randomRegion = firstDbContext.Regions.FirstOrDefault();
var anotherRandomRegion = secondDbContext.Regions.FirstOrDefault();
randomRegion.RegionDescription = "Changed Description 1";
anotherRandomRegion.RegionDescription = "changed Description 2";
firstDbContext.SaveChanges();
secondDbContext.SaveChanges();
firstDbContext.Dispose();
secondDbContext.Dispose();
var thirdDbContext = new NorthwindEntities();
var actualRegion = thirdDbContext.Regions.FirstOrDefault();
Console.WriteLine(actualRegion.RegionDescription);
}
private static void MakeConcurencyChanges()
{
//7. Try to open two different data contexts and perform concurrent changes
//on the same records. What will happen at SaveChanges()? How to deal with it?
NorthwindEntities dbContext1 = new NorthwindEntities();
Employee employee1 = dbContext1.Employees.Find(10);
//employee1.City = "Burgas";
dbContext1.Employees.Remove(employee1);
//dbContext1.SaveChanges();
NorthwindEntities dbContext2 = new NorthwindEntities();
Employee employee2 = dbContext2.Employees.Find(10);
employee2.City = "Varna";
dbContext1.SaveChanges();
dbContext2.SaveChanges();
dbContext1.Dispose();
dbContext2.Dispose();
}
public ActionResult GetOrderData(string id)
{
NorthwindEntities entities = new NorthwindEntities();
try
{
List <Orders> orders = (from o in entities.Orders
where o.CustomerID == id
orderby o.OrderDate descending
select o).ToList();
StringBuilder html = new StringBuilder();
html.AppendLine("<td colspan=\"5\">" +
"<table class=\"table table-striped\">");
foreach (Orders order in orders)
{
html.AppendLine("<tr><td>" +
order.OrderDate.Value.ToShortDateString() + "</td>" +
"<td>" + order.OrderID + "</td>" +
"<td>" + order.ShipCity + "</td>" +
"<td>" + order.RequiredDate.Value.ToShortDateString() + "</td></tr>");
}
html.AppendLine("</table></td>");
var jsonData = new { html = html.ToString() };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
finally
{
//resurssien vapautus
entities.Dispose();
}
}
public void Dispose()
{
context.Dispose();
}
public void Dispose()
{
dc.Dispose();
}
