//Employee List in XML Format public XmlDocument GetEmployeeList() { XmlDocument xml = new XmlDocument(); xml.LoadXml(XMLGenerator.GetXMLFromObject(employeeList)); return(xml); }
protected void OnAgregarCancion(object sender, EventArgs e) { AddSongUI addSongUI = new AddSongUI(mainWindow); XDocument document = XMLGenerator.RequestSongs(page); UpdateSongs(document); }
private static XmlDocument GenerateLoginTicketRequestXML(LoginTicketRequests loginTicketRequest) { XmlQualifiedName qualifiedName = new XmlQualifiedName(loginTicketRequestNodeName); //TODO: SACAR EL hardcode del XSD //XMLGenerator generator = new XMLGenerator(@"C:\Vero\Proyectos\MFD\MFDHOMO\MFD\LoginTicketRequest.xsd", qualifiedName); XMLGenerator generator = new XMLGenerator(AppDomain.CurrentDomain.BaseDirectory + @"LoginTicketRequest.xsd", qualifiedName); Stream xmlStream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(xmlStream, Encoding.UTF8); writer.Formatting = Formatting.Indented; generator.WriteXml(writer); XmlDocument document = new XmlDocument(); xmlStream.Seek(0, SeekOrigin.Begin); XmlReader reader = new XmlTextReader(xmlStream); document.Load(reader); reader.Close(); writer.Close(); xmlStream.Close(); xmlStream.Dispose(); XmlElement headerNode = document[loginTicketRequestNodeName][HeaderNodeName]; headerNode[SourceNodeName].InnerText = loginTicketRequest.Empresa.DNOrigen; headerNode[DestinationNodeName].InnerText = loginTicketRequest.Empresa.DNDestino; //TODO: ver cual debe ser el loginTicketRequest.Id headerNode[UniqueIDNodeName].InnerText = loginTicketRequest.Id.ToString(); headerNode[GenerationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.GenerationTime, XmlDateTimeSerializationMode.RoundtripKind); headerNode[ExpirationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.ExpirationTime, XmlDateTimeSerializationMode.RoundtripKind); document[loginTicketRequestNodeName][ServiceNodeName].InnerText = "wsfe"; return(document); }
private void ImportFromSqlToXml(object sender, EventArgs e) { TravelAgencyDbContext dbContext = new TravelAgencyDbContext(); XMLGenerator xmlGenerator = new XMLGenerator(); this.GenerateXmlButtonHandler(sender, e); }
public static int ImportarCanciones(CacheItem documento, bool reemplazarExistentes) { MemoryStream file = new MemoryStream(documento.Content, false); var settings = new XmlReaderSettings(); var xmlReader = XmlTextReader.Create(file, settings); XPathDocument xPath = new XPathDocument(xmlReader); var navigator = xPath.CreateNavigator(); XmlDocument xmldocument = new XmlDocument(); xmldocument.InnerXml = navigator.OuterXml; List <Cancion> canciones = XMLGenerator.ImportarCancionesDesdeXml(xmldocument); foreach (var item in canciones) { int idCancion = CancionesComponent.GetIdCancion(item.Titulo); if (idCancion > 0 && reemplazarExistentes) { Cancion cancion = new Cancion(idCancion, item.Titulo, item.Tono, item.Compas, item.Letra, true, item.DuracionEstimada, string.Empty); CancionesComponent.SaveCancion(cancion); } else { CancionesComponent.CreateCancion(item); } } return(canciones.Count); }
public string GetLoginUserInfo(string token) { this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.PARAMATER, string.Format("token:{0}", token)); //验证参数 bool ret = ArgumentHelper.Validate("token", token, false); if (!ret) { this.log(LogLevel.ERROR, FunctionName.WS_GET_LOGIN_USER_INFO, "token", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, ""); return(""); } //取token的登录用户ID string cu_id = this.GetCustomerService().GetLoginCustomerUserIDByToken(token); if (string.IsNullOrEmpty(cu_id)) { this.log(LogLevel.ERROR, FunctionName.WS_GET_LOGIN_USER_INFO, "CustomerUserID", "未找到"); this.log(LogLevel.INFO, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, ""); return(""); } this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, "CustomerUserID", cu_id); //取登录用户 CustomerUserInfo cUser = this.GetCustomerService().GetCustomerUserByID(cu_id); if (cUser == null) { this.log(LogLevel.ERROR, FunctionName.WS_GET_LOGIN_USER_INFO, "CustomerUser", "未找到"); this.log(LogLevel.INFO, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, ""); return(""); } LoggingUserInfo user = new LoggingUserInfo(); user.CustomerID = cUser.Customer.ID; user.CustomerCode = cUser.Customer.Code; user.CustomerName = cUser.Customer.Name; user.UserID = cUser.ID; user.UserName = cUser.Name; CustomerConnectInfo cConnect = this.GetCustomerService().GetCustomerConnectByID(cUser.Customer.ID); if (cConnect != null) { user.ConnectionString = cConnect.DBConnectionString; } string s = XMLGenerator.Serialize(user); this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, "DecryptResult", s); //加密 cPos.Admin.Service.BaseService base_service = this.GetCustomerService() as cPos.Admin.Service.BaseService; string output = base_service.EncryptStringByKeyFile(cConnect.KeyFile, s); this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, output); return(output); }
public void GenerateXMLFromXsd() { var generator = new XMLGenerator(); //generator.ReadSchemaFromXmlTextReader(@"C:\Dev\CTM.Transformers.Schema\home\v2.0\HomePolicy.xsd"); generator.ReadSchemaFromXmlTextReader(@"C:\Dev\XSDs\BritishGasRequest.xsd"); }
/// <summary> /// Returns a new Generator instance /// </summary> /// <param name="pProductStorageType">IActiveLock.ProductsStoreType - Storage Type!</param> /// <returns>IALUGenerator - New Generator instance</returns> /// <remarks></remarks> public _IALUGenerator GeneratorInstance(IActiveLock.ProductsStoreType pProductStorageType) { _IALUGenerator functionReturnValue = null; switch (pProductStorageType) { case IActiveLock.ProductsStoreType.alsINIFile: functionReturnValue = new INIGenerator(); break; case IActiveLock.ProductsStoreType.alsXMLFile: functionReturnValue = new XMLGenerator(); break; case IActiveLock.ProductsStoreType.alsMDBFile: functionReturnValue = new MDBGenerator(); break; //TODO - MSSQLGenerator //Case ProductsStoreType.alsMSSQL // Set GeneratorInstance = New MSSQLGenerator default: modActiveLock.Set_Locale(modActiveLock.regionalSymbol); Err().Raise(Globals.ActiveLockErrCodeConstants.AlerrNotImplemented, modTrial.ACTIVELOCKSTRING, modActiveLock.STRNOTIMPLEMENTED); functionReturnValue = null; break; } return(functionReturnValue); }
protected void SendSort(object sender, EventArgs e) { SocketClient.GetSocketClient().send(XMLGenerator.RequestSort(combobox1.ActiveText)); XDocument document = XMLGenerator.RequestSongs(page); UpdateSongs(document); //image1.Pixbuf; }
public bool SynTerminal(string customerID, int typeID, string terminalInfo) { this.log(LogLevel.DEBUG, FunctionName.WS_SYS_TERMINAL, MessageType.PARAMATER, "customerID: " + customerID); this.log(LogLevel.DEBUG, FunctionName.WS_SYS_TERMINAL, MessageType.PARAMATER, "typeID: " + typeID.ToString()); this.log(LogLevel.DEBUG, FunctionName.WS_SYS_TERMINAL, MessageType.PARAMATER, "terminalInfo: " + terminalInfo); //验证参数 bool ret = ArgumentHelper.Validate("customerID", customerID, false); if (!ret) { this.log(LogLevel.ERROR, FunctionName.WS_SYS_TERMINAL, "customerID", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_SYS_TERMINAL, MessageType.RESULT, ret.ToString()); return(ret); } CustomerConnectInfo cConnect = this.GetCustomerService().GetCustomerConnectByID(customerID); if (cConnect == null) { this.log(LogLevel.ERROR, FunctionName.WS_SYS_TERMINAL, "CustomerConnect", "未找到"); this.log(LogLevel.INFO, FunctionName.WS_SYS_TERMINAL, MessageType.RESULT, "false"); return(false); } if (typeID < 1 || typeID > 2) { this.log(LogLevel.ERROR, FunctionName.WS_SYS_TERMINAL, "typeID", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_SYS_TERMINAL, MessageType.RESULT, "false"); return(false); } //解密 cPos.Admin.Service.BaseService base_service = this.GetCustomerService() as cPos.Admin.Service.BaseService; string s = base_service.DecryptStringByCustomer(customerID, terminalInfo); this.log(LogLevel.DEBUG, FunctionName.WS_SYS_TERMINAL, "DecryptCustomerTerminal", s); CustomerTerminalInfo terminal = (CustomerTerminalInfo)XMLGenerator.Deserialize(typeof(CustomerTerminalInfo), s); terminal.Customer.ID = customerID; switch (typeID) { case 1: //新建 ret = this.GetCustomerService().InsertCustomerTerminalFromCP(terminal); break; case 2: //修改 ret = this.GetCustomerService().ModifyCustomerTerminalFromCP(terminal); break; default: ret = false; break; } this.log(LogLevel.INFO, FunctionName.WS_SYS_TERMINAL, MessageType.RESULT, ret.ToString()); return(ret); }
private MainWindow() : base(Gtk.WindowType.Toplevel) { this.player = new WaveOut(); Build(); XDocument xml = XMLGenerator.RequestSongs(0); UpdateSongs(xml); }
public string GetCustomerInfo(string customer_code) { CustomerInfo customerInfo = new CustomerInfo(); customerInfo = new cPos.Admin.Service.Implements.InitialService().GetCustomerInfoByCode(customer_code); string s = XMLGenerator.Serialize(customerInfo); return(s); }
public static void Main() { IDatabase db = new Database(); //read from zip file & populate the database with more data + create updates pdf, xml & json files var reader = new ReadExcelFromZip(); var movies = reader.SelectExcelFilesFromZip("../../../../Movies.zip"); foreach (var movie in movies) { Console.WriteLine(movie.Name); } var import = new MoviesImportToSql(); import.Import(movies); Console.WriteLine("Importing data from xml..."); //Importing data from xml XmlImporter.ImportXml(db); //Console.WriteLine("Importing data to Mongo..."); //Importing data to MongoDB //ImportToMongo.ImportToMongo.ImportData(); Console.WriteLine("Generating xml files..."); //Generating Xml file report var generateXMLFile = new XMLGenerator(); generateXMLFile.Generate(db); Console.WriteLine("Generating json files..."); //Generating Json file reports var generateJsonReports = new JSONGenerator(); generateJsonReports.Generate(db); Console.WriteLine("Generating pdf reports..."); //Generating Pdf fle reports var generatePdfReports = new PDFGenerator(); generatePdfReports.Generate(db); Console.WriteLine("Sending data to MySql..."); //Sending data to MySql var sendDataToMySQL = new MySqlManager(); sendDataToMySQL.SendDataToMySql(); Console.WriteLine("Exporting data from MySql to excel file..."); //Exporting data from MySql to excel file var mySqlExcelExport = new MySqlManager(); mySqlExcelExport.ExportDataFromMySql(); }
public static System.Web.Mvc.FileContentResult GenerarCancionesXML(IList <Cancion> canciones) { MemoryStream fileXmlCanciones = new MemoryStream(); var xmlDocument = XMLGenerator.GenerarXmlCancionesExport(canciones); xmlDocument.Save(fileXmlCanciones); FileContentResult file = new FileContentResult(fileXmlCanciones.ToArray(), "application/xml"); file.FileDownloadName = string.Format("IBVD_ExportCanciones_{0}.xml", DateTime.Now.ToString("dd-MM-yyyy hh:mm")); return(file); }
protected void PreviousPage(object sender, EventArgs e) { --page; if (page < 0) { page = 0; } XDocument xml = XMLGenerator.RequestSongs(page); UpdateSongs(xml); Pagina.Text = "" + (page + 1); }
protected void NextPage(object sender, EventArgs e) { if (button24.Label == " ") { } else { page++; } XDocument xml = XMLGenerator.RequestSongs(page); UpdateSongs(xml); Pagina.Text = "" + (page + 1); }
private void Edit(object sender, EventArgs e) { try { Button button = (Button)sender; string name = ""; string artist = ""; char separator = " ".ToCharArray()[0]; string buttonLabel = ""; if (button.Name == "1") { buttonLabel = button21.Label; name = buttonLabel.Split(separator)[0]; artist = buttonLabel.Split(separator)[2]; } else if (button.Name == "2") { buttonLabel = button22.Label; name = buttonLabel.Split(separator)[0]; artist = buttonLabel.Split(separator)[2]; } else if (button.Name == "3") { buttonLabel = button23.Label; name = buttonLabel.Split(separator)[0]; artist = buttonLabel.Split(separator)[2]; } else if (button.Name == "4") { buttonLabel = button24.Label; name = buttonLabel.Split(separator)[0]; artist = buttonLabel.Split(separator)[2]; } XDocument document = new XDocument(new XElement("Data", new XElement("opCode", 25), new XElement("SongName", name), new XElement("Artist", artist))); SocketClient.GetSocketClient().send(document); EditSong editSong = new EditSong(name, artist, page); document = XMLGenerator.RequestSongs(page); UpdateSongs(document); } catch (Exception) { AlertWindow alertWindow = new AlertWindow("Error: No se pudo eliminar el elemento o este no existe, por favor reintentar"); } }
public string GetItemInfoByBarcode(string barcode) { cPos.Model.LoggingSessionInfo loggingSessionInfo = new cPos.Model.LoggingSessionInfo(); var itemService = new ItemService(); var skuService = new SkuService(); ItemInfo item = new ItemInfo(); SkuInfo sku = skuService.GetSkuByBarcode(barcode); item.SkuInfoByBarcode = sku; if (sku != null) { item.ItemInfoByBarcode = itemService.GetItemInfoById(loggingSessionInfo, sku.item_id); } return(XMLGenerator.Serialize(item)); }
public void Generate() { StringWriter outStream = new StringWriter(); string tempDirectory = $"temp/{rnd.Next()}-{rnd.Next()}"; Directory.CreateDirectory(tempDirectory); XMLGenerator generator = new XMLGenerator(outStream, tempDirectory); bool loaded = true; loaded = loaded && generator.LoadOutagesFromCSV(OutagesCSV); loaded = loaded && generator.LoadCriticalBranchesFromCSV(CriticalBranchesCSV); if (loaded) { generator.DontAsk(); generator.SetSettings(Settings); if (generator.Generate()) { if (!IncludeXSD) { //Remove XSD files string[] xsdFiles = Directory.GetFiles(tempDirectory, "*.xsd"); foreach (var file in xsdFiles) { File.Delete(file); } } OutputFile = $"{tempDirectory}.zip"; ZipFile.CreateFromDirectory(tempDirectory, _OutputFile); } } Directory.Delete(tempDirectory, true); ResultSummary = generator.Summary; if (File.Exists(OutagesCSV)) { File.Delete(OutagesCSV); } if (File.Exists(CriticalBranchesCSV)) { File.Delete(CriticalBranchesCSV); } Output = outStream.ToString(); // Clear old outputs ClearTempFolder(); }
private void GenerateXmlButtonHandler(object sender, EventArgs e) { try { TravelAgencyDbContext dbContext = new TravelAgencyDbContext(); XMLGenerator xmlGenerator = new XMLGenerator(); var cb1Value = this.destinationsComboBox.SelectedValue.ToString(); var cb2Value = this.guidesComboBox.SelectedValue.ToString(); var cb3Value = this.transportsComboBox.SelectedValue.ToString(); xmlGenerator.XmlGenerate(dbContext, cb1Value, cb2Value, cb3Value); MessageBox.Show("XML document was generated successfully with the data from SQL!"); } catch (Exception) { MessageBox.Show("XML document couldn't be generated!"); } }
public string GetCustomerDBConnectionString(string customerID) { this.log(LogLevel.DEBUG, FunctionName.WS_GET_CUSTOMER_DB_CONNECTION_STRING, MessageType.PARAMATER, string.Format("customerID:{0}", customerID)); //验证参数 bool ret = ArgumentHelper.Validate("customerID", customerID, false); if (!ret) { this.log(LogLevel.ERROR, FunctionName.WS_GET_LOGIN_USER_INFO, "customerID", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, ""); return(""); } //取连接 CustomerConnectInfo cConnect = this.GetCustomerService().GetCustomerConnectByID(customerID); if (cConnect == null) { this.log(LogLevel.ERROR, FunctionName.WS_GET_LOGIN_USER_INFO, "CustomerConnect", "未找到"); this.log(LogLevel.INFO, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, ""); return(""); } //生成XML LoggingUserInfo user = new LoggingUserInfo(); user.CustomerID = customerID; user.CustomerCode = cConnect.Customer.Code; user.CustomerName = cConnect.Customer.Name; user.ConnectionString = cConnect.DBConnectionString; string s = XMLGenerator.Serialize(user); this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, "DecryptResult", s); //加密 cPos.Admin.Service.BaseService base_service = this.GetCustomerService() as cPos.Admin.Service.BaseService; string output = base_service.EncryptStringByKeyFile(cConnect.KeyFile, s); this.log(LogLevel.DEBUG, FunctionName.WS_GET_LOGIN_USER_INFO, MessageType.RESULT, output); return(output); }
public static XmlDocument GenerateLoginTicketRequestXML(LoginTicketRequests loginTicketRequest) { const string loginTicketRequestNodeName = "loginTicketRequest"; const string HeaderNodeName = "header"; const string ServiceNodeName = "service"; const string SourceNodeName = "source"; const string DestinationNodeName = "destination"; const string UniqueIDNodeName = "uniqueId"; const string GenerationTimeNodeName = "generationTime"; const string ExpirationTimeNodeName = "expirationTime"; XmlQualifiedName qualifiedName = new XmlQualifiedName(loginTicketRequestNodeName); //TODO: SACAR EL hardcode del XSD XMLGenerator generator = new XMLGenerator("LoginTicketRequest.xsd", qualifiedName); Stream xmlStream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(xmlStream, Encoding.UTF8); writer.Formatting = Formatting.Indented; generator.WriteXml(writer); XmlDocument document = new XmlDocument(); xmlStream.Seek(0, SeekOrigin.Begin); XmlReader reader = new XmlTextReader(xmlStream); document.Load(reader); reader.Close(); writer.Close(); xmlStream.Close(); xmlStream.Dispose(); XmlElement headerNode = document[loginTicketRequestNodeName][HeaderNodeName]; headerNode[SourceNodeName].InnerText = loginTicketRequest.Empresa.DNOrigen; headerNode[DestinationNodeName].InnerText = loginTicketRequest.Empresa.DNDestino; //TODO: ver cual debe ser el loginTicketRequest.Id headerNode[UniqueIDNodeName].InnerText = loginTicketRequest.Id.ToString(); headerNode[GenerationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.GenerationTime, XmlDateTimeSerializationMode.RoundtripKind); headerNode[ExpirationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.ExpirationTime, XmlDateTimeSerializationMode.RoundtripKind); document[loginTicketRequestNodeName][ServiceNodeName].InnerText = "wsfe"; return(document); }
public static void Main() { //var db = new MoviesDatabaseOfTeamSingaporeSlingEntities(); //var employees = db.Employees // .Where(e => e.FirstName == "Tom") // .Select(n => // new // { // FirstName = n.FirstName, // LastName = n.LastName, // Salary = n.Salary, // Movies = n.Movies.Select(m => m.Name).ToList(), // IsDirector = n.IsDirector // } // ) // .ToList(); //foreach (var employee in employees) //{ // Console.WriteLine("The actor {0} {1} has participated in this movies:", employee.FirstName, employee.LastName); // foreach (var movie in employee.Movies) // { // Console.WriteLine(movie); // } //} var db = new Database(); //Generating Xml file report var generateXMLFile = new XMLGenerator(); generateXMLFile.Generate(db); //Generating Json file reports var generateJsonReports = new JSONGenerator(); generateJsonReports.Generate(db); //Generating Pdf fle reports var generatePdfReports = new PDFGenerator(); generatePdfReports.Generate(db); //XMLImporter.ImportXML(); }
public XmlDocument GenerarXml() { #region constants const string Comprobante = "comprobante"; const string Cabecera = "cabecera"; const string Detalle = "detalle"; const string Resumen = "resumen"; #endregion XmlQualifiedName qualifiedName = new XmlQualifiedName("factura"); XMLGenerator generator = new XMLGenerator("Factura_v1.22.xsd", qualifiedName); Stream xmlStream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(xmlStream, Encoding.GetEncoding("iso-8859-1")); writer.Formatting = Formatting.Indented; generator.WriteXml(writer); XmlDocument document = new XmlDocument(); xmlStream.Seek(0, SeekOrigin.Begin); XmlReader reader = new XmlTextReader(xmlStream); document.Load(reader); reader.Close(); writer.Close(); xmlStream.Close(); xmlStream.Dispose(); //document.InsertAfter(document.CreateProcessingInstruction("xml-stylesheet", "type=\"text/xsl\" href=\"../../Factura_v1.22.xsl\""), document.ChildNodes[0]);/*Lote_Factura_Response_v1.0.xsl*/ document.InsertAfter(document.CreateProcessingInstruction("xml-stylesheet", "type=\"text/xsl\" href=\"Factura_v1.22.xsl\""), document.ChildNodes[0]); CargarDatosCabecera(document[Comprobante][Cabecera]); CargarDatosDetalle(document[Comprobante][Detalle]); CargarDatosResumen(document[Comprobante][Resumen]); XmlNode nodoLogo = document.CreateNode(XmlNodeType.Element, "string", "logo", ""); XmlNode nodoUrl = document.CreateNode(XmlNodeType.Element, "url", ""); CargarDatosExtensiones(document[Comprobante]["extensiones"], nodoLogo, nodoUrl); document[Comprobante].Attributes["xmlns"].Value = ""; XmlAttribute attns = document.CreateAttribute("xmlns:tns"); attns.Value = "http://www.cace.org.ar/facturaelectronica/"; document[Comprobante].Attributes.Append(attns); XmlAttribute atxsi = document.CreateAttribute("xmlns:xsi"); atxsi.Value = "http://www.w3.org/2001/XMLSchema-instance"; document[Comprobante].Attributes.Append(atxsi); return(document); }
public XmlDocument GenerateLoginTicketRequestXML(LoginTicketRequests loginTicketRequest) { XmlQualifiedName qualifiedName = new XmlQualifiedName(LoginTicketRequestNodeName); //TODO: SACAR EL hardcode del XSD XMLGenerator generator = new XMLGenerator("LoginTicketRequest.xsd", qualifiedName); Stream xmlStream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(xmlStream, Encoding.UTF8); writer.Formatting = Formatting.Indented; generator.WriteXml(writer); XmlDocument document = new XmlDocument(); xmlStream.Seek(0, SeekOrigin.Begin); XmlReader reader = new XmlTextReader(xmlStream); document.Load(reader); reader.Close(); writer.Close(); xmlStream.Close(); xmlStream.Dispose(); EmpresasBL empresasBL = new EmpresasBL(); empresasBL.SetParameters(DBConnection); XmlElement headerNode = document[LoginTicketRequestNodeName][HeaderNodeName]; headerNode[SourceNodeName].InnerText = loginTicketRequest.Empresa.DNOrigen; headerNode[DestinationNodeName].InnerText = loginTicketRequest.Empresa.DNDestino; headerNode[UniqueIDNodeName].InnerText = loginTicketRequest.Id.ToString(); headerNode[GenerationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.GenerationTime, XmlDateTimeSerializationMode.RoundtripKind); headerNode[ExpirationTimeNodeName].InnerText = XmlConvert.ToString(loginTicketRequest.ExpirationTime, XmlDateTimeSerializationMode.RoundtripKind); document[LoginTicketRequestNodeName][ServiceNodeName].InnerText = GeneralSettings.Instance.WSNegocio; //writer = new XmlTextWriter("c:\\pepe.xml",Encoding.UTF8); //writer.Formatting = Formatting.Indented; //document.WriteTo(writer); //writer.Flush(); //writer.Close(); return(document); }
//generates testRequest xml. private void generateXMLTestRequest() { Console.WriteLine("\n REQUIREMENT 8: generating a TEST request XML"); List <List <string> > temp = new List <List <string> >(); List <string> temp2 = new List <string>(); temp2.AddRange(_testNames["testName"]); temp.Add(temp2); string _xmlReceived = _fullPathToTestDirectory + "/" + _testDirectory + "BuildRequest.xml"; XDocument.Parse(xmlBuildReqString).Save(_xmlReceived); try { XMLGenerator xmlGenerator = new XMLGenerator(xmlBuildReqString, "", _testRequestXMLToBeGenerated, null, temp, 1); } catch (Exception ex) { File.AppendAllText(_fileLoggerPath.ToString(), ex.Source); File.AppendAllText(_fileLoggerPath.ToString(), ex.Message); Console.WriteLine("\n failure to generate XML Test request. check logger at {0} for further details", _fullPathToTestDirectory); } }
//this function first creates a directory with the name author and then a subdirectory //with the name author+firstTestName. then it generates the XML build request by aggregating XMLGenerator. //it returns the relative path of the XML build request generated. private string generateXMLBuildRequest() { Console.WriteLine("author is: {0}", clientsBuildContent[0][0]); string author = clientsBuildContent[0][0]; string authorDirectory = _mockRepoFileStorage + "/" + author; string testNameDirectory = authorDirectory + "/" + author + clientsBuildContent[1][0]; Console.WriteLine("Client selected testdriver and teste files are being copied from \n ../../mockRepoStorage to" + "\n {0}", testNameDirectory); Console.WriteLine("files to the child builders will be sent upon request from the above path"); getNameOfBuildRequestToBeCreated(); if (!Directory.Exists(_mockRepoFileStorage + "/" + author)) { Directory.CreateDirectory(authorDirectory); Directory.CreateDirectory(testNameDirectory); string fullNameOfBuildRequestToBeCreated = testNameDirectory + "/" + _nameOfBuildRequestToBeCreated.ToString(); xmlGenerator = new XMLGenerator("", fullNameOfBuildRequestToBeCreated, "", clientsBuildContent, null, 0); copyFilesFromMockRepoStorageToAuthorTestNameFolder(testNameDirectory); return(fullNameOfBuildRequestToBeCreated); } else if (!Directory.Exists(testNameDirectory)) { Directory.CreateDirectory(testNameDirectory); string fullNameOfBuildRequestToBeCreated = testNameDirectory + "/" + _nameOfBuildRequestToBeCreated.ToString(); xmlGenerator = new XMLGenerator("", fullNameOfBuildRequestToBeCreated, "", clientsBuildContent, null, 0); copyFilesFromMockRepoStorageToAuthorTestNameFolder(testNameDirectory); return(fullNameOfBuildRequestToBeCreated); } else { string fullNameOfBuildRequestToBeCreated = testNameDirectory + "/" + _nameOfBuildRequestToBeCreated.ToString(); xmlGenerator = new XMLGenerator("", fullNameOfBuildRequestToBeCreated, "", clientsBuildContent, null, 0); copyFilesFromMockRepoStorageToAuthorTestNameFolder(testNameDirectory); return(fullNameOfBuildRequestToBeCreated); } }
/// <summary> /// Generate data xml files and enter db info in xml DatabaseDetails file. /// </summary> /// <param name="databasePath"></param> /// <param name="tempDatabaseFolderPath"></param> /// <param name="dbDetails"></param> /// <param name="dbDetailsXmlFileWithPath"></param> public bool GenerateXmlFilesNLog(string tempDatabaseFolderPath, UIDatabaseDetails uiDBDetails, string dbDetailsXmlFileWithPath, string xmlDataPath) { bool RetVal = false; string TmpDatabaseFilenameWithPath = string.Empty; string DbFileName = string.Empty; string XmlDataOutputFolderpath = string.Empty; string DataFolerName = string.Empty; UIDatabaseInfo CurrentDBInfo = null; XMLGenerator ObjXMLGenerator = null; CacheGenerator ObjCacheGenerator = null; string AvlDbName = string.Empty; int ProgressCount = 3; try { //-- raise event to display progress form this.RaiseDisplayProgressFormEvent(); // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, false); // check n create temp database folder if (!Directory.Exists(tempDatabaseFolderPath)) { Directory.CreateDirectory(tempDatabaseFolderPath); } // get database file and copy it into temp DbFileName = Path.GetFileName(this._DatabasePath); TmpDatabaseFilenameWithPath = Path.Combine(tempDatabaseFolderPath, DbFileName); // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, false); //-- Get Available database name AvlDbName = GetAvailableDbName(this._DatabasePath); //-- Get all database details if (uiDBDetails.DatabaseInfo.Count > 0) { // get current database info CurrentDBInfo = uiDBDetails.DatabaseInfo.Find(delegate(UIDatabaseInfo p) { return p.DatabaseName == AvlDbName; }); } // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, false); if (CurrentDBInfo == null || CurrentDBInfo.LastModifiedDataNTime != File.GetLastWriteTime(this._DatabasePath).ToString() || CurrentDBInfo.IsXmlFilesGenerated == false) { //-- Copy db into temp foler File.Copy(this._DatabasePath, TmpDatabaseFilenameWithPath, true); // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, false); //-- Delete old database info entry if exists if (CurrentDBInfo != null) { uiDBDetails.DatabaseInfo.Remove(CurrentDBInfo); } //-- Create current database info CurrentDBInfo = new UIDatabaseInfo(); CurrentDBInfo.DatabaseName = AvlDbName; CurrentDBInfo.DatabaseFilename = DbFileName; CurrentDBInfo.LastModifiedDataNTime = File.GetLastWriteTime(this._DatabasePath).ToString(); //-- Set DatabaseInfo details XmlDataOutputFolderpath = Path.Combine(tempDatabaseFolderPath, "data"); ObjXMLGenerator = new XMLGenerator(XmlDataOutputFolderpath, this._DatabasePath); DataFolerName = Path.GetFileNameWithoutExtension(this._DatabasePath); //-- add events ObjXMLGenerator.ProgressChangedEvent += new ProgressChangedDelegate(ObjXMLGenerator_ProgressChangedEvent); //-- Generate XML files ObjXMLGenerator.GenerateDefaultXmlFiles(DataFolerName, "AreaName", "Immediate"); ProgressCount = 19; // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, "Genetating cache", string.Empty, false); // Genetating cache ObjCacheGenerator = new CacheGenerator(); //-- add events ObjCacheGenerator.ProgressChangedEvent += new ProgressChangedDelegate(ObjCacheGenerator_ProgressChangedEvent); //-- Generate Cache in db ObjCacheGenerator.GenerateCacheResults(TmpDatabaseFilenameWithPath); ProgressCount = 37; // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, false); //-- update xml files generation status into DesktopDatabaseDetails.xml file CurrentDBInfo.IsXmlFilesGenerated = true; // add current db info into database details xml file uiDBDetails.DatabaseInfo.Add(CurrentDBInfo); // update database details xml file uiDBDetails.Save(dbDetailsXmlFileWithPath); // increment progress bar value this.RaiseProgressChangedEvent(ProgressCount++, string.Empty, string.Empty, true); RetVal = true; } else { // do nothing } } catch (Exception) { throw; } return RetVal; }
public bool SynUser(string customerID, int typeID, string userInfo) { this.log(LogLevel.DEBUG, FunctionName.WS_SYN_USER, MessageType.PARAMATER, "customerID: " + customerID); this.log(LogLevel.DEBUG, FunctionName.WS_SYN_USER, MessageType.PARAMATER, "typeID: " + typeID.ToString()); this.log(LogLevel.DEBUG, FunctionName.WS_SYN_USER, MessageType.PARAMATER, "userInfo: " + userInfo); //验证参数 bool ret = ArgumentHelper.Validate("customerID", customerID, false); if (!ret) { this.log(LogLevel.ERROR, FunctionName.WS_SYN_USER, "customerID", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_SYN_USER, MessageType.RESULT, ret.ToString()); return(ret); } //获取连接 CustomerConnectInfo cConnect = this.GetCustomerService().GetCustomerConnectByID(customerID); if (cConnect == null) { this.log(LogLevel.ERROR, FunctionName.WS_SYN_USER, "CustomerConnect", "未找到"); this.log(LogLevel.INFO, FunctionName.WS_SYN_USER, MessageType.RESULT, "false"); return(false); } if (typeID < 1 || typeID > 5) { this.log(LogLevel.ERROR, FunctionName.WS_SYN_USER, "typeID", "参数不正确"); this.log(LogLevel.INFO, FunctionName.WS_SYN_USER, MessageType.RESULT, "false"); return(false); } //解密 cPos.Admin.Service.BaseService base_service = this.GetCustomerService() as cPos.Admin.Service.BaseService; string s = base_service.DecryptStringByCustomer(customerID, userInfo); this.log(LogLevel.DEBUG, FunctionName.WS_SYN_USER, "DecryptCustomerUser", s); CustomerUserInfo user = (CustomerUserInfo)XMLGenerator.Deserialize(typeof(CustomerUserInfo), s); user.Customer.ID = customerID; switch (typeID) { case 1: //新建 ret = this.GetCustomerService().InsertCustomerUserFromCP(user); break; case 2: //修改 ret = this.GetCustomerService().ModifyCustomerUserFromCP(user); break; case 3: //启用 ret = this.GetCustomerService().EnableCustomerUserFromCP(user); break; case 4: //停用 ret = this.GetCustomerService().DisableCustomerUserFromCP(user); break; case 5: //修改密码 ret = this.GetCustomerService().ModifyCustomerUserPasswordFromCP(user); break; default: ret = false; break; } this.log(LogLevel.INFO, FunctionName.WS_SYN_USER, MessageType.RESULT, ret.ToString()); return(ret); }
public static void Menu() { const string Menu = "\nMenu:\n" + "1. Replicate data from Oracle Database into MsSql Database\n" + "2. Load Zip Excel Reports to MsSql Database\n" + "3. Generate Pdf Sales report\n" + "4. Generate XML Sales by Vendor from given date range\n" + "5. Generate JSON reports in given date range and load them into MongoDB\n" + "6. Load Xml Vendors Expenses Report into MsSql Database\n" + "7. Load data from MsSql to MySql\n" + "8. Generate financial report\n" + "9. Exit\n"; try { Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; var isFinished = false; while (!isFinished) { Console.WriteLine(Menu); var menuChoise = int.Parse(Console.ReadLine()); var context = new SupermarketContext(); switch (menuChoise) { case 1: OracleReplicationEngine.ReplicateOracleToMssql(); break; case 2: var importExelFiles = new ImportExel(); importExelFiles.LoadExelReports(context); break; case 3: PDFReportGenerator.GeneratePDFReport(); break; case 4: XMLGenerator.GenerateXMLReport(); break; case 5: ImportJSONtoMongoDB.GenerateJSONReports(); break; case 6: Console.WriteLine(@" Importing XML To MsSqlDB ------------------------------------------------"); Console.WriteLine("Extracting data..."); var xmlManager = new ImportFromXML(@"..\..\..\..\Import\Sample-Vendor-Expenses.xml", context); Console.WriteLine("Sending data..."); xmlManager.TransferData(); Console.WriteLine("Sales report imported."); break; case 7: MsSqlReplicationEngine.ReplicateMssqlToMySql(); break; //case 8: Engine.GenerateFinancialReport(); break; case 9: isFinished = true; break; default: throw new InvalidOperationException("Invalid operation."); } } } catch (Exception e) { Console.WriteLine(e.Message); } }
public static void Menu() { const string Menu = "\n Main Menu:\n" + " ----------------\n\n" + " Select one: \n\n" + " 1. Replicate data from Oracle Database into MsSql Database\n" + " 2. Load Zip Excel Reports to MsSql Database\n" + " 3. Generate Pdf Sales report\n" + " 4. Generate XML Sales by Vendor report\n" + " 5. Generate JSON reports in given date range and load them into MongoDB\n" + " 6. Load Xml Vendors Expenses Report into MsSql Database\n" + " 7. Load data from MsSql to MySql\n" + " 8. Generate financial report\n" + " 9. Exit\n"; const string Logo = @" ___________ _____ .__ ___________ \__ ___/___ _____ _____ / \ |__| ____ ____ \_ _____/__________ ____ | |_/ __ \\__ \ / \ / \ / \| |/ \ / ___\ | __)/ __ \_ __ \/ \ | |\ ___/ / __ \| Y Y \ / Y \ | | \/ /_/ > | \\ ___/| | \/ | \ |____| \___ >____ /__|_| / \____|__ /__|___| /\___ / \___ / \___ >__| |___| / \/ \/ \/ \/ \//_____/ \/ \/ \/ "; try { Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; var isFinished = false; Console.WriteLine(Logo); while (!isFinished) { Console.WriteLine(Menu); var menuChoise = int.Parse(Console.ReadLine()); var context = new SupermarketContext(); switch (menuChoise) { case 1: OracleReplicationEngine.ReplicateOracleToMssql(); break; case 2: var importExelFiles = new ImportExel(); importExelFiles.LoadExelReports(context); break; case 3: PDFReportGenerator.GeneratePDFReport(); break; case 4: XMLGenerator.GenerateXMLReport(); break; case 5: ImportJSONtoMongoDB.GenerateJsonReports(); break; case 6: var xmlManager = new ImportFromXML(@"..\..\..\..\Import\Sample-Vendor-Expenses.xml", context); xmlManager.TransferData(); break; case 7: MsSqlReplicationEngine.ReplicateMssqlToMySql(); break; case 8: var data = SqLiteFactory.GetFinancialReportData(); FinancialReportGenerator.GenerateFinancialReport(data, @"..\..\..\..\Reports\"); break; case 9: isFinished = true; Console.WriteLine("\n\nSo Long!!!\n\n"); break; default: throw new InvalidOperationException("Invalid operation."); } } } catch (Exception e) { Console.WriteLine(e.Message); } }