public static System.Data.DataTable Sent_View(DateTime start, DateTime end, string sentTo = "", string content = "", Tab_Contact.Communication via = Tab_Contact.Communication.NaN, Tab_Sent.Confirmation status = Tab_Sent.Confirmation.SentSuccessful)
{
string query = "SELECT Gesendet, An, Inhalt, Via, Sendestatus FROM " + Sent_ViewName +
" WHERE Gesendet BETWEEN '" + start.ToUniversalTime() + "' AND '" + end.ToUniversalTime() + "' ";
if (sentTo.Length > 2)
{
query += " AND Von LIKE '%" + sentTo + "%' ";
}
if (content.Length > 2)
{
query += " AND Inhalt LIKE '%" + content + "%' ";
}
if (via != Tab_Contact.Communication.NaN)
{
query += " AND Via = " + via + " ";
}
if (status != Tab_Sent.Confirmation.SentSuccessful)
{
query += " AND Sendestatus = " + status + " ";
}
return(Sql.SelectDataTable("Gesendet", query));
}
public Sent(int toId, int contentId, Tab_Contact.Communication toVia)
{
ToId = toId;
ContentId = contentId;
ToVia = toVia;
}
