public static List <DateTimeStorage> GetByOID(Guid oid, Guid aid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.DateTimeStorageDB where i.OwnerID == oid && i.API == aid select i).ToList();
return(query);
}
}
public static LeadPages GetByID(Guid id, Guid oid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.LeadPagesDB where i.ID == id && i.OwnerID == oid select i).FirstOrDefault();
return(query);
}
}
public static List <LeadPages> GetByOID(Guid oid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.LeadPagesDB where i.OwnerID == oid select i).ToList();
return(query);
}
}
public static IS_ItemStock GetBySKUSerialNum(string sku, string ser)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.IS_ItemStockDB where i.SKU.Equals(sku) && i.SerialNumber.Equals(ser) select i).FirstOrDefault();
return(query);
}
}
public static List <IS_ItemStock> GetByItemColorID(Guid icid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.IS_ItemStockDB where i.ItemColorID == icid select i).ToList();
return(query);
}
}
public static QuizQuestionAnswer GetByID(Guid id, Guid qqid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.QuizQuestionAnswerDB where i.ID == id && i.QuizQuestionsID == qqid select i).FirstOrDefault();
return(query);
}
}
public static IS_ItemStock GetByID(Guid id, Guid iid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.IS_ItemStockDB where i.ID == id && i.ItemID == iid select i).FirstOrDefault();
return(query);
}
}
public static Users GetByIDEmail(Guid id, string email)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.UsersDB where i.ID == id && i.EmailAddress.Equals(email) select i).FirstOrDefault();
return(query);
}
}
public static List <Users> GetAll()
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.UsersDB select i).ToList();
return(query);
}
}
public static List <Users> GetByContactNumber(string cnum)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.UsersDB where i.ContactNumber.Equals(cnum) select i).ToList();
return(query);
}
}
public static MessagingRoom GetByID(Guid id, Guid aid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.MessagingRoomDB where i.ID == id && i.API == aid select i).FirstOrDefault();
return(query);
}
}
public static List <MessagingRoom> GetByOIDAID(Guid oid, Guid aid)
{
using (var context = new CentralProcessContext()) {
var query = (from i in context.MessagingRoomDB where i.OwnerID == oid && i.API == aid select i).ToList();
return(query);
}
}