public ChartResult(Chart chart, User creator)
{
this.User = chart.Users;
this.Profile = chart.Profile;
this.Creator = creator;
this.CreationBegin = DateTime.Now;
this.Sales = DatabaseHandler.GetPurchaseCart(Profile, User);
this.Cancellations = DatabaseHandler.GetCanceledArticles(Profile, User);
List<DepositReturn> returns = new List<DepositReturn>();
foreach (User u in User)
{
var userDepRet = DatabaseHandler.GetUserDepositReturnsDetailed(u, Profile);
returns.AddRange(userDepRet);
}
DepositReturns = new ObservableCollection<DepositReturn>((from r in returns orderby r.Created select r).ToList());
this.CreationEnd = DateTime.Now;
}
public static void RemoveChart(Chart chart)
{
string query = "DELETE Chart WHERE ChartID = " + chart.ChartID;
try
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(query, connection);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
string errmsg = "Fehler beim Löschen der Auswertung.\n\n";
errmsg += "DatabaseHandler.RemoveChart(chart): " + ex.ToString();
throw new Exception(errmsg);
}
}