/// <summary>
/// TR :
/// EN :
/// </summary>
/// <param name="contextID">TR : WORM.config dosyası içerisinden istenen ContextID </param>
/// <returns></returns>
public static DBInformationModel ReturnDBInformatinFromXML(string contextID)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName + "\\WORM.config");
XmlElement xmlElement = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode($"{contextID}[@id='{contextID}']");
DBInformationModel dBInformationModel = new DBInformationModel
{
ConnectionString = xmlElement.GetElementsByTagName("ConnectionString")[0].Attributes[0].InnerXml,
Provider = xmlElement.GetElementsByTagName("Provider")[0].Attributes[0].InnerXml,
UpdatedAuthor = xmlElement.GetElementsByTagName("UpdatedAuthor")[0].Attributes[0].InnerXml
};
return(dBInformationModel);
}
private Tuple <string, MySqlCommand> Create__WORM__Configuration_Table(string tablesXMLForm)
{
string configurationTableQuery = $"CREATE TABLE IF NOT EXISTS __worm__configuration ( " +
"Version int NOT NULL AUTO_INCREMENT," +
"UpdatedTime DATETIME," +
"UpdatedAuthor VARCHAR(255)," +
"TablesXMLForm MEDIUMTEXT," +
"PRIMARY KEY (Version) " +
");";
DBInformationModel dBInformationModel = DBConnectionFactory.ReturnDBInformatinFromXML(this.ContextName);
MySqlCommand command = new MySqlCommand($"INSERT INTO __worm__configuration(UpdatedTime, UpdatedAuthor, TablesXMLForm) " +
$"VALUES(@UpdatedTime,@UpdatedAuthor,@TablesXMLForm)",
(MySqlConnection)connection);
command.Parameters.AddWithValue("@UpdatedTime", DateTime.Now);
command.Parameters.AddWithValue("@UpdatedAuthor", dBInformationModel.UpdatedAuthor);
command.Parameters.AddWithValue("@TablesXMLForm", tablesXMLForm);
return(Tuple.Create(configurationTableQuery, command));
}
private Tuple <string, SqlCommand> Create__WORM__Configuration_Table(string tablesXMLForm)
{
string configurationTableQuery = $"IF NOT EXISTS (SELECT * FROM sys.tables WHERE name = N'__WORM__Configuration')" +
"BEGIN " +
"CREATE TABLE [dbo].[__WORM__Configuration]( " +
"Version int IDENTITY(1,1) PRIMARY KEY," +
"UpdatedTime datetime," +
"UpdatedAuthor nvarchar(200)," +
"TablesXMLForm nvarchar(max)" +
") END";
DBInformationModel dBInformationModel = DBConnectionFactory.ReturnDBInformatinFromXML(this.ContextName);
SqlCommand command = new SqlCommand($"INSERT INTO [dbo].[__WORM__Configuration](UpdatedTime, UpdatedAuthor, TablesXMLForm) " +
$"VALUES(@UpdatedTime,@UpdatedAuthor,@TablesXMLForm)",
(SqlConnection)connection);
command.Parameters.AddWithValue("@UpdatedTime", DateTime.Now);
command.Parameters.AddWithValue("@UpdatedAuthor", dBInformationModel.UpdatedAuthor);
command.Parameters.AddWithValue("@TablesXMLForm", tablesXMLForm);
return(Tuple.Create(configurationTableQuery, command));
}
