private DataTable GetTable(Guid orderId)
{
var dbContext = new SCMSEntities();
var orderDetail = dbContext.OrderRequests.First(r => r.Id == orderId);
Model.OrderRequest myOrder = (Model.OrderRequest)orderDetail;
Model.Currency currency = dbContext.Currencies.First(c => c.Id == myOrder.CurrencyId);
Model.CountryProgramme prgm = dbContext.CountryProgrammes.First(p => p.Id == myOrder.CountryProgrammeId);
Model.Project subP = dbContext.Projects.FirstOrDefault(p => p.Id == myOrder.ProjectId);
Model.Donor donor = dbContext.ProjectDonors.First(d => d.Id == myOrder.ProjectDonorId).Donor;
Model.Location reqDes = dbContext.Locations.First(l => l.Id == myOrder.RequestedDestinationId);
Model.Location finDes = dbContext.Locations.First(l => l.Id == myOrder.FinalDestinationId);
DataTable table = new DataTable();
table.Columns.Add("Order Request", typeof(string));
table.Columns.Add("Date", typeof(string));
table.Columns.Add("Currency of OR", typeof(string));
table.Rows.Add(myOrder.RefNumber, myOrder.OrderDate.Value.ToShortDateString(), currency.Name);
table.Rows.Add("Program:", "Project:", "Donor");
table.Rows.Add(prgm.ProgrammeName, subP.Name, donor.Name);
table.Rows.Add("Requested Delivery Date:", "Requested Delivery Destination:", "Final Delivery Destination:");
table.Rows.Add(myOrder.DeliveryDate.HasValue ? ((DateTime)myOrder.DeliveryDate).ToString("dd.MMM.yyyy") : "-",
reqDes.Name, finDes.Name);
return(table); // Return reference.
}
public BusinessLog(Model.Currency currency, Model.Customer customer, decimal amount)
{
//zapis do bazy
}
