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)); }