private bool InsertIntoCatalog() { string WebURL = Global.GetAdaptationUrl(); string AdaptationName = Global.adaptation_name; string AdaptedFor = Global.adapted_for; string SubNation = Global.sub_nation; string DbAdmName = Global.DbAdmName; string DbAdmInstitution = Global.DbAdmInstitution; string DbAdmEmail = Global.DbAdmEmail; string UnicefRegion = Global.UnicefRegion; string AdaptationYear = Global.AdaptationYear; //Check for newly added App Setting Key -Country XmlDocument XmlDoc; string AppSettingFile = string.Empty; AppSettingFile = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, ConfigurationManager.AppSettings[Constants.WebConfigKey.AppSettingFile]); XmlDoc = new XmlDocument(); XmlDoc.Load(AppSettingFile); Global.CheckAppSetting(XmlDoc, Constants.AppSettingKeys.Country, string.Empty); string Country = Global.Country; bool RetVal = false; string typeOfEmail = string.Empty; string DateCreated = string.Empty; string Visible = string.Empty; try { DIWorldwide.Catalog CatalogService = new DIWorldwide.Catalog(); CatalogService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.CatalogWebService; DataSet dsCatalogAdaptation = new DataSet(); dsCatalogAdaptation = CatalogService.CatalogExists(Global.GetAdaptationGUID()); if (dsCatalogAdaptation.Tables[0].Rows.Count == 0) { typeOfEmail = "New"; DateCreated = String.Format("{0:r}", DateTime.Now); } else { typeOfEmail = "Updated"; DateCreated = String.Format("{0:r}", Convert.ToDateTime(dsCatalogAdaptation.Tables[0].Rows[0][1])); Visible = dsCatalogAdaptation.Tables[0].Rows[0][2].ToString(); } if (CatalogService.SetCatalog(AdaptationName, "", "", false, true, WebURL, 0, 0, 0, 0, "", "", DateTime.Now.ToString(), 0, SubNation, "", DbAdmName, DbAdmInstitution, DbAdmEmail, UnicefRegion, AdaptationYear, "", "", AdaptedFor, Country, DateTime.Now.ToString(), Global.GetAdaptationGUID())) { RetVal = true; Frame_Message_And_Send_Catalog_Mail(AdaptationName, WebURL, Visible, DbAdmName, DbAdmInstitution, DbAdmEmail, AdaptedFor, Country, SubNation, DateCreated, String.Format("{0:r}", DateTime.Now), typeOfEmail); } } catch (Exception ex) { RetVal = false; Global.CreateExceptionString(ex, null); } return RetVal; }
public string AdminSaveAdaptation(string requestParam) { string RetVal = string.Empty; string[] Params; string AdaptationName = string.Empty; string Description = string.Empty; string Version = string.Empty; bool IsDesktop; bool IsWeb; string WebURL = string.Empty; int AreaCount; int IUSCount; int TimePeriodsCount; int DataValuesCount; string StartYear = string.Empty; string EndYear = string.Empty; string LastModifiedOn = string.Empty; int AreaNId; string SubNation = string.Empty; string CatalogImage = string.Empty; string DbAdmName = string.Empty; string DbAdmInstitution = string.Empty; string DbAdmEmail = string.Empty; string UnicefRegion = string.Empty; string AdaptationYear = string.Empty; string DbLanguages = string.Empty; string LangCode_CSVFiles = string.Empty; try { Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter); AdaptationName = Params[0]; Description = Params[1]; Version = Params[2]; IsDesktop = Convert.ToBoolean(Params[3]); IsWeb = Convert.ToBoolean(Params[4]); WebURL = Params[5]; AreaCount = Convert.ToInt32(Params[6]); IUSCount = Convert.ToInt32(Params[7]); TimePeriodsCount = Convert.ToInt32(Params[8]); DataValuesCount = Convert.ToInt32(Params[9]); StartYear = Params[10]; EndYear = Params[11]; LastModifiedOn = Params[12]; AreaNId = Convert.ToInt32(Params[13]); SubNation = Params[14]; CatalogImage = Params[15]; DbAdmName = Params[16]; DbAdmInstitution = Params[17]; DbAdmEmail = Params[18]; UnicefRegion = Params[19]; AdaptationYear = Params[20]; DbLanguages = Params[21]; if(Params.Length > 22) LangCode_CSVFiles = Params[22]; string AdaptedFor = Global.adapted_for; XmlDocument XmlDoc; string AppSettingFile = string.Empty; AppSettingFile = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, ConfigurationManager.AppSettings[Constants.WebConfigKey.AppSettingFile]); XmlDoc = new XmlDocument(); XmlDoc.Load(AppSettingFile); Global.CheckAppSetting(XmlDoc, Constants.AppSettingKeys.Country, string.Empty); string Country = Global.Country; string typeOfEmail = string.Empty; DIWorldwide.Catalog CatalogService = new DIWorldwide.Catalog(); CatalogService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.CatalogWebService; DataSet dsCatalogAdaptation = new DataSet(); dsCatalogAdaptation = CatalogService.CatalogExists(Global.GetAdaptationGUID()); string DateCreated = string.Empty; string Visible = string.Empty; if (dsCatalogAdaptation.Tables[0].Rows.Count == 0) { typeOfEmail = "New"; DateCreated = String.Format("{0:r}", DateTime.Now); } else { typeOfEmail = "Updated"; DateCreated = String.Format("{0:r}", Convert.ToDateTime(dsCatalogAdaptation.Tables[0].Rows[0][1])); Visible = dsCatalogAdaptation.Tables[0].Rows[0][2].ToString(); } if (CatalogService.SetCatalog(AdaptationName, Description, Version, IsDesktop, IsWeb, WebURL, AreaCount, IUSCount, TimePeriodsCount, DataValuesCount, StartYear, EndYear, LastModifiedOn, AreaNId, SubNation, CatalogImage, DbAdmName, DbAdmInstitution, DbAdmEmail, UnicefRegion, AdaptationYear, DbLanguages, LangCode_CSVFiles, AdaptedFor, Country, DateTime.Now.ToString(), Global.GetAdaptationGUID())) { RetVal = "true"; Frame_Message_And_Send_Catalog_Mail(AdaptationName, WebURL, Visible, DbAdmName, DbAdmInstitution, DbAdmEmail, AdaptedFor, Country, SubNation, DateCreated, String.Format("{0:r}", DateTime.Now), typeOfEmail); } } catch (Exception ex) { Global.CreateExceptionString(ex, null); } return RetVal; }