public void ChecknotificationOutbox()
{
Outbox_notificationcount = 0;
List <SMSBAL> smsList = sms_db.LoadAll();
outboxcount = smsList.Where(m => !m.IsDelieverd && m.status).Count();
sentItemscount = smsList.Where(m => m.IsDelieverd && m.status).Count();
trashcount = smsList.Where(m => !m.status).Count();
foreach (var item in smsList)
{
if (!item.IsDelieverd && !item.IsSeen && item.status)
{
Outbox_notificationcount++;
}
}
}
public void LoadSendItems()
{
gridTrash.Rows.Clear();
gridTrash.Columns.Clear();
gridTrash.Columns.Add("sms_id", "sms_id"); //0
gridTrash.Columns["sms_id"].Visible = false;
gridTrash.Columns.Add("phoneNo", "Phone No"); //1
gridTrash.Columns.Add("Message", "Message"); //2
gridTrash.Columns["Message"].Width = 390;
gridTrash.Columns.Add("Time", "Date/Time"); //3
gridTrash.Columns["Time"].Width = 150;
gridTrash.Columns.Add(btn_MoveToTrash); //4
btn_MoveToTrash.HeaderText = "Restore";
btn_MoveToTrash.Text = "Restore";
btn_MoveToTrash.Name = "Restore";
btn_MoveToTrash.UseColumnTextForButtonValue = true;
gridTrash.Columns.Add(btn_MoveToTrash1); //5
btn_MoveToTrash1.HeaderText = "Remove From Trash";
btn_MoveToTrash1.Text = "Remove From Trash";
btn_MoveToTrash1.Name = "Remove From Trash";
btn_MoveToTrash1.UseColumnTextForButtonValue = true;
gridTrash.Columns[5].Width = 175;
foreach (var item in sms_db.LoadAll().Where(m => !m.status))
{
gridTrash.Rows.Add(item.sms_id, item.phoneNo, item.Message, item.TimeStamp);
}
}
public void SeenOutbox()
{
foreach (var item in sms_db.LoadAll().Where(m => !m.IsDelieverd && !m.IsSeen))
{
item.IsSeen = true;
sms_db.Update(item);
}
}
