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