public void UpdateLot(Lots lot)
{
InventorySprocs sproc = new InventorySprocs();
//Build customProp Ids and Values
string propValsId = lot.weightId + "," + lot.widthId + "," + lot.heightId + "," + lot.volumeId + "," + lot.nextInvDateId + "," + lot.lastInvDateId;
string propVals = lot.weight + "," + lot.width + "," + lot.height + "," + lot.volume + "," + lot.nextInvDate + "," + lot.lastInvDate;
sproc.UpdateLot(lot, propValsId, propVals);
}
public string AddLot(Lots lot)
{
InventorySprocs sproc = new InventorySprocs();
//Build customProp Ids and Values
string propValsId = "1,2,3,4,5,6";
string propVals = lot.weight + "," + lot.width + "," + lot.height + "," + lot.volume + "," + lot.nextInvDate + "," + lot.lastInvDate;
return sproc.InsertLot(lot.serialNo,lot.price.ToString(),
lot.purchaseDate, lot.expirationDate, propValsId, propVals, lot.notes);
}
public List<Lots> SearchSerialNo(string serialNo)
{
InventorySprocs sproc = new InventorySprocs();
return sproc.SearchSerialNo(serialNo);
}
public void InsertImageMapping(string id, string fileName)
{
InventorySprocs sproc = new InventorySprocs();
sproc.InsertImageMapping(id, fileName);
}
public List<MatType> GetMatTypesByCategories(int brandID)
{
InventorySprocs sproc = new InventorySprocs();
return sproc.GetMatTypesByCategories(brandID);
}
public List<MatCategory> GetMatCategories()
{
InventorySprocs sproc = new InventorySprocs();
return sproc.GetMatCategories();
}
public List<Lots> GetInventoryReport(string serialNo)
{
InventorySprocs sproc = new InventorySprocs();
return sproc.GetInventoryReport(serialNo);
}
public List<ImageMapping> GetImagesByLot(int lotID)
{
InventorySprocs sproc = new InventorySprocs();
return sproc.GetImagesByLot(lotID);
}
