public List <Param> getVariables(Site site) { IParamRepository paramRepo = new ParamRepository(); List <Param> paramListe = (List <Param>)paramRepo.ForSite(site.Id, "Adresse API", null); return(paramListe); }
public IDictionary <Param, IList <HisValue> > applyScaleFactory(IDictionary <Param, IList <HisValue> > data) { IParamRepository paramRepo = new ParamRepository(); var mapValueConverted = new Dictionary <Param, IList <HisValue> >(); if (data != null) { foreach (var listValeurs in data) { IList <HisValue> ListValeurValide = new List <HisValue>(); if (listValeurs.Key.TypeConversion != 0) { foreach (var val in listValeurs.Value) { HisValue convertedValue = paramRepo.ApplyScaleToValue(listValeurs.Key, val); ListValeurValide.Add(convertedValue); } } else { ListValeurValide = listValeurs.Value; } mapValueConverted.Add(listValeurs.Key, ListValeurValide); } } return(mapValueConverted); }
public ActionResult Edit(string id, ParamRepository value) { if (AccessDenied(System.Web.HttpContext.Current.Session.SessionID)) { return(RedirectToAction("Index", "Home")); } value.mensagem = new Validate(); if (ModelState.IsValid) { try { ControllerFactory <ParamModel> factory = new ControllerFactory <ParamModel>(); #region gravar os dados do parâmetro value.parametro.parametroID = int.Parse(id); value = (ParamRepository)factory.Edit(value); if (value.mensagem.Code > 0) { throw new PinheiroSereniException(value.mensagem); } #endregion return(RedirectToAction("Browse", new { sucesso = MensagemPadrao.Message(0).ToString() })); } catch (PinheiroSereniException ex) { ModelState.AddModelError(value.mensagem.Field, ex.Result.Message); return(View(value)); } }
public SingerManageController() { paramRepository = ClassInstance <ParamRepository> .Instance; singerRepository = ClassInstance <SingerRepository> .Instance; singerTypeRepository = ClassInstance <SingerTypeRepository> .Instance; songBookRepository = ClassInstance <SongBookRepository> .Instance; }
public Repository getObject(Object id) { using (db = new PinheiroSereniContext()) { ParamRepository r = new ParamRepository() { mensagem = new Validate(), parametro = db.Parametros.Find((int)id) }; return(r); } }
public Repository Update(Repository value) { using (db = new PinheiroSereniContext()) { try { value.mensagem = new Validate() { Code = 0, Message = MensagemPadrao.Message(0).ToString() }; ParamRepository r = (ParamRepository)value; db.Entry(r.parametro).State = EntityState.Modified; db.SaveChanges(); } catch (System.Data.Entity.Infrastructure.DbUpdateException ex) { value.mensagem.Code = 36; value.mensagem.MessageBase = MensagemPadrao.Message(36).ToString(); if ((ex.Message.ToUpper().Contains("FOREIGN KEY") || ex.Message.ToUpper().Contains("REFERENCE")) || (ex.InnerException.ToString().ToUpper().Contains("FOREIGN KEY") || ex.InnerException.ToString().ToUpper().Contains("REFERENCE"))) { value.mensagem.Code = 16; value.mensagem.Message = MensagemPadrao.Message(16).ToString(); } else if (ex.Message.ToUpper().Contains("PRIMARY KEY") || ex.InnerException.ToString().ToUpper().Contains("PRIMARY KEY")) { value.mensagem.Code = 37; value.mensagem.Message = MensagemPadrao.Message(37).ToString(); } else { value.mensagem.Message = MensagemPadrao.Message(17).ToString(); } PinheiroSereniException.saveError(ex, GetType().FullName); } catch (Exception ex) { PinheiroSereniException.saveError(ex, GetType().FullName); value.mensagem.Code = 17; value.mensagem.MessageBase = ex.InnerException.InnerException.Message ?? ex.Message; value.mensagem.Message = new PinheiroSereniException(ex.Message, GetType().FullName).Message; } } return(value); }
/// <summary> /// Configures the api. /// </summary> /// <param name="modelCache">The optional model cache</param> /// <param name="imageProcessor">The optional image processor</param> private void Setup(IContentServiceFactory factory, ICache modelCache = null, IImageProcessor imageProcessor = null) { cache = modelCache; var cacheLevel = (int)App.CacheLevel; Aliases = new AliasRepository(this, db, cacheLevel > 2 ? cache : null); Archives = new ArchiveRepository(this, db); Categories = new CategoryRepository(this, db, cacheLevel > 2 ? cache : null); Media = new MediaRepository(this, db, storage, cacheLevel > 2 ? cache : null, imageProcessor); Pages = new PageRepository(this, db, factory, cacheLevel > 2 ? cache : null); PageTypes = new PageTypeRepository(db, cacheLevel > 1 ? cache : null); Params = new ParamRepository(db, cacheLevel > 0 ? cache : null); Posts = new PostRepository(this, db, factory, cacheLevel > 2 ? cache : null); PostTypes = new PostTypeRepository(db, cacheLevel > 1 ? cache : null); Sites = new SiteRepository(this, db, cacheLevel > 0 ? cache : null); Tags = new TagRepository(db, cacheLevel > 2 ? cache : null); }
public string GetSiteData(IList <Site> listSites) { IParamRepository paramRepo = new ParamRepository(); string ReadingFeedback = null; foreach (var site in listSites) { IApiProtocol proto = null; mapLineApiProtocol.TryGetValue(site.Ligne, out proto);//getProtocolForSite(site.Id); if (proto != null) { Thread th = Thread.CurrentThread; if (String.IsNullOrEmpty(th.Name)) { th.Name = "PCCOMApi_getSiteData_ " + site.Id; } // Insertion de traces dans la table log_application //DiagBoxApp.Instance.GetLogger("EventLogTable").Trace( // message: string.Format("Launching new thread to retrieve data from PCComApi in the thread {0}", th.Name), // categories: "DiagBox;Applications;PCCOMAPI;PCCOMAPI;SpoolerPCComApi"); // get data from last acquisition to now, if not date acquisition get from 7 days. get from 7 days max lock (proto) { var paramsValues = proto.readDataSite((site.DateAcquisition.HasValue && site.DateAcquisition.Value > DateTime.Now.AddDays(G_DAYS_BACKUP)) ? site.DateAcquisition.Value : DateTime.Now.AddDays(G_DAYS_BACKUP), DateTime.Now, site); // insertion en base dans his_valeur en HQL et 1000lignes max par requêtes bool ReadingOk = InsertPCComApiValues(paramsValues, site); if (!ReadingOk) { ReadingFeedback = "Failed"; } } } } return(ReadingFeedback); }
public bool InsertPCComApiValues(IDictionary <Param, IList <HisValue> > data, Site site) { // get des doublons var valideParamsValues = checkDoublon(data); // gestion des bornes var ValuesWithEdge = applyScaleFactory(valideParamsValues); bool insertFeedback = false; ISiteRepository siteRepo = new SiteRepository(); IParamRepository paramRepo = new ParamRepository(); IFastHisValeurRepository valeurRepo = new FastHisValeurRepository(); foreach (var values in ValuesWithEdge.Values) { try { valeurRepo.InsertPCComApiValues(values); } catch (Exception ex) { } } try { insertFeedback = true; // insertion de la date d'acquisiton dans site var siteLocal = siteRepo.FindById(site.Id); siteLocal.DateAcquisition = DateTime.Now; siteRepo.Update(siteLocal); } catch (Exception ex) { insertFeedback = false; } return(insertFeedback); }
public ActionResult Edit(string id, string sucesso = "") { if (AccessDenied(System.Web.HttpContext.Current.Session.SessionID)) { return(RedirectToAction("Index", "Home")); } ControllerFactory <ParamModel> factory = new ControllerFactory <ParamModel>(); ParamRepository value = (ParamRepository)factory.getObject(int.Parse(id)); if (sucesso != null) { if (sucesso.Trim() != "") { value.mensagem = new Validate() { Code = 0, Message = sucesso }; ViewBag.Sucesso = sucesso; } } return(View(value)); }
// // GET: /param/edit/1 public ActionResult Edit(int id) { var model = new ParamRepository().Items.Single(x => x.Id == id); return(View(model)); }
public int GetNextParamTypeId(ParamType paramType) { var x = db.Params.Max("ParamId", x => x.ParamType == paramType, true); return(ParamRepository.Find(x).ParamId); }