public object DisplayMark(TeacherRatingParam obj)
{
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 AssignTeacher = db.TBLASSIGNSTAFFs.Where(r => r.EMPLOYEEID == EmployeeCode).FirstOrDefault();
if (AssignTeacher == null)
{
return(new Results()
{
IsSuccess = false, Message = "Teacher Not Assign"
});
}
List <string> Parameter = db.TBLRATINGMASTERs.OrderBy(r => r.RatingMasterId).Select(r => r.Parameter).ToList();
var PramerterList = db.TBLRATINGMASTERs.Where(r => r.Display == 1).Distinct().ToList();
List <Rate> lt = new List <Rate>();
foreach (var item in Parameter)
{
item.ToList();
double totalcount = 0;
double Counts = 0;
double GetStars = 0;
double GettingStars = 0;
double GetAvrage = 0;
string Stars = "";
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 = db.View_DisplayRate.Where(r => r.TeacherId == EmployeeCode).ToList();
for (int i = 0; i < data_d.Count(); i++)
{
if (item == data_d[i].Parameter)
{
Counts++;
totalcount += Convert.ToDouble(data_d[i].Mark);
GetStars = (totalcount / Counts * 10);
GettingStars = (GetStars * 5) / 100;
GetAvrage = Math.Round(GettingStars);
if (GetAvrage == 1)
{
Stars = "One Star";
}
else if (GetAvrage == 2)
{
Stars = "Two Star";
}
else if (GetAvrage == 3)
{
Stars = "Three Star";
}
else if (GetAvrage == 4)
{
Stars = "Four Star";
}
else
{
Stars = "Five Star";
}
if (Counts <= 1)
{
lt.Add(new Rate
{
PramerterName = item,
Stars = Stars
});
}
else
{
lt.RemoveAll(r => r.PramerterName == item);
lt.Add(new Rate
{
PramerterName = item,
Stars = Stars
});
}
}
//else
//{
// lt.RemoveAll(r => r.Stars =="" && r.PramerterName==item);
// lt.Add(new Rate
// {
// PramerterName = item,
// Stars = Stars
// });
//}
}
if (data_d.Count() == 0)
{
lt.Add(new Rate
{
PramerterName = item,
Stars = Stars
});
}
if (data_d.Count() <= 1)
{
lt.RemoveAll(r => r.PramerterName == item);
lt.Add(new Rate
{
PramerterName = item,
Stars = Stars
});
}
}
return(new RateParameterList()
{
IsSuccess = true, GetStars = lt.ToArray()
});
}
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
});
}
}
