private void filler()
{
EmailClass emailClass = new EmailClass();
emailClass.ID = 0;
emailClass.Name = "Yeni";
emailClass.Email = "";
emailClass.ToEnd = 0;
emailClass.ToYol = 0;
this.cbValues.Items.Clear();
this.cbValues.Items.Add((object)emailClass);
this.cbValues.Items.AddRange((object[])EmailClass.Emails_GetAll());
}
public static EmailClass[] Emails_GetAll()
{
string query = "Emails_GetAll";
DataTable dt = Connection.runQuery(query, new SqlParameter[0]);
List<EmailClass> res = new List<EmailClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
EmailClass tmp = new EmailClass();
tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
tmp.Name = dt.Rows[i]["Name"].ToString();
tmp.Email = dt.Rows[i]["Email"].ToString();
tmp.ToEnd = Convert.ToInt32(dt.Rows[i]["ToEnd"].ToString());
tmp.ToYol = Convert.ToInt32(dt.Rows[i]["ToYol"].ToString());
res.Add(tmp);
}
return res.ToArray();
}