public JsonResult SiparisOlustur(List <SiparisViewModel> model)
{
if (model == null)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
NorthContext db = new NorthContext();
using (var tran = db.Database.BeginTransaction())
{
try
{
var siparis = new Order()
{
CustomerID = "DUMON",
EmployeeID = 1,
OrderDate = DateTime.Now,
RequiredDate = DateTime.Now.AddDays(7),
ShipVia = 1,
Freight = 59,
ShipName = "Lucky S",
ShipRegion = "Çorum",
ShipCity = "Sungurlu",
ShipCountry = "USÇ"
};
db.Orders.Add(siparis);
db.SaveChanges();
foreach (var item in model)
{
db.Order_Details.Add(new Order_Detail
{
OrderID = siparis.OrderID,
ProductID = item.ProductID,
Discount = 0,
Quantity = item.Count,
UnitPrice = item.UnitPrice
});
}
db.SaveChanges();
tran.Commit();
var msg = new
{
success = true,
message = $"{siparis.OrderID} nolu sipariş başarıyla oluşturuldu"
};
return(Json(msg, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
tran.Rollback();
var msg = new
{
success = false,
message = "Sipariş oluşturulurken bir hata oluştu " + ex.Message
};
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var context = new NorthContext())
{
var results = context.Customers.Include(item => item.ContactTitleNavigation).ToList();
Console.WriteLine();
}
}
public static List <Category> Categories()
{
using (var context = new NorthContext())
{
return(context.Categories
.OrderBy(category => category.CategoryName).ToList());
}
}
public static List <Product> Products()
{
using (var context = new NorthContext())
{
return(context.Products
.OrderBy(product => product.ProductName).ToList());
}
}
public GenericRepository(NorthContext context)
{
if (context == null)
{
throw new ArgumentException("An instance of DbContext is required to use this repository.", "context");
}
this.Context = context;
this.DbSet = this.Context.Set <T>();
}
public static List <CategoryItem> CategoryItems()
{
using (var context = new NorthContext())
{
return(context.Categories.Select(category => new CategoryItem()
{
CategoryId = category.CategoryId,
CategoryName = category.CategoryName
}).OrderBy(category => category.CategoryName).ToList());
}
}
public JsonResult UrunleriGetir()
{
NorthContext db = new NorthContext();
var model = db.Products.Select(x => new
{
x.ProductID,
x.ProductName,
x.UnitPrice,
x.Category.CategoryName,
x.UnitsInStock,
x.Discontinued,
x.Supplier.CompanyName
}).ToList();
return(Json(model, JsonRequestBehavior.AllowGet));
}
private void Form1_Shown(object sender, EventArgs e)
{
listView1.View = View.Details;
listView1.GridLines = true;
listView1.OwnerDraw = false;
listView1.FullRowSelect = true;
//Add column header
listView1.Columns.Add("NameColumn", 150);
listView1.Columns.Add("VersionColumn", 130);
listView1.Columns[0].Text = "First name";
listView1.Columns[1].Text = "Last name";
using (NorthContext context = new NorthContext())
{
var contacts = context.Contacts.ToList();
foreach (var contact in contacts)
{
var item = new ListViewItem(new []
{
contact.FirstName,
contact.LastName,
contact.ContactId.ToString()
});
listView1.Items.Add(item);
}
}
listView1.Items[0].Selected = true;
listView1.Select();
CurrentButton.Enabled = true;
}
public GenericRepository(NorthContext context)
{
DbContext = Activator.CreateInstance <TContext>();
DbContext.Configuration.LazyLoadingEnabled = true;
_entity = context.Set <TEntity>();
}
public UowData(NorthContext context)
{
this.context = context;
}
