//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); }