public string Save(Candidate aCandidate)
{
connection.Open();
string query = string.Format("INSERT INTO t_Candidate VALUES('{0}','{1}')", aCandidate.Name,
aCandidate.Symbol);
SqlCommand command = new SqlCommand(query, connection);
int affectedRow = command.ExecuteNonQuery();
if (affectedRow>0)
{
return @"Candidate has been saved sucessfully";
}
return @"Candidate save failed";
}
private void SaveButton_Click(object sender, EventArgs e)
{
Candidate aCandidate=new Candidate(nameTextBox.Text,symbolTextBox.Text);
string msg = aCandidateBll.Save(aCandidate);
MessageBox.Show(msg);
}
private void GetAllSymbolInComboBox()
{
Candidate aCandidate = new Candidate();
List<Candidate> candidates = aCandidateBll.GetAllCandidate(aCandidate);
}
public string Save(Candidate aCandidate)
{
return aCandidateGateway.Save(aCandidate);
}
public List<Candidate> GetAllCandidate(Candidate aCandidate)
{
return aCandidateGateway.GetAllCandidate(aCandidate);
}
public List<Candidate> GetAllCandidate(Candidate aCandidate)
{
connection.Open();
}