// private POS.DataLayer.INVProductStock _iNVProductStock;
public INVProductStockCollection GetInventoryStock(int?ProductStockID, string productCode, string productName, bool?IsAcceptBatch, bool getWithBatch)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStock.GetInventoryStock(ProductStockID, productCode, productName, IsAcceptBatch, getWithBatch))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.ProductCode = _iNVProductStock.ProductCode;
_iNVProductStockWCF.ProductName = _iNVProductStock.ProductName;
_iNVProductStockWCF.StockType = _iNVProductStock.StockType;
_iNVProductStockWCF.BatchNo = _iNVProductStock.BatchNo;
_iNVProductStockWCF.ExpiryDate = _iNVProductStock.ExpiryDate;
_iNVProductStockWCF.BatchQty = _iNVProductStock.BatchQty;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return(iNVProductStockCollection);
}
public frmOpenningQuantitiesBatches(INVProductStock iNVProductStock, frmOpenningQuantities frm)
{
InitializeComponent();
_iNVProductStockWrapper = new INVProductStockWrapper();
this.iNVProductStock = iNVProductStock;
this.frmOpenningQuantitiesObj = frm;
}
private bool CollectScreenData()
{
foreach (DataGridViewRow row in dgrd_Batches.Rows)
{
if (row.Index != dgrd_Batches.Rows.Count - 1)
{
if (!Validate(row))
{
return(false);
}
INVProductStock _iNVProductStock = new INVProductStock();
_iNVProductStock.InventoryID = this.iNVProductStock.InventoryID;
_iNVProductStock.CreateDate = this.iNVProductStock.CreateDate;
_iNVProductStock.CreatedBy = this.iNVProductStock.CreatedBy;
_iNVProductStock.OpeningQty = this.iNVProductStock.OpeningQty;
_iNVProductStock.OpennigDate = this.iNVProductStock.OpennigDate;
_iNVProductStock.ProductID = this.iNVProductStock.ProductID;
_iNVProductStock.StockTypeID = this.iNVProductStock.StockTypeID;
_iNVProductStock.TotalQty = this.iNVProductStock.TotalQty;
_iNVProductStock.BatchNo = row.Cells["BatchNumber"].Value.ToString();
_iNVProductStock.ExpiryDate = DateTime.Parse(row.Cells["ExpiryDate"].Value.ToString());
_iNVProductStock.BatchQty = Convert.ToDecimal(row.Cells["Qty"].Value);
frmOpenningQuantitiesObj.iNVProductStockCollection.Add(_iNVProductStock);
}
}
return(true);
}
// private POS.DataLayer.INVProductStock _iNVProductStock;
public INVProductStockCollection GetInventoryStock(int? ProductStockID, string productCode, string productName, bool? IsAcceptBatch, bool getWithBatch,int? InventoryID)
{
INVProductStock _iNVProductStockWCF;
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStock.GetInventoryStock(ProductStockID, productCode, productName, IsAcceptBatch, getWithBatch, InventoryID))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.ProductCode = _iNVProductStock.ProductCode;
_iNVProductStockWCF.ProductName = _iNVProductStock.ProductName;
_iNVProductStockWCF.StockType = _iNVProductStock.StockType;
_iNVProductStockWCF.BatchNo = _iNVProductStock.BatchNo;
_iNVProductStockWCF.ExpiryDate = _iNVProductStock.ExpiryDate;
_iNVProductStockWCF.BatchQty = _iNVProductStock.BatchQty;
_iNVProductStockWCF.IsAcceptBatch = _iNVProductStock.IsAcceptBatch;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
private INVProductStock CollectHeaderData(DataGridViewRow row)
{
INVProductStock _iNVProductStock = new INVProductStock();
_iNVProductStock.InventoryID = Convert.ToInt32(cbx_Inventory.SelectedValue);
_iNVProductStock.OpeningQty = Convert.ToDecimal(row.Cells["TotalQty"].Value);
_iNVProductStock.OpennigDate = DateTime.Now;
_iNVProductStock.ProductID = Convert.ToInt32(row.Cells["ProductID"].Value);
_iNVProductStock.StockTypeID = 1;
_iNVProductStock.TotalQty = Convert.ToDecimal(row.Cells["TotalQty"].Value);
_iNVProductStock.CreateDate = DateTime.Now;
_iNVProductStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
return(_iNVProductStock);
}
/// <summary>
/// This method will return an object representing the record matching the primary key information specified.
/// </summary>
///
/// <param name="pk" type="INVProductStockPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVProductStock</returns>
public INVProductStock SelectOne(INVProductStockPrimaryKey pk)
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStock = POS.DataLayer.INVProductStockBase.SelectOne(new POS.DataLayer.INVProductStockPrimaryKey(pk.ProductStockID));
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
return _iNVProductStockWCF;
}
private void CollectScreenData()
{
foreach (DataGridViewRow row in dgrd_OpeningStockProducts.Rows)
{
if (row.Cells["TotalQty"].Value != null)
{
var result = iNVProductStockCollection.Where(a => a.ProductID == Convert.ToInt32(row.Cells["ProductID"].Value)).ToList();
if (result.Count == 0)
{
INVProductStock _iNVProductStock = new INVProductStock();
_iNVProductStock.InventoryID = Convert.ToInt32(cbx_Inventory.SelectedValue);
_iNVProductStock.CreateDate = DateTime.Now;
_iNVProductStock.OpeningQty = Convert.ToDecimal(row.Cells["TotalQty"].Value);
_iNVProductStock.OpennigDate = DateTime.Now;
_iNVProductStock.ProductID = Convert.ToInt32(row.Cells["ProductID"].Value);
_iNVProductStock.StockTypeID = 1;
_iNVProductStock.TotalQty = Convert.ToDecimal(row.Cells["TotalQty"].Value);
iNVProductStockCollection.Add(_iNVProductStock);
}
}
}
}
/// <summary>
/// This method will return a list of objects representing all records in the table.
/// </summary>
///
/// <returns>list of objects of class INVProductStock in the form of object of INVProductStockCollection </returns>
public INVProductStockCollection SelectAll()
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAll())
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
///<summary>
/// This method will update one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVProductStock" type="INVProductStock">This INVProductStock will be updated in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Update(INVProductStock iNVProductStock)
{
_iNVProductStock=POS.DataLayer.INVProductStock.SelectOne(new POS.DataLayer.INVProductStockPrimaryKey(iNVProductStock.ProductStockID));
_iNVProductStock.ProductID=iNVProductStock.ProductID;
_iNVProductStock.TotalQty=iNVProductStock.TotalQty;
_iNVProductStock.StockTypeID=iNVProductStock.StockTypeID;
_iNVProductStock.OpeningQty=iNVProductStock.OpeningQty;
_iNVProductStock.OpennigDate=iNVProductStock.OpennigDate;
_iNVProductStock.CreateDate=iNVProductStock.CreateDate;
_iNVProductStock.CreatedBy=iNVProductStock.CreatedBy;
_iNVProductStock.UpdateDate=iNVProductStock.UpdateDate;
_iNVProductStock.UpdatedBy=iNVProductStock.UpdatedBy;
_iNVProductStock.InventoryID=iNVProductStock.InventoryID;
_iNVProductStock.IsBlocked=iNVProductStock.IsBlocked;
return _iNVProductStock.Update();
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table
/// using the value of the field specified
/// </summary>
///
/// <param name="field" type="string">Field of the class INVProductStock</param>
/// <param name="fieldValue" type="object">Value for the field specified.</param>
/// <param name="fieldValue2" type="object">Value for the field specified.</param>
/// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
///
/// <returns>List of object of class INVProductStock in the form of an object of class INVProductStockCollection</returns>
public INVProductStockCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
/// <summary>
/// This method will return a list of objects representing the specified number of entries from the specified record number in the table.
/// </summary>
///
/// <param name="pageSize" type="int">Number of records returned.</param>
/// <param name="skipPages" type="int">The number of missing pages.</param>
/// <param name="orderByStatement" type="string">The field value to number.</param>
///
/// <returns>list of objects of class INVProductStock in the form of an object of class INVProductStockCollection </returns>
public INVProductStockCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement)
{
INVProductStockCollection iNVProductStockCollection = new INVProductStockCollection();
foreach (POS.DataLayer.INVProductStock _iNVProductStock in POS.DataLayer.INVProductStockBase.SelectAllPaged(pageSize, skipPages, orderByStatement))
{
_iNVProductStockWCF = new INVProductStock();
_iNVProductStockWCF.ProductStockID = _iNVProductStock.ProductStockID;
_iNVProductStockWCF.ProductID = _iNVProductStock.ProductID;
_iNVProductStockWCF.TotalQty = _iNVProductStock.TotalQty;
_iNVProductStockWCF.StockTypeID = _iNVProductStock.StockTypeID;
_iNVProductStockWCF.OpeningQty = _iNVProductStock.OpeningQty;
_iNVProductStockWCF.OpennigDate = _iNVProductStock.OpennigDate;
_iNVProductStockWCF.CreateDate = _iNVProductStock.CreateDate;
_iNVProductStockWCF.CreatedBy = _iNVProductStock.CreatedBy;
_iNVProductStockWCF.UpdateDate = _iNVProductStock.UpdateDate;
_iNVProductStockWCF.UpdatedBy = _iNVProductStock.UpdatedBy;
_iNVProductStockWCF.InventoryID = _iNVProductStock.InventoryID;
_iNVProductStockWCF.IsBlocked = _iNVProductStock.IsBlocked;
iNVProductStockCollection.Add(_iNVProductStockWCF);
}
return iNVProductStockCollection;
}
/// <summary>
/// This method will insert one new row into the database using the property Information
/// </summary>
///
/// <param name="iNVProductStock" type="INVProductStock">This INVProductStock will be inserted in the database.</param>
///
/// <returns>True if succeeded</returns>
public bool Insert(INVProductStock iNVProductStock)
{
_iNVProductStock = new POS.DataLayer.INVProductStock();
_iNVProductStock.ProductStockID=iNVProductStock.ProductStockID;
_iNVProductStock.ProductID=iNVProductStock.ProductID;
_iNVProductStock.TotalQty=iNVProductStock.TotalQty;
_iNVProductStock.StockTypeID=iNVProductStock.StockTypeID;
_iNVProductStock.OpeningQty=iNVProductStock.OpeningQty;
_iNVProductStock.OpennigDate=iNVProductStock.OpennigDate;
_iNVProductStock.CreateDate=iNVProductStock.CreateDate;
_iNVProductStock.CreatedBy=iNVProductStock.CreatedBy;
_iNVProductStock.UpdateDate=iNVProductStock.UpdateDate;
_iNVProductStock.UpdatedBy=iNVProductStock.UpdatedBy;
_iNVProductStock.InventoryID=iNVProductStock.InventoryID;
_iNVProductStock.IsBlocked=iNVProductStock.IsBlocked;
return _iNVProductStock.Insert();
}
