/// <summary>
/// PH_UserVendor_Insert
/// </summary>
/// <param name="strConnDB"></param>
/// <param name="drVendor"></param>
/// <returns></returns>
public static string PH_UserVendor_Insert(string strConnDB, AppCode_DS.PHDS_User.User_VendorRow drVendor)
{
try
{
return SqlHelper.ExecuteNonQueryTypedParams(strConnDB, "usp_PrimaryHaul_UserVendorInsert", drVendor).ToString();
}
catch (Exception ex)
{
throw new Exception("PH_UserVendor_Insert >>" + ex.Message);
}
}
/// <summary>
/// PH_UserVendor_Delete
/// </summary>
/// <param name="strConnDB"></param>
/// <param name="drVendor"></param>
/// <returns></returns>
public static string PH_UserVendor_Delete(string strConnDB, AppCode_DS.PHDS_User.User_VendorRow drVendor)
{
try
{
return SqlHelper.ExecuteNonQuery(strConnDB, "sp_UserVendor_delete", new SqlParameter[] { new SqlParameter("@UserID", drVendor.Vendor_Code) }).ToString();
}
catch (Exception ex)
{
throw new Exception("PH_UserVendor_Delete >>" + ex.Message);
}
}
/// <summary>
/// PH_UserProfile_Delete
/// </summary>
/// <param name="strConnDB"></param>
/// <param name="drProfile"></param>
/// <returns></returns>
public static string PH_UserProfile_Delete(string strConnDB, AppCode_DS.PHDS_User.User_ProfileRow drProfile)
{
try
{
return SqlHelper.ExecuteNonQuery(strConnDB, "sp_userprofile_delete",new SqlParameter[] {new SqlParameter("@UserID",drProfile.UserID) } ).ToString();
}
catch(Exception ex)
{
throw new Exception("PH_UserProfile_Delete >>" + ex.Message);
}
}
public static string PH_BHTransaction_InsertTMP(string strConnDB, AppCode_DS.PHDS_BHUpload.BH_Transaction_TMPRow dr)
{
try
{
return SqlHelper.ExecuteNonQueryTypedParams(strConnDB, "usp_BH_Transaction_TMP_Insert", dr).ToString();
}
catch (Exception ex)
{
throw new Exception("PH_BHTransaction_InsertTMP >> " + 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);
}
}
public static string PH_HaulierUp_InsertTMP(string strConnDB, AppCode_DS.PHDS_HaulierUpload.TransportationRow dr)
{
try
{
return SqlHelper.ExecuteNonQueryTypedParams(strConnDB, "usp_PrimaryHaul_TransportationTMP_Insert", dr).ToString();
}
catch (Exception ex)
{
throw new Exception("PH_HaulierUp_InsertTMP >> " + ex.Message);
}
}
