public TablaOszlop LoadXmlById(int id)
{
TablaOszlop t = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.TablaOszlops
.Where(ss => ss.id == id)
.FirstOrDefault <TablaOszlop>();
t = query;
}
string xml = t.serialization;
TablaOszlop tResult = null;
XmlSerializer serializer = new XmlSerializer(typeof(TablaOszlop));
StringReader reader = new StringReader(xml);
tResult = (TablaOszlop)serializer.Deserialize(reader);
reader.Close();
return(tResult);
}
public void addNew(TablaOszlop _TablaOszlop)
{
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.TablaOszlops.Add(_TablaOszlop);
ctx.SaveChanges();
}
}
public TablaOszlop findFirstById(int id)
{
TablaOszlop t = null;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
var query = ctx.TablaOszlops
.Where(ss => ss.id == id)
.FirstOrDefault <TablaOszlop>();
t = query;
}
return(t);
}
public void SaveWithXml(TablaOszlop _TablaOszlop)
{
string xml = "";
XmlSerializer serializer = new XmlSerializer(typeof(TablaOszlop));
StringWriter stringWriter = new StringWriter();
XmlWriter xmlWriter = XmlWriter.Create(stringWriter);
serializer.Serialize(xmlWriter, _TablaOszlop);
xml = stringWriter.ToString();
_TablaOszlop.serialization = xml;
using (var ctx = new AllContext(serverName, baseName, userName, password))
{
ctx.TablaOszlops.Add(_TablaOszlop);
ctx.SaveChanges();
}
}
public GetObjectResponse SaveWithXml(TablaOszlop _TablaOszlop)
{
var response = new GetObjectResponse();
try
{
_TablaOszlopEntityMethods.SaveWithXml(_TablaOszlop);
response.Result = new Ac4yProcessResult()
{
Code = "1"
};
}
catch (Exception exception)
{
response.Result = (new Ac4yProcessResult()
{
Code = "-1", Message = exception.Message
});
}
return(response);
}
public List <TablaOszlop> GetParameters(string name)
{
string sql = "Select COLUMN_NAME, DATA_TYPE From FNOVUM2.information_schema.COLUMNS WHERE TABLE_NAME = @aTablaNev; ";
List <TablaOszlop> lista = new List <TablaOszlop>();
SqlConnection connection = new SqlConnection("Data Source=arnteszt;Integrated Security=False;uid=Fejl_zsberces;pwd=Szappan60;Initial Catalog=FNOVUM2;");
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.Add("@aTablaNev", SqlDbType.VarChar).Value = name;
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
TablaOszlop tablaOszlop = new TablaOszlop();
tablaOszlop.Kod = reader.GetValue(0).ToString();
Console.WriteLine(tablaOszlop.Kod);
tablaOszlop.Adattipus = reader.GetValue(1).ToString();
lista.Add(tablaOszlop);
}
}
return(lista);
}
static void Main(string[] args)
{
Console.WriteLine("Hello adfgarfdvWorld!");
Program program = new Program();
try
{
string[] files =
Directory.GetFiles("d:\\Server\\Visual_studio\\output_Xmls\\StorProcs\\", "*.xml", SearchOption.TopDirectoryOnly);
string[] tablak =
Directory.GetFiles("d:\\Server\\Visual_studio\\output_Xmls\\arntesztTablak\\", "*.xml", SearchOption.TopDirectoryOnly);
Console.WriteLine(files.Length);
conn.Open();
foreach (var tabla in tablak)
{
string _tablaFilename = Path.GetFileNameWithoutExtension(tabla);
Console.WriteLine(_tablaFilename);
Tabla tablaObj = new Tabla();
TablaOszlop TablaOszlopObj = new TablaOszlop();
string textFile = Path.Combine("d:\\Server\\Visual_studio\\output_Xmls\\arntesztTablak\\", _tablaFilename + ".xml");
string text = File.ReadAllText(textFile);
tablaObj = (Tabla)program.deser(text, typeof(Tabla));
string originName = tablaObj.Megnevezes;
Ac4yXMLObjectEntityMethods ac4YXMLObjectEntityMethods = new Ac4yXMLObjectEntityMethods(APPSETTINGS_SERVER, APPSETTINGS_DATABASE, APPSETTINGS_USER, APPSETTINGS_PASSWORD);
Ac4yObjectObjectService ac4YObjectObjectService = new Ac4yObjectObjectService(conn);
foreach (TablaOszlop oszlop in tablaObj.TablaOszlopLista)
{
SetByNamesResponse response = ac4YObjectObjectService.SetByNames(
new SetByNamesRequest()
{
TemplateName = "tábla oszlop", Name = oszlop.Kod
}
);
string argText = program.GetAsXml(oszlop);
ac4YXMLObjectEntityMethods.addNew(new Ac4yXMLObject()
{
serialization = argText, GUID = response.Ac4yObjectHome.GUID
});
/*
* Console.WriteLine(oszlop.Kod);
* Ac4yAssociationObjectService.SetByNamesResponse setByNamesResponse =
* new Ac4yAssociationObjectService(conn).SetByNames(
* new Ac4yAssociationObjectService.SetByNamesRequest() { originTemplateName = "tábla", originName = originName, targetTemplateName = "tábla oszlop", targetName = oszlop.Kod, associationPathName = "tábla.oszlop" }
* );
*
*/
}
}
foreach (var _file in files)
{
string _filename = Path.GetFileNameWithoutExtension(_file);
Console.WriteLine(_filename);
TaroltEljaras taroltEljaras = new TaroltEljaras();
TaroltEljarasArgumentum taroltEljarasArg = new TaroltEljarasArgumentum();
string textFile = Path.Combine("d:\\Server\\Visual_studio\\output_Xmls\\StorProcs\\", _filename + ".xml");
string text = File.ReadAllText(textFile);
taroltEljaras = (TaroltEljaras)program.deser(text, typeof(TaroltEljaras));
string originName = taroltEljaras.Megnevezes;
Ac4yXMLObjectEntityMethods ac4YXMLObjectEntityMethods = new Ac4yXMLObjectEntityMethods(APPSETTINGS_SERVER, APPSETTINGS_DATABASE, APPSETTINGS_USER, APPSETTINGS_PASSWORD);
Ac4yObjectObjectService ac4YObjectObjectService = new Ac4yObjectObjectService(conn);
foreach (TaroltEljarasArgumentum arg in taroltEljaras.ArgumentumLista)
{/*
* SetByNamesResponse response = ac4YObjectObjectService.SetByNames(
* new SetByNamesRequest() { TemplateName = "tárolt eljárás argumentum", Name = arg.BelsoNev }
* );
*
* string argText = program.GetAsXml(arg);
* ac4YXMLObjectEntityMethods.addNew(new Ac4yXMLObject() { serialization = argText, GUID = response.Ac4yObjectHome.GUID });
*
* /* Console.WriteLine(arg.BelsoNev);
* Ac4yAssociationObjectService.SetByNamesResponse setByNamesResponse =
* new Ac4yAssociationObjectService(conn).SetByNames(
* new Ac4yAssociationObjectService.SetByNamesRequest() { originTemplateName = "tárolt eljárás", originName = originName, targetTemplateName = "tárolt eljárás argumentum", targetName = arg.BelsoNev, associationPathName = "tárolt eljárás.Argumentum" }
* );*/
}
}
}catch (Exception exception)
{
Console.WriteLine(exception.Message);
}
}
