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