public UniversalEntity RetrieveDevicesByID(int id)
{
WPDeviceDAO entDAO = new WPDeviceDAO();
sc = new SqlCommand("RetrieveDevicesByID");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@id", id);
return(entDAO.retrieveEntity(sc));
}
public int Create(WPDevice ent)
{
int createdid = 0;
WPDeviceDAO entDAO = new WPDeviceDAO();
sc = new SqlCommand("CreateWPDevice");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public int CreateWithAssign(WPDevice ent, int wpid, int userID)
{
int createdid = 0;
WPDeviceDAO entDAO = new WPDeviceDAO();
sc = new SqlCommand("CreateWPDeviceWithAssign");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
sc.Parameters.Add("@wpid", wpid);
sc.Parameters.Add("@UserID", userID);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public UniversalEntity RetrieveDevicesByNameAndType(int type, string title)
{
WPDeviceDAO entDAO = new WPDeviceDAO();
sc = new SqlCommand("RetrieveDevicesByNameAndType");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@type", type);
if (!string.IsNullOrEmpty(title))
{
sc.Parameters.Add("@Title", title);
}
else
{
sc.Parameters.Add("@Title", DBNull.Value);
}
return(entDAO.retrieveEntity(sc));
}
