private void Button_Click(object sender, RoutedEventArgs e)
{ // FiLL
ds = new DataSet1();
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
dgEmps.ItemsSource = ds.Employees.DefaultView;
}
private void SaveAllButton_Click(object sender, RoutedEventArgs e)
{
using (var ta = new EmployeesTableAdapter())
{
var table = MainGrid.ItemsSource as EmployeesDataTable;
ta.Update(table);
}
}
private void LoadButton_Click(object sender, RoutedEventArgs e)
{
using (var ta = new EmployeesTableAdapter())
{
var table = ta.GetData();
MainGrid.ItemsSource = table;
}
}
private void LoadButton_Click(object sender, RoutedEventArgs e)
{
//var employees = ReadEmployeesFromDb();
//MainGrid.ItemsSource = employees;
using (var ta = new EmployeesTableAdapter()) {
MainGrid.ItemsSource = ta.GetData();
}
}
MyTypedDs ds = new MyTypedDs(); //hence from below function the DataSet ds has all the values
private void Form2_Load(object sender, EventArgs e) //here the TableAdapter is filling a DataSet
{
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
}
private void Form2_Load(object sender, EventArgs e)
{
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
}
//Method to access the DB
private void Get_Data()
{
ds = new DataSet1();
mta = new MenuTableAdapter();
eta = new EmployeesTableAdapter();
mta.Fill(ds.Menu);
eta.Fill(ds.Employees);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
dgEmps.ItemsSource = ds.Employees.DefaultView;
}
void InitializeDataSources()
{
var dataSource = new DataSet1();
var connection = new OleDbConnection();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb";
EmployeesTableAdapter employees = new EmployeesTableAdapter();
employees.Connection = connection;
employees.Fill(dataSource.Employees);
CustomersTableAdapter customers = new CustomersTableAdapter();
customers.Connection = connection;
customers.Fill(dataSource.Customers);
EmployeeCustomersTableAdapter employeeCustomers = new EmployeeCustomersTableAdapter();
employeeCustomers.Connection = connection;
employeeCustomers.Fill(dataSource.EmployeeCustomers);
OrdersTableAdapter orders = new OrdersTableAdapter();
orders.Connection = connection;
orders.Fill(dataSource.Orders);
Order_DetailsTableAdapter orderDetails = new Order_DetailsTableAdapter();
orderDetails.Connection = connection;
orderDetails.Fill(dataSource.Order_Details);
SnapDocument document = snapControl1.Document;
document.BeginUpdateDataSource();
var employeesBinding = new BindingSource()
{
DataSource = dataSource, DataMember = employeeDataSourceName
};
document.DataSources.Add(new DataSourceInfo(employeeDataSourceName, employeesBinding));
var customersBinding = new BindingSource()
{
DataSource = dataSource, DataMember = customerDataSourceName
};
document.DataSources.Add(new DataSourceInfo(customerDataSourceName, customersBinding));
document.EndUpdateDataSource();
}
//connection to the database
private void get_data()
{
ds = new DataSet1();
st = new InventoryTableAdapter();
st.Fill(ds.Inventory);
ct = new SuppliersTableAdapter();
ct.Fill(ds.Suppliers);
et = new EmployeesTableAdapter();
et.Fill(ds.Employees);
}
MyDataSet ds; //here firstly 'MyDataSet' is the name of the Typed DataSet which we made----secondly the order should remain the same i.e we can't add Employee first as its a child table---here we don't need to create Connection and a DataAdapter because it is already initialized in the table eg for Departments table in file DataSet we have DepartmentsTableAdapter
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter(); //here we don't need to create Connection and a DataAdapter because it is already initialized in the table--just using it here
daDeps.Fill(ds.Departments); //previously we were mentioning the .Tables in here which was generated during run time...but since we have that, therefore mentioning the table name directly
EmployeesTableAdapter daEmps = new EmployeesTableAdapter(); //similarly for Employee
daEmps.Fill(ds.Employees); //for Fill button
dgEmps.ItemsSource = ds.Employees.DefaultView; //creating a default view for Employees table
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new DataSet1();
DepartmentsTableAdapter dadeps = new DepartmentsTableAdapter();
dadeps.Fill(ds.Departments);
EmployeesTableAdapter daemps = new EmployeesTableAdapter();
daemps.Fill(ds.Employees);
mygrid.ItemsSource = ds.Employees;
}
private void btnFill_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();// creating object of our own already created data set
DepartmentsTableAdapter daDepts = new DepartmentsTableAdapter();
daDepts.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
dgEmps.ItemsSource = ds.Employees.DefaultView;
}
private void NewButton_Click(object sender, RoutedEventArgs e)
{
var detailWindow = new EmployeeDetail();
if (detailWindow.ShowDialog() == true)
{
// Salvo il dato dalla maschera di dettaglio
//SaveNewEmployee(detailWindow.Model);
//LoadButton_Click(sender, e);
using (var ta = new EmployeesTableAdapter()) {
ta.Insert(detailWindow.Model.Name, detailWindow.Model.Productivity, detailWindow.Model.TotalBonus);
}
}
else
{
// Non modifico niente
}
}
/*
* Function get_data()
* Fills database tables using DataSet.
*/
private void get_data()
{
ds = new DataSet1();
mt = new MenuTableAdapter();
it = new InventoryTableAdapter();
et = new EmployeesTableAdapter();
ot = new OrdersTableAdapter();
olt = new OrderlineTableAdapter();
st = new SuppliersTableAdapter();
pot = new PurchaseOrdersTableAdapter();
polt = new PurchaseOrderlineTableAdapter();
mt.Fill(ds.Menu);
it.Fill(ds.Inventory);
et.Fill(ds.Employees);
ot.Fill(ds.Orders);
olt.Fill(ds.Orderline);
st.Fill(ds.Suppliers);
pot.Fill(ds.PurchaseOrders);
polt.Fill(ds.PurchaseOrderline);
}
//setting a method to get the data from the table
private void Get_Data()
{
ds = new DataSet1();
et = new EmployeesTableAdapter();
et.Fill(ds.Employees);
}
/// <summary>
/// Initializes a new instance of the <see cref="ViewModel"/> class.
/// </summary>
public ViewModel()
{
this.dataAdapter = new EmployeesTableAdapter();
this.dataAdapter.Connection = Connection;
}
private void CopyEmployees(IOdb odb)
{
var employees = new List<Employee>();
var reportingEmployees = new Hashtable();
//Processing Employees
LogMessage("Reading Employees...", false);
var adapter1 = new EmployeesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
var e = new Employee
{
EmployeeID = row.EmployeeID,
FirstName = row.FirstName,
LastName = row.LastName,
Title = row.IsTitleNull() ? null : row.Title,
TitleOfCourtesy = row.IsTitleOfCourtesyNull() ? null : row.TitleOfCourtesy,
Address = row.IsAddressNull() ? null : row.Address,
City = row.IsCityNull() ? null : row.City,
Region = row.IsRegionNull() ? null : row.Region,
PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode,
Country = row.IsCountryNull() ? null : row.Country,
HomePhone = row.IsHomePhoneNull() ? null : row.HomePhone,
Extension = row.IsExtensionNull() ? null : row.Extension,
Notes = row.IsNotesNull() ? null : row.Notes,
Photo = row.IsPhotoNull() ? null : row.Photo,
PhotoPath = row.IsPhotoPathNull() ? null : row.PhotoPath
};
if (!row.IsBirthDateNull())
e.BirthDate = row.BirthDate;
if (!row.IsHireDateNull())
e.HireDate = row.HireDate;
if (!row.IsReportsToNull())
reportingEmployees.Add(e.EmployeeID, row.ReportsTo);
employees.Add(e);
}
foreach (var e in employees)
{
LogMessage("Employee: " + e.EmployeeID.ToString() + " ...", false);
if (reportingEmployees.ContainsKey(e.EmployeeID))
{
LogMessage("linking member...", false);
var reportsToID = Convert.ToInt64(reportingEmployees[e.EmployeeID]);
var found = employees.Find(p => p.EmployeeID == reportsToID);
e.ReportsTo = found;
}
odb.Store(e);
LogMessage("saved (" + e.EmployeeID.ToString() + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Employee>().AddUniqueIndexOn("Employee_EmployeeID_PK_index", Employee.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Employee>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Employees" + Environment.NewLine, true);
}
public void CopyEmployees()
{
List<Employee> employees = new List<Employee>();
Hashtable reportingEmployees = new Hashtable();
//Processing Employees
LogMessage("Reading Employees...", false);
EmployeesTableAdapter adapter1 = new EmployeesTableAdapter();
NorthwindDb4o.NorthwindDataSet.EmployeesDataTable table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (NorthwindDb4o.NorthwindDataSet.EmployeesRow row in table1)
{
Employee e = new Employee();
e.EmployeeID = row.EmployeeID;
e.FirstName = row.FirstName;
e.LastName = row.LastName;
e.Title = row.IsTitleNull() ? null : row.Title;
e.TitleOfCourtesy = row.IsTitleOfCourtesyNull() ? null : row.TitleOfCourtesy;
if (!row.IsBirthDateNull())
e.BirthDate = row.BirthDate;
if (!row.IsHireDateNull())
e.HireDate = row.HireDate;
e.Address = row.IsAddressNull() ? null : row.Address;
e.City = row.IsCityNull() ? null : row.City;
e.Region = row.IsRegionNull() ? null : row.Region;
e.PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode;
e.Country = row.IsCountryNull() ? null : row.Country;
e.HomePhone = row.IsHomePhoneNull() ? null : row.HomePhone;
e.Extension = row.IsExtensionNull() ? null : row.Extension;
e.Notes = row.IsNotesNull() ? null : row.Notes;
e.Photo = row.IsPhotoNull() ? null : row.Photo;
e.PhotoPath = row.IsPhotoPathNull() ? null : row.PhotoPath;
if (!row.IsReportsToNull())
reportingEmployees.Add(e.EmployeeID, row.ReportsTo);
employees.Add(e);
}
foreach (Employee e in employees)
{
LogMessage("Employee: " + e.EmployeeID.ToString() + " ...", false);
if(reportingEmployees.ContainsKey(e.EmployeeID))
{
LogMessage("linking member...", false);
long reportsToID = Convert.ToInt64(reportingEmployees[e.EmployeeID]);
Employee found = employees.Find(delegate(Employee p) { return p.EmployeeID == reportsToID; });
e.ReportsTo = found;
}
container.Store(e);
LogMessage("saved (" + e.EmployeeID.ToString() + ")", true);
}
container.Commit();
long objectCount = Db4oUtil.GetAllInstances(container, typeof(Employee)).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Employees" + Environment.NewLine, true);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Update(ds.Employees);
}
private void CopyEmployees(IOdb odb)
{
var employees = new List <Employee>();
var reportingEmployees = new Hashtable();
//Processing Employees
LogMessage("Reading Employees...", false);
var adapter1 = new EmployeesTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
var e = new Employee
{
EmployeeID = row.EmployeeID,
FirstName = row.FirstName,
LastName = row.LastName,
Title = row.IsTitleNull() ? null : row.Title,
TitleOfCourtesy = row.IsTitleOfCourtesyNull() ? null : row.TitleOfCourtesy,
Address = row.IsAddressNull() ? null : row.Address,
City = row.IsCityNull() ? null : row.City,
Region = row.IsRegionNull() ? null : row.Region,
PostalCode = row.IsPostalCodeNull() ? null : row.PostalCode,
Country = row.IsCountryNull() ? null : row.Country,
HomePhone = row.IsHomePhoneNull() ? null : row.HomePhone,
Extension = row.IsExtensionNull() ? null : row.Extension,
Notes = row.IsNotesNull() ? null : row.Notes,
Photo = row.IsPhotoNull() ? null : row.Photo,
PhotoPath = row.IsPhotoPathNull() ? null : row.PhotoPath
};
if (!row.IsBirthDateNull())
{
e.BirthDate = row.BirthDate;
}
if (!row.IsHireDateNull())
{
e.HireDate = row.HireDate;
}
if (!row.IsReportsToNull())
{
reportingEmployees.Add(e.EmployeeID, row.ReportsTo);
}
employees.Add(e);
}
foreach (var e in employees)
{
LogMessage("Employee: " + e.EmployeeID.ToString() + " ...", false);
if (reportingEmployees.ContainsKey(e.EmployeeID))
{
LogMessage("linking member...", false);
var reportsToID = Convert.ToInt64(reportingEmployees[e.EmployeeID]);
var found = employees.Find(p => p.EmployeeID == reportsToID);
e.ReportsTo = found;
}
odb.Store(e);
LogMessage("saved (" + e.EmployeeID.ToString() + ")", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor <Employee>().AddUniqueIndexOn("Employee_EmployeeID_PK_index", Employee.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances <Employee>(odb).Count;
if (table1.Count == objectCount)
{
LogMessage(table1.Count + " objects saved", true);
}
else
{
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
}
LogMessage("Done with Employees" + Environment.NewLine, true);
}
