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); }