public void PrintDetailsOnScreen()
{
var sb = new StringBuilder();
sb.AppendLine("Employee for ITALY");
sb.Append("Gross salary: EUR ");
sb.AppendLine(GrossAumont.ToString());
sb.AppendLine();
sb.AppendLine("CalculateDeductions details");
sb.AppendLine("---------------------------------------");
sb.Append("Revenue: EUR ");
sb.AppendLine(Revenue.ToString());
sb.Append("Pension: EUR ");
sb.AppendLine(Pension.ToString());
sb.AppendLine("---------------------------------------");
sb.Append("Net salary: EUR ");
sb.AppendLine(NetAumont.ToString());
Console.WriteLine(sb.ToString());
}
// Show Budget properties.
public void ShowBudget(string title)
{
Console.WriteLine(title);
Console.WriteLine("Revenue: " + Revenue.ToString("C"));
Console.WriteLine("Expenses: " + Expenses.ToString("C"));
Console.WriteLine();
}
public string ToString(string fmt)
{
if (String.IsNullOrEmpty(fmt))
{
fmt = "Full";
}
NumberFormatInfo nfi = CultureInfo.CreateSpecificCulture("en-US").NumberFormat;
switch (fmt)
{
case "Full":
return(String.Format("Customer record: {0}, {1}, {2} ", Name, Revenue.ToString("N2", nfi), ContactPhone));
case "Phone":
return(String.Format("Customer record: {0}", ContactPhone));
case "NameRev":
return(String.Format("Customer record: {0}, {1}", Name, Revenue.ToString("N2", nfi)));
case "Name":
return(String.Format("Customer record: {0}", Revenue));
default:
String msg = String.Format("'{0}' is an invalid format string",
fmt);
throw new ArgumentException(msg);
}
}
public string ToString(string format, IFormatProvider formatProvider)
{
if (formatProvider != null)
{
ICustomFormatter formatter = formatProvider.GetFormat(this.GetType()) as ICustomFormatter;
if (formatter != null)
{
return(formatter.Format(format, this, formatProvider));
}
}
switch (format)
{
case "r":
return(Revenue.ToString());
case "p":
return(Phone);
case "nr":
return(string.Format("{0,20}, {1,10:C}", Name, Revenue));
case "np":
return(string.Format("{0,20}, {1,15}", Name, Phone));
case "pr":
return(string.Format("{0,15}, {1,10:C}", Phone, Revenue));
case "pn":
return(string.Format("{0,15}, {1,20}", Phone, Name));
case "rn":
return(string.Format("{0,10:C}, {1,20}", Revenue, Name));
case "rp":
return(string.Format("{0,10:C}, {1,20}", Revenue, Phone));
case "nrp":
return(string.Format("{0,20}, {1,10:C}, {2,15}", Name, Revenue, Phone));
case "npr":
return(string.Format("{0,20}, {1,15}, {2, 10:C}", Name, Phone, Revenue));
case "pnr":
return(string.Format("{0,15}, {1,20}, {2, 10:C}", Phone, Name, Revenue));
case "n":
case "G":
default:
return(Name);
}
}
/// <summary>
/// Convert customer into string representation
/// </summary>
/// <param name="format">format of string representation</param>
/// <param name="formatProvider">Provider of the format</param>
/// <returns>String representation of customer</returns>
public string ToString(string format, IFormatProvider formatProvider)
{
switch (format)
{
case "nnRRcc":
return($"Customer record: {Name}, {Revenue.ToString("C", CultureInfo.CurrentCulture)}, {ContactPhone}");
case "nnRR":
return($"Customer record: {Name}, {Revenue.ToString("C", CultureInfo.CurrentCulture)}");
case "nn":
return($"Customer record: {Name}");
}
return(string.Format(formatProvider, format, this));
}
/// <summary>
/// Return string by format
/// </summary>
/// <param name="format">Format for result string</param>
/// <returns>String line</returns>
private string GetFormatedStringValue(string format)
{
var stringValue = "Customer record:";
switch (format)
{
case "f": return($"{stringValue} {Name}, {Revenue.ToString("N")}, {ContactPhone}");
case "c": return($"{stringValue} {ContactPhone}");
case "nr": return($"{stringValue} {Name}, {Revenue.ToString("N")}");
case "n": return($"{stringValue} {Name}");
case "r-": return($"{stringValue} {Revenue}");
case "r": return($"{stringValue} {Revenue.ToString("N")}");
case "sf": return($"{GetType()} -> {Name}, {Revenue.ToString("N")}, {ContactPhone}");
default:
throw new FormatException("Unknown format: " + format);
}
}
public IActionResult Index()
{
var records = new List <string>();
SqlConnection connection = new SqlConnection("Server=DESKTOP-9N59O8O\\SQLEXPRESS; Database=PizzaBox;Trusted_Connection=True;MultipleActiveResultSets=True");
SqlCommand cmd = new SqlCommand("SELECT StoreId as Store, SUM(TotalPrice) AS Rev, DATEPART(YEAR, DateTime) AS Year, DATEPART(MONTH, DateTime) AS Month, datepart(week, datetime) as Week FROM Orders GROUP BY StoreId, DATEPART(YEAR, DateTime), DATEPART(MONTH, DateTime), datepart(week, datetime);", connection);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var revenue = new Revenue();
revenue.Rev = reader.GetDouble(reader.GetOrdinal("Rev"));
revenue.Year = reader.GetInt32(reader.GetOrdinal("Year"));
revenue.Week = reader.GetInt32(reader.GetOrdinal("Week"));
revenue.Month = reader.GetInt32(reader.GetOrdinal("Month"));
revenue.Store = reader.GetInt32(reader.GetOrdinal("Store"));
records.Add(revenue.ToString());
}
}
return(View(records));
}
