//public int SetCylinderLoaded()
//{
// DateTime unload = sql.ExecuteScalar<DateTime>("SELECT LastUnload FROM Cylinder WHERE Cylinder_Id=@0", Cylinder_ID);
// DateTime now = DateTime.Now;
// if (unload.Year != 2001)
// {
// if (now > unload)
// {
// TimeSpan t = now - unload;
// double min = t.Minutes;
// sql.Execute("UPDATE Cylinder SET Runtime = Runtime + @0 WHERE Cylinder_Id=@1", min, Cylinder_ID);
// }
// }
// return sql.Execute("UPDATE Cylinder SET LastLoad=GETDATE() WHERE Cylinder_Id=@0", Cylinder_ID);
//}
//public int SetCylinderUnloaded()
//{
// IncCylinderCycles();
// return sql.Execute("UPDATE Cylinder SET LastUnload=GETDATE() WHERE Cylinder_Id=" + Cylinder_ID);
//}
//public int SetCylinderMoved()
//{
// IncCylinderCycles();
// return sql.Execute("UPDATE Cylinder SET LastMoved=GETDATE() WHERE Cylinder_Id=" + Cylinder_ID);
//}
//public int IncCylinderCycles()
//{
// return sql.Execute("UPDATE Cylinder SET Cycles=Cycles+1 WHERE Cylinder_Id=" + Cylinder_ID);
//}
public static Dictionary <int, string> GetCylinderStates()
{
Dictionary <int, string> dic = new Dictionary <int, string>();
DataTable dt = MainDb.GetDataTable("SELECT * FROM CylinderStates ORDER BY ID");
foreach (DataRow row in dt.Rows)
{
dic.Add((int)row["ID"], (string)row["Name"]);
}
return(dic);
}
private void BtnCopyData_Click(object sender, EventArgs e)
{
try
{
AddBackupLogText("start making backup copy");
DatabasePrepare(Registry.BackupDestinationConnection, Registry.BackupDestinationProvider);
var srcdb = new BauerSql.MainDb(Registry.BackupSourceConnection, Registry.BackupSourceProvider);
var destdb = new BauerSql.MainDb(Registry.BackupDestinationConnection, Registry.BackupDestinationProvider);
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbAGVLocation)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbAGVLocation>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbAlarm)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbAlarm>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinder)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbCylinder>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
if (chkCopyPictures.Checked)
{
if (srcdb.ExecuteScalar <int>("SELECT COUNT(*) FROM Cylinder WHERE Cylinder_ID=@0 AND NOT picture1 IS NULL", item.Cylinder_ID) == 1)
{
byte[] img = srcdb.ExecuteScalar <byte[]>("SELECT picture1 FROM Cylinder WHERE Cylinder_ID=@0", item.Cylinder_ID);
destdb.Execute("UPDATE Cylinder SET picture1=@0 WHERE Cylinder_ID=@1", img, item.Cylinder_ID);
}
if (srcdb.ExecuteScalar <int>("SELECT COUNT(*) FROM Cylinder WHERE Cylinder_ID=@0 AND NOT picture2 IS NULL", item.Cylinder_ID) == 1)
{
byte[] img = srcdb.ExecuteScalar <byte[]>("SELECT picture2 FROM Cylinder WHERE Cylinder_ID=@0", item.Cylinder_ID);
destdb.Execute("UPDATE Cylinder SET picture2=@0 WHERE Cylinder_ID=@1", img, item.Cylinder_ID);
}
}
}
destdb.CompleteTransaction();
if (chkCylinderMovement.Checked)
{
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinderMovement)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbCylinderMovement>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
}
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinderState)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbCylinderState>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
if (chkCopyLog4Net.Checked)
{
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDblog4net)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDblog4net>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
}
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbMachineInformation)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbMachineInformation>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbMonitor)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbMonitor>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbRack)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbRack>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbRackUser)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbRackUser>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
if (chkOrders.Checked)
{
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbStorageOrder)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbStorageOrder>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
}
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnit)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbUnit>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
if (chkUnitFlow.Checked)
{
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnitFlow)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbUnitFlow>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
}
if (chkUnitMoves.Checked)
{
destdb.BeginTransaction();
DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnitMove)).TableName, destdb);
foreach (var item in srcdb.Fetch <SqlDbUnitMove>(""))
{
ReplaceWrongDate(item);
destdb.Insert(item);
}
destdb.CompleteTransaction();
}
srcdb.CloseSharedConnection();
destdb.CloseSharedConnection();
if (Registry.BackupDestinationProvider.ToLowerInvariant() == "sqlite")
{
string fname = Registry.BackupDestinationConnection.ToLower().Trim().Replace("data source=", "").Replace(";", "");
if (File.Exists(fname))
{
string new_name = fname.Replace(".sqlite", DateTime.Now.ToString("_yyyy_MM_dd__HH_mm_ss") + ".sqlite");
File.Move(fname, new_name);
}
}
AddBackupLogText("ready making backup copy");
}
catch (Exception ex)
{
AddBackupLogText("exception making backup copy " + ex.Message);
}
}
