private void Initialize()
{
//count parents
lblParent.Content = context.PARENTS.Count();
lblTeacher.Content = context.TEACHERS.Count();
lblTotalStd.Content = context.STUDENTS.Count();
lblEarning.Content = (context.PAYMENTS.Sum(x => (float)x.pay_amount));
/////////////////////////////////////////////////////////////////////////
int id = context.NOTICEs.Count();
var name = new List <Label> {
lblNoticeName1, lblNoticeName2, lblNoticeName3, lblNoticeName4, lblNoticeName5, lblNoticeName6
};
var date = new List <Label> {
lblNoticeDate1, lblNoticeDate2, lblNoticeDate3, lblNoticeDate4, lblNoticeDate5, lblNoticeDate6
};
var title = new List <Label> {
lblNoticeMsg1, lblNoticeMsg2, lblNoticeMsg3, lblNoticeMsg4, lblNoticeMsg5, lblNoticeMsg6
};
foreach (var n in name)
{
if (id % 2 == 0)
{
n.Foreground = Brushes.Red;
}
NOTICE s = context.NOTICEs.First(a => a.id == id);
n.Content = s.posted_by;
id--;
}
id = context.NOTICEs.Count();
foreach (var d in date)
{
NOTICE s = context.NOTICEs.First(a => a.id == id);
d.Content = s.post_date;
id--;
}
id = context.NOTICEs.Count();
foreach (var t in title)
{
NOTICE s = context.NOTICEs.First(a => a.id == id);
t.Content = s.title;
id--;
}
}
private void btnNtcSubmit_Click(object sender, RoutedEventArgs e)
{
try {
var notice = new NOTICE
{
title = txtNtcTitle.Text,
detail = txtNtcDetail.Text,
posted_by = txtNtcPosted.Text,
post_date = DateTime.Today.ToString("dd-MM-yyyy")
};
context.NOTICEs.Add(notice);
context.SaveChanges();
}
catch (Exception ex)
{
lblNtcMsg.Content = "Please fill the field correctly";
}
}
private void noticeboard()
{
int id = context.NOTICEs.Count();
var name = new List <Label> {
lblNoticeName1, lblNoticeName2, lblNoticeName3, lblNoticeName4, lblNoticeName5, lblNoticeName6
};
var date = new List <Label> {
lblNoticeDate1, lblNoticeDate2, lblNoticeDate3, lblNoticeDate4, lblNoticeDate5, lblNoticeDate6
};
var title = new List <Label> {
lblNoticeMsg1, lblNoticeMsg2, lblNoticeMsg3, lblNoticeMsg4, lblNoticeMsg5, lblNoticeMsg6
};
foreach (var n in name)
{
if (id % 2 == 0)
{
n.Foreground = Brushes.Red;
}
NOTICE s = context.NOTICEs.First(a => a.id == id);
n.Content = s.posted_by;
id--;
}
id = context.NOTICEs.Count();
foreach (var d in date)
{
NOTICE s = context.NOTICEs.First(a => a.id == id);
d.Content = s.post_date;
id--;
}
id = context.NOTICEs.Count();
foreach (var t in title)
{
NOTICE s = context.NOTICEs.First(a => a.id == id);
t.Content = s.title;
id--;
}
}
