internal static void CreateNewKey(string group, string key, out string errorMsg)
{
string language;
errorMsg = string.Empty;
fwk_ConfigManager record = null;
Boolean wExist = false;
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
for (int i = 0; i < Fwk.Configuration.ConfigurationManager.ConfigProvider.Providers.Count; i++)
{
language = Fwk.Configuration.ConfigurationManager.ConfigProvider.Providers[i].Name;
//Verifico que clave y valor exista
wExist = dc.fwk_ConfigManagers.Any(p => p.ConfigurationFileName.Equals(language) &&
p.group.Equals(group) &&
p.key.Equals(key));
if (wExist)
{
errorMsg = String.Format("Ya existe la clave {0} en el grupo {1} para alguno de los lenguajes", key, group);
continue;
}
else
{
record = new fwk_ConfigManager();
record.ConfigurationFileName = language;
record.group = group;
record.key = key;
dc.fwk_ConfigManagers.InsertOnSubmit(record);
}
dc.SubmitChanges();
}
}
}
internal static void CreateORUpdateKey(string language, string group, string key, string value)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
bool wExist = false;
fwk_ConfigManager record;
//Verifico que clave y valor exista
wExist = dc.fwk_ConfigManagers.Any(p => p.ConfigurationFileName.Equals(language) &&
p.group.Equals(group) &&
p.key.Equals(key));
if (wExist)
{
record = dc.fwk_ConfigManagers.Where(p => p.ConfigurationFileName.Equals(language) &&
p.group.Equals(group) &&
p.key.Equals(key)).FirstOrDefault <fwk_ConfigManager>();
record.value = value;// e.Value.ToString().Trim();
}
else
{
record = new fwk_ConfigManager();
record.ConfigurationFileName = language;
record.group = group;
record.key = key;
record.value = value;
dc.fwk_ConfigManagers.InsertOnSubmit(record);
}
dc.SubmitChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="culture">Lenguaje</param>
/// <param name="parentId">Padre o tipo</param>
/// <param name="paramId">Codigo de param o identificador</param>
/// <param name="name"></param>
internal static void Param_Update(fwk_Param param)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
bool wExist = false;
fwk_Param record;
//Verifico que clave y valor exista
wExist = dc.fwk_Params.Any(p => p.Culture.Equals(param.Culture)
//&& p.ParentId.Equals(param.ParentId)
&& p.Name.Equals(param.Name) &&
p.ParamId.Equals(param.ParamId) == false);
if (wExist)
{
throw new Fwk.Exceptions.FunctionalException(String.Format("Ya existe la param {0} codig:{1} tipo {2} cultura:{2}", param.Name, param.ParamId, param.Culture));
}
else
{
record = dc.fwk_Params.Where(p => p.Id.Equals(param.Id)).FirstOrDefault <fwk_Param>();
record.Name = param.Name;
record.ParamId = param.ParamId;
record.ParentId = param.ParentId;
record.Description = param.Description;
record.Culture = param.Culture;
dc.SubmitChanges();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
internal static void Param_CreateNew(fwk_Param param)
{
Param_CreateNew_Validate_Existent(param);
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
param.Enabled = true;
dc.fwk_Params.InsertOnSubmit(param);
dc.SubmitChanges();
}
}
/// <summary>
/// Verifico si tiene algun hijo
/// </summary>
/// <param name="param"></param>
internal static void Param_ValidateRemove(fwk_Param param)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
//Verifico si tiene algun hijo
bool wExist = dc.fwk_Params.Any(p => p.ParentId.Equals(param.ParamId));
if (wExist)
{
throw new Fwk.Exceptions.FunctionalException(String.Format("{0} es padre de otros en la Base de datos", param.Name));
}
}
}
internal static void Param_Remove(int id)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
var records = dc.fwk_Params.Where(p => p.Id.Equals(id));
foreach (fwk_Param param in records)
{
dc.fwk_Params.DeleteOnSubmit(param);
}
dc.SubmitChanges();
}
}
internal static void Remove(string group, string key)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
var records = dc.fwk_ConfigManagers.Where(p =>
p.group.Equals(group) &&
p.key.Equals(key));
foreach (fwk_ConfigManager config in records)
{
dc.fwk_ConfigManagers.DeleteOnSubmit(config);
}
dc.SubmitChanges();
}
}
/// <summary>
/// Verifico que clave y valor exista
/// </summary>
/// <param name="param"></param>
internal static void Param_CreateNew_Validate_Existent(fwk_Param param)
{
Boolean wExist = false;
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
wExist = dc.fwk_Params.Any(p => p.Culture.Equals(param.Culture) && p.ParamId.Equals(param.ParamId));
if (wExist)
{
param = dc.fwk_Params.Where(p => p.Culture.Equals(param.Culture) && p.ParamId.Equals(param.ParamId)).FirstOrDefault();
throw new Fwk.Exceptions.FunctionalException(String.Format("Ya existe la param {0} codigo: {1} tipo {2} cultura:{2}", param.Name, param.ParamId, param.Culture));
}
}
}
/// <summary>
/// Verifico si existe un registros con los parametros asados.
/// ParentId
/// ParamId
/// cultura
/// </summary>
/// <param name="culture">Lenguaje</param>
/// <param name="parentId">Padre o tipo</param>
/// <param name="paramId">ParamId o identificador</param>
internal static void Param_ValidateUpdate(fwk_Param param)
{
using (ConfigDataContext dc = new ConfigDataContext(cnnString))
{
bool wExist = false;
wExist = dc.fwk_Params.Any(p => p.Culture.Equals(param.Culture) &&
p.ParentId.Equals(param.ParentId)
//&& p.Name.Equals(param.Name)
&& p.ParamId.Equals(param.ParamId) == false);
if (wExist)
{
throw new Fwk.Exceptions.FunctionalException(String.Format("Ya existe la param {0} codig:{1} tipo {2} cultura:{2}", param.Name, param.ParamId, param.Culture));
}
}
}
