public BinLocation Create(BinLocation binLocation) { binLocation.BinLocDesc = binLocation.BinLocDesc.ToUpperCase(); var parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = nameof(binLocation.BinLocationId).Parameterize(), ParameterValue = binLocation.BinLocationId }); parameters.Add(new ParameterInfo() { ParameterName = nameof(binLocation.BinLocDesc).Parameterize(), ParameterValue = binLocation.BinLocDesc }); StringBuilder qry = new StringBuilder(); qry.AppendLine("insert into BinLocations ("); qry.AppendLine(nameof(binLocation.BinLocDesc)); qry.AppendLine(") values ("); qry.AppendLine(nameof(binLocation.BinLocDesc).Parameterize()); qry.AppendLine(")"); qry.AppendLine("select @@identity"); binLocation.BinLocationId = DBContext.ExecuteQueryWithIdentityInt64(qry.ToString(), parameters); return(binLocation); }
// Returns a list of all bin locations in the db public List <BinLocation> ListOfBinLocations() { IEnumerable <Item> Items = db.Items.ToList(); List <BinLocation> BinLocations = new List <BinLocation>(); IEnumerable <string> AllLocations = Items.Select(x => x.BinLocation).Distinct().OrderBy(x => x); // List of locations that have only items on hand string[] LocationsWithQtyOnHand = Items.Where(x => x.OnHand != 0 || x.NewOnHand != 0).Select(x => x.BinLocation).Distinct().ToArray(); // List of locations that have only items that without changes string [] LocationsWithOnlyChanged = Items.Where(x => (x.ChangesMade) || (x.Confirmed)).Select(x => x.BinLocation).Distinct().ToArray(); // Lis of locations that have changes and qty on hand string [] LocationsWithChangesAndOnHand = Items.Where(x => (!(x.ChangesMade) && !(x.Confirmed)) && (x.OnHand != 0 || x.NewOnHand != 0)).Select(x => x.BinLocation).Distinct().ToArray(); foreach (string location in AllLocations) { BinLocation bin = new BinLocation(); bin.Bin = location; bin.ContainsOnlyNonZeros = LocationsWithQtyOnHand.Contains(location); bin.ContainsOnlyCountedItems = LocationsWithOnlyChanged.Contains(location); // Change to LocationsWithChangesMade bin.ContainsUncountedOnHand = LocationsWithChangesAndOnHand.Contains(location); BinLocations.Add(bin); } // Add a blank bin for all bins BinLocation allBin = new BinLocation(); allBin.Bin = ""; BinLocations.Add(allBin); return(BinLocations); }
private void mapVoteToBin(BinLocation fBin, double x, double y, double angle, double scale) { fBin.x = mNumXBins * SafeDivision(x - mMinX, mMaxX - mMinX); fBin.y = mNumYBins * SafeDivision(y - mMinY, mMaxY - mMinY); fBin.angle = (double)(mNumAngleBins * ((angle + PI) * (1 / (2 * PI)))); fBin.scale = mNumScaleBins * SafeDivision(scale - mMinScale, mMaxScale - mMinScale); }
public ActionResult _Create(int Id) //Id ==>GodownId { BinLocation s = new BinLocation(); ViewBag.LineMode = "Create"; Godown Godown = _GodownService.Find(Id); ViewBag.DocNo = Godown.GodownName; s.GodownId = Id; return(PartialView("_Create", s)); }
//[ValidateAntiForgeryToken] public ActionResult DeletePost(BinLocation vm) { bool BeforeSave = true; if (BeforeSave) { try { Godown temp = _GodownService.Find(vm.GodownId); List <LogTypeViewModel> LogList = new List <LogTypeViewModel>(); BinLocation BinLocation = _BinLocationService.Find(vm.BinLocationId); LogList.Add(new LogTypeViewModel { Obj = Mapper.Map <BinLocation>(BinLocation), }); LogList.Add(new LogTypeViewModel { Obj = Mapper.Map <BinLocation>(BinLocation), }); XElement Modifications = _modificationCheck.CheckChanges(LogList); _BinLocationService.Delete(vm.BinLocationId); _logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = (int)temp.DocTypeId, DocId = temp.GodownId, DocLineId = BinLocation.BinLocationId, ActivityType = (int)ActivityTypeContants.Deleted, DocNo = temp.GodownName, xEModifications = Modifications, DocDate = temp.CreatedDate, })); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; ViewBag.LineMode = "Delete"; return(PartialView("_Create", vm)); } } return(Json(new { success = true })); }
public IActionResult Post([FromBody] BinLocation model) { if (ModelState.IsValid) { _repository.Create(model); return(Ok(model)); } else { return(new ResponseResult(Response) { StatusCode = (int)StatusCodes.Status400BadRequest, ResponseObject = ModelState.ToJson() }.ToJsonResult()); } }
public ActionResult UpdateOptionAjax(string binLocation) { // Grab all items in the bin location and check if they meet the criteria IEnumerable <Item> Items = db.Items.Where(x => x.BinLocation == binLocation).ToList(); BinLocation bin = new BinLocation(); bin.Bin = binLocation; // Put logic here bin.ContainsOnlyNonZeros = Items.All(x => x.OnHand != 0); bin.ContainsOnlyCountedItems = Items.All(x => x.ChangesMade || x.Confirmed); bin.ContainsUncountedOnHand = Items.Any(x => (!((x.ChangesMade) || (x.Confirmed)) && (x.OnHand != 0))); return(PartialView("_OptionView", bin)); }
public ActionResult _Delete(int id) { BinLocation temp = _BinLocationService.Find(id); //Getting Settings if (temp == null) { return(HttpNotFound()); } if ((TimePlanValidation || Continue)) { ViewBag.LineMode = "Delete"; } return(PartialView("_Create", temp)); }
public BinLocation Update(BinLocation binLocationChanges) { binLocationChanges.BinLocDesc = binLocationChanges.BinLocDesc.ToUpperCase(); var parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = nameof(binLocationChanges.BinLocationId).Parameterize(), ParameterValue = binLocationChanges.BinLocationId }); parameters.Add(new ParameterInfo() { ParameterName = nameof(binLocationChanges.BinLocDesc).Parameterize(), ParameterValue = binLocationChanges.BinLocDesc }); StringBuilder qry = new StringBuilder(); qry.AppendLine("Update BinLocations set"); qry.AppendLine($"{nameof(binLocationChanges.BinLocDesc)}={nameof(binLocationChanges.BinLocDesc).Parameterize()}"); qry.AppendLine($"where {nameof(binLocationChanges.BinLocationId)} = {nameof(binLocationChanges.BinLocationId).Parameterize()}"); DBContext.ExecuteQuery(qry.ToString(), parameters); return(binLocationChanges); }
public ActionResult _Modify(int id) { BinLocation temp = _BinLocationService.Find(id); Godown Godown = _GodownService.Find(temp.GodownId); ViewBag.DocNo = Godown.GodownName; //Getting Settings if (temp == null) { return(HttpNotFound()); } if ((TimePlanValidation || Continue)) { ViewBag.LineMode = "Edit"; } return(PartialView("_Create", temp)); }
public static void PopulateTestData(AppDbContext dbContext) { //Remove Transaction data foreach (var inv in dbContext.Inventory) { dbContext.Remove(inv); } foreach (var inventoryLoc in dbContext.InventoryLocation) { dbContext.Remove(inventoryLoc); } //Remove Master data foreach (var usr in dbContext.User) { dbContext.Remove(usr); } foreach (var location in dbContext.Location) { dbContext.Remove(location); } foreach (var wearHouse in dbContext.Warehouse) { dbContext.Remove(wearHouse); } foreach (var binloc in dbContext.BinLocation) { dbContext.Remove(binloc); } foreach (var partDetail in dbContext.PartDetails) { dbContext.Remove(partDetail); } //Save Changes dbContext.SaveChanges(); //Add Master data var user1 = new User() { Name = "User1", Role = Role.Admin, CreatedOn = DateTime.Now }; var user2 = new User() { Name = "User2", Role = Role.Admin, CreatedOn = DateTime.Now }; dbContext.User.Add(user1); dbContext.User.Add(user2); //Add Master data var location1 = new Location() { Name = "Ageo", Description = "AgeoDescription", CreatedBy = user1, CreatedOn = DateTime.Now }; var location2 = new Location() { Name = "India", Description = "IndiaDescription", CreatedBy = user1, CreatedOn = DateTime.Now }; dbContext.Location.Add(location1); dbContext.Location.Add(location2); var warehouse1 = new Warehouse() { Id = 1, Name = "Wearhouse1", Description = "W1Description", Location = location1, CreatedBy = user1, CreatedOn = DateTime.Now }; dbContext.Warehouse.Add(warehouse1); var binLocation1 = new BinLocation() { Name = "C903370A00", Description = "BinLoc1Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 120, CreatedOn = DateTime.Now }; var binLocation2 = new BinLocation() { Name = "C903230B00", Description = "BinLoc2Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 100, CreatedOn = DateTime.Now }; var binLocation3 = new BinLocation() { Name = "C903120B00", Description = "BinLoc3Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 90, CreatedOn = DateTime.Now }; var binLocation4 = new BinLocation() { Name = "C902170A00", Description = "BinLoc4Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 80, CreatedOn = DateTime.Now }; var binLocation5 = new BinLocation() { Name = "C902020A00", Description = "BinLoc5Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 70, CreatedOn = DateTime.Now }; var binLocation6 = new BinLocation() { Name = "C901360A00", Description = "BinLoc6Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 110, CreatedOn = DateTime.Now }; var binLocation7 = new BinLocation() { Name = "C903200B", Description = "BinLoc7Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 130, CreatedOn = DateTime.Now }; var binLocation8 = new BinLocation() { Name = "C902200B00", Description = "BinLoc8Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 140, CreatedOn = DateTime.Now }; var binLocation9 = new BinLocation() { Name = "C902120B00", Description = "BinLoc9Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 60, CreatedOn = DateTime.Now }; var binLocation10 = new BinLocation() { Name = "C902080A00", Description = "BinLoc10Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 50, CreatedOn = DateTime.Now }; var binLocation11 = new BinLocation() { Name = "C901370B00", Description = "BinLoc11Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 110, CreatedOn = DateTime.Now }; var binLocation12 = new BinLocation() { Name = "C901110B00", Description = "BinLoc12Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 100, CreatedOn = DateTime.Now }; var binLocation13 = new BinLocation() { Name = "C901090B00", Description = "BinLoc13Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 120, CreatedOn = DateTime.Now }; var binLocation14 = new BinLocation() { Name = "C903400A00", Description = "BinLoc14Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 130, CreatedOn = DateTime.Now }; var binLocation15 = new BinLocation() { Name = "C903300B", Description = "BinLoc15Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 150, CreatedOn = DateTime.Now }; var binLocation16 = new BinLocation() { Name = "C903250B00", Description = "BinLoc16Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 140, CreatedOn = DateTime.Now }; var binLocation17 = new BinLocation() { Name = "C903100A", Description = "BinLoc17Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 90, CreatedOn = DateTime.Now }; var binLocation18 = new BinLocation() { Name = "C902140B00", Description = "BinLoc18Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 80, CreatedOn = DateTime.Now }; var binLocation19 = new BinLocation() { Name = "Buffer1", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 60, CreatedOn = DateTime.Now }; var binLocation20 = new BinLocation() { Name = "Buffer2", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 50, CreatedOn = DateTime.Now }; var binLocation21 = new BinLocation() { Name = "Buffer3", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now }; var binLocation22 = new BinLocation() { Name = "Buffer4", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now }; var binLocation23 = new BinLocation() { Name = "Buffer5", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now }; var binLocation24 = new BinLocation() { Name = "Buffer6", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now }; dbContext.BinLocation.Add(binLocation1); dbContext.BinLocation.Add(binLocation2); dbContext.BinLocation.Add(binLocation3); dbContext.BinLocation.Add(binLocation4); dbContext.BinLocation.Add(binLocation5); dbContext.BinLocation.Add(binLocation6); dbContext.BinLocation.Add(binLocation7); dbContext.BinLocation.Add(binLocation8); dbContext.BinLocation.Add(binLocation9); dbContext.BinLocation.Add(binLocation10); dbContext.BinLocation.Add(binLocation11); dbContext.BinLocation.Add(binLocation12); dbContext.BinLocation.Add(binLocation13); dbContext.BinLocation.Add(binLocation14); dbContext.BinLocation.Add(binLocation15); dbContext.BinLocation.Add(binLocation16); dbContext.BinLocation.Add(binLocation17); dbContext.BinLocation.Add(binLocation18); dbContext.BinLocation.Add(binLocation19); dbContext.BinLocation.Add(binLocation20); dbContext.BinLocation.Add(binLocation21); dbContext.BinLocation.Add(binLocation22); dbContext.BinLocation.Add(binLocation23); dbContext.BinLocation.Add(binLocation24); var part1 = new PartDetails() { Name = "SPRING", PartNo = "9524600Z17", CreatedBy = user1, CreatedOn = DateTime.Now }; var part2 = new PartDetails() { Name = "FILTER KIT", PartNo = "5222842791", CreatedBy = user1, CreatedOn = DateTime.Now }; var part3 = new PartDetails() { Name = "OIL FILTER", PartNo = "5222771970", CreatedBy = user1, CreatedOn = DateTime.Now }; var part4 = new PartDetails() { Name = "BUSHING", PartNo = "5406300Z11", CreatedBy = user1, CreatedOn = DateTime.Now }; var part5 = new PartDetails() { Name = "PLATE-LOCATING", PartNo = "1301000Z01", CreatedBy = user1, CreatedOn = DateTime.Now }; var part6 = new PartDetails() { Name = "BRAKE VALVE", PartNo = "4528900Z05", CreatedBy = user1, CreatedOn = DateTime.Now }; var part7 = new PartDetails() { Name = "PRESSURE LIMITI", PartNo = "4758000Z1B", CreatedBy = user1, CreatedOn = DateTime.Now }; var part8 = new PartDetails() { Name = "V-RIBBED BELT", PartNo = "5222802248", CreatedBy = user1, CreatedOn = DateTime.Now }; var part9 = new PartDetails() { Name = "DIAPHRAGM", PartNo = "C903250B00", CreatedBy = user1, CreatedOn = DateTime.Now }; dbContext.PartDetails.Add(part1); dbContext.PartDetails.Add(part2); dbContext.PartDetails.Add(part3); dbContext.PartDetails.Add(part4); dbContext.PartDetails.Add(part5); dbContext.PartDetails.Add(part6); dbContext.PartDetails.Add(part7); dbContext.PartDetails.Add(part8); dbContext.PartDetails.Add(part9); var inventoryLoc1 = new InventoryLocation() { BinLocation = binLocation1, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc2 = new InventoryLocation() { BinLocation = binLocation2, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc3 = new InventoryLocation() { BinLocation = binLocation3, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc4 = new InventoryLocation() { BinLocation = binLocation4, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc5 = new InventoryLocation() { BinLocation = binLocation5, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc6 = new InventoryLocation() { BinLocation = binLocation6, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc7 = new InventoryLocation() { BinLocation = binLocation7, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc8 = new InventoryLocation() { BinLocation = binLocation8, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc9 = new InventoryLocation() { BinLocation = binLocation9, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc10 = new InventoryLocation() { BinLocation = binLocation10, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc11 = new InventoryLocation() { BinLocation = binLocation11, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc12 = new InventoryLocation() { BinLocation = binLocation12, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc13 = new InventoryLocation() { BinLocation = binLocation13, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc14 = new InventoryLocation() { BinLocation = binLocation14, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc15 = new InventoryLocation() { BinLocation = binLocation15, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc16 = new InventoryLocation() { BinLocation = binLocation16, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc17 = new InventoryLocation() { BinLocation = binLocation17, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc18 = new InventoryLocation() { BinLocation = binLocation18, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc19 = new InventoryLocation() { BinLocation = binLocation19, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc20 = new InventoryLocation() { BinLocation = binLocation20, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc21 = new InventoryLocation() { BinLocation = binLocation21, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc22 = new InventoryLocation() { BinLocation = binLocation22, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc23 = new InventoryLocation() { BinLocation = binLocation23, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventoryLoc24 = new InventoryLocation() { BinLocation = binLocation24, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory1 = new Inventory() { QRCode = "Q1201807121", Warehouse = warehouse1, Description = "Description1", TotalQuantity = 100, Part = part1, InventoryLocations = new List <InventoryLocation>() { inventoryLoc1, inventoryLoc19 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory2 = new Inventory() { QRCode = "Q1201807122", Warehouse = warehouse1, Description = "Description2", TotalQuantity = 200, Part = part2, InventoryLocations = new List <InventoryLocation>() { inventoryLoc2, inventoryLoc20 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory3 = new Inventory() { QRCode = "Q1201807123", Warehouse = warehouse1, Description = "Description3", TotalQuantity = 60, Part = part3, InventoryLocations = new List <InventoryLocation>() { inventoryLoc3, inventoryLoc21 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory4 = new Inventory() { QRCode = "Q1201807124", Warehouse = warehouse1, Description = "Description4", TotalQuantity = 80, Part = part4, InventoryLocations = new List <InventoryLocation>() { inventoryLoc4, inventoryLoc22 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory5 = new Inventory() { QRCode = "Q1201807125", Warehouse = warehouse1, Description = "Description5", TotalQuantity = 70, Part = part5, InventoryLocations = new List <InventoryLocation>() { inventoryLoc5, inventoryLoc23 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory6 = new Inventory() { QRCode = "Q1201807126", Warehouse = warehouse1, Description = "Description6", TotalQuantity = 40, Part = part6, InventoryLocations = new List <InventoryLocation>() { inventoryLoc6, inventoryLoc24 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory7 = new Inventory() { QRCode = "Q1201807127", Warehouse = warehouse1, Description = "Description7", TotalQuantity = 110, Part = part7, InventoryLocations = new List <InventoryLocation>() { inventoryLoc7 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory8 = new Inventory() { QRCode = "Q1201807128", Warehouse = warehouse1, Description = "Description8", TotalQuantity = 120, Part = part8, InventoryLocations = new List <InventoryLocation>() { inventoryLoc8 }, CreatedBy = user1, CreatedOn = DateTime.Now }; var inventory9 = new Inventory() { QRCode = "Q1201807129", Warehouse = warehouse1, Description = "Description9", TotalQuantity = 130, Part = part9, InventoryLocations = new List <InventoryLocation>() { inventoryLoc9 }, CreatedBy = user1, CreatedOn = DateTime.Now }; //dbContext.InventoryLocation.Add(inventoryLoc1); //dbContext.InventoryLocation.Add(inventoryLoc2); //dbContext.InventoryLocation.Add(inventoryLoc3); //dbContext.InventoryLocation.Add(inventoryLoc4); //dbContext.InventoryLocation.Add(inventoryLoc5); //dbContext.InventoryLocation.Add(inventoryLoc6); //dbContext.InventoryLocation.Add(inventoryLoc7); //dbContext.InventoryLocation.Add(inventoryLoc8); //dbContext.InventoryLocation.Add(inventoryLoc9); //dbContext.InventoryLocation.Add(inventoryLoc10); //dbContext.InventoryLocation.Add(inventoryLoc11); //dbContext.InventoryLocation.Add(inventoryLoc12); //dbContext.InventoryLocation.Add(inventoryLoc13); //dbContext.InventoryLocation.Add(inventoryLoc14); //dbContext.InventoryLocation.Add(inventoryLoc15); //dbContext.InventoryLocation.Add(inventoryLoc16); //dbContext.InventoryLocation.Add(inventoryLoc17); //dbContext.InventoryLocation.Add(inventoryLoc18); dbContext.Inventory.Add(inventory1); dbContext.Inventory.Add(inventory2); dbContext.Inventory.Add(inventory3); dbContext.Inventory.Add(inventory4); dbContext.Inventory.Add(inventory5); dbContext.Inventory.Add(inventory6); dbContext.Inventory.Add(inventory7); dbContext.Inventory.Add(inventory8); dbContext.Inventory.Add(inventory9); //Save Changes dbContext.SaveChanges(); }
//[ValidateAntiForgeryToken] public ActionResult _CreatePost(BinLocation svm) { bool BeforeSave = true; Godown temp = _GodownService.Find(svm.GodownId); if (_BinLocationService.IsDuplicateBinLocationName(svm.GodownId, svm.BinLocationCode, svm.BinLocationId)) { ModelState.AddModelError("BinLocationId", "Chak Code is already entered in Property."); } if (_BinLocationService.IsDuplicateBinLocationName(svm.GodownId, svm.BinLocationName, svm.BinLocationId)) { ModelState.AddModelError("BinLocationId", "Chak Name is already entered in Property."); } if (svm.BinLocationId <= 0) { ViewBag.LineMode = "Create"; } else { ViewBag.LineMode = "Edit"; } if (ModelState.IsValid && BeforeSave) { if (svm.BinLocationId <= 0) { try { svm.IsActive = true; svm.CreatedDate = DateTime.Now; svm.ModifiedDate = DateTime.Now; svm.CreatedBy = User.Identity.Name; svm.ModifiedBy = User.Identity.Name; svm.ObjectState = Model.ObjectState.Added; _BinLocationService.Create(svm); _logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = (int)temp.DocTypeId, DocId = temp.GodownId, DocLineId = svm.BinLocationId, ActivityType = (int)ActivityTypeContants.Added, DocNo = temp.GodownName, DocDate = temp.CreatedDate, })); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; return(PartialView("_Create", svm)); } return(RedirectToAction("_Create", new { id = svm.GodownId })); } else { try { BinLocation binlocation = _BinLocationService.Find(svm.BinLocationId); List <LogTypeViewModel> LogList = new List <LogTypeViewModel>(); BinLocation ExTempLine = new BinLocation(); ExTempLine = Mapper.Map <BinLocation>(binlocation); binlocation.BinLocationCode = svm.BinLocationCode; binlocation.BinLocationName = svm.BinLocationName; binlocation.IsActive = svm.IsActive; binlocation.ModifiedDate = DateTime.Now; binlocation.ModifiedBy = User.Identity.Name; binlocation.ObjectState = Model.ObjectState.Modified; _BinLocationService.Update(binlocation); LogList.Add(new LogTypeViewModel { ExObj = ExTempLine, Obj = binlocation }); XElement Modifications = _modificationCheck.CheckChanges(LogList); _logger.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = (int)temp.DocTypeId, DocId = temp.GodownId, DocLineId = binlocation.BinLocationId, ActivityType = (int)ActivityTypeContants.Modified, DocNo = temp.GodownName, xEModifications = Modifications, DocDate = temp.CreatedDate, })); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; return(PartialView("_Create", svm)); } return(Json(new { success = true })); } } return(PartialView("_Create", svm)); }
public BinLocation Create(BinLocation pt) { pt.ObjectState = ObjectState.Added; _unitOfWork.Repository <BinLocation>().Add(pt); return(pt); }
public BinLocation Add(BinLocation pt) { _unitOfWork.Repository <BinLocation>().Insert(pt); return(pt); }
public void Update(BinLocation pt) { pt.ObjectState = ObjectState.Modified; _unitOfWork.Repository <BinLocation>().Update(pt); }
public void Delete(BinLocation pt) { _unitOfWork.Repository <BinLocation>().Delete(pt); }