/// <summary>
/// Check if data of this Period was used by another transaction
/// </summary>
/// <param name="pintStockTakingPeriodID"></param>
/// <returns>return false if was used, true if not</returns>
/// <author>Trada</author>
/// <date>Wednesday, July 26 2006</date>
public bool CheckIfDataWasUsed(int pintStockTakingPeriodID)
{
IV_StockTakingDS dsIV_StockTaking = new IV_StockTakingDS();
DataSet dstStockTaking = dsIV_StockTaking.GetStockTakingByPeriodID(pintStockTakingPeriodID);
if (dstStockTaking.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
public int AddNewStockTaking(object pobjStockTakingMasterVO, DataSet pdstData)
{
IV_StockTakingMasterVO voStockTakingMaster = (IV_StockTakingMasterVO)pobjStockTakingMasterVO;
//Update StockTakingPeriod
IV_StockTakingMasterDS dsStockTakingMaster = new IV_StockTakingMasterDS();
voStockTakingMaster.StockTakingMasterID = dsStockTakingMaster.AddAndReturnID(voStockTakingMaster);
//Set value for StockTakingPeriodID column in the dataset
foreach (DataRow drow in pdstData.Tables[IV_StockTakingTable.TABLE_NAME].Rows)
{
if (drow.RowState == DataRowState.Deleted)
{
continue;
}
drow[IV_StockTakingTable.STOCKTAKINGMASTERID_FLD] = voStockTakingMaster.StockTakingMasterID;
}
//update Stock Taking
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
dsStockTaking.UpdateDataSet(pdstData);
return(voStockTakingMaster.StockTakingMasterID);
}
/// <summary>
/// UpdateStockTaking
/// </summary>
/// <param name="pobjStockTakingMasterVO"></param>
/// <author>Trada</author>
/// <date>Tuesday, July 25 2006</date>
public void UpdateStockTaking(object pobjStockTakingMasterVO, DataSet pdstData)
{
IV_StockTakingMasterVO voStockTakingMaster = (IV_StockTakingMasterVO)pobjStockTakingMasterVO;
//Update StockTakingPeriod
IV_StockTakingMasterDS dsStockTakingMaster = new IV_StockTakingMasterDS();
dsStockTakingMaster.Update(voStockTakingMaster);
pdstData.Tables[1].TableName = "IV_StockTaking";
//Set value for StockTakingPeriodID column in the dataset
foreach (DataRow drow in pdstData.Tables["IV_StockTaking"].Rows)
{
if (drow.RowState == DataRowState.Deleted)
{
continue;
}
drow[IV_StockTakingTable.STOCKTAKINGMASTERID_FLD] = voStockTakingMaster.StockTakingMasterID;
}
//update Stock Taking
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
dsStockTaking.UpdateDataSet(pdstData);
}
public DataTable ListItemToUpdate(int pintPeriodID)
{
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
return(dsStockTaking.ListItemToUpdate(pintPeriodID));
}
/// <summary>
/// Get StockTaking by PeriodID
/// </summary>
/// <param name="pintStockTakingPeriodID"></param>
/// <returns></returns>
/// <author>Trada</author>
/// <date>Monday, August 14 2006</date>
public DataSet GetStockTakingByPeriodID(int pintStockTakingPeriodID)
{
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
return(dsStockTaking.GetStockTakingByPeriodID(pintStockTakingPeriodID));
}
public DataTable GetQuantityFromBin(int pintLocationID, int pintBinID)
{
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
return(dsStockTaking.GetQuantityFromBin(pintLocationID, pintBinID));
}
public void DeleteStockTaking(int pintStockTakingMasterID)
{
IV_StockTakingDS dsStockTaking = new IV_StockTakingDS();
dsStockTaking.DeleteStockTaking(pintStockTakingMasterID);
}
