public IHttpActionResult Put(LSchoolViewModel bp) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingLs = ctx.LSCHOOLMSTs.Where(s => s.TRNNO == bp.TRNNO) .FirstOrDefault <LSCHOOLMST>(); if (existingLs != null) { existingLs.CLASS_TRNNO = bp.CLASS_TRNNO; existingLs.LDATE = bp.LDATE; ctx.SaveChanges(); } else { return(NotFound()); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(Ok()); }
public IHttpActionResult GetLsById(int id) { LSchoolViewModel lss = null; using (var ctx = new EMSEntities()) { lss = ctx.LSCHOOLMSTs .Where(s => s.TRNNO == id) .Select(s => new LSchoolViewModel() { TRNNO = s.TRNNO, CLASS_TRNNO = s.CLASS_TRNNO, LDATE = s.LDATE }).FirstOrDefault <LSchoolViewModel>(); } if (lss == null) { return(NotFound()); } return(Ok(lss)); }
public IHttpActionResult PostNewLs(LSchoolViewModel ls) { int _sr = 1; if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new EMSEntities()) { int _trnno; if (ls.TRNNO == 0) { _trnno = Convert.ToInt32(ctx.LSCHOOLMSTs.OrderByDescending(t => t.TRNNO).FirstOrDefault().TRNNO); _trnno = _trnno + 1; } else { _trnno = Convert.ToInt32(ls.TRNNO) + 1; } ls.TRNNO = _trnno; ctx.LSCHOOLMSTs.Add(new LSCHOOLMST() { TRNNO = ls.TRNNO, CLASS_TRNNO = ls.CLASS_TRNNO, LDATE = ls.LDATE }); foreach (var dtls in ls.LSCHOOLDTLs) { if (dtls.isLeft == true) { var LSdetail = new LSCHOOLDTL { TRNNO = _trnno, SR = _sr, EM_TRNNO = dtls.EM_TRNNO }; ctx.LSCHOOLDTLs.Add(LSdetail); _sr++; } } try { ctx.SaveChanges(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } } return(Ok()); }