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);
}
}
