public recommendedTrainingProgram PostTPC(recommendedTrainingProgram tPC)
{
customer Cust = new customer();
Cust.Id = tPC.CustomerId;
return(Cust.postTrainingP(tPC, Cust.Id));
}
public List <video> postTPC(recommendedTrainingProgram tPC, int id)
{
SqlConnection con = null;
List <video> videoList = new List <video>();
try
{
con = connect("DBConnectionString");
using (SqlCommand cmd = new SqlCommand("PostTP", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", tPC.CustomerId);
cmd.Parameters.AddWithValue("@TPC", tPC.Tcode);
var returnParameter = cmd.Parameters.Add("@results", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
//var result = returnParameter.Value;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
video v = new video();
v.VideoId = Convert.ToInt32(dr["VideoCode"]);
v.Description = (string)dr["description"];
v.Caption = (string)dr["caption"];
v.Subtitlepath = (string)dr["subtitlepath"];
videoList.Add(v);
}
}
}
return(videoList);
}
catch (Exception ex)
{
// write to log
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public List <recommendedTrainingProgram> getRTP(int id)
{
SqlConnection con = null;
List <recommendedTrainingProgram> recommendedTrainingProgramList = new List <recommendedTrainingProgram>();
try
{
con = connect("DBConnectionString");
using (SqlCommand cmd = new SqlCommand("matchTraningProgramForUser", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userId", id);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
recommendedTrainingProgram rt = new recommendedTrainingProgram();
rt.Tcode = Convert.ToInt32(dr["Tcode"]);
rt.Tname = (string)dr["Tname"];
rt.Instuction = (string)dr["instructions"];
rt.LevelType = (string)dr["levelType"];
rt.IsForStrengthening = (bool)dr["isForStrengthening"];
rt.IsForRehabilitation = (bool)dr["isForRehabilitation"];
rt.IsForImproveSport = (bool)dr["isForImproveSport"];
rt.Pic = (string)dr["pic"];
recommendedTrainingProgramList.Add(rt);
}
//customerRTP.RecommendedTrainingPrograms = recommendedTrainingProgramList;
}
}
return(recommendedTrainingProgramList);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
