public static Product GetDataProductToExcel(OleDbDataReader reader)
{
Product pro = new Product();
pro.ProductID = MyConvert.ToInt32(reader["ProductID"]);
pro.ProductName = MyConvert.ToString(reader["ProductName"]);
pro.SupplierID = MyConvert.ToInt32(reader["SupplierID"]);
pro.QuantityPerUnit = MyConvert.ToString(reader["ProductName"]);
pro.UnitPrice = MyConvert.ToDouble(reader["UnitPrice"]);
pro.UnitsInStock = MyConvert.ToInt16(reader["UnitsInStock"]);
pro.UnitsOnOrder = MyConvert.ToInt16(reader["UnitsOnOrder"]);
pro.Discontinued = MyConvert.ToBool(reader["Discontinued"]);
return(pro);
}
public static Customer GetDataCustomerToExcel(OleDbDataReader reader)
{
Customer cus = new Customer();
cus.CustomerID = MyConvert.ToString(reader["ID"]);
cus.CompanyName = MyConvert.ToString(reader["CompanyName"]);
cus.ContactName = MyConvert.ToString(reader["ContactName"]);
cus.Address = MyConvert.ToString(reader["Address"]);
cus.PostalCode = MyConvert.ToString(reader["PostalCode"]);
cus.Country = MyConvert.ToString(reader["Country"]);
cus.Phone = MyConvert.ToString(reader["Phone"]);
cus.Fax = MyConvert.ToString(reader["Fax"]);
return(cus);
}
public static Employee GetDataEmployeeToExcel(OleDbDataReader reader)
{
Employee emp = new Employee();
emp.EmployeeID = MyConvert.ToInt32(reader["EmployeeID"].ToString());
emp.EmployeeName = MyConvert.ToString(reader["Name"].ToString());
emp.HireDate = MyConvert.ToDateTime(reader["HireDate"].ToString());
emp.BirthDate = MyConvert.ToDateTime(reader["BirthDate"].ToString());
emp.Address = MyConvert.ToString(reader["Address"].ToString());
emp.PostalCode = MyConvert.ToString(reader["PostalCode"].ToString());
emp.Country = MyConvert.ToString(reader["Country"].ToString());
emp.HomePhone = MyConvert.ToString(reader["HomePhone"].ToString());
return(emp);
}
public static Order GetDataOrderToExcel(OleDbDataReader reader)
{
Order od = new Order();
od.OrderID = MyConvert.ToInt32(reader["OrderID"]);
od.CustomerID = MyConvert.ToString(reader["CustomerID"]);
od.EmployeeID = MyConvert.ToInt32(reader["EmployeeID"]);
od.OrderDate = MyConvert.ToDateTime(reader["OrderDate"]);
od.RequiredDate = MyConvert.ToDateTime(reader["RequiredDate"]);
od.ShippedDate = MyConvert.ToDateTime(reader["ShippedDate"]);
od.Freight = MyConvert.ToDouble(reader["Freight"]);
od.ShipAddress = MyConvert.ToString(reader["ShipAddress"]);
od.ShipPostalCode = MyConvert.ToString(reader["ShipPostalCode"]);
od.Status = MyConvert.ToString(reader["Status"]);
return(od);
}
public static Supplier GetDataSupplierToExcel(OleDbDataReader reader)
{
Supplier sup = new Supplier();
sup.SupplierID = MyConvert.ToInt32(reader["SupplierID"]);
sup.CompanyName = MyConvert.ToString(reader["CompanyName"]);
sup.ContactName = MyConvert.ToString(reader["ContactName"]);
sup.ContactTitle = MyConvert.ToString(reader["ContactTitle"]);
sup.Address = MyConvert.ToString(reader["ContactTitle"]);
sup.City = MyConvert.ToString(reader["City"]);
sup.Country = MyConvert.ToString(reader["Country"]);
sup.Region = MyConvert.ToString(reader["Region"]);
sup.PostalCode = MyConvert.ToString(reader["Region"]);
sup.Phone = MyConvert.ToString(reader["Region"]);
sup.Fax = MyConvert.ToString(reader["Region"]);
sup.HomePage = MyConvert.ToString(reader["Region"]);
return(sup);
}
