public HttpResponseMessage updateTerm(String id, Models.MstTerm term)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
var terms = from d in db.MstTerms where d.Id == Convert.ToInt32(id) select d;
if (terms.Any())
{
var updateTerm = terms.FirstOrDefault();
updateTerm.Term = term.Term;
updateTerm.NumberOfDays = term.NumberOfDays;
updateTerm.IsLocked = term.IsLocked;
updateTerm.UpdatedById = userId;
updateTerm.UpdatedDateTime = DateTime.Now;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public Int32 insertTerm(Models.MstTerm term)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstTerm newTerm = new Data.MstTerm();
newTerm.Term = term.Term;
newTerm.NumberOfDays = term.NumberOfDays;
newTerm.IsLocked = term.IsLocked;
newTerm.CreatedById = userId;
newTerm.CreatedDateTime = DateTime.Now;
newTerm.UpdatedById = userId;
newTerm.UpdatedDateTime = DateTime.Now;
db.MstTerms.InsertOnSubmit(newTerm);
db.SubmitChanges();
return(newTerm.Id);
}
catch
{
return(0);
}
}
