public Control Create(DalControl entity, bool isTemplate)
{
var ormEntity = mapper.MapToOrm(entity);
if (!isTemplate)
{
ormEntity.protocolNumber = GetLastProtocolNumberOfCurrentType(entity.ControlName_id.Value) + 1;
}
return(context.Set <Control>().Add(ormEntity));
}
public List <DalStatus> GetAllStatusesExceptDeletedAndClosed()
{
var items = context.Set <Status>().Where(e => (e.name != Globals.Globals.STATUS_CLOSED) && (e.name != Globals.Globals.STATUS_DELETED));
List <DalStatus> res = new List <DalStatus>();
if (items.Any())
{
foreach (var item in items)
{
res.Add(mapper.MapToDal(item));
}
}
return(res);
}
public IEnumerable <DalEvent> GetEventsForUser(int user_id)
{
EventMapper mapper = new EventMapper();
//var user = context.Set<User>().FirstOrDefault(entity => entity.id == user_id);
//foreach (var element in user.SelectedUser)
//{
// var ev = element.UserLib.Event;
// if (ev.Count != 0 && ev.Status != delted or closed)
// {
// retElemets.Add(mapper.MapToDal(ev.First()));
// }
//}
var events = context.Set <Event>().Where(entity =>
(entity.StatusLib.SelectedStatus.OrderByDescending(o => o.id).FirstOrDefault().Status.name != Globals.Globals.STATUS_CLOSED) &&
(entity.StatusLib.SelectedStatus.OrderByDescending(o => o.id).FirstOrDefault().Status.name != Globals.Globals.STATUS_DELETED) &&
entity.UserLib.SelectedUser.Any(e => e.User.id == user_id));
var retElemets = new List <DalEvent>();
foreach (var item in events)
{
retElemets.Add(mapper.MapToDal(item));
}
return(retElemets);
}
public IEnumerable <DalSelectedCertificate> GetCertificatesByLibId(int id)
{
var elements = context.Set <SelectedCertificate>().Where(entity => entity.certificateLib_id == id);
var retElemets = new List <DalSelectedCertificate>();
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
return(retElemets);
}
public IEnumerable <DalResult> GetEntitiesByLibId(int id)
{
var elements = context.Set <Result>().Where(entity => entity.resultLib_id == id);
var retElemets = new List <DalResult>();
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
return(retElemets);
}
public IEnumerable <DalSelectedControlMethodDocumentation> GetControlMethodDocumentationsByLibId(int id)
{
var elements = context.Set <SelectedControlMethodDocumentation>().Where(entity => entity.controlMethodDocumentationLib_id == id);
var retElemets = new List <DalSelectedControlMethodDocumentation>();
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
return(retElemets);
}
public IEnumerable <DalImage> GetEntitiesByLibId(int id)
{
ImageMapper mapper = new ImageMapper();
var elements = context.Set <Image>().Where(entity => entity.imageLib_id == id);
var retElemets = new List <DalImage>();
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
return(retElemets);
}
public IEnumerable <DalFilepath> GetEntitiesByLibId(int id)
{
FilepathMapper mapper = new FilepathMapper();
var elements = context.Set <Filepath>().Where(entity => entity.lib_id == id);
var retElemets = new List <DalFilepath>();
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
return(retElemets);
}
public IEnumerable <DalComponent> GetComponentsByIndustrialObject(int id)
{
var ormComponents = context.Set <Component>().Where(entity => entity.industrialObject_id == id);
var res = new List <DalComponent>();
if (ormComponents.Any())
{
foreach (var item in ormComponents)
{
res.Add(mapper.MapToDal(item));
}
}
return(res);
}
//public new SelectedEquipment Create(DalSelectedEquipment entity)
//{
// var ormEntity = mapper.MapToOrm(entity);
// ormEntity.EquipmentLib = context.EquipmentLibs.FirstOrDefault(e => e.id == ormEntity.equipmentLib_id);
// //ormEntity.SelectedEquipmentLib.SelectedEquipment.Add(ormEntity);
// return context.Set<SelectedEquipment>().Add(ormEntity);
//}
public IEnumerable <DalSelectedEquipment> GetEquipmentsByLibId(int id)
{
var elements = context.Set <SelectedEquipment>().Where(entity => entity.equipmentLib_id == id);
var retElemets = new List <DalSelectedEquipment>();
if (elements != null)
{
foreach (var element in elements)
{
retElemets.Add(mapper.MapToDal(element));
}
}
return(retElemets);
}
public TEntity Create(TEntity entity)
{
return(mapper.MapToDal(context.Set <UEntity>().Add(mapper.MapToOrm(entity))));
}
public SelectedUser Create(IDalSelectedEntity entity)
{
var res = context.Set <SelectedUser>().Add(mapper.MapToOrm((DalSelectedUser)entity));
return(res);
}
public UEntity Create(TEntity entity)
{
var res = context.Set <UEntity>().Add(mapper.MapToOrm(entity));
return(res);
}
