public static WebService.WebServiceAccountCollection GetWebServiceAccounts()
{
WebService.WebServiceAccountCollection result = new WebService.WebServiceAccountCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * from tblWebServiceAccount;";
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
WebService.WebServiceAccount webServiceAccount = new WebService.WebServiceAccount();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlServerDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(webServiceAccount, dr);
sqlServerDataReaderPropertyWriter.WriteProperties();
result.Add(webServiceAccount);
}
}
}
return(result);
}
public override object BuildNew()
{
YellowstonePathology.Business.WebService.WebServiceAccount webServiceAccount = new WebService.WebServiceAccount();
this.BuildWebServiceAccount(webServiceAccount);
return(webServiceAccount);
}