public object GETTIMETABLE(UpdateTimeTableParam obj)
{
TimetableBusiness ObjTerm = new TimetableBusiness();
var GetTermVar = ObjTerm.GetTimetableInfo(obj);
return(GetTermVar);
}
public object GetTimetableInfo(UpdateTimeTableParam obj)
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.Userid, obj.Password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
if (obj.WORKINGDAYS == "")
{
var data = db.TBLTIMETABLESCHEDULEs.Where(r => r.DISPLAY == 1 && r.EMPLOYEEID == obj.EMPLOYEEID).ToList();
if (data == null)
{
return(new Results()
{
IsSuccess = false, Message = "Data Not Found"
});
}
else
{
return(new TIMETABLELIST()
{
IsSuccess = true, TABLELIST = data
});
}
}
else
{
var data = db.TBLTIMETABLESCHEDULEs.Where(r => r.DISPLAY == 1 && r.EMPLOYEEID == obj.EMPLOYEEID && r.WORKINGDAYS == obj.WORKINGDAYS).ToList();
if (data == null)
{
return(new Results()
{
IsSuccess = false, Message = "Data Not Found"
});
}
else
{
return(new TIMETABLELIST()
{
IsSuccess = true, TABLELIST = data
});
}
}
}
public object GetTimetableInfo(UpdateTimeTableParam obj)
{
try
{
SchoolMainContext db = new ConcreateContext().GetContext(obj.Username, obj.Password);
var Info = db.TBLUSERLOGINs.Where(r => r.UserName == obj.Username && r.Password == obj.Password).FirstOrDefault();
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
if (Info == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var AcademicYear = db.View_GETACADEMICYEAR.FirstOrDefault();
if (AcademicYear == null)
{
return(new Results()
{
IsSuccess = false, Message = "Academic Year Not Found"
});
}
var EmployeeCode = Convert.ToInt16(Info.EmpCode);
// var days = db.View_DisplayWeekDay.ToList();
List <string> WorkingDay = db.View_DisplayWeekDay.OrderBy(r => r.DayNo).Select(r => r.WORKINGDAYS).ToList();
List <Day> lt = new List <Day>();
foreach (var item in WorkingDay)
{
item.ToList();
TIMETABLELIST ddl = new TIMETABLELIST();
// var data = db.View_Timetable.Where(r => r.EMPLOYEEID == EmployeeCode && r.WORKINGDAYS == item && r.DISPLAY == 1 && r.EDUYEAR == AcademicYear.ACADEMICYEAR).ToList();
var data_d = from c in db.View_Timetable.Where(r => r.EMPLOYEEID == EmployeeCode && r.WORKINGDAYS == item && r.DISPLAY == 1 && r.EDUYEAR == AcademicYear.ACADEMICYEAR).OrderBy(R => R.BATCHID)
select new { c.DIVISIONNAME, c.SUBJECTNAME, c.STANDARDNAME, c.BATCHNAME, c.BATCHTIME };
if (data_d.Count() == 0)
{
lt.Add(new Day
{
WorkingDayName = item,
TimeTableList = data_d
});
}
else
{
lt.Add(new Day
{
WorkingDayName = item,
TimeTableList = data_d
});
}
}
return(new TIMETABLELIST()
{
IsSuccess = true, TABLELIST = lt.ToArray()
});
}
catch (Exception ex)
{
return(new Results
{
IsSuccess = false,
Message = ex.Message
});
}
}