public object ShowHomeWorkAll([FromBody] ParamHomeWorkAll objhome)
{
GETHOMEWORK obj = new GETHOMEWORK();
var homemworkresult = obj.ViewHomeWorkByDates(objhome);
return(homemworkresult);
}
public object ViewHomeWorkByDates(ParamHomeWorkAll 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.FromDate && r.HOMEWORKDATE <= obj.ToDate).OrderByDescending(r => r.HOMEWORKDATE).ToList();
if (EmpHomework.Count() == 0)
{
var StudentHomework = db.VIEWSTUDENTHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE >= obj.FromDate && r.HOMEWORKDATE <= obj.ToDate).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 ViewHomeWorkByDates(ParamHomeWorkAll 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.FromDate && r.HOMEWORKDATE <= obj.ToDate).OrderByDescending(r => r.HOMEWORKDATE).ToList();
//from c in db.VIEWHOMEWORKs.Where(r => r.UserId == obj.userid && r.HOMEWORKDATE>=obj.FromDate && r.HOMEWORKDATE<=obj.ToDate)
//select new { c.UserId, c.HOMEWORKID, c.HOMEWORKDATE.tostr, c.SUBJECTNAME };
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.HOMEWORKDATE >= obj.FromDate && r.HOMEWORKDATE <= obj.ToDate).OrderByDescending(r => r.HOMEWORKDATE).ToList();
if (StudentHomework.Count() == 0)
{
return(new Results
{
IsSuccess = false,
Message = "Homework Not Found"
});
}
else
{
for (int i = 0; i < StudentHomework.Count; i++)
{
string HOMEWORKDATE = Convert.ToDateTime(StudentHomework[i].HOMEWORKDATE).ToString("MM/dd/yyyy");
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].HMDATE);
rs.HOMEWORKDATE = Convert.ToDateTime(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++)
{
string HOMEWORKDATE = Convert.ToDateTime(EmpHomework[i].HOMEWORKDATE).ToString("MM/dd/yyyy");
ResultSet rs = new ResultSet();
rs.UserId = EmpHomework[i].UserId;
rs.UserType = EmpHomework[i].UserType;
rs.HOMEWORKID = EmpHomework[i].HOMEWORKID;
// rs.HOMEWORKDATE = DateTime.ParseExact(EmpHomework[i].HMDATE, "dd/MM/yyyy", null);//DateTime.Parse(EmpHomework[i].HMDATE);
rs.HOMEWORKDATE = Convert.ToDateTime(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
});
}
}
