public Product Get(int id)
{
var context = new Models.mycloudContext();
var objResult = context.Products.Where(i => i.ProductId == id).FirstOrDefault();
return(objResult);
}
public IQueryable <Product> Get()
{
var context = new Models.mycloudContext();
var objResult = context.Products;
return(objResult);
}
public IEnumerable <Installation3> Get(int id1, int id2)
{
var context = new Models.mycloudContext();
var objResult = context.LinkCableInstallations.Where(i => i.Installation1Id == id1).Where(i => i.Installation2Id == id2).Select(y => y.Installation3).Distinct();
return(objResult);
}
public IQueryable <Installation1> Get()
{
var context = new Models.mycloudContext();
var objResult = context.Installation1s;
return(objResult);
}
public IQueryable <Product> Get(int inst1, int inst2, int inst3)
{
var context = new Models.mycloudContext();
var objResult = context.LinkCableInstallations
.Where(i => i.Installation1Id == inst1 && i.Installation2Id == inst2 && i.Installation3Id == inst3)
.Select(j => j.Product);
return(objResult);
}
public async Task <IActionResult> Create([Bind("FirstName, LastName")] Product product)
{
using (var context = new Models.mycloudContext())
{
//context.Add(author);
await context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> Index()
{
using (var context = new Models.mycloudContext())
{
var model = await context.Products
.Include("Insulator")
.Include("Conductor")
.Include("Design")
.Include("Restriction")
.Include("Country")
.Include("CprClass")
.Include("VoltageClass")
.Include("CableRange")
.ToListAsync();
return(View(model));
}
}
