public AccountModel()
{
mSqlConnection = new ConnectionModel();
for (int i = 1; i <= 31; i++)
{
daysListItems.Add(new SelectListItem {Text = "" + i, Value = "" + i});
}
for (int i = 1930; i <= 2005; i++)
{
yearsListItems.Add(new SelectListItem {Text = "" + i, Value = "" + i});
}
}
public string GetFromDb(string key, string value, string column, string dbName)
{
string returnString="";
ConnectionModel connectionModel = new ConnectionModel();
MySqlConnection connection = connectionModel.makeConnection();
MySqlCommand cmd;
try
{
connection.Open();
}
catch (MySqlException e)
{
throw e;
}
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM "+dbName+" WHERE "+key+" LIKE @"+key;
cmd.Parameters.AddWithValue(key, value);
cmd.BeginExecuteNonQuery();
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
DataRow[] dr = ds.Tables[0].Select();
if (dr.Length > 0) returnString = dr[0][column].ToString();
else returnString = "empty";
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
connection.Close();
}
if (returnString != "") return returnString;
else if (returnString == "empty") return "empty";
else return "error";
}