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