//public object GetHomework(PARAMHOMEWORK obj)
//{
// try
// {
// SchoolMainContext db = new ConcreateContext().GetContext(obj.user, obj.PASSWORD);
// var homework = db.VIEWHOMEWORKs.Where(r => r.STANDARDID == obj.standardid && r.DIVISIONID == obj.divisionid && r.DISPLAY == 1 && r.ACADEMICYEAR == "2018-2019").
// FirstOrDefault();
// if (homework == null)
// {
// return new Error() { IsError = true, Message = "Homework not found" };
// }
// else
// {
// return homework;
// }
// }
// catch (Exception E)
// {
// return new Error() { IsError = true, Message = E.Message };
// }
//}
public Object GetStandard(PARAMSTD obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.USERID, obj.PASSWORD);
var GETTYPE = db.VW_GET_USER_TYPE.Where(r => r.UserId == obj.USERID).ToList();
if (GETTYPE[0].UserType != "STUDENT")
{
var Division = db.VIEWDIVISIONLISTs.Where(r => r.STANDARDID == obj.STANDARDID && r.UserId == obj.USERID && r.ACADEMICYEAR == "2018-2019").ToList();
if (Division.Count == 0)
{
return(new Error()
{
IsError = true, Message = "Division Not Found"
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, DivisionListByUser = Division
});
}
}
else
{
var Division = db.VIEWDIVISIONLISTBYSTUDENTs.Where(r => r.STANDARDID == obj.STANDARDID && r.UserId == obj.USERID && r.ACADEMICYEAR == "2018-2019").ToList();
if (Division.Count == 0)
{
return(new Error()
{
IsError = true, Message = "Division Not Found"
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, DivisionListByUser = Division
});
}
}
}
catch (Exception E)
{
return(new Error()
{
IsError = true, Message = E.Message
});
}
}
//public object GetHomework(PARAMHOMEWORK obj)
//{
// try
// {
// SchoolMainContext db = new ConcreateContext().GetContext(obj.user, obj.PASSWORD);
// var homework = db.VIEWHOMEWORKs.Where(r => r.STANDARDID == obj.standardid && r.DIVISIONID == obj.divisionid && r.DISPLAY == 1 && r.ACADEMICYEAR == "2018-2019").
// FirstOrDefault();
// if (homework == null)
// {
// return new Error() { IsError = true, Message = "Homework not found" };
// }
// else
// {
// return homework;
// }
// }
// catch (Exception E)
// {
// return new Error() { IsError = true, Message = E.Message };
// }
//}
public Object GetStandard(PARAMSTD obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.USERID, obj.PASSWORD);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var GETTYPE = db.VW_GET_USER_TYPE.Where(r => r.UserId == obj.USERID).ToList();
var AcadamicYear = db.View_GETACADEMICYEAR.FirstOrDefault();
if (AcadamicYear == null)
{
return(new Results
{
IsSuccess = false,
Message = "Not Found Academic Year"
});
}
if (GETTYPE[0].UserType != "STUDENT")
{
var Division = db.VIEWDIVISIONLISTs.Where(r => r.STANDARDID == obj.STANDARDID && r.UserId == obj.USERID && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR).ToList();
if (Division.Count == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Division Not Found"
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, DivisionListByUser = Division
});
}
}
else
{
var Division = db.VIEWDIVISIONLISTBYSTUDENTs.Where(r => r.STANDARDID == obj.STANDARDID && r.UserId == obj.USERID && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR).ToList();
if (Division.Count == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Division Not Found"
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, DivisionListByUser = Division
});
}
}
}
catch (Exception E)
{
return(new Results
{
IsSuccess = false,
Message = E.Message
});
}
}
public object ViewDivision([FromBody] PARAMSTD objstd)
{
GETHOMEWORK objhome = new GETHOMEWORK();
return(objhome.GetStandard(objstd));
}
