public object ShowHomeWork([FromBody] ParamHOMEWORKBYUSER objhome)
{
GETHOMEWORK obj = new GETHOMEWORK();
var homemworkresult = obj.ViewHomeWorkbyUser(objhome);
//return obj.ViewHomeWorkbyUser(objhome);
//return new DivisionListResult() { IsSuccess = true, HomeWork = obj.ViewHomeWorkbyUser(objhome) };
return(homemworkresult);
}
//internal object ViewHomeWorkbyUser(PARAMHOMEWORKBYUSER objhome)
//{
// throw new NotImplementedException();
//}
//public object GetStdByEmp(PARAMEMP emp)
//{
// try
// {
// var Division = db.VIEWDIVISIONLISTBYEMPs.Where(r => r.EMPLOYEEID == emp.EmployeeId);
// if (Division == null)
// {
// return new Error() { IsError = true, Message = "Division Not Found" };
// }
// else
// {
// return Division;
// }
// }
// catch (Exception E)
// {
// return new Error() { IsError = true, Message = E.Message };
// }
//}
public object ViewHomeWorkbyUser(ParamHOMEWORKBYUSER obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.userid, obj.password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var EmpHomework = db.VIEWHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE == obj.homeworkdate).OrderByDescending(r => r.HOMEWORKDATE).ToList();;
if (EmpHomework.Count() == 0)
{
var StudentHomework = db.VIEWSTUDENTHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE == obj.homeworkdate).OrderByDescending(r => r.HOMEWORKDATE).ToList();;
if (StudentHomework.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = new InvalidUser()
{
IsSuccess = false, Result = "Homework Not Found"
}
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = StudentHomework
});;
}
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = EmpHomework
});;
}
}
catch (Exception E)
{
return(new Results
{
IsSuccess = false,
Message = E.Message
});
}
}
public object ShowHomeWork([FromBody] ParamHOMEWORKBYUSER objhome)
{
int year = DateTime.Now.Year;
if (objhome.Month > 12 || objhome.Month == 0)
{
return(new Results()
{
IsSuccess = false, Message = "Please Enter Month Between 1 to 12"
});
}
int days = DateTime.DaysInMonth(year, objhome.Month);
GETHOMEWORK obj = new GETHOMEWORK();
var homemworkresult = obj.ViewHomeWorkbyUser(objhome);
//return obj.ViewHomeWorkbyUser(objhome);
//return new DivisionListResult() { IsSuccess = true, HomeWork = obj.ViewHomeWorkbyUser(objhome) };
return(homemworkresult);
}
public object ViewHomeWorkbyUser(ParamHOMEWORKBYUSER obj)
{
try
{
var EmpHomework = db.VIEWHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE == obj.homeworkdate).ToList();
if (EmpHomework.Count() == 0)
{
var StudentHomework = db.VIEWSTUDENTHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE == obj.homeworkdate).ToList();
if (StudentHomework.Count() == 0)
{
return(new Error()
{
IsError = true, Message = "HomeWork Not Found."
});
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = StudentHomework
});;
}
}
else
{
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = EmpHomework
});;
}
}
catch (Exception E)
{
return(new Error()
{
IsError = true, Message = E.Message
});
}
}
//internal object ViewHomeWorkbyUser(PARAMHOMEWORKBYUSER objhome)
//{
// throw new NotImplementedException();
//}
//public object GetStdByEmp(PARAMEMP emp)
//{
// try
// {
// var Division = db.VIEWDIVISIONLISTBYEMPs.Where(r => r.EMPLOYEEID == emp.EmployeeId);
// if (Division == null)
// {
// return new Error() { IsError = true, Message = "Division Not Found" };
// }
// else
// {
// return Division;
// }
// }
// catch (Exception E)
// {
// return new Error() { IsError = true, Message = E.Message };
// }
//}
public object ViewHomeWorkbyUser(ParamHOMEWORKBYUSER obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.userid, obj.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 EmpHomework = db.VIEWHOMEWORKs.Where(r => r.UserId == obj.userid && r.HMMONTH == obj.Month && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR)
.OrderByDescending(r => r.HOMEWORKDATE).OrderByDescending(r => r.HOMEWORKID).ToList();;
string UploadBaseUrl = "";
var logindetail = db.TBLUSERLOGINs.
Where(r => r.UserId == obj.userid && r.Password == obj.password && r.STATUS == "ACTIVE")
.FirstOrDefault();
if (logindetail.UserName.StartsWith("NKV"))
{
UploadBaseUrl = ConfigurationManager.AppSettings["NkvsBaseUrlUpload"];
}
else if (logindetail.UserName.StartsWith("SXS"))
{
UploadBaseUrl = ConfigurationManager.AppSettings["StxavierBaseUrlUpload"];
}
else if (logindetail.UserName.StartsWith("ASM"))
{
UploadBaseUrl = ConfigurationManager.AppSettings["AsmBaseUrlUpload"];
}
else if (logindetail.UserName.StartsWith("ASY"))
{
UploadBaseUrl = ConfigurationManager.AppSettings["AsyBaseUrlUpload"];
}
else if (logindetail.UserName.StartsWith("NMS"))
{
UploadBaseUrl = ConfigurationManager.AppSettings["NmsBaseUrlUpload"];
}
List <ResultSet> Res = new List <ResultSet>();
if (EmpHomework.Count() == 0)
{
var StudentHomework = db.VIEWSTUDENTHOMEWORKs.Where(r => r.UserId == obj.userid && r.HMMONTH == obj.Month && r.ACADEMICYEAR == AcadamicYear.ACADEMICYEAR).
OrderByDescending(r => r.HOMEWORKDATE).OrderByDescending(r => r.HOMEWORKID).ToList();;
if (StudentHomework.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Homework Not Found"
});
}
else
{
for (int i = 0; i < StudentHomework.Count; i++)
{
ResultSet rs = new ResultSet();
rs.UserId = StudentHomework[i].UserId;
rs.UserType = StudentHomework[i].UserType;
rs.HOMEWORKID = StudentHomework[i].HOMEWORKID;
rs.HOMEWORKDATE = Convert.ToDateTime(StudentHomework[i].HOMEWORKDATE);
rs.TIME = StudentHomework[i].TIME;
rs.STANDARDID = Convert.ToInt32(StudentHomework[i].STANDARDID);
rs.DIVISIONID = Convert.ToInt32(StudentHomework[i].DIVISIONID);
rs.HOMEWORK = StudentHomework[i].HOMEWORK;
rs.ACADEMICYEAR = StudentHomework[i].ACADEMICYEAR;
if (StudentHomework[i].FILEPATH != "")
{
rs.FILEPATH = UploadBaseUrl + StudentHomework[i].FILEPATH;
}
else
{
rs.FILEPATH = "";
}
rs.STANDARDNAME = StudentHomework[i].STANDARDNAME;
rs.DIVISIONNAME = StudentHomework[i].DIVISIONNAME;
rs.EMPLOYEENAME = StudentHomework[i].EMPLOYEENAME;
rs.SUBJECTNAME = StudentHomework[i].SUBJECTNAME;
rs.DISPLAY = Convert.ToInt32(StudentHomework[i].DISPLAY);
Res.Add(rs);
}
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = Res
});
}
}
else
{
for (int i = 0; i < EmpHomework.Count; i++)
{
ResultSet rs = new ResultSet();
rs.UserId = EmpHomework[i].UserId;
rs.UserType = EmpHomework[i].UserType;
rs.HOMEWORKID = EmpHomework[i].HOMEWORKID;
rs.HOMEWORKDATE = Convert.ToDateTime(EmpHomework[i].HOMEWORKDATE);
rs.TIME = EmpHomework[i].TIME;
rs.STANDARDID = Convert.ToInt32(EmpHomework[i].STANDARDID);
rs.DIVISIONID = Convert.ToInt32(EmpHomework[i].DIVISIONID);
rs.HOMEWORK = EmpHomework[i].HOMEWORK;
rs.ACADEMICYEAR = EmpHomework[i].ACADEMICYEAR;
if (EmpHomework[i].FILEPATH != "")
{
rs.FILEPATH = UploadBaseUrl + EmpHomework[i].FILEPATH;
}
else
{
rs.FILEPATH = "";
}
rs.STANDARDNAME = EmpHomework[i].STANDARDNAME;
rs.DIVISIONNAME = EmpHomework[i].DIVISIONNAME;
rs.EMPLOYEENAME = EmpHomework[i].EMPLOYEENAME;
rs.SUBJECTNAME = EmpHomework[i].SUBJECTNAME;
rs.DISPLAY = Convert.ToInt32(EmpHomework[i].DISPLAY);
Res.Add(rs);
}
return(new DivisionListResult()
{
IsSuccess = true, HomeWork = Res
});
}
}
catch (Exception E)
{
return(new Results
{
IsSuccess = false,
Message = E.Message
});
}
}