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));
}