public async Task Post([FromBody] FundAllocation value) { using (PersonalContext pc = new PersonalContext()) { FundAllocation fa = (from p in pc.FundAllocation where p.Symbol == value.Symbol select p).FirstOrDefault(); if (fa != null) { resetFA(ref fa, value); pc.Update(fa); } else { fa = new FundAllocation(); resetFA(ref fa, value); pc.FundAllocation.Add(fa); } try { await pc.SaveChangesAsync(); } catch (Exception ex) { string s = ex.Message; } } }
public IActionResult savePayType(PayType type) { if (_personalContext.PayType.Contains(type)) { _personalContext.Update(type); } else { _personalContext.Add(type); } _personalContext.SaveChanges(); return(Ok()); }
public IActionResult saveCustomRecord(CustomRecord record) { if (_personalContext.CustomRecord.Contains(record)) { _personalContext.Update(record); } else { record.CreatedOn = DateTime.Now; record.UserId = new Guid(_httpContextAccessor.HttpContext.User.FindFirst("userid").Value); _personalContext.CustomRecord.Add(record); } _personalContext.SaveChanges(); return(Ok()); }
public IActionResult saveWages(Wages wage) { if (_personalContext.Wages.Contains(wage)) { _personalContext.Update(wage); } else { wage.CreatedOn = DateTime.Now; wage.UserId = new Guid(_httpContextAccessor.HttpContext.User.FindFirst("userid").Value); _personalContext.Wages.Add(wage); } _personalContext.SaveChanges(); return(Ok()); }
public void Post([FromBody] FundsValue value) { PersonalContext pc = new PersonalContext(); var rec = (from c in pc.FundsValue where c.FundName == value.FundName && c.CyberAccountId == value.CyberAccountId && c.Date > DateTime.Now.AddDays(-10) select c).FirstOrDefault(); if (rec != null) { rec.Value = value.Value; rec.CyberAccountId = value.CyberAccountId; rec.Date = DateTime.Now; pc.Update(rec); } else { FundsValue fv = new FundsValue(); fv.FundName = value.FundName; fv.Value = value.Value; fv.CyberAccountId = value.CyberAccountId; fv.Date = DateTime.Now; pc.FundsValue.Add(fv); } pc.SaveChanges(); }
public async Task <IActionResult> Edit(Guid id, [Bind("Id,Content,StoredImageUrls,NewImages,InsertDate,LastUpdated,UserId")] PersonalPostViewModel personalPostViewModel) { if (id != personalPostViewModel.Id) { return(NotFound()); } if (ModelState.IsValid) { try { PersonalPost personalPost = _context.PersonalPost.Where(p => p.Id == id).FirstOrDefault(); personalPost.Content = personalPostViewModel.Content; personalPost.InsertDate = personalPostViewModel.InsertDate; personalPost.LastUpdated = DateTime.Now; personalPost.UserId = personalPostViewModel.UserId; string existingImages = _context.PersonalPost.Where(p => p.Id == personalPost.Id).FirstOrDefault().ImageUrls; //delete unselected images if (existingImages != null && existingImages != "") { if (personalPostViewModel.StoredImageUrls == null) { _DeleteImages(personalPost.ImageUrls); } else { foreach (string image in personalPost.ImageUrls.Split(";")) { if (!personalPostViewModel.StoredImageUrls.Contains(image)) { _DeleteOneImage(image); } } } } //upload image new images int startNumber = 0; if (personalPost.ImageUrls != null && personalPost.ImageUrls != "") { startNumber = personalPost.ImageUrls.Split(";").Count(); } string[] newImages = _UploadImages(personalPostViewModel.NewImages, personalPost.Id.ToString(), startNumber + 1); personalPost.ImageUrls = _CreateImageUrls(personalPostViewModel.StoredImageUrls, newImages); _context.Update(personalPost); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!_PersonalPostExists(personalPostViewModel.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(personalPostViewModel)); }