/// <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>("");
}
