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 }