public IHttpActionResult PutAccessCard(int id, AccessCard accessCard) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != accessCard.Id) { return(BadRequest()); } db.Entry(accessCard).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AccessCardExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
protected bool isCreatorNote(AccessCard card) { db.Entry(card).Reference(i => i.Note).Load(); string creatorId = card.Note.CreatorId; string userId = User.Identity.GetUserId(); return(creatorId.Equals(userId)); }
private void CodeEnterFail(AccessCard card) { card.EnteredCodeFail++; if (card.EnteredCodeFail >= 3) { card.IsBlocked = true; card.EnteredCodeFail = 0; } _repo.SaveChanges(); }
public IHttpActionResult GetAccessCard(int id) { AccessCard accessCard = db.AccessCards.Find(id); if (accessCard == null) { return(NotFound()); } return(Ok(accessCard)); }
public async Task <ActionResult> Edit([Bind(Include = "CardID,BayID,Active,IsAssigned,LastActive,ModifiedDate,Remarks,CreatedDate,CardKey")] AccessCard accessCard, byte[] RowVersion) { string[] fieldsToBind = new string[] { "CardID", "BayID", "Active", "IsAssigned", "LastActive", "ModifiedDate", "Remarks", "CreatedDate", "CardKey" }; if (ModelState.IsValid) { var accessCardToUpdate = await db.AccessCards.FindAsync(accessCard.CardID); if (accessCardToUpdate == null) { AccessCard accessCardDeleted = new AccessCard(); TryUpdateModel(accessCardDeleted, fieldsToBind); ModelState.AddModelError(string.Empty, "Unable to save changes. The Access Card was deleted by another user."); return(RedirectToAction("Index")); } if (TryUpdateModel(accessCardToUpdate, fieldsToBind)) { string UpdatedUser = string.Empty; try { UpdatedUser = accessCardToUpdate.ModifiedBy; accessCardToUpdate.ModifiedDate = DateTime.Now; accessCardToUpdate.ModifiedBy = User.Identity.Name; db.Entry(accessCardToUpdate).Property(x => x.CreatedDate).IsModified = false; db.Entry(accessCardToUpdate).Property(x => x.CreatedBy).IsModified = false; db.Entry <AccessCard>(accessCardToUpdate).State = EntityState.Modified; db.Entry(accessCardToUpdate).OriginalValues["RowVersion"] = RowVersion; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } catch (DbUpdateConcurrencyException ex) { var entry = ex.Entries.Single(); var clientValues = (AccessCard)entry.Entity; var databaseEntry = entry.GetDatabaseValues(); if (databaseEntry == null) { TempData["ErrorMessage"] = "Unable to save changes. The record was deleted"; } else { TempData["ErrorMessage"] = "Unable to save changes. The record was edited by " + UpdatedUser + ". Select Updated Record."; } } } return(RedirectToAction("Index")); //db.Entry(accessCard).State = EntityState.Modified; //db.SaveChanges(); //return RedirectToAction("Index"); } ViewBag.BayID = new SelectList(db.Bays, "BayID", "Remarks", accessCard.BayID); return(View(accessCard)); }
public IHttpActionResult PostAccessCard(AccessCard accessCard) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.AccessCards.Add(accessCard); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = accessCard.Id }, accessCard)); }
public IHttpActionResult DeleteAccessCard(int id) { AccessCard accessCard = db.AccessCards.Find(id); if (accessCard == null) { return(NotFound()); } db.AccessCards.Remove(accessCard); db.SaveChanges(); return(Ok(accessCard)); }
public IHttpActionResult PostAccessCard(AccessCard accessCard) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (!isCreatorNote(accessCard)) { return(BadRequest("Not found note")); } db.AccessCards.Add(accessCard); db.SaveChanges(); return(Ok(accessCard)); }
public IHttpActionResult PostAccessCard(int id) { AccessCard accessCard = db.AccessCards.Find(id); if (accessCard == null) { return(NotFound()); } if (!isCreatorNote(accessCard)) { return(NotFound()); } db.AccessCards.Remove(accessCard); db.SaveChanges(); return(Ok(accessCard)); }
public string ClientInformation(Customer client, bool viewCodes = false) { var info = new StringBuilder(); info.Append("Информация о клиенте (на " + DateTime.Now + ")\n"); info.Append(ClientShortInfo(client)); if (client != null) { info.Append("\nПароль " + client.Passoword); } AccessCard ac = null; if (viewCodes && client.AccessCards != null && client.AccessCards.Count > 0) { ac = client.AccessCards.First(); info.Append(".\n\nИнформация о карт-счете клиента: \n"); info.Append(AccessCardInformation(ac)); info.Append("\nКарт-счета клиента:\n"); } return(info.ToString()); }
//[ValidateAntiForgeryToken] public ActionResult Create(AccessCard accessCard) { if (ModelState.IsValid) { try { if (accessCard.CardID.Equals(0)) { db.AccessCards.Add(accessCard); db.SaveChanges(); return(RedirectToAction("Index")); } else { accessCard.ModifiedDate = DateTime.Now; accessCard.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCard); db.Entry(accessCard).Property(x => x.BayID).IsModified = true; db.Entry(accessCard).Property(x => x.Remarks).IsModified = true; db.Entry(accessCard).Property(x => x.Active).IsModified = true; db.Entry(accessCard).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedBy).IsModified = true; //db.Entry(accessCard).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch { TempData["CustomError"] = "Card ID is not Unique"; return(RedirectToAction("Index")); } } ViewBag.BayID = new SelectList(db.Bays, "BayID", "Remarks", accessCard.BayID); return(View(accessCard)); }
public string AccessCardInformation(AccessCard accessCard) { var info = new StringBuilder(); if (accessCard != null) { info.Append("Неудачных попыток входа: "); info.Append(accessCard.EnteredCodeFail); info.Append(".\nКарта доступа "); info.Append(accessCard.IsBlocked?"заблокирована.":"не заблокирована."); if (accessCard.AccessCodes != null && accessCard.AccessCodes.Count > 0) { info.Append("\nКоды доступа:\n"); for (int i = 0, nn = 0; i < accessCard.AccessCodes.Count; i++, nn++) { info.Append(accessCard.AccessCodes.ElementAt(i).Number); info.Append(". "); info.Append(accessCard.AccessCodes.ElementAt(i).Code); info.Append(" \t"); if (nn >= 3) { nn = -1; info.Append("\n"); } } } else { //info.Append("\nКоды доступа не обнаружены."); } } else { info.Append("Карта доступа не обнаружена."); } return(info.ToString()); }
//[ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "ID,IsManual,AccessCardID,DeletedFlag,ShipmentStatusID,OrderID,BayID,BayName,CustomerName,VehicleCode,DriverName,DriverCNIC,CarrierName,ProductID")] Shipment shipment, FormCollection formCollection) { #region update bays queue #endregion #region access card update if (shipment.AccessCardID != null && shipment.ShipmentStatusID == 1) { ///////////////////////////////////////////////////update order status/////////////////////////////////////////////////// Order odr = db.Orders.Where(x => x.OrderID == shipment.OrderID).FirstOrDefault <Order>(); odr.OrderStatusID = 3; odr.ModifiedDate = DateTime.Now; odr.ModifiedBy = User.Identity.Name; db.Orders.Attach(odr); db.Entry(odr).Property(x => x.ModifiedDate).IsModified = true; db.Entry(odr).Property(x => x.ModifiedBy).IsModified = true; db.Entry(odr).Property(x => x.OrderStatusID).IsModified = true; db.SaveChanges(); /////////////////////////////////////////////////assign access card/////////////////////////////////////////////// AccessCard accessCard = db.AccessCards.Where(x => x.CardID == shipment.AccessCardID).FirstOrDefault <AccessCard>(); accessCard.IsAssigned = true; accessCard.ModifiedDate = DateTime.Now; accessCard.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCard); db.Entry(accessCard).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCard).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCard).State = EntityState.Modified; db.SaveChanges(); //db.Entry(accessCard).State = EntityState.Detached; } else if (shipment.AccessCardID != null && shipment.ShipmentStatusID != 1 && shipment.ShipmentStatusID != 5) { ////////////////////////////////////unassign card if any//////////////////////// int?expectedID = db.Shipments.AsNoTracking().Where(x => x.ID == shipment.ID).FirstOrDefault().AccessCardID; if (expectedID != null && expectedID != shipment.AccessCardID) { /////////////////////////////////////////access card old/////////////////////// AccessCard accessCardOld = db.AccessCards.Where(x => x.CardID == expectedID).FirstOrDefault <AccessCard>(); accessCardOld.IsAssigned = false; accessCardOld.ModifiedDate = DateTime.Now; accessCardOld.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCardOld); db.Entry(accessCardOld).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCardOld).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCardOld).Property(x => x.IsAssigned).IsModified = true; //////////////////////////access card New/////////////////////////////////////// AccessCard accessCardNew = db.AccessCards.Where(x => x.CardID == shipment.AccessCardID).FirstOrDefault <AccessCard>(); accessCardNew.CardID = (int)shipment.AccessCardID; accessCardNew.IsAssigned = true; accessCardNew.ModifiedDate = DateTime.Now; accessCardNew.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCardNew); db.Entry(accessCardNew).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCardNew).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCardNew).Property(x => x.IsAssigned).IsModified = true; ///////////////////////////finally save data///////////////////////////////////// db.Entry(accessCardOld).State = EntityState.Modified; db.Entry(accessCardNew).State = EntityState.Modified; db.SaveChanges(); } else { ///////////////////////////////////////////////////update order status/////////////////////////////////////////////////// Order odr = db.Orders.Where(x => x.OrderID == shipment.OrderID).FirstOrDefault <Order>(); odr.OrderStatusID = 3; odr.ModifiedDate = DateTime.Now; odr.ModifiedBy = User.Identity.Name; db.Orders.Attach(odr); db.Entry(odr).Property(x => x.ModifiedDate).IsModified = true; db.Entry(odr).Property(x => x.ModifiedBy).IsModified = true; db.Entry(odr).Property(x => x.OrderStatusID).IsModified = true; db.SaveChanges(); ////////////////////////////////////////////////assign Access card/////////////////////////////////////////////////////// AccessCard accessCard = db.AccessCards.Where(x => x.CardID == shipment.AccessCardID).FirstOrDefault <AccessCard>(); accessCard.CardID = (int)shipment.AccessCardID; accessCard.IsAssigned = true; accessCard.ModifiedDate = DateTime.Now; accessCard.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCard); db.Entry(accessCard).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCard).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCard).State = EntityState.Modified; //commneted by ahad for performance db.SaveChanges(); } } else if (shipment.ShipmentStatusID == 5) { Order odr = db.Orders.Where(x => x.OrderID == shipment.OrderID).FirstOrDefault <Order>(); odr.OrderStatusID = 3; odr.OrderDeliveryDT = DateTime.Now; odr.ModifiedDate = DateTime.Now; odr.ModifiedBy = User.Identity.Name; db.Orders.Attach(odr); db.Entry(odr).Property(x => x.ModifiedDate).IsModified = true; db.Entry(odr).Property(x => x.ModifiedBy).IsModified = true; db.Entry(odr).Property(x => x.OrderStatusID).IsModified = true; db.Entry(odr).Property(x => x.OrderDeliveryDT).IsModified = true; db.SaveChanges(); ////////////////////////////// int bayidfrmDb = db.Shipments.AsNoTracking().Where(x => x.ID == shipment.ID).FirstOrDefault().BayID.Value; bayFrequency(bayidfrmDb); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// int accessCardidfrmDb = db.Shipments.AsNoTracking().Where(x => x.ID == shipment.ID).FirstOrDefault().AccessCardID.Value; AccessCard accessCard = db.AccessCards.Where(x => x.CardID == accessCardidfrmDb).FirstOrDefault <AccessCard>(); accessCard.IsAssigned = false; accessCard.ModifiedDate = DateTime.Now; accessCard.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCard); db.Entry(accessCard).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCard).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCard).State = EntityState.Modified; //commneted by ahad for performance db.SaveChanges(); //db.Entry(accessCard).State = EntityState.Detached; } #endregion #region shipment compartment int compCountTempDataUpdate = Convert.ToInt32(TempData["CompCountUpdate"].ToString()); if (compCountTempDataUpdate != 0) { for (int i = 0; i < compCountTempDataUpdate; i++) { int compIDConverted = Convert.ToInt32(formCollection["compId" + i]); ShipmentCompartment shipmentComp = db.ShipmentCompartments.Where(x => x.ID == compIDConverted).FirstOrDefault <ShipmentCompartment>(); //shipmentComp.ID = Convert.ToInt32(formCollection["compId" + i]); shipmentComp.OrderedQuantity = Convert.ToInt32(formCollection["Order.OrderQty"]); int compPlannedQty; if (Int32.TryParse(formCollection["compPlannedQty" + i], out compPlannedQty)) { shipmentComp.PlannedQuantity = compPlannedQty; } else { shipmentComp.PlannedQuantity = null; } if (shipment.ShipmentStatusID == 3 || shipment.ShipmentStatusID == 5) // Either Close or checkedIn { int compManualPreDip; if (Int32.TryParse(formCollection["compManualPreDip" + i], out compManualPreDip)) { shipmentComp.PreDip = compManualPreDip; } else { shipmentComp.PreDip = null; } int compManualPostDip; if (Int32.TryParse(formCollection["compManualPostDip" + i], out compManualPostDip)) { shipmentComp.PostDip = compManualPostDip; } else { shipmentComp.PostDip = null; } int compDelta; if (Int32.TryParse(formCollection["compDelta" + i], out compDelta)) { shipmentComp.Delta = compDelta; } else { shipmentComp.Delta = null; } } shipmentComp.AccessCardKey = shipment.AccessCardID.ToString(); shipmentComp.BayID = Convert.ToInt32(shipment.BayID); shipmentComp.Product = shipment.ProductID.ToString(); shipmentComp.ShipmentID = shipment.ID; //shipmentComp.CreatedDate = DateTime.Now; shipmentComp.ModifiedDate = DateTime.Now; shipmentComp.ModifiedBy = User.Identity.Name; shipmentComp.CompartmentCode = Convert.ToInt32(formCollection["compCode" + i]); shipmentComp.Capacity = Convert.ToInt32(formCollection["compCapacity" + i]); db.ShipmentCompartments.Attach(shipmentComp); db.Entry(shipmentComp).State = EntityState.Modified; db.SaveChanges(); //db.Entry(shipmentComp).State = EntityState.Detached; } } else { int compCountTempDataNew = Convert.ToInt32(TempData["CompCountNew"].ToString()); for (int i = 0; i < compCountTempDataNew; i++) { try { if (shipment.ShipmentStatusID != 4) { shipment.ShipmentStatusID = 2; // shipment status id is set to queued. } ShipmentCompartment shipmentComp = new ShipmentCompartment(); shipmentComp.OrderedQuantity = Convert.ToInt32(formCollection["Order.OrderQty"]); int compPlannedQty; if (Int32.TryParse(formCollection["compPlannedQty" + i], out compPlannedQty)) { shipmentComp.PlannedQuantity = compPlannedQty; } else { shipmentComp.PlannedQuantity = null; } shipmentComp.AccessCardKey = shipment.AccessCardID.ToString(); shipmentComp.BayID = Convert.ToInt32(shipment.BayID); shipmentComp.Product = shipment.ProductID.ToString(); shipmentComp.ShipmentID = shipment.ID; shipmentComp.CreatedDate = DateTime.Now; shipmentComp.CreatedBy = User.Identity.Name; shipmentComp.ModifiedDate = DateTime.Now; shipmentComp.ModifiedBy = User.Identity.Name; shipmentComp.CompartmentCode = Convert.ToInt32(formCollection["compCode" + i]); shipmentComp.Capacity = Convert.ToInt32(formCollection["compCapacity" + i]); db.ShipmentCompartments.Add(shipmentComp); db.SaveChanges(); } catch (Exception e) { e.ToString(); } } } #endregion if (ModelState.IsValid) { //Shipment ship = db.Shipments.Where(x => x.ID == shipment.ID).FirstOrDefault<Shipment>(); shipment.ShipmentDate = DateTime.Now; shipment.ModifiedDate = DateTime.Now; shipment.ModifiedBy = User.Identity.Name; db.Entry(shipment).State = EntityState.Modified; db.Entry(shipment).Property(x => x.CreatedDate).IsModified = false; db.Entry(shipment).Property(x => x.CreatedBy).IsModified = false; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AccessCardID = new SelectList(db.AccessCards, "CardID", "Remarks", shipment.AccessCardID); ViewBag.BayID = new SelectList(db.Bays, "BayID", "Remarks", shipment.BayID); ViewBag.OrderID = new SelectList(db.Orders, "OrderID", "OrderCode", shipment.OrderID); ViewBag.ShipmentStatusID = new SelectList(db.ShipmentStatus, "ID", "Status", shipment.ShipmentStatusID); ViewBag.ID = new SelectList(db.WeighBridges, "ShipmentID", "Status", shipment.ID); return(View(shipment)); }
//[ValidateAntiForgeryToken] public ActionResult Create(AccessCard accessCard, byte[] RowVersion) { string[] fieldsToBind = new string[] { "CardID", "BayID", "Active", "IsAssigned", "LastActive", "ModifiedDate", "Remarks", "CreatedDate", "CardKey" }; if (ModelState.IsValid) { try { if (accessCard.CardID.Equals(0)) { accessCard.ModifiedDate = accessCard.LastActive = accessCard.CreatedDate = DateTime.Now; accessCard.CreatedBy = accessCard.ModifiedBy = User.Identity.Name; int maxId = 0; if (db.AccessCards.Count() > 0) { maxId = db.AccessCards.Max(x => x.CardID); } accessCard.CardID = (maxId > 0) ? (maxId + 1) : 1; db.AccessCards.Add(accessCard); db.SaveChanges(); return(RedirectToAction("Index")); } else { var accessCardToUpdate = db.AccessCards.Find(accessCard.CardID); if (accessCardToUpdate == null) { AccessCard accessCardDeleted = new AccessCard(); TryUpdateModel(accessCardDeleted, fieldsToBind); ModelState.AddModelError(string.Empty, "Unable to save changes. The Access Card was deleted by another user."); return(RedirectToAction("Index")); } if (TryUpdateModel(accessCardToUpdate, fieldsToBind)) { string UpdatedUser = string.Empty; try { UpdatedUser = accessCardToUpdate.ModifiedBy; accessCardToUpdate.ModifiedDate = DateTime.Now; accessCardToUpdate.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCardToUpdate); db.Entry(accessCardToUpdate).Property(x => x.BayID).IsModified = true; db.Entry(accessCardToUpdate).Property(x => x.Remarks).IsModified = true; db.Entry(accessCardToUpdate).Property(x => x.Active).IsModified = true; db.Entry(accessCardToUpdate).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCardToUpdate).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCardToUpdate).Property(x => x.ModifiedBy).IsModified = true; db.Entry <AccessCard>(accessCardToUpdate).State = EntityState.Modified; db.Entry(accessCardToUpdate).OriginalValues["RowVersion"] = RowVersion; db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbUpdateConcurrencyException ex) { var entry = ex.Entries.Single(); var clientValues = (AccessCard)entry.Entity; var databaseEntry = entry.GetDatabaseValues(); if (databaseEntry == null) { TempData["ErrorMessage"] = "Unable to save changes. The record was deleted"; } else { TempData["ErrorMessage"] = "Unable to save changes. The record was edited by " + UpdatedUser + ". Select Updated Record."; } } } return(RedirectToAction("Index")); } } catch (Exception ex) { TempData["CustomError"] = "Card ID is not Unique"; return(RedirectToAction("Index")); } } ViewBag.BayID = new SelectList(db.Bays, "BayID", "Remarks", accessCard.BayID); return(View("Index", accessCard)); }
//[ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "ID,AccessCardID,DeletedFlag,ShipmentStatusID,OrderID,BayID,BayName,CustomerName,VehicleCode,DriverName,DriverCNIC,CarrierName,ShipmentDate,ProductID")] Shipment shipment, FormCollection formCollection) { #region shipment compartment int compCountTempDataUpdate = Convert.ToInt32(TempData["CompCountUpdate"].ToString()); if (compCountTempDataUpdate != 0) { for (int i = 0; i < compCountTempDataUpdate; i++) { int compID = Convert.ToInt32(formCollection["compId" + i]); ShipmentCompartment shipmentComp = db.ShipmentCompartments.AsNoTracking().Where(x => x.ID == compID).FirstOrDefault <ShipmentCompartment>(); //shipmentComp.ID = Convert.ToInt32(formCollection["compId" + i]); shipmentComp.OrderedQuantity = Convert.ToInt32(formCollection["Order.OrderQty"]); int compActualQty; if (Int32.TryParse(formCollection["compPlannedQty" + i], out compActualQty)) { shipmentComp.ActualBCUQuantity = compActualQty; } else { shipmentComp.ActualBCUQuantity = null; } //shipmentComp.AccessCardKey = shipment.AccessCardID.ToString(); //shipmentComp.BayID = Convert.ToInt32(shipment.BayID); shipmentComp.Product = shipment.ProductID.ToString(); shipmentComp.ShipmentID = shipment.ID; //shipmentComp.CreatedDate = DateTime.Now; shipmentComp.ModifiedDate = DateTime.Now; shipmentComp.ModifiedBy = User.Identity.Name; shipmentComp.CompartmentCode = Convert.ToInt32(formCollection["compCode" + i]); shipmentComp.Capacity = Convert.ToInt32(formCollection["compCapacity" + i]); db.ShipmentCompartments.Attach(shipmentComp); db.Entry(shipmentComp).Property(x => x.OrderedQuantity).IsModified = true; db.Entry(shipmentComp).Property(x => x.ActualBCUQuantity).IsModified = true; db.Entry(shipmentComp).Property(x => x.Product).IsModified = true; db.Entry(shipmentComp).Property(x => x.ShipmentID).IsModified = true; db.Entry(shipmentComp).Property(x => x.ModifiedDate).IsModified = true; db.Entry(shipmentComp).Property(x => x.ModifiedBy).IsModified = true; db.Entry(shipmentComp).Property(x => x.CompartmentCode).IsModified = true; db.Entry(shipmentComp).Property(x => x.Capacity).IsModified = true; db.Entry(shipmentComp).State = EntityState.Modified; db.SaveChanges(); //db.Entry(shipmentComp).State = EntityState.Detached; } } else { int compCountTempDataNew = Convert.ToInt32(TempData["CompCountNew"].ToString()); for (int i = 0; i < compCountTempDataNew; i++) { try { //shipment.ShipmentStatusID = 2; // shipment status id is set to queued. ShipmentCompartment shipmentComp = new ShipmentCompartment(); shipmentComp.OrderedQuantity = Convert.ToInt32(formCollection["Order.OrderQty"]); int compPlannedQty; if (Int32.TryParse(formCollection["compPlannedQty" + i], out compPlannedQty)) { shipmentComp.PlannedQuantity = compPlannedQty; } else { shipmentComp.PlannedQuantity = null; } shipmentComp.AccessCardKey = shipment.AccessCardID.ToString(); shipmentComp.BayID = Convert.ToInt32(shipment.BayID); shipmentComp.Product = shipment.ProductID.ToString(); shipmentComp.ShipmentID = shipment.ID; shipmentComp.CreatedDate = DateTime.Now; shipmentComp.CreatedBy = User.Identity.Name; shipmentComp.ModifiedDate = DateTime.Now; shipmentComp.ModifiedBy = User.Identity.Name; shipmentComp.CompartmentCode = Convert.ToInt32(formCollection["compCode" + i]); shipmentComp.Capacity = Convert.ToInt32(formCollection["compCapacity" + i]); db.ShipmentCompartments.Add(shipmentComp); db.SaveChanges(); } catch (Exception e) { e.ToString(); } } } #endregion if (shipment.ShipmentStatusID == 5) { Order odr = db.Orders.Where(x => x.OrderID == shipment.OrderID).FirstOrDefault <Order>(); odr.OrderStatusID = 3; odr.OrderDeliveryDT = DateTime.Now; odr.ModifiedDate = DateTime.Now; odr.ModifiedBy = User.Identity.Name; db.Orders.Attach(odr); db.Entry(odr).Property(x => x.ModifiedDate).IsModified = true; db.Entry(odr).Property(x => x.ModifiedBy).IsModified = true; db.Entry(odr).Property(x => x.OrderStatusID).IsModified = true; db.Entry(odr).Property(x => x.OrderDeliveryDT).IsModified = true; db.SaveChanges(); /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// AccessCard accessCard = db.AccessCards.Where(x => x.CardID == shipment.AccessCardID).FirstOrDefault <AccessCard>(); accessCard.CardID = (int)shipment.AccessCardID; accessCard.IsAssigned = false; accessCard.ModifiedDate = DateTime.Now; accessCard.ModifiedBy = User.Identity.Name; db.AccessCards.Attach(accessCard); db.Entry(accessCard).Property(x => x.ModifiedDate).IsModified = true; db.Entry(accessCard).Property(x => x.ModifiedBy).IsModified = true; db.Entry(accessCard).Property(x => x.IsAssigned).IsModified = true; db.Entry(accessCard).State = EntityState.Modified; //commneted by ahad for performance db.SaveChanges(); //db.Entry(accessCard).State = EntityState.Detached; } if (ModelState.IsValid) { shipment.ModifiedDate = DateTime.Now; shipment.ModifiedBy = User.Identity.Name; db.Shipments.Attach(shipment); db.Entry(shipment).Property(x => x.ModifiedDate).IsModified = true; db.Entry(shipment).Property(x => x.ModifiedBy).IsModified = true; db.Entry(shipment).Property(x => x.ShipmentStatusID).IsModified = true; //db.Entry(shipment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AccessCardID = new SelectList(db.AccessCards, "CardID", "Remarks", shipment.AccessCardID); ViewBag.BayID = new SelectList(db.Bays, "BayID", "Remarks", shipment.BayID); ViewBag.OrderID = new SelectList(db.Orders, "OrderID", "OrderCode", shipment.OrderID); ViewBag.ShipmentStatusID = new SelectList(db.ShipmentStatus, "ID", "Status", shipment.ShipmentStatusID); ViewBag.ID = new SelectList(db.WeighBridges, "ShipmentID", "Status", shipment.ID); return(View(shipment)); }
private int GetEnterCodeRemaining(AccessCard card) { return(3 - card.EnteredCodeFail); }
private void SetupData() { var guest = new GangwayService.Entity.Guest { CruiseDetail = new GuestCruiseDetail { ////IsVip = false, IsPrimary = false, Stateroom = "1", StateroomCategoryTypeId = "A", ReservationStatusId = "1001", ReservationNumber = "111", ReservationId = "3", LoyaltyLevelTypeId = "8", BeaconId = "212", HasRecovery = true, CanDebarkAlone = false, StateroomOccupancy = "5" }, PersonalDetail = new PersonalDetail { FirstName = "Robert", Gender = Gender.Male, Birthdate = DateTime.Now, Suffix = "MR.", AnniversaryDate = DateTime.Now, BirthCountryId = "2", CitizenshipCountryId = "232", LastName = "Singh", MaritalStatus = "Single" }, GuestId = "600001", LastDateTime = DateTime.Now.AddMinutes(5), LastEvent = "True", SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23" }; var guest1 = new GangwayService.Entity.Guest { CruiseDetail = new GuestCruiseDetail { ////IsVip = false, IsPrimary = false, Stateroom = "121", StateroomCategoryTypeId = "A", ReservationStatusId = "1001", ReservationNumber = "111", ReservationId = "3", LoyaltyLevelTypeId = "8", BeaconId = "212", HasRecovery = true, CanDebarkAlone = false, StateroomOccupancy = "5" }, PersonalDetail = new PersonalDetail { FirstName = "Robert", Gender = Gender.Male, Birthdate = DateTime.Now, Suffix = "MR.", AnniversaryDate = DateTime.Now, BirthCountryId = "2", CitizenshipCountryId = "232", LastName = "Singh", MaritalStatus = "Single" }, GuestId = "600001", LastDateTime = DateTime.Now.AddMinutes(5), LastEvent = "True", SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23" }; var guest2 = new GangwayService.Entity.Guest { CruiseDetail = new GuestCruiseDetail { ////IsVip = false, IsPrimary = false, Stateroom = "2", StateroomCategoryTypeId = "A", ReservationStatusId = "1001", ReservationNumber = "111", ReservationId = "3", LoyaltyLevelTypeId = "8", BeaconId = "212", HasRecovery = true, CanDebarkAlone = false, StateroomOccupancy = "5" }, PersonalDetail = new PersonalDetail { FirstName = "Robert", Gender = Gender.Male, Birthdate = DateTime.Now, Suffix = "MR.", AnniversaryDate = DateTime.Now, BirthCountryId = "2", CitizenshipCountryId = "232", LastName = "Singh", MaritalStatus = "Single" }, GuestId = "600001", LastDateTime = DateTime.Now.AddMinutes(5), LastEvent = "True", SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23" }; var guest3 = new GangwayService.Entity.Guest { PersonalDetail = new PersonalDetail { FirstName = "Robert", Gender = Gender.Male, Birthdate = DateTime.Now, Suffix = "MR.", AnniversaryDate = DateTime.Now, BirthCountryId = "2", CitizenshipCountryId = "232", LastName = "Singh", MaritalStatus = "Single" }, GuestId = "600001", LastDateTime = DateTime.Now.AddMinutes(5), LastEvent = "True", SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23" }; var crew = new DataAccess.Entities.Crewmember { CrewmemberId = "212", CrewmemberTypeId = "21", EmployeeNo = "22", StateroomId = "1", PersonalDetail = new PersonalDetail { FirstName = "Robert" }, SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23", EmbarkDetail = new EmbarkDetail { AshoreDate = DateTime.Now, OnboardDate = DateTime.Now } }; var safetyDuty = new SafetyDuty { CrewmemberId = "212", SafetyRoleId = "1", EndDate = DateTime.Now, StartDate = DateTime.Now }; var accessCard = new AccessCard { AccessCardId = "1", AddedDate = DateTime.Now, AccessCardNumber = "1234", ExpiryDate = DateTime.Now.AddDays(1) }; crew.CrewmemberAccessCards.Add(accessCard); var identification = new Identification { DocumentTypeId = "1", Number = "12345" }; crew.Identifications.Add(identification); var crewMemberRole = new CrewmemberRole { RoleId = "1" }; crew.CrewmemberRoles.Add(crewMemberRole); crew.SafetyDuties.Add(safetyDuty); var visitor = new GangwayService.Entity.Visitor { HasAlert = true, PersonalDetail = new PersonalDetail { DepartmentId = "1", DepartmentName = "TesT", FirstName = "Robert", Gender = Gender.Male, DepartmentPOC = "Test" }, SecurityPhotoAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23", VisitorId = "22", VisitorTypeId = "21", VisitorInfo = new AdditionalInfo { CompanyName = "234dfgfd", ContactNumber = "23452456", VisitPurpose = "retsrt" } }; var portDebarkAuthorization = new PortDebarkAuthorization(); var alert = new Collection<GangwayService.Entity.Alert> { new GangwayService.Entity.Alert { AlertId = "12", AlertType = "2", Message = new Message { Description = "Test", ImageAddress = "http://172.26.248.122/ImagingMediaService/MediaItems/23", Subject = "Test" } } }; var message = new Collection<GangwayService.Entity.PersonMessage> { new GangwayService.Entity.PersonMessage { AddedBy = Environment.MachineName } }; var debarkAuthorizedPersonCollection = new DebarkAuthorizedPersonCollection { new DebarkAuthorizedPerson { PersonId = "22", PersonTypeId = "2" }, new DebarkAuthorizedPerson { PersonId = "600001", PersonTypeId = "2" } }; portDebarkAuthorization.AssignDebarkAuthorizedPersons(debarkAuthorizedPersonCollection); var portDebarkAuthorizations = new PortDebarkAuthorizationCollection { new PortDebarkAuthorization { CanDebarkAlone = true } }; guest.AssignAlerts(alert); guest.AssignMessages(message); visitor.AssignAlerts(alert); guest.AssignPortAuthorizations(portDebarkAuthorizations); this.guests.Add(guest); this.guests.Add(guest1); this.guests.Add(guest2); this.guests.Add(guest3); this.crewmembers.Add(crew); this.visitors.Add(visitor); var guestList = new ListResult<GangwayService.Entity.Guest>(); guestList.AssignItems(this.guests); guestList.TotalResults = this.guests.Count; var crewList = new ListResult<DataAccess.Entities.Crewmember>(); crewList.AssignItems(this.crewmembers); crewList.TotalResults = this.crewmembers.Count; var visitorList = new ListResult<GangwayService.Entity.Visitor>(); visitorList.AssignItems(this.visitors); visitorList.TotalResults = this.visitors.Count; this.personRepository.Setup(data => data.RetrieveGuest(It.IsAny<PersonSearchParameter>())).Returns(Task.FromResult(guestList)); this.personRepository.Setup(data => data.RetrieveCrew(It.IsAny<PersonSearchParameter>())).Returns(Task.FromResult(crewList)); this.personRepository.Setup(data => data.RetrieveVisitor(It.IsAny<PersonSearchParameter>())).Returns(Task.FromResult(visitorList)); }
public override bool Execute() { if (!Verifier.CheckName(Country)) { Information = StringSource.NameStructureError(); return(false); } if (!Verifier.CheckAddress(Address)) { Information = StringSource.AddressStructureError(); return(false); } if (!Verifier.CheckPassportNumber(PassportNumber)) { Information = StringSource.PassportNumberStructureError(); return(false); } if (!Verifier.CheckName(FirstName)) { Information = StringSource.NameStructureError(); return(false); } if (!Verifier.CheckName(LastName)) { Information = StringSource.NameStructureError(); return(false); } if (!Verifier.CheckName(MiddleName)) { Information = StringSource.NameStructureError(); return(false); } if (!Verifier.CheckEMail(EMail)) { Information = StringSource.EMailStructureError(); return(false); } Client = new Customer { FirstName = FirstName, LastName = LastName, MiddleName = MiddleName, PassportNumber = PassportNumber, Country = Country, Address = Address, Email = EMail, Login = LoginGeneration(), Passoword = PasswordGeneration(), IsLocked = false, }; var gen = new Generator { NumberCount = DataSource.LengthCode }; using (var localrepos = new Repositories()) { var all = localrepos.Customers.GetAll(); if (all.Where(el => el.PassportNumber == PassportNumber).Count() > 0) { Information = StringSource.ClientPassportNumberIsContains(); return(false); } localrepos.Customers.Add(Client); localrepos.SaveChanges(); //////////////////////////////////////////////////////////////////// new Supporting().RemoveClientInformationById(Client.CustomerID); //////////////////////////////////////////////////////////////////// if (all.Count() > 0) { var cl = all.Where(el => el.Login == Client.Login).ToList(); if (cl.Count() > 0) { var cc = (Customer)cl.ElementAt(0); IdClient = cc.CustomerID; } else { Information = StringSource.ClientRegistredError(); return(false); } } else { Information = StringSource.ClientRegistredError(); return(false); } // зарегаем карту доступа AccessCard = new AccessCard { //Customer=Client, CustomerID = Client.CustomerID, EnteredCodeFail = 0, IsBlocked = false, //AccessCodes=, }; localrepos.AccessCards.Add(AccessCard); localrepos.SaveChanges(); var acs = localrepos.AccessCards.GetAll(); if (acs.Count() > 0) { var acs2 = acs.Where(el => el.CustomerID == Client.CustomerID).ToArray(); if (acs2.Count() > 0) { AccessCard = acs2[0]; } else { Information = StringSource.ClientRegistredError(); return(false); } } else { Information = StringSource.ClientRegistredError(); return(false); } for (int i = 0; i < 40; i++) { localrepos.AccessCodes.Add(new AccessCode { //AccessCard=ac, AccessCardID = AccessCard.AccessCardID, Code = gen.NumberGenerate().ToString(), Number = i + 1, }); } ; localrepos.SaveChanges(); } Login = Client.Login; Information = StringSource.ClientRegistred(Client.Login); return(true); }