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