//update the video/exam status
public int UpdateUserTalksStatus(UpdateUserTalkModel model)
{
int res = 0;
try
{
using (TransactionScope trScope = new TransactionScope())
{
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
con.Open();
SqlCommand command = new SqlCommand("Update_UserTalk_Status", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserTalkId", model.UserTalkId);
command.Parameters.AddWithValue("@IsVideoStatus", model.IsVideoStatus);
command.Parameters.AddWithValue("@IsExamlear", model.IsExamlear);
res = Convert.ToInt32(command.ExecuteScalar());
}
trScope.Complete();
}
}
catch
{
throw;
}
return(res);
}
public int UpdateUserTalksStatus(UpdateUserTalkModel model)
{
int result = 0;
try
{
result = _businessLayer.UpdateUserTalksStatus(model);
}
catch (Exception ex)
{
throw;
}
return(result);
}
