Line 5166: DataRow dr = (DataRow)Session["drMySession"];
Line 5167:
Line 5168: if (Convert.ToInt32(dr["user_id"].ToString()) == 311)
Line 5169: {
Line 5170: sortsql = "Select 'https://perfectliving.org/app/lawnschedule.aspx?bwtype=1&lawn_care_id='+ CAST(lawn_care_id as varchar(10)) as Website, lawn_care_id, last_completed_date,service_day,start_date, frequency,client_name as name,contact_number as phone,house_number + ' ' + street_name + ' ' + city + ' ' + zip_code as Address,provider_pay as PAY, date_added, latitude, longitude, '0.00 miles' as distance, sequence_order, lot_size,route_notes,route_notify,valued_customer,route_shrubs,route_shrubspay,client_next_service_notes,shrubs_completed_ind, (Select NHA_USER.full_name from NHA_User where NHA_User.user_id=cust_lawn_care.employee_id) as employeename, routeday, routesort from cust_lawn_care where lawn_provider_id=@lawn_provider_id order by sequence_order";
|