public static string PH_HaulierUp_Insert(string strConnDB, AppCode_DS.PHDS_HaulierUpload.TransportationRow dr) { try { return(SqlHelper.ExecuteNonQueryTypedParams(strConnDB, "usp_PrimaryHaul_TransportationInsert", dr).ToString()); } catch (Exception ex) { throw new Exception("PH_HaulierUp_Insert >> " + ex.Message); } }
public static string PH_HaulierUp_FindRateCard(string strConnDB, AppCode_DS.PHDS_HaulierUpload.TransportationRow dr) { try { DataSet ds = SqlHelper.ExecuteDataset(strConnDB, "usp_PrimaryHaul_FindRateCard" , new SqlParameter[] { new SqlParameter("@Vendor_Code", dr.Vendor_Code) , new SqlParameter("@Vendor_Name", dr.Vendor_Name) , new SqlParameter("@Fuel_Rate", dr.Fuel_Rate) , new SqlParameter("@Rate_Per_Unit", dr.Rate_Per_Unit) , new SqlParameter("@RateType", dr.RateType) , new SqlParameter("@Deliver_Location", dr.Delivery_Location) , new SqlParameter("@Collection_Point", dr.Collection_Point) , new SqlParameter("@PO_No", dr.PO_No) , new SqlParameter("@Delivery_Ref", dr.Delivery_Ref) }); return(ds.Tables[0].Rows.Count > 0 ? "" : "err_miss"); } catch (Exception ex) { throw new Exception("PH_HaulierUp_FindRateCard >> " + ex.Message); } }