public static void CostumersReport()
{
IList <CostumersTable> customers = DataLayer.GetAllCostumersDL();
String fileName = Path.GetTempFileName() + ".html";
string body = "<html><head><style>body { direction:rtl; font-family: Arial, Sans Serif; }" +
"table { width: 100%; } " + "thead th { background: gray; }</style>" +
"<title>דוח לקוחות</title>" + "</head><body><h1>תוצאות דוח לקוחות</h1>" +
"<table>" +
"<thead><tr><th>מזהה</th><th>שם מלא</th><th>כתובת</th><th>מספר טלפון</th><th>מייל</th><th>הערות</th><th>מצב פעילות</th></tr></thead>" +
"<tbody>";
foreach (CostumersTable elemant in customers)
{
bool active;
if (elemant.active == 0)
{
active = true;
}
else
{
active = false;
}
body += "<tr><td>" + elemant.Id.ToString() + "</td><td>" + elemant.full_Name + "</td><td>" + elemant.address +
"</td><td>" + elemant.phoneNumber + "</td><td>" + elemant.E_mail + "</td><td>" + elemant.notes + "</td><td>" + active.ToString() + "</td></tr>";
}
body += "</tbody></table></body></html>";
File.WriteAllText(fileName, body);
ProcessStartInfo processStartInfo = new ProcessStartInfo(fileName);
processStartInfo.UseShellExecute = true;
Process.Start(processStartInfo);
}
public IList <CostumersTable> GetAll()
{
return(DataLayer.GetAllCostumersDL());
}