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