//public IEnumerable<PNDS_AUT_PARA> GetAll_PNDS_AUT_PARA(PNDSEntities dc)
//{
// List<String> geraete = new List<String>()
// { "K", //AKI
// "T" //PATX
// };
// var found = from d in dc.PNDS_AUT_PARA
// where geraete.Contains(d.Geraeteart)
// orderby d.Automatennr ascending
// select d;
// if (found.Any())
// {
// return found;
// }
// return null;
//}
#region EntityChar
#endregion
#region Physics
public static bool insertEntity(IDAL_DCTX ctx, Entity po)
{
try
{
var result = (ctx.Context as dbDataEntities).Entity.Where(x => x.EntID == po.EntID);
if (result.Any())
{
result.First().Data = po.Data;
}
else
{
(ctx.Context as dbDataEntities).Entity.Add(po);
}
(ctx.Context as dbDataEntities).SaveChanges();
// MessageBox.Show("Entity (" + po.EntID + ") saved to DB");
return(true);
}catch (Exception ex)
{
MessageBox.Show(ex.InnerException != null ? ex.InnerException.Message : ex.Message);
}
return(false);
}
public static bool insertScene(IDAL_DCTX ctx, VEX.IDAL.MDB.Scene scene)
{
try
{
var ctxtmp = (ctx.Context as dbDataEntities);
var result = ctxtmp.Scene.Where(x => x.SceneID == scene.SceneID);
if (result.Any())
{
var dbScene = result.First();
dbScene.Name = scene.Name;
dbScene.Data = scene.Data;
}
else
{
(ctx.Context as dbDataEntities).Scene.Add(scene);
}
(ctx.Context as dbDataEntities).SaveChanges();
return(true);
}
catch (Exception ex)
{
}
return(false);
}
private void RekursivSaveToDB(IItem item, IDAL_DCTX ctx)
{
if (item.Items.Count > 0)
{
foreach (var subItem in item.Items)
{
if (subItem is IDBFileItem)// && subItem is INetID)
{
var netObj = subItem as IDBFileItem;
netObj.SaveToDB(ctx);
}
if (subItem.Items.Count > 0)
{
RekursivSaveToDB(subItem, ctx); // rekursiv
}
}
}
else
{
if (item is IDBFileItem)// && item is INetID)
{
var netObj = item as IDBFileItem;
netObj.SaveToDB(ctx);
}
}
}
public static IEnumerable <EntityContainer> selectAllEntities(IDAL_DCTX ctx)
{
try
{
var result = from n in (ctx.Context as dbDataEntities).Entity
join oj in (ctx.Context as dbDataEntities).EntityData on n.EntDID equals oj.EntDID into gjo
from Ent in gjo.DefaultIfEmpty()
//where n.SceneID == sceneID
//select
// where n.SceneID == sceneID
select new EntityContainer {
Entity = n, EntityData = Ent
};
if (result.Any())
{
return(result);
}
else
{
return(null);
}
}
catch (Exception ex)
{
MessageBox.Show("selectAllEntities. " + ex.Message);
}
return(null);
}
public static VEX.IDAL.MDB.Scene selectSceneDataOnly(IDAL_DCTX ctx, int id)
{
try
{
var result = from n in (ctx.Context as dbDataEntities).Scene
where n.SceneID == id
select n;
// var result = m(ctx.Context as dbDataEntities).Scene.Where(x => x.SceneID == id);
if (result.Any())
{
return(result.First());//.Data;
}
else
{
return(new VEX.IDAL.MDB.Scene());
}
}
catch (Exception ex)
{
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(null);
}
public static bool insertSceneNode(IDAL_DCTX ctx, SceneNode sceneNode)
{
try
{
var result = (ctx.Context as dbDataEntities).SceneNode.Where(x => x.NodeID == sceneNode.NodeID &&
x.SceneID == sceneNode.SceneID);
if (result.Any())
{
var scenNode = result.First();
scenNode.Data = sceneNode.Data;
scenNode.SceneID = sceneNode.SceneID;
scenNode.EntID = sceneNode.EntID;
scenNode.Name = sceneNode.Name;
(ctx.Context as dbDataEntities).SaveChanges();
return(true);
}
else
{
(ctx.Context as dbDataEntities).SceneNode.Add(sceneNode);
(ctx.Context as dbDataEntities).SaveChanges();
return(true);
}
}catch (Exception ex)
{
}
return(false);
}
public static IEnumerable <SceneNodeContainer> selectSceneNodes(IDAL_DCTX ctx, int sceneID)
{
try
{
var result = from n in (ctx.Context as dbDataEntities).SceneNode
join oj in (ctx.Context as dbDataEntities).Entity on n.EntID equals oj.EntID into gjo
from Ent in gjo.DefaultIfEmpty()
//where n.SceneID == sceneID
//select
where n.SceneID == sceneID
select new SceneNodeContainer {
Node = n, Entity = Ent
};
// var result = m(ctx.Context as dbDataEntities).Scene.Where(x => x.SceneID == id);
if (result.Any())
{
return(result);//.Data;
}
}
catch (Exception ex)
{
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(null);
}
public bool SaveToDB(IDAL_DCTX ctx)
{
foreach (var item in Items)
{
var dbFileItem = item as IDBFileItem;
if (dbFileItem != null)
{
return(dbFileItem.SaveToDB(ctx));
}
}
return(true);
}
public bool SaveToDB(IDAL_DCTX ctx)
{
string DBPath = DBFileUtil.GetDBFilePath(this.Parent);
if (!String.IsNullOrEmpty(DBPath))
{
IDAL.MDB.Scene dbSceneData = new IDAL.MDB.Scene();
dbSceneData.Data = FBObject.CreateFBData()._fbData;
dbSceneData.SceneID = SceneID;
dbSceneData.Name = this.Name;
IDAL.IDAL.insertScene(ctx, dbSceneData);
uint nodeCount = 0;
foreach (var sceneitem in Entities)
{
var entity = sceneitem as EntityX;
if (entity != null)
{
// entity.SaveToDB(ctx);
var m_SceneNodeDB = new IDAL.MDB.SceneNode();
var body = entity.GetComponentX <BodyComponent>() as BodyComponent;
if (body != null)
{
//if (body.SceneNodeID <= 0)
// MessageBox.Show("SceneNodeID <= 0!");
//else {
m_SceneNodeDB.Data = body.FBObject.CreateFBData()._fbData;
m_SceneNodeDB.Name = Name;
m_SceneNodeDB.SceneID = SceneID;
m_SceneNodeDB.NodeID = nodeCount = nodeCount + 1;
m_SceneNodeDB.EntID = entity.EntityID;
//save sceneNode to db
if (m_SceneNodeDB.NodeID > 0)
{
IDAL.IDAL.insertSceneNode(ctx, m_SceneNodeDB);
}
// }
}
}
}
}
return(true);
}
//public bool insertSceneNode(SceneNode sceneNode)
//{
// m(ctx.Context as dbDataEntities).SceneNode.Add(sceneNode);
// m(ctx.Context as dbDataEntities).SaveChanges();
// return true;
//}
public static bool DeleteSceneNode(IDAL_DCTX ctx, Int32 id)
{
try
{
// Scene tmp = new Scene() { Data = data };
(ctx.Context as dbDataEntities).SceneNode.Remove((ctx.Context as dbDataEntities).SceneNode.Where(x => x.NodeID == id).First());
(ctx.Context as dbDataEntities).SaveChanges();
// id = (int)tmp.SceneID;
return(true);
}catch (Exception ex)
{
MessageBox.Show("error in DeleteSceneNode '" + id + "' " + ex.Message);
}
return(false);
}
public bool SaveToDB(IDAL_DCTX ctx)
{
string DBPath = DBFileUtil.GetDBFilePath(this.Parent);
if (!String.IsNullOrEmpty(DBPath))
{
foreach (var item in Items)
{
var entity = item as EntityX;
if (entity != null)
{
entity.SaveToDB(ctx);
}
}
}
return(true);
}
public static bool DeleteScene(IDAL_DCTX ctx, Int32 id)
{
try
{
// Scene tmp = new Scene() { Data = data };
(ctx.Context as dbDataEntities).Scene.Remove((ctx.Context as dbDataEntities).Scene.Where(x => x.SceneID == id).First());
(ctx.Context as dbDataEntities).SaveChanges();
// id = (int)tmp.SceneID;
return(true);
}
catch (Exception ex)
{
// m_loggerService.Log("error IDAL.DeleteScene(id=" + id + ")" + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), LogCategory.Exception, LogPriority.High);
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(false);
}
public static bool deleteEntity(IDAL_DCTX ctx, Entity po)
{
try
{
var result = (ctx.Context as dbDataEntities).Entity.Where(x => x.EntID == po.EntID);
if (result.Any())
{
(ctx.Context as dbDataEntities).Entity.Remove(result.First());
(ctx.Context as dbDataEntities).SaveChanges();
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
public static bool TruncateDatabase(IDAL_DCTX ctx)
{
try
{
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [SceneNode]; VACUUM;");
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [Entity]; VACUUM;");
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [EntityData]; VACUUM;");
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [State];VACUUM;");
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [UI];VACUUM;");
(ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM [Scene]; VACUUM;");
// (ctx.Context as dbDataEntities).Database.ExecuteSqlCommand("DELETE FROM \"sqlite_sequence\"; VACUUM;");
}
catch (Exception ex)
{
}
return(false);
}
public static EntityData selectEntityData(IDAL_DCTX ctx, int id)
{
try
{
var result = (ctx.Context as dbDataEntities).EntityData.Where(x => x.EntDID == id);
if (result.Any())
{
return(result.First());
}
else
{
return(new EntityData());
}
}
catch (Exception ex)
{
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(new EntityData());
}
public static IEnumerable <EntityData> selectAllEntityData(IDAL_DCTX ctx)
{
try
{
var result = (ctx.Context as dbDataEntities).EntityData;
if (result.Any())
{
return(result);
}
else
{
return(null);
}
}
catch (Exception ex)
{
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(null);
}
public static bool insertEntityData(IDAL_DCTX ctx, EntityData entityData)
{
try
{
var result = (ctx.Context as dbDataEntities).EntityData.Where(x => x.EntDID == entityData.EntDID);
if (result.Any())
{
result.First().Data = entityData.Data;
}
else
{
(ctx.Context as dbDataEntities).EntityData.Add(entityData);
}
(ctx.Context as dbDataEntities).SaveChanges();
return(true);
}
catch (Exception ex)
{
}
return(false);
}
//public IEnumerable<SceneContainer> selectCompleteScene(int id)
//{
// try
// {
// var result = from n in m(ctx.Context as dbDataEntities).Scene
// join nj in m(ctx.Context as dbDataEntities).SceneNodes on n.SceneID equals nj.SceneID into gj
// from node in gj.DefaultIfEmpty()
// join oj in m(ctx.Context as dbDataEntities).Entity on node.EntID equals oj.EntID into gjo
// from Ent in gjo.DefaultIfEmpty()
// where n.SceneID == id
// select new SceneContainer { Scene = n, Nodes = node, Entity = Ent };
// // var result = m(ctx.Context as dbDataEntities).Scene.Where(x => x.SceneID == id);
// if (result.Any())
// {
// return result;//.Data;
// }
// }
// catch (Exception ex)
// {
// // MessageBox.Show("dreck_" + id + "_!!!!");
// }
// return null;
//}
public static IEnumerable <VEX.IDAL.MDB.Scene> selectAllScenesDataOnly(IDAL_DCTX ctx)
{
try
{
var result = from n in (ctx.Context as dbDataEntities).Scene
select n;
// var result = m(ctx.Context as dbDataEntities).Scene.Where(x => x.SceneID == id);
if (result.Any())
{
return(result);//.Data;
}
else
{
return(null);
}
}
catch (Exception ex)
{
// MessageBox.Show("dreck_" + id + "_!!!!");
}
return(null);
}
public IDAL_DCTX GetDataContextOpt(Boolean checkUser = true)
{
IDAL_DCTX ctx = new IDAL_DCTX();
try
{
var _databaseService = VEFModule.UnityContainer.Resolve(typeof(IDatabaseService), "") as IDatabaseService;
////if (m_DBFound)
////{
////}
////else
//// ShowDBSetting(m_Container);
// PS_COMID_DataContext crmDataContext = new PS_COMID_DataContext();
IDALOptions options = _databaseService.CurrentDB.DBOptions;
if (options.DBType == DBType.MSSQL)
{
//
//string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;Server = " + options.Host + "; Database = PNDS; User Id = " + options.User + ";Password = "******"metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=AP-HAAG\\SQLEX2008R203;initial catalog=PNDS;user id=PecuSoft;password=sesam1997oeffne;MultipleActiveResultSets=True;App=EntityFramework\"";
string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=" + options.Host + ";initial catalog=PNDS;user id=" + options.User + ";password="******";MultipleActiveResultSets=True;App=EntityFramework\"";
//string connectionString = "User Id=" + options.User + ";Password="******";Server=" + options.Host + ";Direct=True;Sid=" + options.ServiceName + ";Persist Security Info=True";
// string providerPrefix = "";
//if (!ConnectionDialog.Show(out connectionString, out providerPrefix))
//{
// stripLabel.Text = "Incorrect connection string";
// return;
//}
//Frame activating
// Stream contextStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(String.Format("ComID.IDAL.MDB.CrmDataMapping{0}.lqml", providerPrefix));
// Devart.Data.Linq.Mapping.MappingSource mappingSource = Devart.Data.Linq.Mapping.XmlMappingSource.FromStream(contextStream);
//PNDSEntities crmDataContext = new PNDSEntities(m_Container, connectionString);//, mappingSource);
//crmDataContext.CTXID = _databaseService.GetNextCtxID();
//// crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);
//crmDataContext.Database.Connection.Open();
//// foreach (ListViewItem lvItem in lvFrames.Items)
//// ((BaseControl)lvItem.Tag).OpenClick();
//if (checkUser && _databaseService.LoggedUser.UserID < 1)
//{
// ShowLoginDialog(m_Container);
// return null;
//}
//return crmDataContext;
}
else if (options.DBType == DBType.SQLite)
{
//System.Data.SQLite.SQLiteConnection.CreateFile("databaseFile.db3"); // Create the file which will be hosting our database
//using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=\"F:\\Projekte\\coop\\XGame\\data\\dbData.s3db\""))
//{
// using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
// {
// con.Open(); // Open the connection to the database
// //com.CommandText = createTableQuery; // Set CommandText to our query that will create the table
// //com.ExecuteNonQuery(); // Execute the query
// //com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key one','value one')"; // Add the first entry into our database
// //com.ExecuteNonQuery(); // Execute the query
// //com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key two','value value')"; // Add another entry into our database
// //com.ExecuteNonQuery(); // Execute the query
// //com.CommandText = "Select * FROM MyTable"; // Select all rows from our database table
// //using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
// //{
// // while (reader.Read())
// // {
// // Console.WriteLine(reader["Key"] + " : " + reader["Value"]); // Display the value of the key and value column for every row
// // }
// //}
// con.Close(); // Close the connection to the database
// }
//}
//todo per settings!
// string connectionString = "metadata=res://*/MDB.EDM_DBData.csdl|res://*/MDB.EDM_DBData.ssdl|res://*/MDB.EDM_DBData.msl;provider=System.Data.SQLite.EF6;provider connection string=\"data source=F:\\Projekte\\coop\\XGame\\data\\dbData.s3db\"";
// string connectionString = "data source=F:\\Projekte\\coop\\XGame\\data\\dbData.s3db";
string connectionString = _databaseService.CurrentDB.DBOptions.Host;
// string connectionString = "metadata=res://*/MDB.EDM_DBData.csdl|res://*/MDB.EDM_DBData.ssdl|res://*/MDB.EDM_DBData.msl;provider=System.Data.SQLite.EF6;provider connection string=\"data source=" + options.Host + "\""; //D:\\Projekte\\coop\\VEX\\Test\\dbData.s3db\"";
// string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=" + options.Host + ";initial catalog=PNDS;user id=" + options.User + ";password="******";MultipleActiveResultSets=True;App=EntityFramework\"";
dbDataEntities crmDataContext = new dbDataEntities(connectionString);//, mappingSource);
crmDataContext.CTXID = _databaseService.GetNextCtxID();
// crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);
//------------- crmDataContext..Database..Connection.Open();
// foreach (ListViewItem lvItem in lvFrames.Items)
// ((BaseControl)lvItem.Tag).OpenClick();
if (checkUser && _databaseService.LoggedUser.UserID < 1)
{
ShowLoginDialog();
return(null);
}
ctx.Context = crmDataContext;
return(ctx);
}
else if (options.DBType == DBType.Oracle)
{
//string connectionString = "User Id=" + options.User + ";Password="******";Server=" + options.Host + ";Direct=True;Sid=" + options.ServiceName + ";Persist Security Info=True";
//// string providerPrefix = "";
////if (!ConnectionDialog.Show(out connectionString, out providerPrefix))
////{
//// stripLabel.Text = "Incorrect connection string";
//// return;
////}
////Frame activating
//// Stream contextStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(String.Format("ComID.IDAL.MDB.CrmDataMapping{0}.lqml", providerPrefix));
//// Devart.Data.Linq.Mapping.MappingSource mappingSource = Devart.Data.Linq.Mapping.XmlMappingSource.FromStream(contextStream);
//PNDSEntities crmDataContext = new PNDSEntities(m_Container, connectionString);//, mappingSource);
//crmDataContext.CTXID = _databaseService.GetNextCtxID();
//// crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);
//crmDataContext.Database.Connection.Open();
//// foreach (ListViewItem lvItem in lvFrames.Items)
//// ((BaseControl)lvItem.Tag).OpenClick();
//if (checkUser && _databaseService.LoggedUser.UserID < 1)
//{
// ShowLoginDialog(m_Container);
// return null;
//}
//return crmDataContext;
}
}
catch (Exception ex)
{
var loggerService = VEFModule.UnityContainer.Resolve(typeof(ILoggerService), "") as ILoggerService;
loggerService.Log("Datenbankverbindung fehlgeschlagen." + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), LogCategory.Exception, LogPriority.High);
//
// workspace.NotificationRequest.Raise(new Notification { Content = "Datenbankverbindung fehlgeschlagen." + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), Title = "Fehler" });
// stripLabel.Text = ex.Message;
}
return(ctx);
}
