private void UpdateGridDataSource(Table t)
{
schemaDS1.TableSchema.AddTableSchemaRow(t.Id, t.Name, t.Schema, t.Schema + "." + t.Name, t.HasData);
}
public Column(string name, string type,Table parentTable)
{
this.Name = name;
this.ColumnDataType = new DataType() { SQLType = type };
this.Parent = parentTable;
}
private string GetColumnString(Table table, Column col)
{
string result = col.Name;
foreach(RelationShip r in table.ParentRelationShips)
{
if(r.ChildColumn.Name == col.Name)
{
switch(r.MasterTable.Name)
{
case "Address":
result = string.Format("Migration.fn_GetNewAddressID({0}, 0, 0)", col.Name);
break;
case "Banks":
result = string.Format("Migration.fn_GetNewBankID({0}, 0, 0)", col.Name);
break;
case "Categories":
result = string.Format("Migration.fn_GetNewCategoryID({0}, 0, 0)", col.Name);
break;
case "Cities":
result = string.Format("Migration.fn_GetNewCityID({0}, 0, 0)", col.Name);
break;
case "ProjectsComments":
result = string.Format("Migration.fn_GetNewCommentID({0}, 0, 0)", col.Name);
break;
case "Currencies":
result = string.Format("Migration.fn_GetNewCurrencyID({0}, 0, 0)", col.Name);
break;
case "Customers":
result = string.Format("Migration.fn_GetNewCustomerID({0}, 0, 0)", col.Name);
break;
case "CustomerSupplierRegistration":
result = string.Format("Migration.fn_GetNewCustomerSupplierRegistrationID({0}, 0, 0)", col.Name);
break;
case "DocumentsJobs":
result = string.Format("Migration.fn_GetNewDocID({0}, 0, 0)", col.Name);
break;
case "ProjectsGuarantee":
result = string.Format("Migration.fn_GetNewGuranteeID({0}, 0, 0)", col.Name);
break;
case "Inquiries":
result = string.Format("Migration.fn_GetNewInquiryNumber({0}, 0, 0)", col.Name);
break;
case "Notifications":
result = string.Format("Migration.fn_GetNewNotificationID({0}, 0, 0)", col.Name);
break;
case "SystemPages":
result = string.Format("Migration.fn_GetNewPageID({0}, 0, 0)", col.Name);
break;
case "PartialOrder":
result = string.Format("Migration.fn_GetNewPartialOrderID({0}, 0, 0)", col.Name);
break;
case "PartialShipment":
result = string.Format("Migration.fn_GetNewPartialShipmentID({0}, 0, 0)", col.Name);
break;
case "Person.Person":
case "Person.BusinessEntity":
result = string.Format("Migration.fn_GetNewPersonID({0}, 0, 0)", col.Name);
break;
case "Products":
result = string.Format("Migration.fn_GetNewProductID({0}, 0, 0)", col.Name);
break;
case "ProjectsHistory":
result = string.Format("Migration.fn_GetNewProjectHistoryID({0}, 0, 0)", col.Name);
break;
case "Projects":
result = string.Format("Migration.fn_GetNewProjectID({0}, 0, 0)", col.Name);
break;
case "Roles":
result = string.Format("Migration.fn_GetNewRoleID({0}, 0, 0)", col.Name);
break;
case "Suppliers":
result = string.Format("Migration.fn_GetNewSupplierID({0}, 0, 0)", col.Name);
break;
case "TimeSheet":
result = string.Format("Migration.fn_GetNewTimeSheetID({0}, 0, 0)", col.Name);
break;
case "Transactions":
result = string.Format("Migration.fn_GetNewTransactionID({0}, 0, 0)", col.Name);
break;
case "Visits":
result = string.Format("Migration.fn_GetNewVisitID({0}, 0, 0)", col.Name);
break;
case "ProjectsLog":
result = string.Format("Migration.fn_GetProjectLogID({0}, 0, 0)", col.Name);
break;
}
}
}
return result;
}
public override object Clone()
{
if (!this.EntitySelected)
return null;
Table tbl = new Table();
tbl.Name = this.Name;
tbl.EntitySelected = this.EntitySelected;
tbl.Id = this.Id;
tbl.PrimaryColumnCount = this.PrimaryColumnCount;
tbl.Schema = this.Schema;
tbl.TableID = this.TableID;
foreach (Column col in this.Columns)
{
Column newCol = col.Clone() as Column;
if (newCol != null)
{
newCol.Parent = tbl;
tbl.Columns.Add(newCol);
}
}
return tbl;
}
public abstract void GetTableRelations(Table table);
public abstract void GetChildRelations(Table table);
public abstract void GetParentRelations(Table table);
public abstract void GetColumns(Table table);
