public Int32 GetColumnLength(String tableName, String columnName)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetColumnLength");
commandBuilder.AddParameter("table", tableName);
commandBuilder.AddParameter("column", columnName);
return(ExecuteScalar(commandBuilder));
}
public Int32 MoveContainer(Int32 movedContainerId, Int32 toContainerId, int user_id)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_MoveContainer");
commandBuilder.AddParameter(ContainerData.CONTAINER_ID, movedContainerId);
if (ChiasmaDepData.IsValidId(toContainerId))
{
commandBuilder.AddParameter(ContainerData.TO_CONTAINER_ID, toContainerId);
}
commandBuilder.AddParameter(ContainerData.AUTHORITY_ID, user_id);
return(ExecuteCommand(commandBuilder));
}
public DataReader SetAuthorityMappingFromBarcode(string userBarcode)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_SetAuthorityMappingFromBarcode");
commandBuilder.AddParameter(LoginData.CHIASMA_BARCODE, userBarcode);
return(GetRow(commandBuilder));
}
public DataReader GetUserFromBarcode(string barcode)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetUserFromBarcode");
commandBuilder.AddParameter(LoginData.CHIASMA_BARCODE, barcode);
return(GetReader(commandBuilder));
}
public DataReader GetUserByBarCode(String barCode)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetUserByBarCode");
commandBuilder.AddParameter(UserData.BAR_CODE, barCode);
return(GetReader(commandBuilder, CommandBehavior.Default));
}
public DataReader GetItem(String barCode)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetItem");
commandBuilder.AddParameter(BarCodeData.BAR_CODE, barCode);
return(GetRow(commandBuilder));
}
public DataReader GetGenericContainerByIdentifier(String genericContainerIdentifier)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetGenericContainerByIdentifier");
commandBuilder.AddParameter(GenericContainerData.IDENTIFIER, genericContainerIdentifier);
return(GetReader(commandBuilder, CommandBehavior.Default));
}
public DataReader GetContainerPath(Int32 genericContainerId)
{
SqlCommandBuilder commandBuilder;
commandBuilder = new SqlCommandBuilder("p_GetContainerPath");
commandBuilder.AddParameter(GenericContainerData.GENERIC_CONTAINER_ID, genericContainerId);
return(GetReader(commandBuilder, CommandBehavior.Default));
}