public void Delete(T entity)
{
InspectionProcessEntities context = CreateContext();
context.Entry(entity).State = EntityState.Deleted;
context.SaveChanges();
}
protected InspectionProcessEntities CreateContext()
{
InspectionProcessEntities context = new InspectionProcessEntities();
context.Configuration.ProxyCreationEnabled = false;
context.Database.Log = x => Console.WriteLine(x);
return(context);
}
public virtual void Insert(T entity)
{
InspectionProcessEntities context = CreateContext();
//context.Albums.Add(album);
context.Entry(entity).State = EntityState.Added;
context.SaveChanges();
}
public int GetMaxId()
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.Inspections
orderby x.InspectionId descending
select x.InspectionId;
return(query.FirstOrDefault());
}
public int GetbyCountDumpA()
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.Warehouses
where x.WarehouseId == 4
select x.Count;
return(query.FirstOrDefault());
}
public List <Warehouse> GetbyDump()
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.Warehouses
where x.WarehouseId > 3
select x;
return(query.ToList());
}
public int GetbyId(int inspectionId)
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.Inspections
where x.InspectionId == inspectionId
select x.InspectionId;
return(query.FirstOrDefault());
}
public List <Inspection> GetAllbyDate(DateTime startDate, DateTime finishDate)
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.Inspections
orderby x.InspectionId descending
where (x.FinishTime == null || x.FinishTime != null && x.StartTime >= startDate) ||
(x.FinishTime <= finishDate && x.StartTime >= startDate)
select x;
return(query.ToList());
}
public List <InspectionResult> SearchByQuality(int?inspectionId, int?productId, int?inspectionTeamId)
{
InspectionProcessEntities context = CreateContext();
var query = from x in context.InspectionResults
select new
{
InspectionResult = x,
MerchandiseName = x.Product.Merchandise.Name,
InspectionTeamName = x.Inspection.Team.Name,
};
if (inspectionId.HasValue)
{
query = query.Where(x => x.InspectionResult.Inspection.InspectionId == inspectionId);
}
if (productId.HasValue)
{
query = query.Where(x => x.InspectionResult.ProductId == productId);
}
if (inspectionTeamId.HasValue)
{
query = query.Where(x => x.InspectionResult.Inspection.InspectionTeam == inspectionTeamId);
}
var list = query.ToList();
foreach (var x in list)
{
x.InspectionResult.MerchandiseName = x.MerchandiseName;
x.InspectionResult.InspectionTeamName = x.InspectionTeamName;
}
return(list.ConvertAll(x => x.InspectionResult));
}
public Inspection Get(int inspectionId)
{
InspectionProcessEntities context = CreateContext();
return(context.Inspections.FirstOrDefault(a => a.InspectionId == inspectionId));
}
public Team Get(int teamId)
{
InspectionProcessEntities context = CreateContext();
return(context.Teams.FirstOrDefault(a => a.TeamId == teamId));
}
public Product Get(int productId)
{
InspectionProcessEntities context = CreateContext();
return(context.Products.FirstOrDefault(a => a.ProductId == productId));
}
public Keeping Get(int warehouseId, int inspectionResultId)
{
InspectionProcessEntities context = CreateContext();
return(context.Keepings.FirstOrDefault(a => a.WarehouseId == warehouseId && a.InspectionResultId == inspectionResultId));
}
public int GetCount()
{
InspectionProcessEntities context = CreateContext();
return(context.Set <T>().Count());
}
public List <T> GetAll()
{
InspectionProcessEntities context = CreateContext();
return(context.Set <T>().ToList());
}
public Warehouse Get(int warehouseId)
{
InspectionProcessEntities context = CreateContext();
return(context.Warehouses.FirstOrDefault(a => a.WarehouseId == warehouseId));
}
public Merchandise Get(int merchandiseId)
{
InspectionProcessEntities context = CreateContext();
return(context.Merchandises.FirstOrDefault(a => a.MerchandiseId == merchandiseId));
}