public static void UpdateUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.Entry(userVideo).State = EntityState.Modified;
db.SaveChanges();
}
public static void InsertUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.UserVideos.Add(userVideo);
db.SaveChanges();
}
public static TeacherTimeDetails GetTeacherTimeDetails(long classId)
{
TeachersEntities db = new TeachersEntities();
var qry = from up in db.UserProfiles
join cls in db.Classes on up.PKUserId equals cls.FKUserId
join at in db.AvailableTeacherTimes on cls.PKClassId equals at.FKClassId
join tp in db.TeacherProfiles on cls.PKClassId equals tp.FKClassId
join sub in db.Subjects on cls.FKSubjectId equals sub.PKSubjectId
where cls.PKClassId == classId
select new TeacherTimeDetails
{
UserId = up.PKUserId,
ClassId = cls.PKClassId,
TeacherName = up.UserName,
FromAvailableDate = at.FromAvailableDate.ToString(),
ToAvailableDate = at.ToAvailableDate.ToString(),
FromAvailableTime = at.FromAvailableTime.ToString(),
ToAvailableTime = at.ToAvailableTime.ToString(),
SubjectName = sub.SubjectName,
Rating = tp.Rating.Value,
TeacherImageUrl = up.PhotoUrl,
TeacherId = tp.PKTeachersId,
EmailId = up.EmailId,
PhoneNo = up.PhoneNo,
Description = tp.Description
};
//var q1 = qry.GroupBy(x => x.EmailId).Select(x => x.FirstOrDefault()).ToList();
// return qry.ToList(); ;
return(qry.FirstOrDefault());
}
//Teacher Profile
public static TeacherProfile GetTeacher(long teacherProfileId)
{
TeachersEntities db = new TeachersEntities();
db.Configuration.LazyLoadingEnabled = false;
return(db.TeacherProfiles.Include("UserProfile").Where(t => t.PKTeachersId == teacherProfileId).SingleOrDefault());
}
public static void InsertUserImages(UserImage objUserImage)
{
TeachersEntities db = new TeachersEntities();
db.UserImages.Add(objUserImage);
db.SaveChanges();
}
public static Subject GetSubject(long subjectId)
{
TeachersEntities db = new TeachersEntities();
db.Configuration.LazyLoadingEnabled = false;
return(db.Subjects.Where(s => s.PKSubjectId == subjectId).SingleOrDefault());
}
public static void UpdateUserEnquiry(UserEnquiry objUserEnquiry)
{
TeachersEntities db = new TeachersEntities();
db.Entry(objUserEnquiry).State = EntityState.Modified;
db.SaveChanges();
}
public static TeacherTimeDetails TeacherToBookDetails(long classId)
{
TeachersEntities db = new TeachersEntities();
var qry = from up in db.UserProfiles
join cls in db.Classes on up.PKUserId equals cls.FKUserId
join at in db.AvailableTeacherTimes on cls.PKClassId equals at.FKClassId
join tch in db.TeacherProfiles on cls.PKClassId equals tch.FKClassId
join sub in db.Subjects on cls.FKSubjectId equals sub.PKSubjectId
where cls.PKClassId == classId
select new TeacherTimeDetails
{
UserId = up.PKUserId,
ClassId = cls.PKClassId,
TeacherId = tch.PKTeachersId,
AvailableTeacherTimeId = at.PKAvailableTeacherTimeId,
TeacherName = up.UserName,
//ImageName = ui.ImageName,
//ImageUrl = ui.ImageUrl,
//VideoUrl = ui.VideoUrl,
FromAvailableDate = at.FromAvailableDate.ToString(),
ToAvailableDate = at.ToAvailableDate.ToString(),
FromAvailableTime = at.FromAvailableTime.ToString(),
ToAvailableTime = at.ToAvailableTime.ToString(),
SubjectName = sub.SubjectName,
EmailId = up.EmailId
};
// var q1 = qry.GroupBy(x => x.EmailId).Select(x => x.FirstOrDefault()).SingleOrDefault();
return(qry.SingleOrDefault());
}
public static void UpdateLoginHistory(LoginHistory objLoginHistory)
{
TeachersEntities db = new TeachersEntities();
db.Entry(objLoginHistory).State = EntityState.Modified;
db.SaveChanges();
}
public static void InsertUserEnquiry(UserEnquiry objUserEnquiry)
{
TeachersEntities db = new TeachersEntities();
db.UserEnquiries.Add(objUserEnquiry);
db.SaveChanges();
}
public static void InsertLoginHistory(LoginHistory objLoginHistory)
{
TeachersEntities db = new TeachersEntities();
db.LoginHistories.Add(objLoginHistory);
db.SaveChanges();
}
//List of Cities
public static List <UserProfile> GetCities()
{
TeachersEntities db = new TeachersEntities();
var q = db.UserProfiles.Distinct().GroupBy(x => x.City).Select(x => x.FirstOrDefault()).Where(x => x.FKRoleId == 2);
return(q.ToList());
}
public static List <UserComment> GetUserComments(long classId)
{
using (TeachersEntities db = new TeachersEntities())
{
return(db.UserComments.Where(x => x.FKClassId == classId).ToList());
}
}
public static void InsertTeacherProfile(TeacherProfile objTeacherProfile)
{
TeachersEntities db = new TeachersEntities();
db.TeacherProfiles.Add(objTeacherProfile);
db.SaveChanges();
cache.Remove("GetTeachersHome");
}
public static void InsertUsers(UserProfile objUser)
{
TeachersEntities db = new TeachersEntities();
db.UserProfiles.Add(objUser);
db.SaveChanges();
cache.Remove("UserProfile");
}
public static void UpdateCity(City objCity)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Entry(objCity).State = EntityState.Modified;
db.SaveChanges();
}
}
public static City GetCity(long CityId)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Configuration.LazyLoadingEnabled = false;
return(db.Cities.Find(CityId));
}
}
public static void DeleteLoginHistory(int loginHistoryId)
{
TeachersEntities db = new TeachersEntities();
LoginHistory objLoginHistory = db.LoginHistories.Find(loginHistoryId);
db.LoginHistories.Remove(objLoginHistory);
db.SaveChanges();
}
public static void DeleteUserImages(int userImageId)
{
TeachersEntities db = new TeachersEntities();
UserImage objUserImage = db.UserImages.Find(userImageId);
db.UserImages.Remove(objUserImage);
db.SaveChanges();
}
public static void DeleteUserEnquiry(int userEnquiryId)
{
TeachersEntities db = new TeachersEntities();
UserEnquiry objUserEnquiry = db.UserEnquiries.Find(userEnquiryId);
db.UserEnquiries.Remove(objUserEnquiry);
db.SaveChanges();
}
public static void InsertAvailableTeacherTime(AvailableTeacherTime objAvailableTeacherTime)
{
TeachersEntities db = new TeachersEntities();
db.AvailableTeacherTimes.Add(objAvailableTeacherTime);
db.SaveChanges();
cache.Remove("GetTeachersHome");
}
public static void InsertCity(City objCity)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Cities.Add(objCity);
db.SaveChanges();
}
}
public static void UpdateUsers(UserProfile objuser)
{
TeachersEntities db = new TeachersEntities();
db.Entry(objuser).State = EntityState.Modified;
db.SaveChanges();
cache.Remove("UserProfile");
}
public static void AddUserComments(UserComment userComments)
{
using (TeachersEntities db = new TeachersEntities())
{
db.UserComments.Add(userComments);
db.SaveChanges();
}
}
public static void DeleteUserVideo(long id)
{
TeachersEntities db = new TeachersEntities();
UserVideo userVideo = db.UserVideos.Find(id);
db.UserVideos.Remove(userVideo);
db.SaveChanges();
}
public static State GetState(long stateId)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Configuration.LazyLoadingEnabled = false;
return(db.States.Where(x => x.PKStateId == stateId).FirstOrDefault());
}
}
public static void DeleteUsers(int userId)
{
TeachersEntities db = new TeachersEntities();
UserProfile objUser = db.UserProfiles.Find(userId);
db.UserProfiles.Remove(objUser);
db.SaveChanges();
cache.Remove("UserProfile");
}
public static void UpdateState(State objState)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Entry(objState).State = EntityState.Modified;
db.SaveChanges();
cache.Remove("GetStates");
}
}
public static void InsertState(State objState)
{
using (TeachersEntities db = new TeachersEntities())
{
db.States.Add(objState);
db.SaveChanges();
cache.Remove("GetStates");
}
}
public static void DeleteCity(long cityId)
{
using (TeachersEntities db = new TeachersEntities())
{
City objCity = db.Cities.Find(cityId);
db.Cities.Remove(objCity);
db.SaveChanges();
}
}
