//update usertalk video comment //UpdateUserTalkCommentModel public int UpdateUserTalkComment(UpdateUserTalkCommentModel 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_Commet", con); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@UserTalkId", model.UserTalkId); command.Parameters.AddWithValue("@Comment", model.Comment); res = Convert.ToInt32(command.ExecuteScalar()); } trScope.Complete(); } } catch { throw; } return(res); }
public int UpdateUserTalksStatus(UpdateUserTalkCommentModel model) { int result = 0; try { result = _businessLayer.UpdateUserTalkComment(model); } catch (Exception ex) { throw; } return(result); }