/// <summary> /// Retorna un param por id y cultura /// </summary> /// <param name="paramId"></param> /// <param name="culture"></param> /// <param name="cnnStringName"></param> /// <returns></returns> public static ParamBE Get(int?paramId, string culture, string cnnStringName) { ParamBE wParamBE = null; try { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { var param_db = dc.fwk_Params.Where(s => (!paramId.HasValue || s.ParamId.Equals(paramId)) && (string.IsNullOrEmpty(culture) || s.Culture.Equals(culture)) ).FirstOrDefault(); if (param_db != null) { wParamBE = new ParamBE(); wParamBE.ParamId = param_db.ParamId; wParamBE.ParentId = param_db.ParentId; wParamBE.Name = param_db.Name; wParamBE.Description = param_db.Description; wParamBE.Enabled = param_db.Enabled; wParamBE.Culture = param_db.Culture; wParamBE.Id = param_db.Id; } return(wParamBE); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Retorna un param por id y cultura /// </summary> /// <param name="paramId"></param> /// <param name="culture"></param> /// <param name="cnnStringName"></param> /// <returns></returns> public static ParamBE Get(int? paramId, string culture, string cnnStringName) { ParamBE wParamBE =null; try { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { var param_db = dc.fwk_Params.Where(s => (!paramId.HasValue || s.ParamId.Equals(paramId)) && (string.IsNullOrEmpty(culture) || s.Culture.Equals(culture)) ).FirstOrDefault(); if (param_db != null) { wParamBE = new ParamBE(); wParamBE.ParamId = param_db.ParamId; wParamBE.ParentId = param_db.ParentId; wParamBE.Name = param_db.Name; wParamBE.Description = param_db.Description; wParamBE.Enabled = param_db.Enabled; wParamBE.Culture = param_db.Culture; wParamBE.Id = param_db.Id; } return wParamBE; } } catch (Exception ex) { throw ex; } }
/// <summary> /// La cadena de conexión se obtiene del atributo appId del wrapper /// </summary> /// <param name="wrapperProviderName">Proveedor que espesifica el despachador de servicios</param> /// <param name="pParam"></param> internal static void CreateParam(string wrapperProviderName,ParamBE pParam) { CreateParamReq req = new CreateParamReq(); req.BusinessData = pParam; req.ContextInformation.UserId = pParam.UserId.ToString(); CreateParamRes res = req.ExecuteService<CreateParamReq, CreateParamRes>(wrapperProviderName,req); if (res.Error != null) throw Fwk.Exceptions.ExceptionHelper.ProcessException(res.Error); }
/// <summary> /// La cadena de conexión se obtiene del atributo appId del wrapper /// </summary> /// <param name="wrapperProviderName">Proveedor que espesifica el despachador de servicios</param> /// <param name="pParam"></param> internal static void CreateParam(string wrapperProviderName, ParamBE pParam) { CreateParamReq req = new CreateParamReq(); req.BusinessData = pParam; req.ContextInformation.UserId = pParam.UserId.ToString(); CreateParamRes res = req.ExecuteService <CreateParamReq, CreateParamRes>(wrapperProviderName, req); if (res.Error != null) { throw Fwk.Exceptions.ExceptionHelper.ProcessException(res.Error); } }
/// <summary> /// Retorna parametros por id, id padre, y filtra x vigentes o no vigentes La cultura puede se String.Empty /// en cuyo caso no la tendra en cuenta para el filtro /// </summary> /// <param name="parentId">Relacion con otro param</param> /// <param name="enabled">Vigentes o no</param> /// <param name="culture">Cultura que se desea consultar: th-TH, en-US, es-AR etc etc</param> /// <param name="cnnStringName">Cadena de coneccion</param> /// <returns></returns> public static ParamList RetriveByParams(int? parentId, bool? enabled,string culture, string cnnStringName) { ParamList wParamList = new ParamList(); ParamBE wParamBE = null; try { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { var rulesinCat = from s in dc.fwk_Params where (!parentId.HasValue || s.ParentId.Equals(parentId)) && (!enabled.HasValue || s.Enabled.Equals(enabled) && (string.IsNullOrEmpty(culture) || s.Culture.Equals(culture))) select s; foreach (Fwk.ConfigData.fwk_Param param_db in rulesinCat.ToList<Fwk.ConfigData.fwk_Param>()) { wParamBE = new ParamBE(); wParamBE.ParamId = param_db.ParamId; wParamBE.ParentId = param_db.ParentId; wParamBE.Name = param_db.Name; wParamBE.Description = param_db.Description; wParamBE.Enabled = param_db.Enabled; wParamBE.Culture = param_db.Culture; wParamBE.Id = param_db.Id; wParamList.Add(wParamBE); } } return wParamList; } catch (Exception ex) { throw ex; } }
/// <summary> /// Actualiza fwk_Param /// </summary> /// <param name="paramBE"></param> /// <param name="userUpdateId"></param> /// <param name="cnnStringName"></param> public static void Update(ParamBE paramBE, Guid?userUpdateId, string cnnStringName) { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { Fwk.ConfigData.fwk_Param param = dc.fwk_Params.Where(p => p.Id.Equals(paramBE.Id)).FirstOrDefault(); if (param != null) { param.Enabled = true; param.Name = paramBE.Name; param.Culture = paramBE.Culture; param.Description = paramBE.Description; //param.ParamId = paramBE.ParamId; //param.ParentId = paramBE.ParentId; dc.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="paramBE"></param> /// <param name="userId"></param> /// <param name="cnnStringName"></param> public static void Create(ParamBE paramBE, Guid?userId, string cnnStringName) { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { Fwk.ConfigData.fwk_Param param = new ConfigData.fwk_Param(); param.Culture = paramBE.Culture; param.Description = paramBE.Description; param.Enabled = true; param.Name = paramBE.Name; param.ParamId = paramBE.ParamId; param.ParentId = paramBE.ParentId; dc.fwk_Params.InsertOnSubmit(param); dc.SubmitChanges(); paramBE.Id = param.Id; } }
/// <summary> /// Retorna parametros por id, id padre, y filtra x vigentes o no vigentes La cultura puede se String.Empty /// en cuyo caso no la tendra en cuenta para el filtro /// </summary> /// <param name="parentId">Relacion con otro param</param> /// <param name="enabled">Vigentes o no</param> /// <param name="culture">Cultura que se desea consultar: th-TH, en-US, es-AR etc etc</param> /// <param name="cnnStringName">Cadena de coneccion</param> /// <returns></returns> public static ParamList RetriveByParams(int?parentId, bool?enabled, string culture, string cnnStringName) { ParamList wParamList = new ParamList(); ParamBE wParamBE = null; try { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { var rulesinCat = from s in dc.fwk_Params where (!parentId.HasValue || s.ParentId.Equals(parentId)) && (!enabled.HasValue || s.Enabled.Equals(enabled) && (string.IsNullOrEmpty(culture) || s.Culture.Equals(culture))) select s; foreach (Fwk.ConfigData.fwk_Param param_db in rulesinCat.ToList <Fwk.ConfigData.fwk_Param>()) { wParamBE = new ParamBE(); wParamBE.ParamId = param_db.ParamId; wParamBE.ParentId = param_db.ParentId; wParamBE.Name = param_db.Name; wParamBE.Description = param_db.Description; wParamBE.Enabled = param_db.Enabled; wParamBE.Culture = param_db.Culture; wParamBE.Id = param_db.Id; wParamList.Add(wParamBE); } } return(wParamList); } catch (Exception ex) { throw ex; } }
public void CreateParamTest() { ParamBE pParam = new ParamBE (); pParam.Description = "DESC1"; pParam.Enabled= true; pParam.ParamId = 9002; pParam.ParamTypeId = 9000; pParam.Name = "parameter 1"; try { //ParamsController.CreateParam(wrapperProviderName, pParam); } catch(Exception ex) { Assert.AreEqual(ex,null,ex.Message); } }
private void button9_Click(object sender, EventArgs e) { Sebito.BackEnd.BusinessEntities.ParamBE param = new ParamBE (); param = ParamBE.GetFromXml < ParamBE>(""); }
/// <summary> /// Actualiza fwk_Param /// </summary> /// <param name="paramBE"></param> /// <param name="userUpdateId"></param> /// <param name="cnnStringName"></param> public static void Update(ParamBE paramBE, Guid? userUpdateId, string cnnStringName) { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { Fwk.ConfigData.fwk_Param param = dc.fwk_Params.Where(p => p.Id.Equals(paramBE.Id)).FirstOrDefault(); if (param != null) { param.Enabled = true; param.Name = paramBE.Name; param.Culture = paramBE.Culture; param.Description = paramBE.Description; //param.ParamId = paramBE.ParamId; //param.ParentId = paramBE.ParentId; dc.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="paramBE"></param> /// <param name="userId"></param> /// <param name="cnnStringName"></param> public static void Create(ParamBE paramBE, Guid? userId, string cnnStringName) { using (Fwk.ConfigData.FwkDatacontext dc = new Fwk.ConfigData.FwkDatacontext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringName].ConnectionString)) { Fwk.ConfigData.fwk_Param param = new ConfigData.fwk_Param(); param.Culture = paramBE.Culture; param.Description = paramBE.Description; param.Enabled = true; param.Name = paramBE.Name; param.ParamId = paramBE.ParamId; param.ParentId = paramBE.ParentId; dc.fwk_Params.InsertOnSubmit(param); dc.SubmitChanges(); paramBE.Id = param.Id; } }
private void button9_Click(object sender, EventArgs e) { Sebito.BackEnd.BusinessEntities.ParamBE param = new ParamBE(); param = ParamBE.GetFromXml <ParamBE>(""); }