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