public ActionResult LendingManage([Bind(Include = "CardIssueId,CardId,IssuedOn, ReturnedOn,ExpiresOn,ToPerson,ContactDetails,DepositAmt")] CardIssue cardIssue)
{
//check if card is already issued
var preissu = db.SingleOrDefault <CardIssue>("select * from CardIssue where CardId=@0 and CardIssueId<>@1 and " +
"(@2 between IssuedOn and ReturnedOn OR (@2 > IssuedOn and ReturnedOn IS null))", cardIssue.CardId, cardIssue.CardIssueId, cardIssue.IssuedOn);
if (preissu != null)
{
ViewBag.preissu = preissu;
ViewBag.CardId = new SelectList(db.Fetch <CashCard>("Select * from CashCard where discarded=0"), "CardID", "CardName");
return(View(base.BaseCreateEdit <CardIssue>(null, "CardIssueID")));
}
return(base.BaseSave <CardIssue>(cardIssue, cardIssue.CardIssueId > 0, "LendingIndex", null));
}
protected override void AfterInsert(RfidCard item, Microsoft.EntityFrameworkCore.DbContext dbContext)
{
CardIssue issue = new CardIssue();
issue.CardNo = item.RfidNo;
issue.CardId = item.RecordId;
issue.WorkstationId = -1;
issue.WorkstationCode = "";
issue.WorkstationName = "";
SystemUser currentUser = GlobalConstants.GetCurrentUser();
issue.IssueUserId = currentUser.RecordId;
issue.IssueUserCode = currentUser.UserCode;
issue.IssueUserName = currentUser.UserName;
issue.IssueQty = item.IssueQty;
dbContext.Add(issue);
dbContext.SaveChanges();
}
