/// <summary> /// Gets a Cabset based on CabsetID /// </summary> /// <param name="cabsetId">ID of Cabset</param> /// <returns>Cabset</returns> public async Task <CabSet> GetCabsetById(int cabsetId) { try { var cabset = await CabsetDatabase.Where <CabSet>(c => c.CabsetId == cabsetId).FirstOrDefaultAsync(); return(cabset); } catch (Exception) { return(null); } }
/// <summary> /// Adds a Cabset to the Database /// </summary> /// <param name="newCabset">New Cabset</param> /// <returns>True if created, false else</returns> public async Task <bool> AddNewCabset(CabSet newCabset) { try { await CabsetDatabase.AddAsync(newCabset); await SaveChangesAsync(); return(true); } catch (Exception) { return(false); } }
/// <summary> /// Get a Cabset ID based on name /// </summary> /// <param name="name"></param> /// <returns></returns> public async Task <int> GetCabsetIdByName(string name) { var result = await CabsetDatabase.Where <CabSet>(c => c.CabsetName == name).FirstOrDefaultAsync <CabSet>(); return(result.CabsetId); }