public object GetAttendanceData([FromBody] ParamAttendance objPA)
{
int year = DateTime.Now.Year;
int days = DateTime.DaysInMonth(year, objPA.MONTH);
ClassTeacherData objCT = new ClassTeacherData();
var result = objCT.GetAttendanceStatus(objPA);
return(result);
// return new MonthlyAttendanceResult() { IsSuccess = "true", DateWiseStatus = result };
}
public object GetAttendanceData([FromBody] ParamAttendance objPA)
{
int year = DateTime.Now.Year;
if (objPA.MONTH > 12 || objPA.MONTH == 0)
{
return(new MonthlyAttendanceResult()
{
IsSuccess = false, DateWiseStatus = "Please Enter Month Between 1 to 12"
});
}
int days = DateTime.DaysInMonth(year, objPA.MONTH);
ClassTeacherData objCT = new ClassTeacherData();
var result = objCT.GetAttendanceStatus(objPA);
return(result);
// return new MonthlyAttendanceResult() { IsSuccess = "true", DateWiseStatus = result };
}
/// <summary>
/// TO RETURN CLASS TEACHER DATA
/// </summary>
/// <param name="PC"></param>
/// <returns></returns>
//public object GetClassTeacher(ParamClassTeacher PC)
//{
// try
// {
// var ClassTeacher = db.VIEWCLASSTEACHERs.
// Where(r => r.EMPLOYEEID == PC.EMPLOYEEID && r.DISPLAY == 1 && r.ACADEMICYEAR == "2018-2019")
// .FirstOrDefault();
// if (ClassTeacher == null)
// return new Error() { IsError = true, Message = "No Class is Assigned To This Teacher" };
// else
// return ClassTeacher;
// }
// catch (Exception ex)
// {
// return new Error() { IsError = true, Message = ex.Message };
// }
//}
public object GetAttendanceStatus(ParamAttendance PA)
{
try
{
int year = DateTime.Now.Year;
List <DateTime> li = GetDates(year, PA.MONTH);
CheckUsernamePassword objUP = new CheckUsernamePassword();
bool iStrue = objUP.ValidateUsernamePassword(PA.UserId, PA.Password);
if (iStrue == false)
{
return(new MonthlyAttendanceResult()
{
IsSuccess = false, DateWiseStatus = "Invalid User"
});
}
List <Result> lt = new List <Result>();
SchoolMainContext db = new ConcreateContext().GetContext(PA.UserId, PA.Password);
var USERTYPE = db.VW_GET_USER_TYPE.Where(r => r.UserId == PA.UserId).ToList();
if (USERTYPE[0].UserType == "STUDENT")
{
var ATTENDANCEDATA = db.VWATTENDANCEBYDATESTUDENTs.Where(r => r.ATTMONTH == PA.MONTH && r.UserId == PA.UserId).ToList();
//var HOLIDAYDATA = db.VIEWCHECKHOLIDAYs.Where(r => r.HOLIDAYDATE == PA.MONTH && r.DISPLAY == 1).ToList();
int flag = 0;
foreach (var item in li)
{
var checkattendace = db.VIewAttendaceClasswiseChecks.Where(r => r.UserId == PA.UserId && r.ATTEDANCEDATE == item && r.DISPLAY == 1 && r.EDUCATIONYEAR == "2018-2019" && r.ACADEMICYEAR == "2018-2019").ToList();
if (checkattendace.Count == 0)
{
Result ddl = new Result();
ddl.Date = item.ToString("dd/MM/yyyy");
ddl.Status = "Attendance is not marked by class teacher for this date.";
lt.Add(ddl);
}
else
{
flag = 0;
foreach (var att in ATTENDANCEDATA)
{
if (att.ATTEDANCEDATE == item)
{
Result ddl = new Result();
ddl.Date = item.ToString("dd/MM/yyyy");
ddl.Status = "Absent";
lt.Add(ddl);
flag = 1;
}
}
if (flag == 0)
{
Result ddl = new Result();
ddl.Date = item.ToString("dd/MM/yyyy");
ddl.Status = "Present";
lt.Add(ddl);
}
}
}
if (lt == null)
{
return new ResultBirth {
IsSuccess = false, Result = "No Attendance Is Found Of This Date"
}
}
;
else
{
return new MonthlyAttendanceResult()
{
IsSuccess = true, DateWiseStatus = lt
}
};
}
else
{
if (USERTYPE[0].UserType == "CLASS TEACHER")
{
var ATTENDANCEDATAEMP = db.VWATTENDANCEEMPLOYEEs.Where(r => r.ATTMONTH == PA.MONTH && r.UserId == PA.UserId && r.DISPLAY == 1).ToList();
//var HOLIDAYDATA = db.VIEWCHECKHOLIDAYs.Where(r => r.HOLIDAYDATE == PA.MONTH && r.DISPLAY == 1).ToList();
int flag = 0;
foreach (var item in li)
{
flag = 0;
foreach (var att in ATTENDANCEDATAEMP)
{
if (att.ATTEDANCEDATE == item)
{
Result ddl = new Result();
ddl.Date = item.ToString("dd/MM/yyyy");
ddl.Status = "Attendance Marked";
lt.Add(ddl);
flag = 1;
}
}
if (flag == 0)
{
Result ddl = new Result();
ddl.Date = item.ToString("dd/MM/yyyy");
ddl.Status = "Attendance Not Marked";
lt.Add(ddl);
}
}
if (lt == null)
{
return new Results
{
IsSuccess = false,
Message = "No Attendance Is Found Of This Date"
}
}
;
else
{
// return lt;
return new MonthlyAttendanceResult()
{
IsSuccess = true, DateWiseStatus = lt
}
};
}
else
{
return(new Results
{
IsSuccess = false,
Message = "User Is Not Class Teacher"
});
}
}
}
catch (Exception ex)
{
return(new Results
{
IsSuccess = false,
Message = ex.Message
});
}
}
