public List <InputQueryDataDAO> GetQueries() { List <InputQueryDataDAO> list = new List <InputQueryDataDAO>(); try { using (I4IDBEntities context = new I4IDBEntities()) { InputQueryDataDAO obj = new InputQueryDataDAO(); var data = (from query in context.InputQueryDatas join userDetail in context.RegisterUsers on query.UserNo equals userDetail.UserNo //where qur.acion == "True" && !itemIds.Contains(query.Id) && qur.Supplier == SID select new { Id = query.Id, UQueryNum = query.UQueryNum, Name = userDetail.UserFirstName + " " + userDetail.UserLastName, Email = userDetail.Email, Phone = userDetail.phone, //QueryText=query.QueryText, acion = query.acion, QDate = query.QDate, Attachments = query.Attachments }).OrderByDescending(m => m.QDate); //var data = context.InputQueryDatas; //from inpQ in context.InputQueryDatas // join frwQ in context.ForwardQueries on inpQ.Id equals frwQ.QueryId // select new // { // }; foreach (var item in data) { list.Add(new InputQueryDataDAO { UQueryNum = item.UQueryNum, Name = item.Name, Email = item.Email, Phone = item.Phone, acion = item.acion, Checkbox = false }); //, QueryText = item.QueryText } } } catch { } return(list); }
public List<InputQueryDataDAO> GetQueries() { List<InputQueryDataDAO> list = new List<InputQueryDataDAO>(); try { using ( I4IDBEntities context = new I4IDBEntities()) { InputQueryDataDAO obj = new InputQueryDataDAO(); var data = (from query in context.InputQueryDatas join userDetail in context.RegisterUsers on query.UserNo equals userDetail.UserNo //where qur.acion == "True" && !itemIds.Contains(query.Id) && qur.Supplier == SID select new { Id = query.Id, UQueryNum = query.UQueryNum, Name = userDetail.UserFirstName + " " + userDetail.UserLastName, Email = userDetail.Email, Phone = userDetail.phone, //QueryText=query.QueryText, acion = query.acion, QDate = query.QDate, Attachments=query.Attachments }).OrderByDescending(m => m.QDate); //var data = context.InputQueryDatas; //from inpQ in context.InputQueryDatas // join frwQ in context.ForwardQueries on inpQ.Id equals frwQ.QueryId // select new // { // }; foreach (var item in data) { list.Add(new InputQueryDataDAO { UQueryNum = item.UQueryNum, Name = item.Name, Email = item.Email, Phone = item.Phone, acion = item.acion, Checkbox = false });//, QueryText = item.QueryText } } } catch { } return list; }