protected void saveButton_Click(object sender, EventArgs e) { Voter voter=new Voter(); voter.VoterId = voterIdTextBox.Text; voter.VoterName = voterNameTextBox.Text; voter.VoterStatus = "Not Casted"; string msg=voterManager.SaveVoter(voter); alertMessage.InnerHtml = msg; }
public void SaveVoter(Voter voter) { string connectionString = ConfigurationManager.ConnectionStrings["VoteConnectionString"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "INSERT INTO VoterTable (VoterId,VoterName,VoterStatus) VALUES('" + voter.VoterId + "','" + voter.VoterName + "','"+voter.VoterStatus+"')"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); }
public Voter GetVoterByVoterId(string voterId) { string connectionString = ConfigurationManager.ConnectionStrings["VoteConnectionString"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "SELECT * FROM VoterTable WHERE VoterId = '"+voterId+"'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); Voter voter=null; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { voter = new Voter(); voter.VoterId = sqlDataReader["VoterId"].ToString(); voter.VoterName = sqlDataReader["VoterName"].ToString(); voter.VoterStatus = sqlDataReader["VoterStatus"].ToString(); } sqlConnection.Close(); return voter; }
public string SaveVoter(Voter voter) { if (voter.VoterName == "" || voter.VoterId == "") { return "Fiedls cannot be empty"; } else if (voter.VoterId.Count() != 13) { return "Voter Id must be 13 characters long"; } else { if (voterGateway.GetVoterByVoterId(voter.VoterId) != null) { return "Voter already exists"; } else { voterGateway.SaveVoter(voter); return "Successfully Saved"; } } }