public tbl_tutor Get(string id)
{
using (hivetutEntities entities = new hivetutEntities())
{
return(entities.tbl_tutor.FirstOrDefault(t => t.Email == id));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (hivetutEntities entities = new hivetutEntities())
{
var entity = entities.tbl_tutor.Remove(entities.tbl_tutor.FirstOrDefault(t => t.ID == id));
if (entity == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Tutor with ID=" + id.ToString() + "not found to be deleted"));
}
else
{
entities.tbl_tutor.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Tutor with ID=" + id.ToString() + " has been successfuly deleted"));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
public IEnumerable <tbl_tutor> Get()
{
using (hivetutEntities entities = new hivetutEntities())
{
return(entities.tbl_tutor.ToList());
}
}
public IHttpActionResult Post(tbl_student tutor)
{
hivetutEntities db = new hivetutEntities();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tbl_student.Add(tutor);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new
{
id = tutor.id
}, tutor));
}
public IHttpActionResult Post(tbl_tutor employee)
{
hivetutEntities db = new hivetutEntities();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tbl_tutor.Add(employee);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new
{
id = employee.ID
}, employee));
}
public HttpResponseMessage Put(int id, [FromBody] tbl_tutor tutor)
{
try
{
using (hivetutEntities entities = new hivetutEntities())
{
var entity = entities.tbl_tutor.FirstOrDefault(t => t.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Tutor with ID=" + id.ToString() + "not found to be updated"));
}
else
{
entity.City = tutor.City;
entity.Qualified = tutor.Qualified;
entity.Experience = tutor.Experience;
entity.Subjects = tutor.Subjects;
entity.Classes = tutor.Classes;
entity.Available = tutor.Available;
entity.Description = tutor.Description;
entity.Name = tutor.Name;
entity.Gender = tutor.Gender;
entity.Email = tutor.Email;
entity.Address = tutor.Address;
entity.Dob = tutor.Dob;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Tutor with ID=" + id.ToString() + " has been successfuly updated"));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
//Update Student Profile
public HttpResponseMessage Put(string email, [FromBody] tbl_student tutor)
{
try
{
using (hivetutEntities entities = new hivetutEntities())
{
var entity = entities.tbl_student.FirstOrDefault(t => t.Email == email);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with email=" + email.ToString() + "not found to be updated"));
}
else
{
entity.City = tutor.City;
entity.Class = tutor.Class;
entity.Description = tutor.Description;
entity.Subjects = tutor.Subjects;
entity.Name = tutor.Name;
entity.Gender = tutor.Gender;
entity.Email = tutor.Email;
entity.Address = tutor.Address;
entity.Dob = tutor.Dob;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Student with email=" + email.ToString() + " has been successfuly updated"));
}
}
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e));
}
}
