public Order SearchEditOrder(string whrSQLquery)
{
var _context = new DeluxeOrderManagementEntities();
var order = _context.usp_Get_Orders(whrSQLquery, string.Empty).Select(x =>
new Order
{
AnnouncemntId = x.AnnouncementId,
OrderId = x.OrderID,
//VId = x.VId,
Title = x.Title,
OrderStatus = x.OrderStatus,
OrderCategory = x.Category,
Region = x.Region,
Territory = x.Territory,
Language = x.Language,
RequestNumber = x.RequestNumber,
MPO = x.MPO,
HALID = x.HALID,
VendorId = x.VendorId,
FirstAnnouncementDate = x.FirstAnnouncedDate != null ? x.FirstAnnouncedDate.Value.ToString("MM/dd/yyyy") : null,
DueDate = x.DeliveryDueDate != null ? x.DeliveryDueDate.Value.ToString("MM/dd/yyyy") : null,
GreenlightSent = x.GreenlightSenttoPackaging != null ? x.GreenlightSenttoPackaging.Value.ToString("MM/dd/yyyy") : null,
GreenlightReceived = x.GreenlightValidatedbyDMDM != null ? x.GreenlightValidatedbyDMDM.Value.ToString("MM/dd/yyyy") : null,
DeliveryDate = x.ActualDeliveryDate != null ? x.ActualDeliveryDate.Value.ToString("MM/dd/yyyy") : null,
AssetRequired = x.LanguageType,
ESTUPC = x.ESTUPC,
VODUPC = x.IVODUPC,
LockedBy = x.LockedBy,
LockedOn = x.LockedOn,
IsLocked = x.IsLocked
//OrderType=x.OrderType
}).FirstOrDefault();
return(order);
}