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(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringNAme].ConnectionString)) { 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(System.Configuration.ConfigurationManager.ConnectionStrings["bb"].ConnectionString)) { 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(); } }
internal static void Remove(string group, string key) { using (ConfigDataContext dc = new ConfigDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringNAme].ConnectionString)) { 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(); } }
internal static void CreateNewParam(ParamCampaing param ,string relatedName, out string errMsg) { string language; errMsg = string.Empty; ParamCampaing record = null; Boolean wExist = false; using (ConfigDataContext dc = new ConfigDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringNAme].ConnectionString)) { 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.ParamCampaings.Any(p => p.Language.Equals(language) && p.ParamCampaingIdRelated.Equals(param.ParamCampaingIdRelated) && p.ParamCapaingId.Equals(param.ParamCapaingId)); if (wExist) { errMsg = String.Format("Ya existe la param {0} codig:{1} en el grupo {2} para alguno de los lenguajes", param.Name,param.ParamCapaingId, relatedName); return; } else { record = new ParamCampaing(); record.Language = language; record.ParamCampaingIdRelated = param.ParamCampaingIdRelated; record.ParamCapaingId = param.ParamCapaingId; record.Name = param.Name; record.Remarks = param.Remarks; dc.ParamCampaings.InsertOnSubmit(record); } dc.SubmitChanges(); } } }
internal static void Remove_Param(int paramCampaingId) { using (ConfigDataContext dc = new ConfigDataContext(System.Configuration.ConfigurationManager.ConnectionStrings[cnnStringNAme].ConnectionString)) { var records = dc.ParamCampaings.Where(p => p.ParamCapaingId.Equals(paramCampaingId) ); foreach (ParamCampaing param in records) { dc.ParamCampaings.DeleteOnSubmit(param); } dc.SubmitChanges(); } }
/// <summary> /// /// </summary> /// <param name="language">Lenguaje</param> /// <param name="paramCampaingIdRelated">Padre o tipo</param> /// <param name="paramCapaingId">Codigo de param o identificador</param> /// <param name="name"></param> internal static void CreateORUpdate_Param(string language, int paramCampaingIdRelated, int paramCapaingId, string name) { using (ConfigDataContext dc = new ConfigDataContext(System.Configuration.ConfigurationManager.ConnectionStrings["bb"].ConnectionString)) { bool wExist = false; ParamCampaing record; //Verifico que clave y valor exista wExist = dc.ParamCampaings.Any(p => p.Language.Equals(language) && p.ParamCampaingIdRelated.Equals(paramCampaingIdRelated) && p.ParamCapaingId.Equals(paramCapaingId)); if (wExist) { record = dc.ParamCampaings.Where(p => p.Language.Equals(language) && p.ParamCampaingIdRelated.Equals(paramCampaingIdRelated) && p.ParamCapaingId.Equals(paramCapaingId)).FirstOrDefault<ParamCampaing>(); record.Name = name;// e.Value.ToString().Trim(); } else { record = new ParamCampaing(); record.Language = language; record.ParamCapaingId = paramCapaingId; record.ParamCampaingIdRelated = paramCampaingIdRelated; //record.Remarks = ""; record.Name = name; dc.ParamCampaings.InsertOnSubmit(record); } dc.SubmitChanges(); } }