public static List <ItemAssignCategory> GetByItemID(Guid id)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemAssignCategoryDB where i.ItemID == id select i).ToList();
return(query);
}
}
public static Request GetByID(string ID)
{
using (var context = new GeopersonContext()) {
var data = (from c in context.RequestDB where c.ID.ToString().Equals(ID) select c).FirstOrDefault();
return(data);
}
}
public static List <ItemImage> GetByItemsID(Guid ID)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemImageDB where i.Item.ID == ID select i).ToList();
return(query);
}
}
public static List <IS_ItemStock> GetByItemID(Guid id, Guid status)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.IS_ItemStockDB where i.IS_ItemID == id && i.IS_ItemStockStatus == status select i).ToList();
return(query);
}
}
public static ItemSubCategory GetByID(Guid id)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemSubCategoryDB where i.ID == id select i).FirstOrDefault();
return(query);
}
}
public static QuizInfo GetID(Guid id)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizInfoDB where i.ID == id select i).FirstOrDefault();
return(query);
}
}
public static List <QuizInfo> GetByOID(Guid oid, Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizInfoDB where i.OwnerID == oid && i.ApplicationID == api select i).ToList();
return(query);
}
}
public static QuizUserAnswer GetByQTIDQQID(Guid qtid, Guid qqid)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizUserAnswerDB where i.QuizTakersID == qtid && i.QuizQuestionID == qqid select i).FirstOrDefault();
return(query);
}
}
public static List <QuizUserAnswer> GetByQuizQuestionIDQuizAnswerID(Guid qqid, Guid qaid)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizUserAnswerDB where i.QuizQuestionID == qqid && i.QuizAnswerID == qaid select i).ToList();
return(query);
}
}
public static ItemCategory GetByID(Guid ID)
{
using (var context = new GeopersonContext()) {
var query = (from ic in context.ItemCategoryDB where ic.ID == ID select ic).FirstOrDefault();
return(query);
}
}
public static List <QuizUserAnswer> GetByQTID(Guid qtid)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizUserAnswerDB where i.QuizTakersID == qtid select i).ToList();
return(query);
}
}
public static List <ItemCategory> GetAll()
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemCategoryDB where i.isArchived == false select i).ToList();
return(query);
}
}
public static List <UsersReview> GetByUserID(Guid id, Guid API)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.UserReviewDB where i.UserID == id && i.API == API orderby i.UpdatedAt descending select i).ToList();
return(query);
}
}
public static UsersReview GetByID(Guid id, Guid API)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.UserReviewDB where i.ID == id && i.API == API select i).FirstOrDefault();
return(query);
}
}
public static List <Items> GetByOwnerID(Guid ID, bool isArchived)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemsDB where i.OwnerID == ID && i.isArchived == isArchived select i).ToList();
return(query);
}
}
public static List <IS_Item> GetByAPI(Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.IS_ItemDB where i.API == api select i).ToList();
return(query);
}
}
public static List <StatusTypesReferences> GetByList()
{
using (var context = new GeopersonContext()) {
var query = (from i in context.StatusTypesReferencesDB select i).ToList();
return(query);
}
}
public static List <IS_Item> GetByItemCategory(Guid api, Guid category)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.IS_ItemDB where i.API == api && i.IS_ItemCategoryID == category select i).ToList();
return(query);
}
}
public static QuizInfo GetByID(Guid id, Guid oid, Guid appID)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizInfoDB where i.ID == id && i.OwnerID == oid && i.ApplicationID == appID select i).FirstOrDefault();
return(query);
}
}
public static IS_Item GetByID(Guid id, Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.IS_ItemDB where i.ID == id && i.API == api select i).FirstOrDefault();
return(query);
}
}
public static QuizInfo GetByQC(string qc)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.QuizInfoDB where i.QuizCode.Equals(qc) select i).FirstOrDefault();
return(query);
}
}
public static List <LocationSessionInvitation> GetByUserID(Guid id, Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.LocationSessionInvitationDB where i.UserID == id && i.API == api select i).ToList();
return(query);
}
}
public static IS_ItemStock GetByID(Guid id, Guid itemID, Guid status)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.IS_ItemStockDB where i.ID == id && i.IS_ItemID == itemID && i.IS_ItemStockStatus == status select i).FirstOrDefault();
return(query);
}
}
public static List <TimerAppLimiters> GetByOID(Guid oid, Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.TimerAppLimitersDB where i.OwnerID == oid && i.API == api select i).ToList();
return(query);
}
}
public static List <ItemSubCategory> GetByCategoryID(Guid catID)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemSubCategoryDB where i.Category == catID && i.isArchived == false select i).ToList();
return(query);
}
}
public static TimerAppLimiters GetByID(Guid id, Guid oid, Guid api)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.TimerAppLimitersDB where i.ID == id && i.OwnerID == oid && i.API == api select i).FirstOrDefault();
return(query);
}
}
public static Request GetByConnectionIDRTID(string CID, string RTID)
{
using (var context = new GeopersonContext()) {
var data = (from r in context.RequestDB where r.ConnectionRequest.ID.ToString().Equals(CID) && r.RequestTo.ToString().Equals(RTID) select r).FirstOrDefault();
return(data);
}
}
public static Items GetByID(Guid ID, Guid api, bool isArchived)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemsDB where i.ID == ID && i.API == api && i.isArchived == isArchived select i).FirstOrDefault();
return(query);
}
}
public static ItemImage GetByID(Guid ID)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.ItemImageDB where i.ID == ID select i).FirstOrDefault();
return(query);
}
}
//get seconds remaining
public static int CalculateRemainingTimeSeconds(Guid id, Guid api, DateTime timeNow)
{
using (var context = new GeopersonContext()) {
var query = (from i in context.TimerAppDB where i.ID == id && i.API == api select i).FirstOrDefault();
return(0);
}
}
