public PlcConnectorModule Add(PLCConnectorModuleConfigure p_configure) { PlcConnectorModule objTemp = new PlcConnectorModule(p_configure); PlcConnectorModulesList.Add(objTemp); using (var db = new MES_DATABASE()) { db.PLC_PLCConnectorable.Add(new PLC_PLCConnector() { ID_PLC = objTemp.Id, Status = (int)objTemp.EModuleState, IP = objTemp.PlcModuleConfigure.IpString, Port = objTemp.PlcModuleConfigure.PortString, Rack = objTemp.PlcModuleConfigure.Rack, Slot = objTemp.PlcModuleConfigure.Slot, TimeCreated = DateTime.Now, TimeModified = DateTime.Now, P_Created = "Honza", P_Modified = "Honza" }); db.SaveChanges(); } return(objTemp); }
public void Add(StateModel p_entity) { using (var db = new MES_DATABASE()) { db.STA_StateList.Add(MapperState.MapStateToSTA(p_entity)); db.SaveChanges(); } }
public void Add(TranslationModel p_entity) { using (var db = new MES_DATABASE()) { db.TRA_TranslationState.Add(MapperTranslation.MapTranslationToTra(p_entity)); db.SaveChanges(); } }
public ReceivedResult Add(ReceivedResult p_entity) { using (var db = new MES_DATABASE()) { db.RES_ResultTable.Add(Mapper.Map <RES_ResultTable>(p_entity)); db.SaveChanges(); } return(null); }
public void Add(EntityModel p_entity) { //musi se vytvořit také základní translation a state using (var db = new MES_DATABASE()) { // db.ENT_Entity.Add(MapperEntity.MapEntityToENT(p_entity)); db.ENT_Entity.Add(Mapper.Map <ENT_Entity>(p_entity)); db.SaveChanges(); } }
public void Add(UserFull p_userFull) { var Temp = MapperUserFull.MapUserFullToUSREntity(p_userFull); using (var db = new MES_DATABASE()) { db.USR_UserList.Add(Temp); db.SaveChanges(); } }
public void Edit(UserFull p_userFull) { var Temp = MapperUserFull.MapUserFullToUSREntity(p_userFull); using (var db = new MES_DATABASE()) { db.USR_UserList.Attach(Temp); db.Entry(Temp).State = EntityState.Modified; db.SaveChanges(); } }
public IEnumerable <ComObjectModel> RetrieveModel() { List <ComObjectModel> Temp = new List <ComObjectModel>(); using (var db = new MES_DATABASE()) { Temp = db.PLC_PLCConnectorable .Select(Mapper.Map <ComObjectModel>) .ToList(); } return(Temp); }
public IEnumerable <UserFull> Retrieve() { List <UserFull> Temp = new List <UserFull>(); using (var db = new MES_DATABASE()) { Temp = db.USR_UserList .Select(MapperUserFull.MapUSREntityToUserFull) .ToList(); } return(Temp); }
public UserFull Retrieve(int p_id) { UserFull Temp = new UserFull(); using (var db = new MES_DATABASE()) { Temp = db.USR_UserList.Where(x => x.ID_USR == p_id) .Select(MapperUserFull.MapUSREntityToUserFull) .FirstOrDefault(); } return(Temp); }
public IEnumerable <TranslationDetailModel> RetrieveDetail() { List <TranslationDetailModel> Temp = new List <TranslationDetailModel>(); using (var db = new MES_DATABASE()) { Temp = db.TRA_TranslationState .Select(MapperTranslation.MapTraToTranslationDetail) .ToList(); } return(Temp); }
public ReceivedResult Retrieve(int p_id) { ReceivedResult Temp = new ReceivedResult(); using (var db = new MES_DATABASE()) { Temp = db.RES_ResultTable .Where(x => x.ID_RES == p_id) .Select(Mapper.Map <ReceivedResult>) .SingleOrDefault(); } return(Temp); }
public IEnumerable <TranslationDetailModel> RetrieveDetailByEntityId(int p_entityID) { List <TranslationDetailModel> Temp = new List <TranslationDetailModel>(); using (var db = new MES_DATABASE()) { Temp = db.TRA_TranslationState .Where(id_ent => id_ent.ID_ENT == p_entityID) .Select(MapperTranslation.MapTraToTranslationDetail) .ToList(); } return(Temp); }
public EntityDetailModel RetrieveDetail(int p_id) { EntityDetailModel Temp = new EntityDetailModel(); using (var db = new MES_DATABASE()) { Temp = db.ENT_Entity .Where(x => x.ID_ENT == p_id) .Select(Mapper.Map <EntityDetailModel>) .SingleOrDefault(); } return(Temp); }
public TranslationDetailModel RetrieveDetail(int p_id) { var Temp = new TranslationDetailModel(); using (var db = new MES_DATABASE()) { Temp = db.TRA_TranslationState .Where(id => id.ID_TRA == p_id) .Select(MapperTranslation.MapTraToTranslationDetail) .SingleOrDefault(); } return(Temp); }
public IEnumerable <EntityModel> Retrieve() { List <EntityModel> Temp = new List <EntityModel>(); using (var db = new MES_DATABASE()) { Temp = db.ENT_Entity .Select(Mapper.Map <EntityModel>) .ToList(); //.Select(MapperEntity.MapENTToMapperEntity) } return(Temp); }
public ComObjectDetailModel RetrieveDetailModel(Guid p_id) { ComObjectDetailModel Temp = new ComObjectDetailModel(); using (var db = new MES_DATABASE()) { Temp = db.ComObjecTable .Where(x => x.ID_COM == p_id) .Select(Mapper.Map <ComObjectDetailModel>) .SingleOrDefault(); } return(Temp); }
public PLCConnectorDetailModel RetrieveDetailModel(Guid p_id) { PLCConnectorDetailModel Temp = new PLCConnectorDetailModel(); using (var db = new MES_DATABASE()) { Temp = db.PLC_PLCConnectorable .Where(x => x.ID_PLC == p_id) .Select(Mapper.Map <PLCConnectorDetailModel>) .SingleOrDefault(); } return(Temp); }
public StateDetailModel RetrieveDetail(int p_id) { var Temp = new StateDetailModel(); using (var db = new MES_DATABASE()) { Temp = db.STA_StateList .Where(id => id.ID_STA == p_id) .Select(MapperState.MapSTAToStateDetail) .SingleOrDefault(); } return(Temp); }
public IEnumerable <StateDetailModel> RetrieveDetail() { List <StateDetailModel> Temp = new List <StateDetailModel>(); using (var db = new MES_DATABASE()) { Temp = db.STA_StateList .Select(MapperState.MapSTAToStateDetail) .ToList(); } return(Temp); }
public bool GetInformation(int p_Id) { ProfileFull = new UserFull(); bool isFound = false; using (var db = new MES_DATABASE()) { var result = db.USR_UserList.FirstOrDefault(x => x.ID_USR == p_Id); ProfileFull = MapperUserFull.MapUSREntityToUserFull(result); isFound = true; } return(isFound); }
public IEnumerable <StateDetailModel> RetrieveDetailByEntityId(int p_EntityId) { List <StateDetailModel> Temp = new List <StateDetailModel>(); using (var db = new MES_DATABASE()) { Temp = db.STA_StateList .Where(x => x.ENT_Entity.ID_ENT == p_EntityId) .Select(MapperState.MapSTAToStateDetail) .ToList(); } return(Temp); }
public void Edit(TranslationModel p_entity) { var Temp = MapperTranslation.MapTranslationToTra(p_entity); using (var db = new MES_DATABASE()) { if (!db.TRA_TranslationState.Local.Any(c => c.ID_TRA == p_entity.ID_TRA)) { db.TRA_TranslationState.Attach(Temp); db.Entry(Temp).State = EntityState.Modified; } db.SaveChanges(); } }
public IEnumerable <TranslationModel> GetPossibleTranslations(int ID_ENT, int ID_STA) { List <TranslationModel> Temp = new List <TranslationModel>(); using (var db = new MES_DATABASE()) { Temp = db.TRA_TranslationState .Where(id_ent => id_ent.ID_ENT == ID_ENT) .Where(id_sta => id_sta.ID_STA_PICA_FROM == ID_STA) .Select(MapperTranslation.MapTraToTranslation) .ToList(); } return(Temp); }
public void Edit(StateModel p_entity) { var Temp = MapperState.MapStateToSTA(p_entity); using (var db = new MES_DATABASE()) { if (!db.STA_StateList.Local.Any(c => c.ID_STA == p_entity.ID_STA)) { db.STA_StateList.Attach(Temp); db.Entry(Temp).State = EntityState.Modified; } db.SaveChanges(); } }
public void Edit(EntityDetailModel p_entity) { // var Temp = MapperEntity.MapEntityDetilToENT(p_entity); var Temp = Mapper.Map <ENT_Entity>(p_entity);; using (var db = new MES_DATABASE()) { if (!db.ENT_Entity.Local.Any(c => c.ID_ENT == p_entity.ID_ENT)) { db.ENT_Entity.Attach(Temp); db.Entry(Temp).State = EntityState.Modified; } db.SaveChanges(); } }
public static bool Authenticate(User p_user) { bool result = false; //Přihlášení -> komunikace s entity frameworkem -> přihlášení do systému using (var db = new MES_DATABASE()) { var getUser = db.USR_UserList.Where(x => x.LOGIN == p_user.UserName).FirstOrDefault(); if (getUser?.PASSWORD.Trim() == p_user.Password) { p_user.ID = getUser.ID_USR; result = true; } } return(result); // Do authentication against database, web service, whatever }
// bude použito ve vyšší třídě public int AddComobject(int p_area, int p_wordLen, int p_start, int p_iPeriod, int p_iDbNumber = 1, int p_rw = 0) { var tempConfiguration = new ComObjectConfigure() { AreaOfMemory = p_area, WorldLen = p_wordLen, StartOffset = p_start, PeriodOfCheck = p_iPeriod, DbNumber = p_iDbNumber, ERW = p_rw }; var instance = ComObjectRepository.Instance.Add(tempConfiguration); CommunicationObjects.Add(instance); instance.StateChanged += OnChangeState; //tohle musí být mimo v tom prostředí using (var db = new MES_DATABASE()) { db.ComObjecTable.Add(new COM_ComObject() { ID_COM = instance.Id, Status = (int)instance.EModuleState, AreaMemory = instance.ObjectConfigure.AreaOfMemory, StartOffSet = instance.ObjectConfigure.StartOffset, Period = instance.ObjectConfigure.PeriodOfCheck, ReadWrite = instance.ObjectConfigure.ERW, DBnumber = instance.ObjectConfigure.DbNumber, WorldLen = instance.ObjectConfigure.WorldLen, ID_PLC = Id, P_Created = "Honza", P_Modified = "Honza", TimeCreated = DateTime.Now, TimeModified = DateTime.Now, }); db.SaveChanges(); } GetMinPeriod(); return(0); }