public object GetStdList(ParamDIVISIONLIST Stdobj)
{
SchoolMainContext db = new ConcreateContext().GetContext(Stdobj.userid, Stdobj.password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var UserType = db.VW_GET_USER_TYPE.Where(r => r.UserId == Stdobj.userid).ToList();
if (UserType[0].UserType == "STUDENT")
{
var STDLIST = db.Vw_STUDSTANDARD.Where(r => r.USERID == Stdobj.userid && r.ACADEMICYEAR == "2018-2019").ToList();
if (STDLIST.Count == 0)
{
return(new Results
{
IsSuccess = false,
Message = new InvalidUser()
{
IsSuccess = false, Result = "Standard is not assigned for this user"
}
});
}
else
{
return(new StdListResult()
{
IsSuccess = true, StandardList = STDLIST
});
}
}
else
{
var STDLIST = db.Vw_STANDARDLIST.Where(r => r.UserId == Stdobj.userid && r.ACADEMICYEAR == "2018-2019" && r.DISPLAY == 1).ToList();
if (STDLIST.Count == 0)
{
return(new Results
{
IsSuccess = false,
Message = new InvalidUser()
{
IsSuccess = false, Result = "Standard is not assigned for this user"
}
});
}
else
{
return(new StdListResult()
{
IsSuccess = true, StandardList = STDLIST
});
}
}
}
public object GetDivision(ParamDIVISIONLIST objdiv)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(objdiv.userid, objdiv.password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var AcadamicYear = db.View_GETACADEMICYEAR.FirstOrDefault();
if (AcadamicYear == null)
{
return(new Results
{
IsSuccess = false,
Message = "Not Found Academic Year"
});
}
var EmpDivision = db.VIEWEMPDIVISIONs.Where(r => r.UserId == objdiv.userid && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR && r.DISPLAY == 1).ToList();
if (EmpDivision.Count == 0)
{
var StudentDivision = db.VIEWSTUDENTDIVISIONs.Where(r => r.UserId == objdiv.userid && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR && r.DISPLAY == 1).ToList();
if (StudentDivision.Count == 0)
{
return(new Results
{
IsSuccess = false,
Message = "No Attendance Is Found Of This DateDivision is not assigned for this user"
});
}
else
{
return(new DivisionListByUserResult()
{
IsSuccess = true, DivisionList = StudentDivision
});
}
}
else
{
return(new DivisionListByUserResult()
{
IsSuccess = true, DivisionList = EmpDivision
});
}
}
catch (Exception E)
{
return(new Results
{
IsSuccess = false,
Message = E.Message
});
}
}
public object GetStdList(ParamDIVISIONLIST Stdobj)
{
SchoolContext db = new SchoolContext();
var UserType = db.VW_GET_USER_TYPE.Where(r => r.UserId == Stdobj.userid).ToList();
if (UserType[0].UserType == "STUDENT")
{
var STDLIST = db.Vw_STUDSTANDARD.Where(r => r.USERID == Stdobj.userid && r.ACADEMICYEAR == "2018-2019").ToList();
if (STDLIST.Count == 0)
{
return(new Error()
{
IsError = true, Message = "Standard is not assigned for this user"
});
}
else
{
return(new StdListResult()
{
IsSuccess = true, StandardList = STDLIST
});
}
}
else
{
var STDLIST = db.Vw_STANDARDLIST.Where(r => r.UserId == Stdobj.userid && r.ACADEMICYEAR == "2018-2019" && r.DISPLAY == 1).ToList();
if (STDLIST.Count == 0)
{
return(new Error()
{
IsError = true, Message = "Standard is not assigned for this user"
});
}
else
{
return(new StdListResult()
{
IsSuccess = true, StandardList = STDLIST
});
}
}
}
public object GetDivision(ParamDIVISIONLIST objdiv)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(objdiv.userid, objdiv.password);
var EmpDivision = db.VIEWEMPDIVISIONs.Where(r => r.UserId == objdiv.userid && r.ACADEMICYEAR == "2018-2019" && r.DISPLAY == 1).ToList();
if (EmpDivision.Count == 0)
{
var StudentDivision = db.VIEWSTUDENTDIVISIONs.Where(r => r.UserId == objdiv.userid && r.ACADEMICYEAR == "2018-2019" && r.DISPLAY == 1).ToList();
if (StudentDivision.Count == 0)
{
return(new Error()
{
IsError = true, Message = "Division is not assigned for this user"
});
}
else
{
return(new DivisionListByUserResult()
{
IsSuccess = true, DivisionList = StudentDivision
});
}
}
else
{
return(new DivisionListByUserResult()
{
IsSuccess = true, DivisionList = EmpDivision
});
}
}
catch (Exception E)
{
return(new Error()
{
IsError = true,
Message = E.Message
});
}
}
public object GetStandard([FromBody] ParamDIVISIONLIST objdiv)
{
GetStandardList objstd = new GetStandardList();
return(objstd.GetStdList(objdiv));
}
public object getStdDivList([FromBody] ParamDIVISIONLIST objdiv)
{
GetDivisionInfoBusiness obj = new GetDivisionInfoBusiness();
return(obj.GetDivision(objdiv));
}
