public void TestEditScrum() { ScrumModel scrumModel = new ScrumModel(); scrumModel.AnswerList = new System.Collections.ArrayList(); Answers answers = new Answers(); answers.Answer = "Test Edit"; answers.QuestionId = 1; answers.UserId = 1; answers.AnswerKey = 0; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = "Test Edit"; answers.QuestionId = 2; answers.UserId = 1; answers.AnswerKey = 0; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = "None"; answers.QuestionId = 3; answers.UserId = 1; answers.AnswerKey = 0; scrumModel.AnswerList.Add(answers); Assert.IsTrue(new ScrumController().EditScrum(scrumModel)); }
protected void submit_Click(object sender, EventArgs e) { ScrumModel scrumModel = new ScrumModel(); scrumModel.AnswerList = new System.Collections.ArrayList(); Answers answer = new Answers(); answer.QuestionId = 1; answer.AnswerKey = Convert.ToInt32(Request["AnswerKey"]); answer.Answer = txtBoxAnswer1.Text; scrumModel.AnswerList.Add(answer); answer = new Answers(); answer.QuestionId = 2; answer.AnswerKey = Convert.ToInt32(Request["AnswerKey"]); answer.Answer = txtBoxAnswer2.Text; scrumModel.AnswerList.Add(answer); answer = new Answers(); answer.QuestionId = 3; answer.AnswerKey = Convert.ToInt32(Request["AnswerKey"]); answer.Answer = txtBoxAnswer3.Text; scrumModel.AnswerList.Add(answer); new Controllers.ScrumController().EditScrum(scrumModel); Response.Redirect("~/Scrum/ViewScrumData.aspx"); }
protected void submit_Click(object sender, EventArgs e) { User user = (User)Session["User"]; ScrumModel scrumModel = new ScrumModel(); scrumModel.AnswerList = new System.Collections.ArrayList(); Answers answers = new Answers(); answers.Answer = answer1.Text; answers.QuestionId = Convert.ToInt32(answer1.ID); answers.UserId = user.UserId; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = answer2.Text; answers.QuestionId = Convert.ToInt32(answer2.ID); answers.UserId = user.UserId; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = answer3.Text; answers.QuestionId = Convert.ToInt32(answer3.ID); answers.UserId = user.UserId; scrumModel.AnswerList.Add(answers); bool dataInserted = new ScrumController().InputNewScrum(scrumModel); if (dataInserted) { Session.Add("Message", "The scrum data was successfully entered."); Response.Redirect("~/Scrum/ViewScrumData.aspx"); } else { Message.Text = "There was an error inserting the scrum data."; } }
public ScrumModel GetScrumQuestions() { ScrumModel scrumModel = new ScrumModel(); using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM ScrumQuestions WHERE Active=" + 1, sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { scrumModel.QuestionList = new System.Collections.ArrayList(); while (sqlDataReader.Read()) { Questions question = new Questions(); question.QuestionId = Convert.ToInt32(sqlDataReader["ScrumQuestionId"]); question.Question = Convert.ToString(sqlDataReader["ScrumQuestion"]); scrumModel.QuestionList.Add(question); } } sqlDataReader.Close(); } } sqlConnection.Close(); } return scrumModel; }
public ScrumModel GetScrumDetails(int AnswerKey) { ScrumModel scrumModel = new ScrumModel(); using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM ScrumAnswers WHERE AnswerKey=" + AnswerKey, sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { scrumModel.AnswerList = new System.Collections.ArrayList(); while (sqlDataReader.Read()) { Answers answers = new Answers(); answers.QuestionId = Convert.ToInt32(sqlDataReader["QuestionId"]); answers.Answer = Convert.ToString(sqlDataReader["Answer"]); scrumModel.AnswerList.Add(answers); } } sqlDataReader.Close(); } } sqlConnection.Close(); } return scrumModel; }
public bool EditScrum(ScrumModel scrumModel) { try { using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); foreach (Answers answer in scrumModel.AnswerList) { using (SqlCommand sqlCommand = new SqlCommand("Update ScrumAnswers SET Answer = @Answer, DateModified = @DateModified WHERE QuestionId = @QuestionId AND AnswerKey = @AnswerKey", sqlConnection)) { sqlCommand.Parameters.Add(new SqlParameter("Answer", answer.Answer)); sqlCommand.Parameters.Add(new SqlParameter("DateModified", DateTime.Now)); sqlCommand.Parameters.Add(new SqlParameter("QuestionId", answer.QuestionId)); sqlCommand.Parameters.Add(new SqlParameter("AnswerKey", answer.AnswerKey)); sqlCommand.ExecuteNonQuery(); } } sqlConnection.Close(); } return true; } catch { return false; } }
public bool InputNewScrum(ScrumModel scrum) { return new ScrumDAL().InputNewScrum(scrum); }
public bool EditScrum(ScrumModel scrum) { return new ScrumDAL().EditScrum(scrum); }
public void TestInputNewScrum() { ScrumModel scrumModel = new ScrumModel(); scrumModel.AnswerList = new System.Collections.ArrayList(); Answers answers = new Answers(); answers.Answer = "Worked on Unit Test Cases"; answers.QuestionId = 1; answers.UserId = 1; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = "Worked on Scrum Room"; answers.QuestionId = 2; answers.UserId = 1; scrumModel.AnswerList.Add(answers); answers = new Answers(); answers.Answer = "None"; answers.QuestionId = 3; answers.UserId = 1; scrumModel.AnswerList.Add(answers); Assert.IsTrue(new ScrumController().InputNewScrum(scrumModel)); }
public ScrumModel ViewScrumDataByDate(string date, string nextDay) { ScrumModel scrumModel = new ScrumModel(); using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); string sqlString = "SELECT Users.FirstName, Users.LastName, dbo.ScrumQuestions.ScrumQuestion, ScrumAnswers. * " + "FROM ScrumAnswers " + "INNER JOIN dbo.ScrumQuestions ON dbo.ScrumQuestions.ScrumQuestionId = dbo.ScrumAnswers.QuestionId " + "INNER JOIN dbo.Users ON dbo.Users.UserID = dbo.ScrumAnswers.UserId WHERE " + "ScrumAnswers.DateEntered >= '" + date + "' " + "AND ScrumAnswers.DateEntered < '" + nextDay + "' " + "ORDER BY ScrumAnswers.DateEntered, Users.LastName, ScrumAnswers.QuestionId"; using (SqlCommand sqlCommand = new SqlCommand(sqlString, sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { scrumModel.ScrumList = new System.Collections.ArrayList(); while (sqlDataReader.Read()) { ScrumData scrumData = new ScrumData(); scrumData.FirstName = Convert.ToString(sqlDataReader["FirstName"]); scrumData.LastName = Convert.ToString(sqlDataReader["LastName"]); scrumData.Question = Convert.ToString(sqlDataReader["ScrumQuestion"]); scrumData.AnswerId = Convert.ToInt32(sqlDataReader["AnswerId"]); scrumData.AnswerKey = Convert.ToInt32(sqlDataReader["AnswerKey"]); scrumData.Answer = Convert.ToString(sqlDataReader["Answer"]); scrumData.QuestionId = Convert.ToInt32(sqlDataReader["QuestionId"]); scrumData.UserId = Convert.ToInt32(sqlDataReader["UserId"]); scrumData.DateEntered = Convert.ToDateTime(sqlDataReader["DateEntered"]); scrumData.DateModified = Convert.ToDateTime(sqlDataReader["DateModified"]); scrumModel.ScrumList.Add(scrumData); } } sqlDataReader.Close(); } } sqlConnection.Close(); } return scrumModel; }
public bool InputNewScrum(ScrumModel scrumModel) { try { using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); int sequence = 0; using (SqlCommand sqlCommand = new SqlCommand("SELECT MAX(AnswerKey) As Sequence FROM ScrumAnswers", sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { if (sqlDataReader.Read()) { if (sqlDataReader["Sequence"] != DBNull.Value) { sequence = Convert.ToInt32(sqlDataReader["Sequence"]); sequence += 1; } } } sqlDataReader.Close(); } } foreach (Answers answer in scrumModel.AnswerList) { using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO ScrumAnswers VALUES (@Answer, @AnswerKey, @QuestionId, @UserId, @DateEntered, @DateModified)", sqlConnection)) { sqlCommand.Parameters.Add(new SqlParameter("Answer", answer.Answer)); sqlCommand.Parameters.Add(new SqlParameter("AnswerKey", sequence)); sqlCommand.Parameters.Add(new SqlParameter("QuestionId", answer.QuestionId)); sqlCommand.Parameters.Add(new SqlParameter("UserId", answer.UserId)); sqlCommand.Parameters.Add(new SqlParameter("DateEntered", DateTime.Now)); sqlCommand.Parameters.Add(new SqlParameter("DateModified", DateTime.Now)); sqlCommand.ExecuteNonQuery(); } } sqlConnection.Close(); } return true; } catch (Exception ex) { return false; } }