public JsonResult Create(UserCardMap userCardMap) { var card = db.CardInfoes.FirstOrDefault(c => c.IdNumber.Equals(userCardMap.CardIdNumber)); var user = db.AspNetUsers.FirstOrDefault(u => u.Email.Equals(userCardMap.UserEmail)); var doubleCard = db.UserCardMaps.FirstOrDefault(uc => uc.CardId == card.Id); if (doubleCard != null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Card already assigned")); } if (card == null || user == null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Invalid Model State")); } var userCard = new UserCardMap { UserId = user.Id, CardId = card.Id, StatusId = userCardMap.StatusId, IssueDate = userCardMap.IssueDate, RevocationDate = userCardMap.RevocationDate, Notes = userCardMap.Notes }; db.UserCardMaps.Add(userCard); new CardInfoesController().MakeActive(card); db.SaveChanges(); return(Json("")); }
public ActionResult Delete(int id) { UserCardMap userCardMap = db.UserCardMaps.Find(id); if (userCardMap == null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json(new { jobId = -1 })); } db.UserCardMaps.Remove(userCardMap); db.SaveChanges(); return(Json("")); }
public JsonResult Edit(UserCardMap userCardMap) { var dbUserCard = db.UserCardMaps.Find(userCardMap.Id); var card = db.CardInfoes.FirstOrDefault(c => c.IdNumber.Equals(userCardMap.CardIdNumber)); var user = db.AspNetUsers.FirstOrDefault(u => u.Email.Equals(userCardMap.UserEmail)); if (card == null || user == null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json("Invalid Model State")); } dbUserCard.CardId = card.Id; dbUserCard.UserId = user.Id; dbUserCard.StatusId = userCardMap.StatusId; dbUserCard.IssueDate = userCardMap.IssueDate; dbUserCard.RevocationDate = userCardMap.RevocationDate; dbUserCard.Notes = userCardMap.Notes; db.SaveChanges(); return(Json(userCardMap)); }