public static DietViewE getDietViewByDietID(int id)
{
DietViewE temp = null;
SqlCommand com = new SqlCommand("getDietViewByDietID", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@id", id));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
if (rd.Read())
{
temp = new DietViewE
{
RequestID = Convert.ToInt32(rd["RequestID"]),
DietContent = rd["DietContent"].ToString(),
DietitianID = Convert.ToInt32(rd["DietitianID"]),
RequestContent = rd["RequestContent"].ToString(),
Health = Convert.ToBoolean(rd["Health"]),
Fitness = Convert.ToBoolean(rd["Fitness"]),
WeightLoss = Convert.ToBoolean(rd["WeightLoss"]),
WeightGain = Convert.ToBoolean(rd["WeightGain"]),
UserID = Convert.ToInt32(rd["UserID"]),
DietID = Convert.ToInt32(rd["DietID"]),
ReportID = Convert.ToInt32(rd["ReportID"]),
BloodTest = rd["BloodTest"] == DBNull.Value ? "" : rd["BloodTest"].ToString(),
Disease = rd["Disease"] == DBNull.Value ? "" : rd["Disease"].ToString(),
Height = rd["Height"] == DBNull.Value ? "" : rd["Height"].ToString(),
UrineTest = rd["UrineTest"] == DBNull.Value ? "" : rd["UrineTest"].ToString(),
UsedDrugs = rd["UsedDrugs"] == DBNull.Value ? "" : rd["UsedDrugs"].ToString(),
Weight = rd["Weight"] == DBNull.Value ? "" : rd["Weight"].ToString(),
UserName = rd["UserName"].ToString(),
UserSurname = rd["UserSurname"].ToString(),
UserEmail = rd["UserEmail"].ToString(),
UserBodyPhoto = rd["BodyPhoto"] == DBNull.Value ? "" : rd["BodyPhoto"].ToString(),
UserBirth = DateTime.Parse(rd["UserBirth"].ToString()),
Gender = rd["Gender"] == DBNull.Value ? "" : rd["Gender"].ToString()
};
}
}
com.Dispose();
com.Connection.Close();
return(temp);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["dietitian"] == null)
{
Response.Redirect("~/Logon.aspx");
}
// Get "id" from URL
string id = Page.RouteData.Values["id"] as string;
if (id != null)
{
currentDietView = BusinessLayers.Business.getDietViewByDietID(id);
}
}
public static string UserRequest(DietViewE view)
{
if (view.Health == true)
{
return("Health");
}
else if (view.Fitness == true)
{
return("Fitness");
}
else if (view.WeightGain == true)
{
return("Weight Gain");
}
else if (view.WeightLoss == true)
{
return("Weight Loss");
}
return("");
}
