public string SaveCandidate(Candidate candidate) { if (candidate.CandidateName == "" || candidate.CandidateSymbol == "") { return "Fiedls cannot be empty"; } else if(candidateGateway.GetCandidateByCandidateSymbol(candidate.CandidateSymbol)!=null) { return "Candidate already exists"; } else { candidateGateway.SaveCandidate(candidate); return "Successfully Saved"; } }
public List<Candidate> GetAllCandidateOrderByVotes() { string connectionString = ConfigurationManager.ConnectionStrings["VoteConnectionString"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "SELECT * FROM CandidateTable ORDER BY NoOfVote DESC"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); List<Candidate> candidateList = new List<Candidate>(); while (sqlDataReader.Read()) { Candidate candidate = new Candidate(); candidate.CandidateName = sqlDataReader["CandidateName"].ToString(); candidate.CandidateSymbol = sqlDataReader["CandidateSymbol"].ToString(); candidate.NoOfVote = int.Parse(sqlDataReader["NoOfVote"].ToString()); candidateList.Add(candidate); } sqlConnection.Close(); return candidateList; }
public void SaveCandidate(Candidate candidate) { string connectionString = ConfigurationManager.ConnectionStrings["VoteConnectionString"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "INSERT INTO CandidateTable (CandidateName,CandidateSymbol,NoOfVote) VALUES('" + candidate.CandidateName + "','" + candidate.CandidateSymbol + "','"+candidate.NoOfVote+"')"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }
public Candidate GetCandidateByCandidateSymbol(string candidateSymbol) { string connectionString = ConfigurationManager.ConnectionStrings["VoteConnectionString"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "SELECT * FROM CandidateTable WHERE CandidateSymbol = '" + candidateSymbol + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); Candidate candidate = null; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { candidate = new Candidate(); candidate.CandidateName = sqlDataReader["CandidateName"].ToString(); candidate.CandidateSymbol = sqlDataReader["CandidateSymbol"].ToString(); candidate.NoOfVote = int.Parse(sqlDataReader["NoOfVote"].ToString()); } sqlConnection.Close(); return candidate; }