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); } }
public HttpResponseMessage AddTerm(Entities.MstTerm objTerm) { try { var currentUser = from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var currentUserId = currentUser.FirstOrDefault().Id; var userForms = from d in db.MstUserForms where d.UserId == currentUserId && d.SysForm.FormName.Equals("SystemTables") select d; if (userForms.Any()) { if (userForms.FirstOrDefault().CanAdd) { Data.MstTerm newTerm = new Data.MstTerm { Term = objTerm.Term, NumberOfDays = objTerm.NumberOfDays, IsLocked = true, CreatedById = currentUserId, CreatedDateTime = DateTime.Now, UpdatedById = currentUserId, UpdatedDateTime = DateTime.Now }; db.MstTerms.InsertOnSubmit(newTerm); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, newTerm.Id)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add term.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system table page.")); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in.")); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server.")); } }
public Int32 postTerm() { try { Data.MstTerm newTerm = new Data.MstTerm(); newTerm.Term = "n/a"; newTerm.NumberOfDays = 0; db.MstTerms.InsertOnSubmit(newTerm); db.SubmitChanges(); return(newTerm.Id); } catch (Exception e) { return(0); } }
public int Post(Models.MstTerm term) { try { Data.MstTerm newTerm = new Data.MstTerm(); // newTerm.Term = term.Term; newTerm.NumberOfDays = term.NumberOfDays; // db.MstTerms.InsertOnSubmit(newTerm); db.SubmitChanges(); return newTerm.Id; } catch { return 0; } }