public object Communicate(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 StudentDetails = db.TBLTRANSFERSTUDENTs.Where(r => r.ACADEMICYEAR == AcademicYear.ACADEMICYEAR && r.STUDENTID == EmployeeCode).FirstOrDefault();
int StandardId = Convert.ToInt32(StudentDetails.STANDARDID);
int DivisionId = Convert.ToInt32(StudentDetails.DIVISIONID);
var GetTeacherDetails = db.View_Communiation.Where(r => r.STANDARDID == StandardId && r.DIVISIONID == DivisionId).FirstOrDefault();
if (GetTeacherDetails == null)
{
return(new Results()
{
IsSuccess = false, Message = "Teacher Not Found"
});
}
else
{
return(new TeacherData()
{
IsSuccess = true, TeacherInformation = GetTeacherDetails
});
}
}
public object CommunicationToParents(TeacherRatingParam obj)
{
try
{
CommunicationBusiness objp = new CommunicationBusiness();
var Rate = objp.CommunicateWithParents(obj);
return(Rate);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object DisplayRating(TeacherRatingParam obj)
{
try
{
RatingBusiness objp = new RatingBusiness();
var Rate = objp.DisplayMark(obj);
return(Rate);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object CommunicateWithParents(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 GetTeacherDeatils = db.TBLASSIGNCLASSTEACHERs.Where(r => r.EMPLOYEEID == EmployeeCode).FirstOrDefault();
var StandardId = GetTeacherDeatils.STANDARDID.ToString();
int DivisionId = Convert.ToInt16(GetTeacherDeatils.DIVISIONID);
var GetStudents = //db.TBLTRANSFERSTUDENTs.Where(r => r.STANDARDID == StandardId && r.DIVISIONID == DivisionId).ToList();
from c in db.View_DisplayStudentDetails.Where(r => r.STANDARDID == StandardId && r.DIVISIONID == DivisionId)
select new { c.STUDENTNAME, c.GENDER, c.DOB, c.GMOBILE, c.IMAGEPATH, c.STUDENTID };
return(GetStudents);
}
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()
});
}