/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVProductStockPrimaryKey">Primary Key information based on which data is to be fetched.</param>
///
/// <returns>object of class INVProductStockBatchCollection</returns>
public INVProductStockBatchCollection SelectAllByForeignKeyProductStockID(INVProductStockPrimaryKey pk)
{
INVProductStockBatchCollection iNVProductStockBatchCollection = new INVProductStockBatchCollection();
foreach (POS.DataLayer.INVProductStockBatch _iNVProductStockBatch in POS.DataLayer.INVProductStockBatchBase.SelectAllByForeignKeyProductStockID(new POS.DataLayer.INVProductStockPrimaryKey(pk.ProductStockID)))
{
_iNVProductStockBatchWCF = new INVProductStockBatch();
_iNVProductStockBatchWCF.ProductStockBatchID = _iNVProductStockBatch.ProductStockBatchID;
_iNVProductStockBatchWCF.ProductStockID = _iNVProductStockBatch.ProductStockID;
_iNVProductStockBatchWCF.BatchID = _iNVProductStockBatch.BatchID;
_iNVProductStockBatchWCF.Qty = _iNVProductStockBatch.Qty;
iNVProductStockBatchCollection.Add(_iNVProductStockBatchWCF);
}
return(iNVProductStockBatchCollection);
}
/// <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;
return(_iNVProductStockWCF);
}
new private bool Validate()
{
bool isValid = false;
bool isValidProduct = false;
int ProductID=0;
int InvProductID=0;
int? oldStockTypeId = dgrid_stock.SelectedRows.Count > 0 ? int.Parse(dgrid_stock.SelectedRows[0].Cells["col_StockTypeID"].Value.ToString()) : 0;
string BatchID = dgrid_batches.SelectedRows.Count > 0 ? dgrid_batches.SelectedRows[0].Cells["col_batch"].Value.ToString() : "";
DateTime? ExpiryDate = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDateTime(dgrid_batches.SelectedRows[0].Cells["col_expiry"].Value.ToString()) : (DateTime?)null;
decimal oldQty = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDecimal(dgrid_batches.SelectedRows[0].Cells["col_batchQty"].Value.ToString()) : dgrid_stock.SelectedRows.Count>0? Convert.ToDecimal(dgrid_stock.SelectedRows[0].Cells["col_qty"].Value.ToString()):0;
int AdjustReasonID = 0;
int StockTypeID = 0;
int InventoryID = 0;
decimal Qty = num_Qty.Value;
if (dgrid_stock.SelectedRows.Count > 0)
int.TryParse(dgrid_stock.SelectedRows[0].Cells["col_invProductStock"].Value.ToString(), out InvProductID);
if (cbx_AdjustReason.SelectedValue != null)
int.TryParse(cbx_AdjustReason.SelectedValue.ToString(), out AdjustReasonID);
if (cbx_StockTypeTO.SelectedValue != null)
int.TryParse(cbx_StockTypeTO.SelectedValue.ToString(), out StockTypeID);
if (cbx_Store.SelectedValue != null)
int.TryParse(cbx_Store.SelectedValue.ToString(), out InventoryID);
if (InvProductID > 0)
{
isValidProduct = true;
INVProductStockPrimaryKey ispk = new INVProductStockPrimaryKey();
ispk.ProductStockID = InvProductID;
var invPS = _invProductStockWrapper.SelectOne(ispk);
ProductID = invPS.ProductID.Value;
BDProductPrimaryKey pk = new BDProductPrimaryKey();
pk.ProductID = invPS.ProductID;
if (_ProductWrapper.SelectOne(pk).IsAcceptBatch == true)
isValidProduct = (!string.IsNullOrEmpty(BatchID) && ExpiryDate.HasValue);
}
if (!isValidProduct || AdjustReasonID == 0 || StockTypeID == 0 || InventoryID == 0 || Qty == 0 || Qty > oldQty || oldStockTypeId == StockTypeID)
isValid= false;
else
{
isValid = true;
if (_isEdit)
{
INVAdjustStock _EditNewAdjustStock = _adjustStock;
_EditNewAdjustStock.Qty *= -1;
_adjustStockCollection.Add(_EditNewAdjustStock);
INVAdjustStock _EditOldAdjustStock = _adjustStock;
_adjustStock.StockTypeID = _adjustStock.OldStockTypeID;
_adjustStockCollection.Add(_EditOldAdjustStock);
}
_adjustStock.ProductID = ProductID;
_adjustStock.AdjustReasonID = AdjustReasonID;
_adjustStock.AdjustStockID = _adjustStockID;
_adjustStock.BatchID = null;
_adjustStock.InventoryID = InventoryID;
_adjustStock.StockTypeID = StockTypeID;
_adjustStock.OldStockTypeID = oldStockTypeId;
_adjustStock.Qty = Qty;
_adjustStock.BatchNumber = BatchID;
_adjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_adjustStock.UpdateDate = DateTime.Now;
_adjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_adjustStock.CredateDate = DateTime.Now;
_adjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
_adjustStockCollection.Add(_adjustStock);
INVAdjustStock _oldAdjustStock = new INVAdjustStock();
_oldAdjustStock.ProductID = ProductID;
_oldAdjustStock.AdjustReasonID = AdjustReasonID;
_oldAdjustStock.AdjustStockID = _adjustStockID;
_oldAdjustStock.BatchID = null;
_oldAdjustStock.InventoryID = InventoryID;
_oldAdjustStock.StockTypeID = oldStockTypeId;
_oldAdjustStock.Qty = (-1 * Qty);
_oldAdjustStock.BatchNumber = BatchID;
_oldAdjustStock.ExpiryDate = ExpiryDate;
if (_isEdit)
{
_oldAdjustStock.UpdateDate = DateTime.Now;
_oldAdjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID;
}
else
{
_oldAdjustStock.CredateDate = DateTime.Now;
_oldAdjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID;
}
_adjustStockCollection.Add(_oldAdjustStock);
}
return isValid;
}
///<summary>
///This method will Delete the object from the database
///</summary>
///<param name="pk" type="INVProductStockPrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <returns>True if succeeded</returns>
public bool Delete(INVProductStockPrimaryKey pk)
{
return(POS.DataLayer.INVProductStockBase.Delete(new POS.DataLayer.INVProductStockPrimaryKey(pk.ProductStockID)));
}
/// <summary>
/// This method will get row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVProductStockPrimaryKey">Primary Key information based on which data is to be fetched.</param>
/// <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>object of class INVProductStockBatchCollection</returns>
public INVProductStockBatchCollection SelectAllByForeignKeyProductStockIDPaged(INVProductStockPrimaryKey pk, int pageSize, int skipPages, string orderByStatement)
{
INVProductStockBatchCollection iNVProductStockBatchCollection = new INVProductStockBatchCollection();
foreach (POS.DataLayer.INVProductStockBatch _iNVProductStockBatch in POS.DataLayer.INVProductStockBatchBase.SelectAllByForeignKeyProductStockIDPaged(new POS.DataLayer.INVProductStockPrimaryKey(pk.ProductStockID), pageSize, skipPages, orderByStatement))
{
_iNVProductStockBatchWCF = new INVProductStockBatch();
_iNVProductStockBatchWCF.ProductStockBatchID = _iNVProductStockBatch.ProductStockBatchID;
_iNVProductStockBatchWCF.ProductStockID = _iNVProductStockBatch.ProductStockID;
_iNVProductStockBatchWCF.BatchID = _iNVProductStockBatch.BatchID;
_iNVProductStockBatchWCF.Qty = _iNVProductStockBatch.Qty;
iNVProductStockBatchCollection.Add(_iNVProductStockBatchWCF);
}
return(iNVProductStockBatchCollection);
}
/// <summary>
/// This method will delete row(s) from the database using the value of the field specified
/// along with the details of the child table.
/// </summary>
///
/// <param name="pk" type="INVProductStockPrimaryKey">Primary Key information based on which data is to be deleted.</param>
///
/// <returns>True if succeeded</returns>
public bool DeleteAllByForeignKeyProductStockID(INVProductStockPrimaryKey pk)
{
return(POS.DataLayer.INVProductStockBatchBase.DeleteAllByForeignKeyProductStockID(new POS.DataLayer.INVProductStockPrimaryKey(pk.ProductStockID)));
}
