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