public IHttpActionResult GetFeeCollectById(int id) { FeeCollectViewModel fcs = null; using (var ctx = new EMSEntities()) { fcs = ctx.FEECOLLECTMSTs .Where(s => s.TRNNO == id) .Select(s => new FeeCollectViewModel() { TRNNO = s.TRNNO, RDATE = s.RDATE, EM_TRNNO = s.EM_TRNNO, FMONTH = s.FMONTH, DDATE = s.DDATE, LDATE = s.LDATE, FSTATUS = s.FSTATUS, DISCOUNT = s.DISCOUNT, DISCOUNTTYPE = s.DISCOUNTTYPE, CLASS_TRNNO = s.CLASS_TRNNO, SECDTL_TRNNO = s.SECDTL_TRNNO, SECDTL_SR = s.SECDTL_SR, PDATE = s.PDATE, ARRFLG = s.ARRFLG, }).FirstOrDefault <FeeCollectViewModel>(); } if (fcs == null) { return(NotFound()); } return(Ok(fcs)); }
public IHttpActionResult getCurrentFee(FeeCollectViewModel fcCVm) { ObjectParameter FEE1 = new System.Data.Entity.Core.Objects.ObjectParameter("FEE1", typeof(double)); if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new EMSEntities()) { ctx.spStudentCurrentFee(fcCVm.EM_TRNNO, FEE1, fcCVm.CLASS_TRNNO); var res = FEE1.Value; if (res == null) { return(NotFound()); } return(Ok(res)); } }
public IHttpActionResult Put(FeeCollectViewModel fc) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingFeeCollect = ctx.FEECOLLECTMSTs.Where(s => s.TRNNO == fc.TRNNO) .FirstOrDefault <FEECOLLECTMST>(); if (existingFeeCollect != null) { existingFeeCollect.RDATE = fc.RDATE; existingFeeCollect.EM_TRNNO = fc.EM_TRNNO; existingFeeCollect.FMONTH = fc.FMONTH; existingFeeCollect.DDATE = fc.DDATE; existingFeeCollect.LDATE = fc.LDATE; existingFeeCollect.FSTATUS = fc.FSTATUS; existingFeeCollect.DISCOUNT = fc.DISCOUNT; existingFeeCollect.DISCOUNTTYPE = fc.DISCOUNTTYPE; existingFeeCollect.CLASS_TRNNO = fc.CLASS_TRNNO; existingFeeCollect.SECDTL_TRNNO = fc.SECDTL_TRNNO; existingFeeCollect.SECDTL_SR = fc.SECDTL_SR; existingFeeCollect.PDATE = fc.PDATE; existingFeeCollect.ARRFLG = fc.ARRFLG; foreach (var dtl in fc.FEECOLLECTDTLs) { var mkdetail = new FEECOLLECTDTL { TRNNO = dtl.TRNNO, FMONTH = dtl.FMONTH, FEETYPE_TRNNO = dtl.FEETYPE_TRNNO, SR = dtl.SR, AMT = dtl.AMT, FEEMON = dtl.FEEMON, }; ctx.Entry(mkdetail).State = System.Data.Entity.EntityState.Modified; } 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 PostNewFeeCollect(FeeCollectViewModel fc) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new EMSEntities()) { int _trnno; int _sr = 1; //db.Users.OrderByDescending(u => u.UserId).FirstOrDefault(); if (fc.TRNNO == 0) { _trnno = Convert.ToInt32(ctx.FEECOLLECTMSTs.OrderByDescending(t => t.TRNNO).FirstOrDefault().TRNNO); // _trnno = _trnno + 1; //_trnno = Convert.ToInt32(ctx.EMs.OrderByDescending(t => t.TRNNO).First().ToString()); } else { _trnno = Convert.ToInt32(fc.TRNNO) + 1; } // int totalConunt = ctx.FEECOLLECTMSTs.Count<MARKTOTAL>(); fc.TRNNO = _trnno; ctx.ALLCLASSVOUCHERS(fc.RDATE, fc.TRNNO, fc.DDATE, fc.FMONTH, fc.LDATE); //ctx.FEECOLLECTMSTs.Add(new FEECOLLECTMST() //{ // TRNNO = fc.TRNNO, // RDATE = fc.RDATE, // EM_TRNNO = fc.EM_TRNNO, // FMONTH = fc.FMONTH, // DDATE = fc.DDATE, // LDATE = fc.LDATE, // FSTATUS = fc.FSTATUS, // DISCOUNT = fc.DISCOUNT, // DISCOUNTTYPE = fc.DISCOUNTTYPE, // CLASS_TRNNO = fc.CLASS_TRNNO, // SECDTL_TRNNO = fc.SECDTL_TRNNO, // SECDTL_SR = fc.SECDTL_SR, // PDATE = fc.PDATE, // ARRFLG = fc.ARRFLG, //}); //foreach (var dtls in fc.FEECOLLECTDTLs) //{ // var fcdetail = new FEECOLLECTDTL // { // //BudgetId = Here i need to get id of the Budget table that i inserted before // TRNNO = _trnno, // FMONTH = dtls.FMONTH, // FEETYPE_TRNNO = dtls.FEETYPE_TRNNO, // SR = _sr, // AMT = dtls.AMT, // FEEMON = dtls.FEEMON, // }; // ctx.FEECOLLECTDTLs.Add(fcdetail); // _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()); }