public static Cart GetUserCancellationSummary(Profile profile, User user)
{
Cart c = new Cart();
try
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT [Artikel],[Anzahl] FROM [KASSE].[dbo].[vCancellationSummaryUserDetailed] WHERE Benutzer = '" + user.Username + "' AND Veranstaltung = '" + profile.Name + "' ORDER BY Summe DESC", connection);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ArticleCount ac = new ArticleCount(GetArticle(profile.ProfileID, reader["Artikel"].ToString()), Convert.ToInt32(reader["Anzahl"]));
c.Add(ac);
}
connection.Close();
}
catch (Exception ex)
{
LogWriter.Write(ex, LOGFILE_NAME);
string errmsg = "Fehler beim Abrufen der Benutzerstornos.\n\n";
errmsg += "DatabaseHandler.GetUserCancellationSummary(profile, user): " + ex.Message;
throw new Exception(errmsg);
}
return c;
}
public void Add(ArticleCount articleCount)
{
Add(articleCount.Article, articleCount.Count);
}
private string FormatItem(ArticleCount a)
{
int maxCountLength = 3;
int maxPriceLength = 3;
int spacesToName = 3;
string result = "";
// spaces to count
for (int i = 0; i < maxCountLength - a.Count.ToString().Length; i++) result += " ";
// count
result += a.Count.ToString() + "x";
// spaces to price
for (int i = 0; i < maxPriceLength - ((int)a.Article.Price).ToString().Length; i++) result += " ";
// price
result += string.Format("{0:0.00}", a.Article.Price);
// spaces to name
for (int i = 0; i < spacesToName; i++) result += " ";
// name
result += a.Article.Name;
return result;
}