public HttpResponseMessage Delete(int id) { try { using (SMSDBEntities entities = new SMSDBEntities()) { var question = entities.questions.FirstOrDefault(q => q.qid == id); if (question == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Question with id = " + id + " not found")); } else { entities.questions.Remove(question); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.OK); message.Headers.Location = new Uri(Request.RequestUri + id.ToString()); return(message); } } } catch (Exception exp) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exp)); } }
public HttpResponseMessage Put(int id, [FromBody] survey survey) { try { using (SMSDBEntities entities = new SMSDBEntities()) { var entity = entities.surveys.FirstOrDefault(s => s.sid == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Survey with id = " + id.ToString() + " not found to update")); } else { entity.title = survey.title; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception exp) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exp)); } }
public IEnumerable <question> Get(int id) { using (SMSDBEntities entities = new SMSDBEntities()) { entities.Configuration.ProxyCreationEnabled = false; return(entities.questions.Where(q => q.sid == id).ToList()); } }
public IEnumerable <survey> Get() { using (SMSDBEntities entities = new SMSDBEntities()) { entities.Configuration.ProxyCreationEnabled = false; return(entities.surveys.ToList()); } }
public HttpResponseMessage Get(int id) { using (SMSDBEntities entities = new SMSDBEntities()) { entities.Configuration.ProxyCreationEnabled = false; var survey = entities.surveys.FirstOrDefault(s => s.sid == id); if (survey != null) { return(Request.CreateResponse(HttpStatusCode.OK, survey)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Survey with id = " + id + " not found")); } } }
public HttpResponseMessage Post([FromBody] question question) { try { using (SMSDBEntities entities = new SMSDBEntities()) { entities.questions.Add(question); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, question); message.Headers.Location = new Uri(Request.RequestUri + question.qid.ToString()); return(message); } } catch (Exception exp) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exp)); } }
public CustomRepository(SMSDBEntities context) { this.context = context; }
public SPRepository(SMSDBEntities context) { context = this.context; }
public PaymentRepository() { _smsdb = new SMSDBEntities(); }
public StudentRepository() { _smsdb = new SMSDBEntities(); }
/// <summary> /// Initializes a new instance of the <see cref="GenericRepository{TEntity}"/> class. /// </summary> /// <param name="context">The context.</param> /// <CreatedBy>Shohid</CreatedBy> /// <DateOfCreation>Jan-03-2017</DateOfCreation> public GenericRepository(SMSDBEntities context) { this.context = context; this.dbSet = context.Set <TEntity>(); }
public GradeRepository() { _smsdb = new SMSDBEntities(); }