public static DietE getDietByID(int id)
{
DietE temp = null;
SqlCommand com = new SqlCommand("getDietByID", 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 DietE
{
//TODO: DATES
DietID = Convert.ToInt32(rd["RequestID"]),
DietContent = rd["DietContent"].ToString(),
DietitianID = Convert.ToInt32(rd["DietitianID"]),
DietRequestID = Convert.ToInt32(rd["DietRequestID"]),
UserID = Convert.ToInt32(rd["UserID"]),
};
}
}
com.Dispose();
com.Connection.Close();
return(temp);
}
public static int InsertDiet(DietE diet)
{
int dietID = 0;
SqlCommand com = new SqlCommand("InsertDiet", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@dietitianID", diet.DietitianID));
com.Parameters.Add(new SqlParameter("@userID", diet.UserID));
if (diet.DietRequestID != 0)
{
com.Parameters.Add(new SqlParameter("@dietRequestID", diet.DietRequestID));
}
else
{
com.Parameters.Add(new SqlParameter("@dietRequestID", DBNull.Value));
}
if (diet.DietContent != null)
{
com.Parameters.Add(new SqlParameter("@dietContent", diet.DietContent));
}
else
{
com.Parameters.Add(new SqlParameter("@dietContent", DBNull.Value));
}
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
if (rd.HasRows)
{
rd.Read();
dietID = Convert.ToInt32(rd[0]);
}
com.Dispose();
com.Connection.Close();
return(dietID);
}
protected void sendDiet_Click(object sender, EventArgs e)
{
DietE diet = new DietE();
diet.DietitianID = currentDietView.DietitianID;
diet.DietID = currentDietView.DietID;
diet.DietRequestID = currentDietView.RequestID;
diet.UserID = currentDietView.UserID;
diet.DietContent = dietContent_textbox.Text;
BusinessLayers.Business.updateDiet(diet);
Logging.logDietFollowUp(diet.DietitianID.ToString(), diet.UserID.ToString());
PaymentE pay = new PaymentE();
pay.DietitianID = currentDietView.DietitianID;
pay.UserID = currentDietView.UserID;
pay.Fee = "30";
BusinessLayers.Business.insertPayment(pay);
}
protected void saveRequest_Click(object sender, EventArgs e)
{
DietRequestE dietRequest = new DietRequestE();
dietRequest.RequestContent = content_textbox.Text;
dietRequest.Health = false;
dietRequest.Fitness = false;
dietRequest.WeightGain = false;
dietRequest.WeightLoss = false;
switch (ddlGender.Text)
{
case "1":
dietRequest.Health = true;
break;
case "2":
dietRequest.Fitness = true;
break;
case "3":
dietRequest.WeightGain = true;
break;
case "4":
dietRequest.WeightLoss = true;
break;
}
int requestID = BusinessLayers.Business.insertDietRequest(dietRequest);
DietE diet = new DietE();
diet.DietitianID = Convert.ToInt32(Session["selectedDietitianID"]);
diet.DietRequestID = requestID;
diet.UserID = (Session["user"] as Entity.UserE).UserID;
int dietID = BusinessLayers.Business.insertDiet(diet);
Logging.logDiet(diet.UserID.ToString(), dietID.ToString());
Session["dietID"] = dietID;
Response.Redirect("~/User/MedicalReport");
}
public static void UpdateDiet(DietE obj)
{
SqlCommand com = new SqlCommand("UpdateDiet", Connection.Con); // Prodecure
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@dietContent", obj.DietContent));
com.Parameters.Add(new SqlParameter("@dietitianID", obj.DietitianID));
com.Parameters.Add(new SqlParameter("@dietRequestID", obj.DietRequestID));
com.Parameters.Add(new SqlParameter("@userID", obj.UserID));
com.Parameters.Add(new SqlParameter("@id", obj.DietID));
if (com.Connection.State == ConnectionState.Closed)
{
com.Connection.Open();
}
SqlDataReader rd = com.ExecuteReader();
com.Dispose();
com.Connection.Close();
}
public static void updateDiet(DietE obj)
{
DietC.UpdateDiet(obj);
}
public static int insertDiet(DietE obj)
{
return(DietC.InsertDiet(obj));
}
