public object GetNoticeDetails(NoticeParam obj)
{
NoticeBusinessLayer result = new NoticeBusinessLayer();
var Notice = result.GetNotice(obj);
return(Notice);
}
public object GetNotice(NoticeParam obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.UserName, obj.Password);
if (db == null)
{
return(new Results {
IsSuccess = false, Message = "Invalid User"
});
}
else
{
var GetData = db.TBLUSERLOGINs.Where(r => r.UserName == obj.UserName && r.Password == obj.Password).FirstOrDefault();
if (GetData == null)
{
return(new Results {
IsSuccess = false, Message = "Invalid User"
});
}
var AcademicYear = db.View_GETACADEMICYEAR.FirstOrDefault();
if (obj.EventType == "" || obj.EventType == "string")
{
var data = //db.View_DisplayNotice.Where(r => r.STARTDATE >= System.DateTime.Today.Date && r.DISPLAY == 1 && r.ACADEMICYEAR == AcademicYear.ACADEMICYEAR).ToList();
from c in db.View_DisplayNotice.Where(r => r.STARTDATE >= System.DateTime.Today.Date && r.DISPLAY == 1 && r.ACADEMICYEAR == AcademicYear.ACADEMICYEAR).OrderBy(r => r.STARTDATE)
select new { c.TYPE, c.HOLIDAY, c.SDATE, c.EDATE, c.NUMBEROFDAYS };
if (data != null)
{
return(new NoticeResult {
IsSuccess = true, Result = data
});
}
else
{
return(new NoticeResult {
IsSuccess = true, Result = "Notice or Event Not Found"
});
}
}
else
{
var data = //db.View_DisplayNotice.Where(r => r.STARTDATE >= System.DateTime.Today.Date && r.DISPLAY == 1 && r.TYPE == obj.EventType && r.ACADEMICYEAR == AcademicYear.ACADEMICYEAR).ToList();
from c in db.View_DisplayNotice.Where(r => r.STARTDATE >= System.DateTime.Today.Date && r.DISPLAY == 1 && r.TYPE == obj.EventType && r.ACADEMICYEAR == AcademicYear.ACADEMICYEAR).OrderBy(r => r.STARTDATE)
select new { c.TYPE, c.HOLIDAY, c.SDATE, c.EDATE, c.NUMBEROFDAYS };
if (data != null)
{
return(new NoticeResult {
IsSuccess = true, Result = data
});
}
else
{
return(new NoticeResult {
IsSuccess = true, Result = "Notice or Event Not Found"
});
}
}
}
}
catch (Exception ex)
{
return(new Results
{
IsSuccess = false,
Message = ex.Message
});
}
}