Esempio n. 1
0
 // Changes outstanding items.isdone to true
 public void UpdateOutstanding(LogisticContext db, IEnumerable<Outstanding> outstandings)
 {
     foreach (Outstanding o in outstandings)
     {
         if (o.IsDone)
         {
             MakeDoneItem(o);
         } else
         {
             InsertItem(o);
         }                                            
     }
     FlushOutstanding();
 }
Esempio n. 2
0
        public ActionResult Excel(string id)
        {
            string filename;
            FileInfo newFile;
            LogisticContext db = new LogisticContext();

            switch (id)
            {
                case "recent":
                    filename = Path.Combine(Server.MapPath("~/App_Data/Temp"),
                        string.Format("{0}.xlsx", Guid.NewGuid().ToString()));
                    newFile = new FileInfo(filename);

                    using (ExcelPackage package = new ExcelPackage(newFile))
                    {
                        ExcelWorksheet sheet = package.Workbook.Worksheets.Add("Recent Items");
                        string[] headers = { "Material ID", "Description", "Top Up", "UOM", "Cost Center ID", "Cost Center", "Time Requested", "Time Done" };

                        int row = 1;
                        for (int i = 1; i <= headers.Length; i++)
                        {
                            sheet.Cells[row, i].Value = headers[i - 1];
                        }
                        row++;

                        DateTime compare = DateTime.Now.AddHours(-1);
                        var query = from o in db.Outstandings
                                    where o.IsDone == true && o.TimeDone >= compare
                                    select new
                                    {
                                        o.MaterialID,
                                        o.Description,
                                        o.TopUp,
                                        o.UOM,
                                        o.CostCenterID,
                                        o.CostCenterName,
                                        o.TimeRequested,
                                        o.TimeDone
                                    };
                        foreach (var o in query.ToList())
                        {
                            sheet.Cells[row, 1].Value = o.MaterialID;
                            sheet.Cells[row, 2].Value = o.Description;
                            sheet.Cells[row, 3].Value = o.TopUp;
                            sheet.Cells[row, 4].Value = o.UOM;
                            sheet.Cells[row, 5].Value = o.CostCenterID;
                            sheet.Cells[row, 6].Value = o.CostCenterName;
                            sheet.Cells[row, 7].Value = o.TimeRequested.ToString();
                            sheet.Cells[row, 8].Value = o.TimeDone.Value.ToString();
                            row++;
                        }
                        package.Save();
                    }

                    Response.Clear();
                    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                    Response.AddHeader("Content-Disposition", "attachment;filename=report.xlsx");
                    Response.TransmitFile(newFile.FullName);
                    Response.End();
                    if (newFile.Exists)
                    {
                        newFile.Delete();
                    }

                    break;
                case "get_all":
                    filename = Path.Combine(Server.MapPath("~/App_Data/Temp"),
                        string.Format("{0}.xlsx", Guid.NewGuid().ToString()));
                    newFile = new FileInfo(filename);

                    using (ExcelPackage package = new ExcelPackage(newFile))
                    {
                        ExcelWorksheet sheet = package.Workbook.Worksheets.Add("Recent Items");
                        string[] headers = { "Material ID", "Description", "Top Up", "UOM", "Cost Center ID", "Cost Center", "Time Requested", "Time Done" };

                        int row = 1;
                        for (int i = 1; i <= headers.Length; i++)
                        {
                            sheet.Cells[row, i].Value = headers[i - 1];
                        }
                        row++;

                        DateTime compare = DateTime.Now.AddHours(-1);
                        var query = from p in db.PastRecords                                    
                                    select new
                                    {
                                        p.MaterialID,
                                        p.Description,
                                        p.TopUp,
                                        p.UOM,
                                        p.CostCenterID,
                                        p.CostCenterName,
                                        p.TimeRequested,
                                        p.TimeDone
                                    };
                        foreach (var p in query.ToList())
                        {
                            sheet.Cells[row, 1].Value = p.MaterialID;
                            sheet.Cells[row, 2].Value = p.Description;
                            sheet.Cells[row, 3].Value = p.TopUp;
                            sheet.Cells[row, 4].Value = p.UOM;
                            sheet.Cells[row, 5].Value = p.CostCenterID;
                            sheet.Cells[row, 6].Value = p.CostCenterName;
                            sheet.Cells[row, 7].Value = p.TimeRequested.ToString();
                            sheet.Cells[row, 8].Value = p.TimeDone.ToString();
                            row++;
                        }
                        package.Save();
                    }

                    Response.Clear();
                    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                    Response.AddHeader("Content-Disposition", "attachment;filename=AllRecords.xlsx");
                    Response.TransmitFile(newFile.FullName);
                    Response.End();
                    if (newFile.Exists)
                    {
                        newFile.Delete();
                    }
                    break;
                default:
                    Session["Download"] = false;
                    Session["arg"] = id;
                    return Redirect("~");
            }

            Session["Download"] = true;
            return Redirect("~");
        }