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); }