public dsUser fillAccountDetails()
{
//create dataset
dsUser dsUserDetails;
try
{
//pass lastname text to findcustomer method and return results to dataset
dsUserDetails = myDataLayer.UserDetails(HttpContext.Current.Session["username"].ToString());
if (dsUserDetails.tblUsers.Rows.Count > 0)
{
foreach (DataRow row in dsUserDetails.tblUsers.Rows)
{
if (DBNull.Value.Equals(row["City"]))
{
row["City"] = "";
}
if (DBNull.Value.Equals(row["State"]))
{
row["State"] = "";
}
if (DBNull.Value.Equals(row["Favorite_Language"]))
{
row["Favorite_Language"] = "";
}
if (DBNull.Value.Equals(row["Least_Favorite_Language"]))
{
row["Least_Favorite_Language"] = "";
}
if (DBNull.Value.Equals(row["Last_Program_Date"]))
{
row["Last_Program_Date"] = DateTime.MinValue;
}
}
return(dsUserDetails);
}
else
{
//Set feedback text to no records found
HttpContext.Current.Response.Redirect("Account Details Confirmation.aspx");
return(null);
}
}
catch (Exception error)
{
//feedback text displays catch error
string message = "Something went wrong - ";
HttpContext.Current.Session["feedback"] = message + error.Message;
return(null);
}
}
