public ActionResult Update(FitnessDataViewModel fitnessModel)
{
FitnessInfoDal dal = new FitnessInfoDal();
dal.AddFitnessData(fitnessModel, User.Identity.GetUserId());
ViewBag.Success = true;
ViewBag.ArrayData = GetFitnessData();
return(View());
}
public void AddFitnessData(FitnessDataViewModel fitnessData, string userId)
{
string sqltext = string.Format("Insert into User_FitnessDetails (User_ID, Height,Weight,WeightDate,DailySteps,DailyStepsDate) " +
"values('{0}',{1},{2},'{3}',{4},'{5}') ",
userId, fitnessData.Height, fitnessData.Weight, fitnessData.WeightDate.ToString("yyyy-MM-dd"),
fitnessData.DailySteps, fitnessData.DailyStepsDate.ToString("yyyy-MM-dd"));
using (
var connection =
new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)
)
{
using (
var command = new SqlCommand(sqltext, connection)
)
{
connection.Open();
command.ExecuteNonQuery();
}
}
}
