public static double GetDefaultBoxRate(string zip) { sp_004_box_rateTableAdapter taBoxRate = new sp_004_box_rateTableAdapter(); Search.sp_004_box_rateDataTable dtBoxRate = taBoxRate.GetBoxRate(zip); string utilityRate = dtBoxRate.Rows[0]["BoxRate"].ToString(); return(Convert.ToDouble(utilityRate)); }
public static double GetDefaultBoxRate(string zip) { try { sp_004_box_rateTableAdapter taBoxRate = new sp_004_box_rateTableAdapter(); Search.sp_004_box_rateDataTable dtBoxRate = taBoxRate.GetBoxRate(zip); string utilityRate = dtBoxRate.Rows[0]["BoxRate"].ToString(); return Convert.ToDouble(utilityRate); } catch { return 0; } }