public object GetClassWiseAttendanceList([FromBody] ParamDateWiseAttendance PA)
{
try
{
UserWiseAttendance objUA = new UserWiseAttendance();
var Result = objUA.GetClassWiseStatus(PA);
return(Result);
//return new AttendanceResult()
//{
// IsSuccess = true,
// UserWiseAttendanceList = Result
//};
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object GetAttendanceByUser(ParamDateWiseAttendance obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.UserId, obj.Password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var usertype = db.VW_GET_USER_TYPE.Where(r => r.UserId == obj.UserId).ToList();
if (usertype.Count() == 0)
{
return(new AttendanceResult()
{
IsSuccess = false, UserWiseAttendanceList = "User Not Found"
});
}
if (usertype[0].UserType == "STUDENT")
{
var checkattendace = db.VIewAttendaceClasswiseChecks.Where(r => r.UserId == obj.UserId && r.ATTEDANCEDATE == obj.AttendanceDate && r.DISPLAY == 1 && r.EDUCATIONYEAR == "2018-2019" && r.ACADEMICYEAR == "2018-2019").ToList();
if (checkattendace.Count() == 0)
{
return(new AttendanceResult()
{
IsSuccess = true, UserWiseAttendanceList = "Status : Attendance Is Not Marked By Class Teacher For This Date"
});
}
else
{
var StudentAttendance = db.VWATTENDANCEBYDATESTUDENTs.Where(r => r.UserId == obj.UserId && r.ATTEDANCEDATE == obj.AttendanceDate).ToList();
if (StudentAttendance.Count() == 0)
{
return(new AttendanceResult()
{
IsSuccess = true, UserWiseAttendanceList = "Status : Present"
});
//EMPLOYEE logic
// return new Error() { IsError = true, Message = "Attendance not found" };
}
else
{
return(new AttendanceResult()
{
IsSuccess = true, UserWiseAttendanceList = "Status : Absent"
});
}
}
}
else
{
var EMPATTENDANCE = db.VWATTENDANCEEMPLOYEEs.Where(r => r.UserId == obj.UserId && r.ATTEDANCEDATE == obj.AttendanceDate && r.DISPLAY == 1).ToList();
if (usertype[0].UserType == "CLASS TEACHER")
{
if (EMPATTENDANCE.Count() == 0)
{
return(new AttendanceResult()
{
IsSuccess = true, UserWiseAttendanceList = "Status : Attendance Not Completed"
});
}
else
{
return(new AttendanceResult()
{
IsSuccess = true, UserWiseAttendanceList = "Status : Attendance Completed"
});
}
}
else
{
return(new AttendanceResult()
{
IsSuccess = true,
UserWiseAttendanceList = "Status : User is not class Teacher"
});
}
}
}
catch (Exception e)
{
return(new Results
{
IsSuccess = false,
Message = e.Message
});
}
}
public object GetClassWiseStatus(ParamDateWiseAttendance PA)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(PA.UserId, PA.Password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var usertype = db.VW_GET_USER_TYPE.Where(r => r.UserId == PA.UserId).ToList();
if (usertype.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Incorrect Username"
});
}
var EMPATTENDANCE = db.VWATTENDANCEEMPLOYEEs.Where(r => r.UserId == PA.UserId && r.ATTEDANCEDATE == PA.AttendanceDate && r.DISPLAY == 1).ToList();
if (EMPATTENDANCE.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Attendance Is Not Marked By Class Teacher"
});
}
if (usertype.Count() == 0)
{
return(new Results()
{
IsSuccess = false, Message = "User Not Found"
});
}
if (usertype[0].UserType != "CLASS TEACHER")
{
return(new Results
{
IsSuccess = false,
Message = "User Is Not Class Teacher"
});
}
else
{
var AttendaceStatus = db.VW_DATEWISECLASSSTATUSATTENDANCE.Where(r => r.ATTEDANCEDATE == PA.AttendanceDate && r.CREATEDID == PA.UserId).ToList().OrderBy(r => r.ROLLNO);
if (AttendaceStatus.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "No Records Found"
});
}
else
{
return(new AttendanceResult()
{
IsSuccess = true,
UserWiseAttendanceList = AttendaceStatus.ToList().OrderBy(r => r.ROLLNO)
});
}
}
}
catch (Exception e)
{
return(new Results
{
IsSuccess = false,
Message = e.Message
});
}
}
public object GetClassWiseStatus(ParamDateWiseAttendance PA)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(PA.UserId, PA.Password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var usertype = db.VW_GET_USER_TYPE.Where(r => r.UserId == PA.UserId).ToList();
if (usertype.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Incorrect Username"
});
}
var AcadamicYear = db.View_GETACADEMICYEAR.FirstOrDefault();
if (AcadamicYear == null)
{
return(new Results
{
IsSuccess = false,
Message = "Not Found Academic Year"
});
}
var EMPATTENDANCE = db.VWATTENDANCEEMPLOYEEs.Where(r => r.UserId == PA.UserId && r.ATTEDANCEDATE == PA.AttendanceDate && r.DISPLAY == 1).ToList();
if (EMPATTENDANCE.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Attendance Is Not Marked By Class Teacher"
});
}
if (usertype.Count() == 0)
{
return(new Results()
{
IsSuccess = false, Message = "User Not Found"
});
}
if (usertype[0].UserType != "CLASS TEACHER")
{
return(new Results
{
IsSuccess = false,
Message = "User Is Not Class Teacher"
});
}
else
{
var EMPID = Convert.ToInt32(usertype[0].EmpCode);
var DivData = db.TBLASSIGNCLASSTEACHERs.Where(r => r.EMPLOYEEID == EMPID && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR && r.DISPLAY == 1).FirstOrDefault();
var AttendaceStatus = db.VW_DATEWISECLASSSTATUSATTENDANCE.Where(r => r.ATTEDANCEDATE == PA.AttendanceDate && r.CREATEDID == PA.UserId && r.DIVISIONID == DivData.DIVISIONID).ToList().OrderBy(r => r.ROLLNO);
if (AttendaceStatus.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "No Records Found"
});
}
else
{
return(new AttendanceResult()
{
IsSuccess = true,
UserWiseAttendanceList = AttendaceStatus.ToList().OrderBy(r => r.ROLLNO)
});
}
}
}
catch (Exception e)
{
return(new Results
{
IsSuccess = false,
Message = e.Message
});
}
}
