DataTable IInvoiceContext.GetInvoiceByID(int InvoiceID)
{
string query = "SELECT* FROM Invoice WHERE ID = @InvID";
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@InvID", InvoiceID)
};
return(SQL_CRUD_Methods.SQLReadParameterized(query, parameters));
}
DataTable IEmployeeContext.GetEmployeeByID(int EmployeeID)
{
string query = "SELECT * FROM Employee WHERE ID = @EmpID";
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@EmpID", EmployeeID)
};
return(SQL_CRUD_Methods.SQLReadParameterized(query, parameters));
}
DataTable ICustomerContext.GetCustomerByID(int CustomerID)
{
string query = "SELECT * FROM [Customer] WHERE ID = @CustID";
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@CustID", CustomerID)
};
return(SQL_CRUD_Methods.SQLReadParameterized(query, parameters));
}
DataTable IRentableContext.GetRentableByID(int RentableID)
{
string query = "SELECT * FROM Rentable WHERE ID = @RentID";
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("@RentID", RentableID)
};
return(SQL_CRUD_Methods.SQLReadParameterized(query, parameters));
}
