public IHttpActionResult PutClass(long id, Class @class)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != @class.PKClassId)
{
return(BadRequest());
}
db.Entry(@class).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ClassExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutUserVideo(long id, UserVideo userVideo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userVideo.PKUserVideoId)
{
return(BadRequest());
}
db.Entry(userVideo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserVideoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutAvailableTeacherTime(long id, AvailableTeacherTime availableTeacherTime)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != availableTeacherTime.PKAvailableTeacherTimeId)
{
return(BadRequest());
}
db.Entry(availableTeacherTime).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AvailableTeacherTimeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutTeacherProfile(long id, TeacherProfile teacherProfile)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != teacherProfile.PKTeachersId)
{
return(BadRequest());
}
db.Entry(teacherProfile).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherProfileExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutSubject(long id, Subject subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != subject.PKSubjectId)
{
return(BadRequest());
}
db.Entry(subject).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SubjectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void InsertUserEnquiry(UserEnquiry objUserEnquiry)
{
TeachersEntities db = new TeachersEntities();
db.UserEnquiries.Add(objUserEnquiry);
db.SaveChanges();
}
public static void UpdateLoginHistory(LoginHistory objLoginHistory)
{
TeachersEntities db = new TeachersEntities();
db.Entry(objLoginHistory).State = EntityState.Modified;
db.SaveChanges();
}
public static void InsertLoginHistory(LoginHistory objLoginHistory)
{
TeachersEntities db = new TeachersEntities();
db.LoginHistories.Add(objLoginHistory);
db.SaveChanges();
}
public static void InsertUserImages(UserImage objUserImage)
{
TeachersEntities db = new TeachersEntities();
db.UserImages.Add(objUserImage);
db.SaveChanges();
}
public static void UpdateUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.Entry(userVideo).State = EntityState.Modified;
db.SaveChanges();
}
public static void UpdateUserEnquiry(UserEnquiry objUserEnquiry)
{
TeachersEntities db = new TeachersEntities();
db.Entry(objUserEnquiry).State = EntityState.Modified;
db.SaveChanges();
}
public static void InsertUserVideo(UserVideo userVideo)
{
TeachersEntities db = new TeachersEntities();
db.UserVideos.Add(userVideo);
db.SaveChanges();
}
public static void InsertCity(City objCity)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Cities.Add(objCity);
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 void DeleteUserImages(int userImageId)
{
TeachersEntities db = new TeachersEntities();
UserImage objUserImage = db.UserImages.Find(userImageId);
db.UserImages.Remove(objUserImage);
db.SaveChanges();
}
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 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 void InsertAvailableTeacherTime(AvailableTeacherTime objAvailableTeacherTime)
{
TeachersEntities db = new TeachersEntities();
db.AvailableTeacherTimes.Add(objAvailableTeacherTime);
db.SaveChanges();
cache.Remove("GetTeachersHome");
}
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 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 InsertTeacherProfile(TeacherProfile objTeacherProfile)
{
TeachersEntities db = new TeachersEntities();
db.TeacherProfiles.Add(objTeacherProfile);
db.SaveChanges();
cache.Remove("GetTeachersHome");
}
public static void DeleteAvailableTeacherTime(long availableTeacherTimeId)
{
TeachersEntities db = new TeachersEntities();
AvailableTeacherTime objAvailableTeacherTime = db.AvailableTeacherTimes.Find(availableTeacherTimeId);
db.AvailableTeacherTimes.Remove(objAvailableTeacherTime);
db.SaveChanges();
cache.Remove("GetTeachersHome");
}
public static void InsertSubject(Subject objSubject)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Subjects.Add(objSubject);
db.SaveChanges();
}
cache.Remove("GetSubjects");
}
public static void UpdateSubject(Subject objSubject)
{
using (TeachersEntities db = new TeachersEntities())
{
db.Entry(objSubject).State = EntityState.Modified;
db.SaveChanges();
}
cache.Remove("GetSubjects");
}
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();
}
}