//public void createProjectDirectory(Project project)
//{
// Directory.CreateDirectory(StandardDir + project.Description);
// //Directory.CreateDirectory(@"" + project.Description);
//}
//public void updateProjectDirectory(Project Project)
//{
// if (Project.Description!=Project.OLDDescription)
// {
// try
// {
// Directory.Move(StandardDir + Project.OLDDescription, StandardDir + Project.Description);
// }
// catch { System.Windows.MessageBox.Show("Das Umbenennen des Ordners konnte nicht ausgeführt werden, da der Zugruff verweigert wurde! Der Ordner muss nun manuell umbenannt werden!"); }
// }
//}
//public void createIssueDirectory(Issue Issue)
//{
// string Projectname = (_myCommunicator.getDataSet("SELECT * FROM " + DBProjects.Table + " WHERE " + DBProjects.ID + "=" + Issue.ProjectID).Tables[0].Rows[0]).Field<string>(DBProjects.Name);
// Directory.CreateDirectory(StandardDir + Projectname + "\\" + Issue.Description);
//}
//public void updateIssueDirectoryName(Issue Issue)
//{
// if (Issue.Description != Issue.OLDDescription)
// {
// try
// {
// string Projectname = (_myCommunicator.getDataSet("SELECT * FROM " + DBProjects.Table + " WHERE " + DBProjects.ID + "=" + Issue.ProjectID).Tables[0].Rows[0]).Field<string>(DBProjects.Name);
// Directory.Move(StandardDir + Projectname + "\\" + Issue.OLDDescription, StandardDir + Projectname + "\\" + Issue.Description);
// }
// catch { System.Windows.MessageBox.Show("Das Umbenennen des Ordners konnte nicht ausgeführt werden, da der Zugruff verweigert wurde! Der Ordner muss nun manuell umbenannt werden!"); }
// }
//}
public void createReferenceDirectory(int ReferenceNumber)
{
DataTable _reference = (_myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferences.Table + " WHERE " + DBProcessReferences.RefNumber + "=" + ReferenceNumber).Tables[0]);
//string ProjectName = (_myCommunicator.getDataSet("SELECT * FROM " + DBProjects.Table + " WHERE " + DBProjects.ID + "=" + _reference.Rows[0].Field<int>(DBProcessReferences.ProjectID)).Tables[0].Rows[0]).Field<string>(DBProjects.Name);
//string IssueName = (_myCommunicator.getDataSet("SELECT * FROM " + DBIssues.Table + " WHERE " + DBIssues.ID + "=" + _reference.Rows[0].Field<int>(DBProcessReferences.IssueID)).Tables[0].Rows[0]).Field<string>(DBIssues.Description);
Directory.CreateDirectory(StandardDir /*+ ProjectName + "\\" + IssueName + "\\"*/ + ReferenceNumber);
}
public void insertReferences()
{
//-------------------------------------------------------------------------------
//Toshiba
//-------------------------------------------------------------------------------
DataSet _ds = _myCommunicator.getDataSet("SELECT * FROM " + DBExpToshiba.Table);
int LowerRef;
int UpperRef;
int finalUpper;
int finallower;
List <string> _queries = new List <string>();
int i = 0;
foreach (DataRow dr in _ds.Tables[0].Rows)
{
int PID = dr.Field <int>(DBExpToshiba.ID);
int UpperWP = dr.Field <int>(DBExpToshiba.UpperWPID);
int LowerWP = dr.Field <int>(DBExpToshiba.LowerWPID);
//get references by PID
DataSet _ds2 = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferenceRelation.Table + " where " + DBProcessReferenceRelation.PID + " = " + PID);
LowerRef = _ds2.Tables[0].Rows[0].Field <int>(DBProcessReferenceRelation.RefNumber);
UpperRef = _ds2.Tables[0].Rows[1].Field <int>(DBProcessReferenceRelation.RefNumber);
DataSet _ds3 = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferences.Table + " where " + DBProcessReferences.RefNumber + " = " + UpperRef);
DataSet _ds4 = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferences.Table + " where " + DBProcessReferences.RefNumber + " = " + LowerRef);
int finalUpperWP = _ds3.Tables[0].Rows[0].Field <int>(DBProcessReferences.WorkpiceID);
int finallowerWP = _ds4.Tables[0].Rows[0].Field <int>(DBProcessReferences.WorkpiceID);
if (finallowerWP == LowerWP)
{
finallower = LowerRef;
finalUpper = UpperRef;
}
else
{
finalUpper = LowerRef;
finallower = UpperRef;
}
_queries.Add("update " + DBExpToshiba.Table + " set " + DBExpToshiba.UpperRef + "=" + finalUpper + "," + DBExpToshiba.LowerRef + "=" + finallower + " where " + DBExpToshiba.ID + "=" + PID);
}
//-------------------------------------------------------------------------------
//EXP_Moore
DataSet _dsMoore = _myCommunicator.getDataSet("SELECT * FROM " + DBExpMoore.Table);
foreach (DataRow dr in _dsMoore.Tables[0].Rows)
{
int PID = dr.Field <int>(DBExpMoore.ID);
int?UpperWP = dr.Field <int?>(DBExpMoore.UpperWorkpieceID);
int?LowerWP = dr.Field <int?>(DBExpMoore.LowerWorkpieceID);
//get references by PID
DataSet _ds2 = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferenceRelation.Table + " where " + DBProcessReferenceRelation.PID + " = " + PID);
if (LowerWP != null)
{
DataSet _dsLowerReferences = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferences.Table + " where " + DBProcessReferences.WorkpiceID + " = " + LowerWP);
int?LowerReferenceNumber = null;
foreach (DataRow cand in _ds2.Tables[0].Rows)
{
int reference = cand.Field <int>(DBProcessReferenceRelation.RefNumber);
foreach (DataRow candReference in _dsLowerReferences.Tables[0].Rows)
{
if (reference == candReference.Field <int>(DBProcessReferences.RefNumber))
{
LowerReferenceNumber = reference;
break;
}
}
if (LowerReferenceNumber != null)
{
break;
}
}
_queries.Add("update " + DBExpMoore.Table + " set " + DBExpMoore.LowerReference + "=" + LowerReferenceNumber.ToDBObject() + " where " + DBExpMoore.ID + "=" + PID);
}
if (UpperWP != null)
{
DataSet _dsUpperReferences = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferences.Table + " where " + DBProcessReferences.WorkpiceID + " = " + UpperWP);
int?UpperReferenceNumber = null;
foreach (DataRow cand in _ds2.Tables[0].Rows)
{
int reference = cand.Field <int>(DBProcessReferenceRelation.RefNumber);
foreach (DataRow candReference in _dsUpperReferences.Tables[0].Rows)
{
if (reference == candReference.Field <int>(DBProcessReferences.RefNumber))
{
UpperReferenceNumber = reference;
break;
}
}
if (UpperReferenceNumber != null)
{
break;
}
}
_queries.Add("update " + DBExpMoore.Table + " set " + DBExpMoore.UpperReference + "=" + UpperReferenceNumber.ToDBObject() + " where " + DBExpMoore.ID + "=" + PID);
}
}
//-------------------------------------------------------------------------------
//Cemecon
//-------------------------------------------------------------------------------
_ds = _myCommunicator.getDataSet("SELECT * FROM " + DBCoatingCemecon.Table);
foreach (DataRow dr in _ds.Tables[0].Rows)
{
int PID = dr.Field <int>(DBCoatingCemecon.ID);
DataSet _ds2 = _myCommunicator.getDataSet("SELECT * FROM " + DBProcessReferenceRelation.Table + " where " + DBProcessReferenceRelation.PID + " = " + PID);
int _ref = _ds2.Tables[0].Rows[0].Field <int>(DBProcessReferenceRelation.RefNumber);
_queries.Add("update " + DBCoatingCemecon.Table + " set " + DBCoatingCemecon.Reference + "=" + _ref + " where " + DBCoatingCemecon.ID + "=" + PID);
}
//-------------------------------------------------------------------------------
_myCommunicator.executeTransactedQueries(_queries);
}