public ActionResult DeleteOutlayInfo(int oId)
{
if (Session["CurrentUser"] != null)
{
using (TransactionScope scope = new TransactionScope())
{
Outlay temp = db.Outlay.Where(u => u.oId == oId).SingleOrDefault();
UserAccount currentUser = Session["CurrentUser"] as UserAccount;
temp.oUpdatedBy = currentUser.uaId;
temp.oUpdatedDate = DateTime.Now;
temp.oDeleted = true;
var lines = db.OutlayLine.Where(u => u.oloId == oId);
foreach (var item in lines)
{
item.olUpdatedBy = currentUser.uaId;
item.olUpdatedDate = DateTime.Now;
item.olDelete = true;
}
db.SaveChanges();
scope.Complete();
}
return(AjaxResult("success", "删除成功"));
}
else
{
return(AjaxResult("error", "未登陆"));
}
}
public ActionResult DeleteConfirmed(int id)
{
Outlay outlay = db.Outlaies.Find(id);
db.Outlaies.Remove(outlay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Outlaies/Edit/5
public ActionResult Edit(int id = 0)
{
Outlay outlay = db.Outlaies.Find(id);
if (outlay == null)
{
return(HttpNotFound());
}
return(View(outlay));
}
public ActionResult Edit(Outlay outlay)
{
if (ModelState.IsValid)
{
db.Entry(outlay).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(outlay));
}
public ActionResult Create(Outlay outlay)
{
if (ModelState.IsValid)
{
db.Outlaies.Add(outlay);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(outlay));
}
// Command function
private void AddDebt()
{
if (Check_Inputs())
{
var outlay = new Outlay
{
Date = (DateTime)SelectedDate,
Name = SelectedName,
Price = int.Parse(SelectedPrice),
Category = SelectedCategory,
CategoryId = SelectedCategory.Id,
DebtId = SelectedDebt.Id,
};
App.DBcache.AddOutlay(outlay);
DefaultData();
}
}
public async Task <IActionResult> CreateOutlay([Bind("Id,DateTimePosted,DateTimeChanged," +
"ApplicationUserId,OutlayDateTime,OutlayDescription,Amount,StatusId")] Outlay outlay)
{
if (ModelState.IsValid)
{
var nBSContext = _context.Outlays
.Include(o => o.Status)
.Include(o => o.Employee);
_context.Add(outlay);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(IndexOutlays)));
}
ViewData["StatusId"] = new SelectList(_context.Statuses, "Id", "StatusName", outlay.StatusId);
ViewData["ApplicationUserId"] = new SelectList(_context.Users, "Id", "UserName", outlay.ApplicationUserId);
return(View(outlay));
}
public ActionResult AddOutlayInfo(string modelJson)
{
try
{
OutlayInfoModel model = JsonConvert.DeserializeObject <OutlayInfoModel>(modelJson);
if (Session["CurrentUser"] != null)
{
UserAccount currentUser = Session["CurrentUser"] as UserAccount;
using (TransactionScope scope = new TransactionScope())
{
Outlay outlay = model.OutlayInfo;
outlay.oUpdatedBy = currentUser.uaId;
outlay.oUpdatedDate = DateTime.Now;
db.Outlay.Add(outlay);
db.SaveChanges();
foreach (OutlayLine line in model.OutlayLines)
{
line.oloId = outlay.oId;
line.olUpdatedBy = currentUser.uaId;
line.olUpdatedDate = DateTime.Now;
db.OutlayLine.Add(line);
db.SaveChanges();
}
scope.Complete();
}
return(AjaxResult("success", "添加成功"));
}
else
{
return(AjaxResult("error", "未登陆"));
}
}
catch (Exception ex)
{
return(AjaxResult("error", ex.Message));
}
}
public async Task <IActionResult> ChangeOutlayStatus(int id, [Bind("Id,DateTimePosted,DateTimeChanged," +
"ApplicationUserId,OutlayDateTime,OutlayDescription,Amount,StatusId")] Outlay outlay)
{
if (id != outlay.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var nBSContext = _context.Outlays
.Include(o => o.Status)
.Include(o => o.Employee);
_context.Update(outlay);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OutlayExists(outlay.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(IndexOutlays)));
}
ViewData["StatusId"] = new SelectList(_context.Statuses, "Id", "StatusName");
ViewData["ApplicationUserId"] = new SelectList(_context.Users, "Id", "FullName");
return(View(outlay));
}
public EditOperationForm(Outlay o)
{
InitializeComponent();
this.o = o;
}
