public HaulRouteManager() : base()
{
//haulroute dataadapter and commands
harvestActivityManager = new HarvestActivityManager();
daData = new SqlDataAdapter("select * from rsm_harvesthaulroutes", connRSM);
cbData = new SqlCommandBuilder(daData);
daHaulRoadIDs = new SqlDataAdapter("select * from rsm_HaulRoadIDs", connRSM);
cbHaulRoadIDs = new SqlCommandBuilder(daHaulRoadIDs);
daRoads = new SqlDataAdapter("select * from rsm_Roads", connRSM);
//arrays
harvestUnits = new ArrayList();
destinations = new ArrayList();
//queries
cmdGetHaulName = new SqlCommand("select haulroutename from rsm_harvesthaulroutes where haulid = @haulid", connRSM);
cmdGetHaulName.Parameters.Add("@haulid",SqlDbType.Int);
daGetHaulRoutesForUnit = new SqlDataAdapter("select * from rsm_harvesthaulroutes where harvestunitname = @harvestunitname and lnversionid = @lnversionid", connRSM);
daGetHaulRoutesForUnit.SelectCommand.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 10);
daGetHaulRoutesForUnit.SelectCommand.Parameters.Add("@lnversionid", SqlDbType.Int);
}
public HaulRouteManager() : base()
{
//haulroute dataadapter and commands
harvestActivityManager = new HarvestActivityManager();
daData = new SqlDataAdapter("select * from rsm_harvesthaulroutes", connRSM);
cbData = new SqlCommandBuilder(daData);
daHaulRoadIDs = new SqlDataAdapter("select * from rsm_HaulRoadIDs", connRSM);
cbHaulRoadIDs = new SqlCommandBuilder(daHaulRoadIDs);
daRoads = new SqlDataAdapter("select * from rsm_Roads", connRSM);
//arrays
harvestUnits = new ArrayList();
destinations = new ArrayList();
//queries
cmdGetHaulName = new SqlCommand("select haulroutename from rsm_harvesthaulroutes where haulid = @haulid", connRSM);
cmdGetHaulName.Parameters.Add("@haulid", SqlDbType.Int);
daGetHaulRoutesForUnit = new SqlDataAdapter("select * from rsm_harvesthaulroutes where harvestunitname = @harvestunitname and lnversionid = @lnversionid", connRSM);
daGetHaulRoutesForUnit.SelectCommand.Parameters.Add("@harvestunitname", SqlDbType.VarChar, 10);
daGetHaulRoutesForUnit.SelectCommand.Parameters.Add("@lnversionid", SqlDbType.Int);
}
