public IEnumerable <VoterInfoComelec> IterateAll2()
{
MySqlCommand cmd = new MySqlCommand(_queryAll, _dbClientRead);
cmd.CommandTimeout = int.MaxValue;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
VoterInfoComelec voterInfo = new VoterInfoComelec();
try
{
voterInfo.Lastname = Decrypt(dataReader[0].ToString());
voterInfo.Firstname = Decrypt(dataReader[1].ToString());
}
catch (Exception)
{
Console.WriteLine("Unable to read/decrypt entry!");
continue;
}
try
{
voterInfo.Maternalname = Decrypt(dataReader[2].ToString());
voterInfo.Sex = dataReader[3].ToString();
voterInfo.CivilStatus = dataReader[4].ToString();
voterInfo.Address = dataReader[5].ToString();
}
catch (Exception)
{
Console.WriteLine("Unable to set other info for {0}, {1} - {2}", voterInfo.Lastname, voterInfo.Firstname, voterInfo.Maternalname);
}
try
{
string bdayYear = Decrypt(dataReader[6].ToString());
string bdayMonth = Decrypt(dataReader[7].ToString());
string bdayDay = Decrypt(dataReader[8].ToString());
voterInfo.DateOfBirth = new DateTime(
Convert.ToInt32(bdayYear),
Convert.ToInt32(bdayMonth),
Convert.ToInt32(bdayDay)
);
}
catch (Exception ex)
{
Console.WriteLine("Unable to set birthday for {0}, {1} - {2}", voterInfo.Lastname, voterInfo.Firstname, voterInfo.Maternalname);
}
yield return(voterInfo);
}
dataReader.Close();
}
public List <VoterInfoComelec> SearchData(string inFirstName, string inMaternalName, string inLastName)
{
List <VoterInfoComelec> retList = new List <VoterInfoComelec>();
string qryFirstName = string.IsNullOrEmpty(inFirstName) ? "FIRSTNAME" : string.Format("'{0}'", Encrypt(inFirstName.ToUpper()));
string qryMaternalName = string.IsNullOrEmpty(inMaternalName) ? "MATERNALNAME" : string.Format("'{0}'", Encrypt(inMaternalName.ToUpper()));
string qryLastName = string.IsNullOrEmpty(inLastName) ? "LASTNAME" : string.Format("'{0}'", Encrypt(inLastName.ToUpper()));
string querySearch = string.Format(_querySearch, qryFirstName, qryMaternalName, qryLastName);
MySqlCommand cmd = new MySqlCommand(querySearch, _dbClientRead);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
VoterInfoComelec voterInfo = new VoterInfoComelec();
voterInfo.Lastname = Decrypt(dataReader[0].ToString());
voterInfo.Firstname = Decrypt(dataReader[1].ToString());
voterInfo.Maternalname = Decrypt(dataReader[2].ToString());
voterInfo.Sex = dataReader[3].ToString();
voterInfo.CivilStatus = dataReader[4].ToString();
voterInfo.Address = dataReader[5].ToString();
string bdayYear = Decrypt(dataReader[6].ToString());
string bdayMonth = Decrypt(dataReader[7].ToString());
string bdayDay = Decrypt(dataReader[8].ToString());
voterInfo.DateOfBirth = new DateTime(
Convert.ToInt32(bdayYear),
Convert.ToInt32(bdayMonth),
Convert.ToInt32(bdayDay)
);
retList.Add(voterInfo);
}
return(retList);
}
public IEnumerable <VoterInfoComelec> SearchDataIterator(string inFirstName, string inMaternalName, string inLastName)
{
string qryFirstName = string.IsNullOrEmpty(inFirstName) ? "FIRSTNAME" : string.Format("'{0}'", Encrypt(inFirstName.ToUpper()));
string qryMaternalName = string.IsNullOrEmpty(inMaternalName) ? "MATERNALNAME" : string.Format("'{0}'", Encrypt(inMaternalName.ToUpper()));
string qryLastName = string.IsNullOrEmpty(inLastName) ? "LASTNAME" : string.Format("'{0}'", Encrypt(inLastName.ToUpper()));
string querySearch = string.Format(_querySearch, qryFirstName, qryMaternalName, qryLastName);
MySqlCommand cmd = new MySqlCommand(querySearch, _dbClientRead);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
VoterInfoComelec voterInfo = new VoterInfoComelec();
voterInfo.Lastname = Decrypt(dataReader[0].ToString());
voterInfo.Firstname = Decrypt(dataReader[1].ToString());
voterInfo.Maternalname = Decrypt(dataReader[2].ToString());
voterInfo.Sex = dataReader[3].ToString();
voterInfo.CivilStatus = dataReader[4].ToString();
voterInfo.Address = dataReader[5].ToString();
string bdayYear = Decrypt(dataReader[6].ToString());
string bdayMonth = Decrypt(dataReader[7].ToString());
string bdayDay = Decrypt(dataReader[8].ToString());
voterInfo.DateOfBirth = new DateTime(
Convert.ToInt32(bdayYear),
Convert.ToInt32(bdayMonth),
Convert.ToInt32(bdayDay)
);
yield return(voterInfo);
}
dataReader.Close();
Console.WriteLine("Closed Connection");
}
