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();
}
