public static List<Employee> getCustomers()
{
List<Employee> EmployList = new List<Employee>();
sqlCon = new SqlConnection(connectionString);
sqlCon.Open();
SqlDataAdapter da;
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand(PROC_EMP_TABLE, sqlCon);
cmd.CommandType = CommandType.StoredProcedure;
da = new SqlDataAdapter(cmd);
da.FillSchema(dt, SchemaType.Source);
da.Fill(dt);
sqlCon.Close();
// Modify
foreach (DataRow row in dt.Rows)
{
// Start: These will always have a value and will never equal a null.
int EmployeeID = (int)row["EmployeeID"];
// End.
string FirstName;
string LastName;
string Title;
string TitleOfCourtesy;
DateTime? BirthDate;
DateTime? HireDate;
string Address;
string City;
string Region;
string PostalCode;
string Country;
string HomePhone;
string Extension;
if (row["FirstName"] == DBNull.Value)
FirstName = null;
else
FirstName = (string)row["FirstName"];
if (row["LastName"] == DBNull.Value)
LastName = null;
else
LastName = (string)row["LastName"];
if (row["Title"] == DBNull.Value)
Title = null;
else
Title = (string)row["Title"];
if (row["TitleOfCourtesy"] == DBNull.Value)
TitleOfCourtesy = null;
else
TitleOfCourtesy = (string)row["TitleOfCourtesy"];
if (row["BirthDate"] == DBNull.Value)
BirthDate = null;
else
BirthDate = (DateTime)row["BirthDate"];
if (row["HireDate"] == DBNull.Value)
HireDate = null;
else
HireDate = (DateTime)row["HireDate"];
if (row["Address"] == DBNull.Value)
Address = null;
else
Address = (string)row["Address"];
if (row["City"] == DBNull.Value)
City = null;
else
City = (string)row["City"];
if (row["Region"] == DBNull.Value)
Region = null;
else
Region = (string)row["Region"];
if (row["PostalCode"] == DBNull.Value)
PostalCode = null;
else
PostalCode = (string)row["PostalCode"];
if (row["Country"] == DBNull.Value)
Country = null;
else
Country = (string)row["Country"];
if (row["HomePhone"] == DBNull.Value)
HomePhone = null;
else
HomePhone = (string)row["HomePhone"];
if (row["Extension"] == DBNull.Value)
Extension = null;
else
Extension = (string)row["Extension"];
Employee E = new Employee(EmployeeID);
E.FirstName = FirstName;
E.LastName = LastName;
E.Title = Title;
E.TitleOfCourtesy = TitleOfCourtesy;
E.BirthDate = BirthDate;
E.HireDate = HireDate;
E.PostalCode = PostalCode;
E.Address = Address;
E.City = City;
E.Region = Region;
E.PostalCode = PostalCode;
E.Country = Country;
E.HomePhone = HomePhone;
E.Extension = Extension;
EmployList.Add(E);
}
return EmployList;
}
