public bool UpdateQuestion(Questions question) { SqlConnection sqlConnection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HangWeb;Data Source=DESKTOP-MLI7UBI"); string cmdString = "UPDATE msQuestion SET Status=" + question.Status + ",AnsweredBy=" + question.AnsweredBy + " WHERE IDQuestion=" + question.IDQuestion; SqlCommand sqlCommand = new SqlCommand(); SqlDataReader QuestionDR; sqlCommand.Connection = sqlConnection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = cmdString; sqlConnection.Open(); try { QuestionDR = sqlCommand.ExecuteReader(); QuestionDR.Close(); sqlCommand.Dispose(); sqlConnection.Close(); return(true); } catch (Exception ex) { return(false); } }
public bool UpdateUser(int IDUser, int point) { SqlConnection sqlConnection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HangWeb;Data Source=DESKTOP-MLI7UBI"); string cmdString = "UPDATE msUser SET Point=" + point + " WHERE IDUser=" + IDUser; SqlCommand sqlCommand = new SqlCommand(); SqlDataReader QuestionDR; sqlCommand.Connection = sqlConnection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = cmdString; sqlConnection.Open(); try { QuestionDR = sqlCommand.ExecuteReader(); QuestionDR.Close(); sqlCommand.Dispose(); sqlConnection.Close(); return(true); } catch (Exception ex) { return(false); } }
public Questions getQuestionByIDQuestion(int IDQuestion) { SqlConnection sqlConnection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HangWeb;Data Source=DESKTOP-MLI7UBI"); Questions question = new Questions(); string cmdString = "SELECT Name,Question,Answer,Difficulty FROM msQuestion a JOIN msUser b ON a.QuestionBy = b.IDUser WHERE IDQuestion=" + IDQuestion; SqlCommand sqlCommand = new SqlCommand(); SqlDataReader QuestionDR; sqlCommand.Connection = sqlConnection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = cmdString; sqlConnection.Open(); QuestionDR = sqlCommand.ExecuteReader(); if (QuestionDR.HasRows) { while (QuestionDR.Read()) { question.NameQuestionBy = (string)QuestionDR["Name"]; question.Question = (string)QuestionDR["Question"]; question.Answer = (string)QuestionDR["Answer"]; question.Difficulty = (int)QuestionDR["Difficulty"]; } } QuestionDR.Close(); sqlCommand.Dispose(); sqlConnection.Close(); return(question); }