public EmployeesRow AddEmployeesRow(string LastName)
{
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
null,
LastName
};
this.Rows.Add(rowEmployeesRow);
return(rowEmployeesRow);
}
public EmployeesRow AddEmployeesRow(int EmployeeID, string FirstName, string LastName, string HomePhone, string Notes)
{
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
EmployeeID,
FirstName,
LastName,
HomePhone,
Notes
};
this.Rows.Add(rowEmployeesRow);
return(rowEmployeesRow);
}
public EmployeesRow AddEmployeesRow(string FirstName, string LastName, string Title, string Address, string City, string Country)
{
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
null,
FirstName,
LastName,
Title,
Address,
City,
Country
};
this.Rows.Add(rowEmployeesRow);
return(rowEmployeesRow);
}
public OrdersRow AddOrdersRow(string CustomerID, EmployeesRow parentEmployeesRowByEmployeesOrders, System.DateTime OrderDate, string ShipAddress, string ShipName, System.DateTime ShippedDate)
{
OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
rowOrdersRow.ItemArray = new object[] {
CustomerID,
parentEmployeesRowByEmployeesOrders[0],
OrderDate,
null,
ShipAddress,
ShipName,
ShippedDate
};
this.Rows.Add(rowOrdersRow);
return(rowOrdersRow);
}
public EmployeesRow AddEmployeesRow(
string LastName,
string FirstName,
string Title,
string TitleOfCourtesy,
System.DateTime BirthDate,
System.DateTime HireDate,
string Address,
string City,
string Region,
string PostalCode,
string Country,
string HomePhone,
string Extension,
System.Byte[] Photo,
string Notes,
int ReportsTo,
string PhotoPath)
{
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
null,
LastName,
FirstName,
Title,
TitleOfCourtesy,
BirthDate,
HireDate,
Address,
City,
Region,
PostalCode,
Country,
HomePhone,
Extension,
Photo,
Notes,
ReportsTo,
PhotoPath
};
this.Rows.Add(rowEmployeesRow);
return(rowEmployeesRow);
}
public EmployeesRow AddEmployeesRow(string LastName, string FirstName, string Title, System.DateTime BirthDate, System.DateTime HireDate, string Address, string City, string Region, string PostalCode, string Country, string HomePhone)
{
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
rowEmployeesRow.ItemArray = new object[] {
null,
LastName,
FirstName,
Title,
BirthDate,
HireDate,
Address,
City,
Region,
PostalCode,
Country,
HomePhone
};
this.Rows.Add(rowEmployeesRow);
return(rowEmployeesRow);
}
public void AddEmployeesRow(EmployeesRow row) {
this.Rows.Add(row);
}
public void AddEmployeesRow(EmployeesRow row)
{
this.Rows.Add(row);
}
public EmployeesRowChangeEvent(EmployeesRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public void RemoveEmployeesRow(EmployeesRow row)
{
this.Rows.Remove(row);
}
public OrdersRow AddOrdersRow(int OrderID, CustomersRow parentCustomersRowByFK_Orders_Customers, EmployeesRow parentEmployeesRowByFK_Orders_Employees, System.DateTime OrderDate, System.DateTime ShippedDate, string ShipAddress) {
OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
OrderID,
null,
null,
OrderDate,
ShippedDate,
ShipAddress};
if ((parentCustomersRowByFK_Orders_Customers != null)) {
columnValuesArray[1] = parentCustomersRowByFK_Orders_Customers[0];
}
if ((parentEmployeesRowByFK_Orders_Employees != null)) {
columnValuesArray[2] = parentEmployeesRowByFK_Orders_Employees[0];
}
rowOrdersRow.ItemArray = columnValuesArray;
this.Rows.Add(rowOrdersRow);
return rowOrdersRow;
}
public EmployeeTerritoriesRow AddEmployeeTerritoriesRow(EmployeesRow parentEmployeesRowByFK_EmployeeTerritories_Employees, TerritoriesRow parentTerritoriesRowByFK_EmployeeTerritories_Territories) {
EmployeeTerritoriesRow rowEmployeeTerritoriesRow = ((EmployeeTerritoriesRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
null};
if ((parentEmployeesRowByFK_EmployeeTerritories_Employees != null)) {
columnValuesArray[0] = parentEmployeesRowByFK_EmployeeTerritories_Employees[0];
}
if ((parentTerritoriesRowByFK_EmployeeTerritories_Territories != null)) {
columnValuesArray[1] = parentTerritoriesRowByFK_EmployeeTerritories_Territories[0];
}
rowEmployeeTerritoriesRow.ItemArray = columnValuesArray;
this.Rows.Add(rowEmployeeTerritoriesRow);
return rowEmployeeTerritoriesRow;
}
public OrdersRow AddOrdersRow(CustomersRow parentCustomersRowByFK_Orders_Customers, EmployeesRow parentEmployeesRowByFK_Orders_Employees, System.DateTime OrderDate, System.DateTime RequiredDate, System.DateTime ShippedDate, ShippersRow parentShippersRowByFK_Orders_Shippers, decimal Freight, string ShipName, string ShipAddress, string ShipCity, string ShipRegion, string ShipPostalCode, string ShipCountry) {
OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
null,
null,
OrderDate,
RequiredDate,
ShippedDate,
null,
Freight,
ShipName,
ShipAddress,
ShipCity,
ShipRegion,
ShipPostalCode,
ShipCountry};
if ((parentCustomersRowByFK_Orders_Customers != null)) {
columnValuesArray[1] = parentCustomersRowByFK_Orders_Customers[0];
}
if ((parentEmployeesRowByFK_Orders_Employees != null)) {
columnValuesArray[2] = parentEmployeesRowByFK_Orders_Employees[0];
}
if ((parentShippersRowByFK_Orders_Shippers != null)) {
columnValuesArray[6] = parentShippersRowByFK_Orders_Shippers[0];
}
rowOrdersRow.ItemArray = columnValuesArray;
this.Rows.Add(rowOrdersRow);
return rowOrdersRow;
}
public EmployeesRow AddEmployeesRow(
string LastName,
string FirstName,
string Title,
string TitleOfCourtesy,
System.DateTime BirthDate,
System.DateTime HireDate,
string Address,
string City,
string Region,
string PostalCode,
string Country,
string HomePhone,
string Extension,
byte[] Photo,
string Notes,
EmployeesRow parentEmployeesRowByFK_Employees_Employees,
string PhotoPath) {
EmployeesRow rowEmployeesRow = ((EmployeesRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
LastName,
FirstName,
Title,
TitleOfCourtesy,
BirthDate,
HireDate,
Address,
City,
Region,
PostalCode,
Country,
HomePhone,
Extension,
Photo,
Notes,
null,
PhotoPath};
if ((parentEmployeesRowByFK_Employees_Employees != null)) {
columnValuesArray[16] = parentEmployeesRowByFK_Employees_Employees[0];
}
rowEmployeesRow.ItemArray = columnValuesArray;
this.Rows.Add(rowEmployeesRow);
return rowEmployeesRow;
}
public OrdersRow AddOrdersRow(CustomersRow parentCustomersRowByCustomersOrders, EmployeesRow parentEmployeesRowByEmployeesOrders, System.DateTime OrderDate, System.DateTime RequiredDate, System.DateTime ShippedDate, ShippersRow parentShippersRowByShippersOrders, decimal Freight, string ShipName, string ShipAddress, string ShipCity, string ShipRegion, string ShipPostalCode, string ShipCountry) {
OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
rowOrdersRow.ItemArray = new object[] {
null,
parentCustomersRowByCustomersOrders[0],
parentEmployeesRowByEmployeesOrders[0],
OrderDate,
RequiredDate,
ShippedDate,
parentShippersRowByShippersOrders[0],
Freight,
ShipName,
ShipAddress,
ShipCity,
ShipRegion,
ShipPostalCode,
ShipCountry};
this.Rows.Add(rowOrdersRow);
return rowOrdersRow;
}
public EmployeesRowChangeEvent(EmployeesRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public EmployeesRowChangeEvent(EmployeesRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public EmployeeTerritoriesRow AddEmployeeTerritoriesRow(EmployeesRow parentEmployeesRowByFK_EmployeeTerritories_Employees, TerritoriesRow parentTerritoriesRowByFK_EmployeeTerritories_Territories) {
EmployeeTerritoriesRow rowEmployeeTerritoriesRow = ((EmployeeTerritoriesRow)(this.NewRow()));
rowEmployeeTerritoriesRow.ItemArray = new object[] {
parentEmployeesRowByFK_EmployeeTerritories_Employees[0],
parentTerritoriesRowByFK_EmployeeTerritories_Territories[0]};
this.Rows.Add(rowEmployeeTerritoriesRow);
return rowEmployeeTerritoriesRow;
}
public EmployeesRowChangeEvent(EmployeesRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveEmployeesRow(EmployeesRow row) {
this.Rows.Remove(row);
}