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