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