public static string getName()
{
string name = "";
ConnectionStringSettings myConnectionString = ConfigurationManager.ConnectionStrings["LibrarySystem.Properties.Settings.LibraryConnectionString"];
using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
{
myDatabaseConnection.Open();
using (SqlCommand mySqlCommand = new SqlCommand("select Top 1 Name from Setting Order By SettingID Desc", myDatabaseConnection))
var NameObj = mySqlCommand.ExecuteScalar()
if NameObj != null then
name = NameObj.ToString()
}
return name;
}
private void btnConvert_Click(object sender, EventArgs e)
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.Filter = "XML Document (.xml)|*.xml";
fileDialog.FilterIndex = 1;
fileDialog.Multiselect = false;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
// Put file path in textbox
string sFileName = fileDialog.FileName;
string sFilePath = sFileName.Substring(0, sFileName.LastIndexOf('\\'));
txtFilePath.Text = sFileName;
// Get folder path
string sFolderPath = sFilePath.Substring(0, sFilePath.LastIndexOf('\\'));
string newFolder = Path.GetPathRoot(sFolderPath);
// Get Folder Name
var length = sFilePath.Length;
var index = sFilePath.LastIndexOf("-") + 1;
var ind = sFilePath.LastIndexOf("\\") + 1;
string sFolderName = sFilePath.Substring(index, length - index);
string folderName = sFilePath.Substring(ind, length - ind);
// Get App Number
var ind1 = folderName.LastIndexOf("-");
string appNum = folderName.Substring(0, ind1);
var ind2 = appNum.LastIndexOf("-") + 1;
var foldLeng = appNum.Length;
string appNum1 = appNum.Substring(ind2, foldLeng - ind2);
// Create new folder
string pathString = System.IO.Path.Combine(sFolderPath, "external-" + sFolderName);
System.IO.Directory.CreateDirectory(pathString);
string imagefolder = System.IO.Path.Combine(pathString, "images");
System.IO.Directory.CreateDirectory(imagefolder);
string addtlFiles = string.Empty;
// Copy images and PDF files
string appFolder = sFilePath + "\\app_resources";
string screenshotFolder = sFilePath + "\\app_resources\\" + appNum1 + "\\screenshot";
string[] imgfiles = Directory.GetFiles(appFolder, "*.png*", SearchOption.AllDirectories);
string[] pdffiles = Directory.GetFiles(appFolder, "*.pdf*", SearchOption.AllDirectories);
string[] screenshotfiles = null;
string myAppLogoIcon = sFilePath + "\\app_resources\\" + appNum1 + "\\myAppIcon";
//string[] myAppLogoIconFiles = Directory.GetFiles(myAppLogoIcon, "*.png*", SearchOption.AllDirectories);
string[] myAppLogoIconFiles = null;
if (Directory.Exists(myAppLogoIcon))
{
myAppLogoIconFiles = Directory.GetFiles(myAppLogoIcon, "*.png*", SearchOption.AllDirectories);
foreach (string s in myAppLogoIconFiles)
{
string fileName = System.IO.Path.GetFileName(s);
string destFile = System.IO.Path.Combine(imagefolder, fileName);
System.IO.File.Copy(s, destFile, true);
}
}
//if (Directory.Exists(screenshotFolder))
//{
// screenshotfiles = Directory.GetFiles(screenshotFolder, "*.png*", SearchOption.AllDirectories);
//}
//foreach (string s in imgfiles)
//{
// string fileName = System.IO.Path.GetFileName(s);
// string destFile = System.IO.Path.Combine(imagefolder, fileName);
// System.IO.File.Copy(s, destFile, true);
//}
if (pdffiles.Length > 0)
{
// Create additionalfiles folder if ther are PDF files
addtlFiles = System.IO.Path.Combine(pathString, "additionalfiles");
System.IO.Directory.CreateDirectory(addtlFiles);
foreach (string s in pdffiles)
{
string fileName = System.IO.Path.GetFileName(s);
string destFile = System.IO.Path.Combine(addtlFiles, fileName);
System.IO.File.Copy(s, destFile, true);
}
}
// Display XML file contents
XmlDocument doc = new XmlDocument();
doc.Load(fileDialog.FileName);
txtXmlText.Text = XElement.Parse(doc.OuterXml).ToString();
// Get XML elements by tag name
XML xml = new XML();
if (doc.SelectSingleNode(".//uuid") != null)
{
XmlNode uuid = doc.SelectSingleNode(".//uuid");
xml.uuid = uuid.InnerText;
}
if (doc.SelectSingleNode(".//name") != null)
{
XmlNode name = doc.SelectSingleNode(".//name");
xml.name = name.InnerText;
}
if (doc.SelectSingleNode(".//listing/blurb") != null)
{
XmlNode blurb = doc.SelectSingleNode(".//listing/blurb");
xml.blurb = blurb.InnerText;
}
if (doc.SelectSingleNode(".//overview/splashTitle") != null)
{
XmlNode splashTitle = doc.SelectSingleNode(".//overview/splashTitle");
xml.splashTitle = splashTitle.InnerText;
}
if (doc.SelectSingleNode(".//overview/splashDescription") != null)
{
XmlNode splashDescription = doc.SelectSingleNode(".//overview/splashDescription");
xml.splashDescription = splashDescription.InnerText;
}
if (doc.SelectSingleNode(".//listing/myAppLogoIconUrl") != null)
{
XmlNode myAppLogoIconUrl = doc.SelectSingleNode(".//listing/myAppLogoIconUrl");
xml.myAppLogoIconUrl = myAppLogoIconUrl.InnerText;
}
if (doc.SelectSingleNode(".//listing/companyName") != null)
{
XmlNode companyName = doc.SelectSingleNode(".//listing/companyName");
xml.companyName = companyName.InnerText;
}
if (doc.SelectSingleNode(".//support/email") != null)
{
XmlNode email = doc.SelectSingleNode(".//support/email");
xml.email = email.InnerText;
}
if (doc.SelectSingleNode(".//termsUrl") != null)
{
XmlNode termsUrl = doc.SelectSingleNode(".//termsUrl");
xml.termsUrl = termsUrl.InnerText;
}
if (doc.SelectSingleNode(".//support/knowledgebaseUrl") != null)
{
XmlNode knowledgebaseUrl = doc.SelectSingleNode(".//support/knowledgebaseUrl");
xml.knowledgebaseUrl = knowledgebaseUrl.InnerText;
}
if (doc.SelectSingleNode(".//referUrl") != null)
{
XmlNode referUrl = doc.SelectSingleNode(".//referUrl");
xml.referUrl = referUrl.InnerText;
}
XDocument xdoc = XDocument.Load(fileDialog.FileName);
XElement root = XElement.Parse(xdoc.ToString());
//var version = (from n in root.Descendants("version")
// select n).ToString();
//if (version != null || version != string.Empty)
//{
// xml.version = version;
//}
if (doc.SelectSingleNode(".//listing/languages/language") != null)
{
XmlNodeList language = doc.SelectNodes(".//listing/languages/language");
List <string> list = new List <string>();
foreach (XmlNode n in language)
{
list.Add(n.InnerText);
}
xml.language = list.ToArray();
}
List <string> headerList = new List <string>();
List <string> descList = new List <string>();
if (doc.SelectNodes(".//overview/benefits/benefit/title") != null)
{
XmlNodeList header = doc.SelectNodes(".//overview/benefits/benefit/title");
foreach (XmlNode n in header)
{
headerList.Add(n.InnerText);
}
}
if (doc.SelectNodes(".//overview/benefits/benefit/description") != null)
{
XmlNodeList description = doc.SelectNodes(".//overview/benefits/benefit/description");
foreach (XmlNode n in description)
{
descList.Add(n.InnerText);
}
}
if (doc.SelectNodes(".//features/feature/header") != null)
{
XmlNodeList header = doc.SelectNodes(".//features/feature/header");
foreach (XmlNode n in header)
{
headerList.Add(n.InnerText);
}
}
if (doc.SelectNodes(".//features/feature/description") != null)
{
XmlNodeList description = doc.SelectNodes(".//features/feature/description");
foreach (XmlNode n in description)
{
descList.Add(n.InnerText);
}
}
xml.header = headerList.ToArray();
xml.description = descList.ToArray();
if (doc.SelectNodes(".//tags/tag/id") != null)
{
XmlNodeList categoriesId = doc.SelectNodes(".//tags/tag/id");
List <string> list = new List <string>();
foreach (XmlNode n in categoriesId)
{
list.Add(n.InnerText);
}
xml.categoriesId = list.ToArray();
}
var imageUrl = (from n in root.Descendants("imageUrl")
select n).ToList();
if (imageUrl != null)
{
List <string> list = new List <string>();
foreach (XElement n in imageUrl)
{
list.Add(n.Value);
}
xml.imageUrl = list.ToArray();
}
if (doc.SelectNodes(".//tags/tag/name") != null)
{
XmlNodeList categoriesName = doc.SelectNodes(".//tags/tag/name");
List <string> list = new List <string>();
foreach (XmlNode n in categoriesName)
{
list.Add(n.InnerText);
}
xml.categoriesName = list.ToArray();
}
if (doc.SelectSingleNode(".//overview/demoUrl") != null)
{
XmlNodeList demoUrl = doc.SelectNodes(".//overview/demoUrl");
List <string> list = new List <string>();
foreach (XmlNode n in demoUrl)
{
list.Add(n.InnerText);
}
xml.demoUrl = list.ToArray();
}
Categories result = new Categories();
if (doc.SelectSingleNode(".//categories") != null)
{
XmlNode categories = doc.SelectSingleNode(".//categories");
string text = categories.OuterXml;
XmlSerializer serializer = new XmlSerializer(typeof(Categories));
using (TextReader reader = new StringReader(text))
{
result = (Categories)serializer.Deserialize(reader);
}
// Call GenerateCategories(xml.uuid, categories)
}
// Convert XML to JSON string
JSON json = new JSON();
List <NameObj> JsonPlatformsList = new List <NameObj>();
List <string> catList = new List <string>();
List <string> images = new List <string>();
List <JsonObj> pdfs = new List <JsonObj>();
string fullDesc = string.Empty;
string subLoc = string.Empty;
JsonObj jsonName = new JsonObj();
JsonObj jsonTagline = new JsonObj();
JsonObj jsonBriefDesc = new JsonObj();
JsonObj jsonFullDesc = new JsonObj();
JsonObj jsonCompanyName = new JsonObj();
JsonObj jsonWebsite = new JsonObj();
JsonObj jsonMarketingURL = new JsonObj();
for (int x = 0; x < xml.header.Length; x++)
{
fullDesc = fullDesc + "**" + xml.header[x] + "** \n\n " + xml.description[x] + "\n\n ";
}
foreach (var catName in xml.categoriesName)
{
if (catName == "PureEngage Cloud" || catName == "PureEngage on Premises" || catName == "PureConnect Cloud" || catName == "PureConnect on Premises")
{
NameObj jsonPlatforms = new NameObj();
NameObj PureEngage = (from x in JsonPlatformsList where x.name == "PureEngage" select x).FirstOrDefault();
NameObj PureConnect = (from x in JsonPlatformsList where x.name == "PureConnect" select x).FirstOrDefault();
if (catName.Contains("PureEngage"))
{
if (PureEngage != null)
{
if (catName.Contains("Premise"))
{
List <string> sub = PureEngage.subcategories.ToList();
sub.Add("Premise");
PureEngage.subcategories = sub.ToArray();
}
else if (catName.Contains("Cloud"))
{
List <string> sub = PureEngage.subcategories.ToList();
sub.Add("Cloud");
PureEngage.subcategories = sub.ToArray();
}
}
else
{
jsonPlatforms.name = "PureEngage";
if (catName.Contains("Premise"))
{
List <string> sub = new List <string>();
sub.Add("Premise");
jsonPlatforms.subcategories = sub.ToArray();
}
else if (catName.Contains("Cloud"))
{
List <string> sub = new List <string>();
sub.Add("Cloud");
jsonPlatforms.subcategories = sub.ToArray();
}
JsonPlatformsList.Add(jsonPlatforms);
}
}
else if (catName.Contains("PureConnect"))
{
if (PureConnect != null)
{
if (catName.Contains("Premise"))
{
List <string> sub = PureConnect.subcategories.ToList();
sub.Add("Premise");
PureConnect.subcategories = sub.ToArray();
}
else if (catName.Contains("Cloud"))
{
List <string> sub = PureConnect.subcategories.ToList();
sub.Add("Cloud");
PureConnect.subcategories = sub.ToArray();
}
}
else
{
jsonPlatforms.name = "PureConnect";
if (catName.Contains("Premise"))
{
List <string> sub = new List <string>();
sub.Add("Premise");
jsonPlatforms.subcategories = sub.ToArray();
}
else if (catName.Contains("Cloud"))
{
List <string> sub = new List <string>();
sub.Add("Cloud");
jsonPlatforms.subcategories = sub.ToArray();
}
JsonPlatformsList.Add(jsonPlatforms);
}
}
}
}
jsonTagline.enus = xml.blurb;
jsonBriefDesc.enus = xml.splashDescription;
jsonCompanyName.enus = xml.companyName;
jsonWebsite.enus = "";
jsonFullDesc.enus = fullDesc;
json.id = xml.uuid;
json.registryId = "";
jsonName.enus = xml.name;
json.name = jsonName;
json.tagline = jsonTagline;
json.briefDescription = jsonBriefDesc;
json.fullDescription = jsonFullDesc;
json.platforms = JsonPlatformsList;
json.companyName = jsonCompanyName;
json.website = jsonWebsite;
json.videoLinks = xml.demoUrl;
json.vendorEmail = xml.email;
json.termsOfService = xml.termsUrl;
json.helpDocumentationURL = xml.knowledgebaseUrl;
List <string> lang = new List <string>();
foreach (string l in xml.language)
{
if (l == "en")
{
lang.Add("english");
}
else if (l == "fr")
{
lang.Add("french");
}
else if (l == "de")
{
lang.Add("german");
}
else if (l == "sv")
{
lang.Add("swedish");
}
}
json.languages = lang.ToArray();
foreach (string s in pdffiles)
{
string fileName = System.IO.Path.GetFileName(s);
string pdf = addtlFiles + "\\" + fileName;
int len = pdf.Length;
int i = pdf.LastIndexOf("external");
subLoc = pdf.Substring(i, len - i);
subLoc = subLoc.Replace("\\", "/");
jsonMarketingURL.enus = subLoc;
}
json.marketingURL = jsonMarketingURL;
if (xml.categoriesId.Length > 3)
{
string cat = "universal";
catList.Add(cat);
json.industries = catList.ToArray();
}
else
{
json.industries = xml.categoriesId;
}
if (xml.referUrl != null)
{
int pos = xml.referUrl.IndexOf("cid");
string cid = xml.referUrl.Substring(pos + 4, 15);
json.cid = cid;
}
if (screenshotfiles != null)
{
// Uncomment once Zach has final requirement
//foreach (string s in screenshotfiles)
//{
// string fileName = System.IO.Path.GetFileName(s);
// string image = imagefolder + "\\" + fileName;
// int len = image.Length;
// int i = image.LastIndexOf("external");
// subLoc = image.Substring(i, len - i);
// subLoc = subLoc.Replace("\\", "/");
// images.Add(subLoc);
//}
json.screenshots = images.ToArray();
}
int a = xml.myAppLogoIconUrl.Length;
int b = xml.myAppLogoIconUrl.LastIndexOf("/") + 1;
string file = xml.myAppLogoIconUrl.Substring(b, a - b);
string myAppLogoImage = imagefolder + "\\" + file;
int appLogLen = myAppLogoImage.Length;
int i1 = myAppLogoImage.LastIndexOf("external");
subLoc = myAppLogoImage.Substring(i1, appLogLen - i1);
subLoc = subLoc.Replace("\\", "/");
json.companyLogo = subLoc;
json.appLogo = subLoc;
var jsonCon = JsonConvert.SerializeObject(json, Newtonsoft.Json.Formatting.Indented);
jsonCon = jsonCon.Replace("enus", "en-us");
jsonCon = jsonCon.Replace("null", "\"\"");
jsonCon = jsonCon.Replace("\"registryId\": \"\",", "\"registryId\": {},");
jsonCon = jsonCon.Replace("\"videoLinks\": \"\",", "\"videoLinks\": [],");
jsonCon = jsonCon.Replace("\"screenshots\": \"\",", "\"screenshots\": [],");
txtJsonText.Text = jsonCon;
// Write JSON to file
File.WriteAllText(pathString + "\\data.json", jsonCon);
}
}
public void Visit(NameObj nameObj)
{
throw new InvalidOperationException();
}
