public DepositReturn(int returnID, Deposit deposit, Profile profile, User user, int count, DateTime created)
{
this.returnID = returnID;
this.deposit = deposit;
this.profile = profile;
this.user = user;
this.count = count;
this.created = created;
}
// methods
public Article()
{
this.deposit = Deposit.NullDeposit;
}
private static Deposit GetDeposit(string depositname, int profileID)
{
Deposit deposit = null;
try
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM Deposit WHERE Name = '" + depositname + "' AND ProfileID = " + profileID, connection);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
deposit = new Deposit();
deposit.DepositID = Convert.ToInt32(reader["DepositID"]);
deposit.Name = reader["Name"].ToString();
deposit.Amount = Convert.ToDouble(reader["Amount"]);
deposit.IsDeleted = Convert.ToBoolean(reader["IsDeleted"]);
deposit.Created = Convert.ToDateTime(reader["Created"]);
}
connection.Close();
}
catch (Exception ex)
{
LogWriter.Write(ex, LOGFILE_NAME);
string errmsg = "Fehler beim Abrufen des Pfandes.\n\n";
errmsg += "DatabaseHandler.GetDeposit(depositname, profileID): " + ex.Message;
throw new Exception(errmsg);
}
return deposit;
}
private static List<Deposit> GetDeposites()
{
List<Deposit> deposites = new List<Deposit>();
deposites.Add(Deposit.NullDeposit);
try
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM Deposit", connection);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Deposit deposit = new Deposit();
deposit = new Deposit();
deposit.DepositID = Convert.ToInt32(reader["DepositID"]);
deposit.Name = reader["Name"].ToString();
deposit.Amount = Convert.ToDouble(reader["Amount"]);
deposit.IsDeleted = Convert.ToBoolean(reader["IsDeleted"]);
deposit.Created = Convert.ToDateTime(reader["Created"]);
deposites.Add(deposit);
}
connection.Close();
}
catch (Exception ex)
{
LogWriter.Write(ex, LOGFILE_NAME);
string errmsg = "Fehler beim Abrufen der Pfandobjekte eines Profils.\n\n";
errmsg += "DatabaseHandler.GetDeposites(profileID): " + ex.Message;
throw new Exception(errmsg);
}
return deposites;
}