public HttpResponseMessage Put(int id, [FromBody] Teacher employee)
{
using (TeacherEntities db = new TeacherEntities())
{
try
{
var entity = db.Teachers.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id=" + id.ToString() + "not found to update"));
}
else
{
entity.Name = employee.Name;
entity.Age = employee.Age;
entity.Dep = employee.Dep;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public IEnumerable <Teacher> GetEmployees()
{
using (TeacherEntities db = new TeacherEntities())
{
return(db.Teachers.ToList());
}
}
public ActionResult SaveOrUpdate(TeacherEntities teachenetities)
{
TeacherBL teacherBl = new TeacherBL();
int recordAffected = teacherBl.SaveOrUpdate(teachenetities);
return(Json(recordAffected, JsonRequestBehavior.AllowGet));
}
/*
* The controller will retrieve all the actions based on the browser requests.
* In this case, it will make the requests to the database using the models and
* givin back an answer to the view.**/
// GET Teacher/GetTeacher
public JsonResult GetTeacher()
{
using (var database = new TeacherEntities())
{
List <Teacher> listTeachers = database.Teachers.ToList();
return(Json(listTeachers, JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult Delete(int id)
{
using (var db = new TeacherEntities())
{
var teacher = db.Teacher_Info.Where(s => s.Teacher_Id == id).FirstOrDefault();
db.Entry(teacher).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
return(Ok());
}
public JsonResult AddNewTeacher(Teacher teacher)
{
if (teacher != null)
{
using (var database = new TeacherEntities())
{
database.Teachers.Add(teacher);
database.SaveChanges();
return(Json(new { success = true }));
}
}
return(Json(new { success = false }));
}
public HttpResponseMessage GetEmployeeById(int id)
{
using (TeacherEntities db = new TeacherEntities())
{
var entity = db.Teachers.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id=" + id.ToString() + " not found"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
public HttpResponseMessage Delete(int id)
{
using (TeacherEntities db = new TeacherEntities())
{
var entity = db.Teachers.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id=" + id.ToString() + "not found to delete"));
}
else
{
db.Teachers.Remove(entity);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
public int SaveOrUpdate(TeacherEntities teacher)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("usp_Insert_Update_Teacher", con);
cmd.CommandType = CommandType.StoredProcedure;
if (string.IsNullOrEmpty(teacher.ID.ToString()) || (teacher.ID == 0))
{
cmd.Parameters.AddWithValue("@ID", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ID", teacher.ID);
}
cmd.Parameters.AddWithValue("@FName", teacher.FName);
cmd.Parameters.AddWithValue("@LName", teacher.LName);
cmd.Parameters.AddWithValue("@Photo", teacher.Photo);
cmd.Parameters.AddWithValue("@Gender", teacher.Gender);
cmd.Parameters.AddWithValue("@Address", teacher.Address);
cmd.Parameters.AddWithValue("@Ph1", teacher.Ph1);
cmd.Parameters.AddWithValue("@Ph2", teacher.Ph2);
cmd.Parameters.AddWithValue("@StartDate", teacher.StartDate);
cmd.Parameters.AddWithValue("@EndDate", teacher.EndDate);
cmd.Parameters.AddWithValue("@Comments", teacher.Comments);
cmd.Parameters.AddWithValue("@Designation", teacher.Designation);
cmd.Parameters.AddWithValue("@QualificationID", teacher.TeacherQualificationID);
cmd.Parameters.AddWithValue("@QualName", teacher.QualName);
cmd.Parameters.AddWithValue("@QualCertPath", teacher.QualCertPath);
cmd.Parameters.AddWithValue("@QualStatus", teacher.QualStatus);
cmd.Parameters.AddWithValue("@QualCompletionDate", teacher.QualCompletionDate);
cmd.Parameters.AddWithValue("@TeacherSubjectId", teacher.TeacheSubjectId);
cmd.Parameters.AddWithValue("@TeacherIDinQualification", teacher.TeacherIDInTeacherQualification);
cmd.Parameters.AddWithValue("@SubjectID", teacher.SubjectID);
cmd.Parameters.AddWithValue("@isPrimarySubject", teacher.isPrimarySubject);
int recordAffected = cmd.ExecuteNonQuery();
return(recordAffected);
}
public HttpResponseMessage Post([FromBody] Teacher employee)
{
try
{
using (TeacherEntities db = new TeacherEntities())
{
db.Teachers.Add(employee);
db.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, employee);
message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IHttpActionResult PostTeacher(Teacher_View t)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Data."));
}
using (var db = new TeacherEntities())
{
db.Teacher_Info.Add(new Teacher_Info()
{
Teacher_Id = t.Id,
Teacher_Name = t.Name,
Teacher_Email = t.email
});
db.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetTeacher()
{
IList <Teacher_View> tech = null;
using (var db = new TeacherEntities())
{
tech = db.Teacher_Info.Select(s => new Teacher_View()
{
Id = s.Teacher_Id,
Name = s.Teacher_Name,
email = s.Teacher_Email
}).ToList <Teacher_View>();
}
if (tech.Count == 0)
{
return(NotFound());
}
return(Ok(tech));
}
public IHttpActionResult PutTeacher(Teacher_View t)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Data."));
}
using (var db = new TeacherEntities())
{
var et = db.Teacher_Info.Where(s => s.Teacher_Id == t.Id).FirstOrDefault <Teacher_Info>();
if (et != null)
{
et.Teacher_Name = t.Name;
et.Teacher_Email = t.email;
db.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public int SaveOrUpdate(TeacherEntities teacher)
{
TeacherDAL teacherDl = new TeacherDAL();
return(teacherDl.SaveOrUpdate(teacher));
}
