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;
}
