public IEnumerable <Mark> Get()
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
return(entities.Marks.ToList());
}
}
// Put Method
public HttpResponseMessage Put(int id, [FromBody] Mark mark)
{
try
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
var entity = entities.Marks.FirstOrDefault(s => s.Id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id = " + id.ToString() + " not found to update"));
}
else
{
entity.StdntId = mark.StdntId;
entity.StdntName = mark.StdntName;
entity.Course = mark.Course;
entity.Date = mark.Date;
entity.Status = mark.Status;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IEnumerable <Student> Get()
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
return(entities.Students.ToList());
}
}
public IEnumerable <EmpDailyTimeRecord> Get()
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
return(entities.EmpDailyTimeRecords.ToList());
}
}
public static bool Login(string username, string password)
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
return(entities.Users.Any(user => user.Username.Equals(username,
StringComparison.OrdinalIgnoreCase) && user.Password == password));
}
}
// Get Method
public HttpResponseMessage Get(int id)
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
var entity = entities.Marks.FirstOrDefault(s => s.Id == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id = " + id.ToString() + " not found"));
}
}
}
// Post Method
public HttpResponseMessage Post([FromBody] Mark mark)
{
try
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
entities.Marks.Add(mark);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, mark);
message.Headers.Location = new Uri(Request.RequestUri + mark.Id.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
// Delete Method
public HttpResponseMessage Delete(int id)
{
try
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
var entity = entities.Marks.FirstOrDefault(s => s.Id == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id = " + id.ToString() + " not found to delete"));
}
else
{
entities.Marks.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Get(string course = "All")
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
switch (course.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.TestTables.ToList()));
case "se":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.TestTables.Where(s => s.Course.ToLower() == "se").ToList()));
case "dba":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.TestTables.Where(s => s.Course.ToLower() == "dba").ToList()));
default:
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,
"Value for course must be All, SE or DBA." + course + " is invalid"));
}
}
}
public HttpResponseMessage Get(string course = "All")
{
using (CBCSchoolEntities entities = new CBCSchoolEntities())
{
switch (course.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.StdntMarks.ToList()));
case "se":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.StdntMarks.Where(s => s.Course.ToLower() == "se").ToList()));
case "dba":
return(Request.CreateResponse(HttpStatusCode.OK,
entities.StdntMarks.Where(s => s.Course.ToLower() == "dba").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.OK,
entities.StdntMarks.ToList()));
}
}
}
