public UniversalEntity RetrieveUserLocationByFOrder(int id) { sc = new SqlCommand("RetrieveUserLocationByFOrder"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@id", id); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.RetrieveUserLocationByFOrder(sc)); }
public UniversalEntity RetrieveUActByOrderID5HighRub(int OrderID) { sc = new SqlCommand("RetrieveUActByOrderID5HighRub"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@orderid", OrderID); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.RetrieveFActByOrderID5HighRub(sc)); }
public UniversalEntity RetrieveReplacementActBySOrderID5High(int OrderID) { sc = new SqlCommand("RetrieveReplacementActBySOrderIDHigh"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@orderid", OrderID); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.RetrieveReplacementActBySOrderID5HighStored(sc)); }
public UniversalEntity RetrieveWithdrawalActBySOrderID5HighWithdrawalSpecial(int OrderID) { sc = new SqlCommand("RetrieveSActByOrderID5HighWithdrawal"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@orderid", OrderID); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.RetrieveWithdrawalActBySOrderID5HighWithdrawalSpecial(sc)); }
public UniversalEntity RetrieveUserLocationBySurname(string surname) { sc = new SqlCommand("RetrieveUserLocationBySurname"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@surname", surname); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.RetrieveUserLocationBySurname(sc)); }
public UniversalEntity GetRateByDateAndWP(int wp, int type, DateTime sd, DateTime ed) { sc = new SqlCommand("GetRateByDateAndWP"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@WPID", wp); sc.Parameters.Add("@type", type); sc.Parameters.Add("@DateLow", sd); sc.Parameters.Add("@DateHigh", ed); CustomRetrieverDAO cDAO = new CustomRetrieverDAO(); return(cDAO.GetRateByDateAndWP(sc)); }