static void Main(string[] args) { try { List <Package> packages = new List <Package> { new Package { Company = "Coho Vineyard", Weight = 25.2, TrackingNumber = 89453312L, DateOrder = DateTime.Today, HasCompleted = false }, new Package { Company = "Lucerne Publishing", Weight = 18.7, TrackingNumber = 89112755L, DateOrder = DateTime.Today, HasCompleted = false }, new Package { Company = "Wingtip Toys", Weight = 6.0, TrackingNumber = 299456122L, DateOrder = DateTime.Today, HasCompleted = false }, new Package { Company = "Adventure Works", Weight = 33.8, TrackingNumber = 4665518773L, DateOrder = DateTime.Today.AddDays(-4), HasCompleted = true }, new Package { Company = "Test Works", Weight = 35.8, TrackingNumber = 4665518774L, DateOrder = DateTime.Today.AddDays(-2), HasCompleted = true }, new Package { Company = "Good Works", Weight = 48.8, TrackingNumber = 4665518775L, DateOrder = DateTime.Today.AddDays(-1), HasCompleted = true }, }; List <string> headerNames = new List <string> { "Company", "Weight", "Tracking Number", "Date Order", "Completed" }; ExcelFacade excelFacade = new ExcelFacade( ); excelFacade.Create <Package>(@"d:\123-test-openxml\output1.xlsx", packages, "Packages", headerNames); Console.WriteLine("Completed"); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.Read( ); return; }
static void Main(string[] args) { try { string emailFrom = ConfigurationManager.AppSettings["emailFrom"].ToString(); string emailTo = ConfigurationManager.AppSettings["emailTo"].ToString(); string emailSubject = ConfigurationManager.AppSettings["emailSubject"] + "- " + DateTime.UtcNow; string smtpPort = ConfigurationManager.AppSettings["smtpPort"].ToString(); string smtpServer = ConfigurationManager.AppSettings["smtpServer"].ToString(); string emailPwd = ConfigurationManager.AppSettings["emailPwd"].ToString(); string emailBody = ConfigurationManager.AppSettings["Body"]; String sDate = DateTime.UtcNow.ToString(); DateTime datevalue = (Convert.ToDateTime(sDate.ToString())); String dy = datevalue.Day.ToString(); String mn = datevalue.Month.ToString(); String yy = datevalue.Year.ToString(); string min = datevalue.Minute.ToString(); string sec = datevalue.Second.ToString(); string hours = datevalue.Hour.ToString(); string url = @"\" + yy + @"\" + mn + @"\" + dy; string year = @"\" + yy; var timeFormat = dy + mn + yy + "-" + hours + min + sec; var fileName = ConfigurationManager.AppSettings["FilePath"].ToString() + ConfigurationManager.AppSettings["emailSubject"] + timeFormat + ".xlsx"; DataTable dataTable = new DataTable("OneVisionAgency_GE_Properties"); dataTable.Columns.Add("Sl.No", typeof(Int32)); dataTable.Columns.Add("Message Name", typeof(string)); dataTable.Columns.Add("Application Name", typeof(string)); dataTable.Columns.Add("Success Archive FolderLocation", typeof(string)); dataTable.Columns.Add("Direction", typeof(string)); dataTable.Columns.Add("Files Count", typeof(Int32)); dataTable.Columns.Add("Failed Count", typeof(Int32)); MessageSectionGroup group = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).SectionGroups["MessageServerConfiguration"] as MessageSectionGroup; //List<Package> packages = // new List<Package> // { // //new Package { SerialNumber = "1", MessageName = "APERAK COPARAN 01B", ApplicationName = "MSC.EDI.OVA.DE.IN.APKCOP01B", ServerLocation = @"\\Ch001-ov-a\de-edi01\BZTFiles\IN\APERAK\APK01B_COPARN\Archive" ,DirectionName = "IN" ,filesCount = 1 ,failedFileCount = 0 }, // //new Package { SerialNumber = "2", MessageName = "APERAK IFTMCS 00B", ApplicationName = "MSC.EDI.OVA.DE.IN.APKMCS00B", ServerLocation = @"\\Ch001-ov-a\de-edi01\BZTFiles\IN\APERAK\APK00B_IFTMCS\Archive",DirectionName = "IN" ,filesCount = 1 ,failedFileCount = 0 } // }; //ExcelFacade excelFacade1 = new ExcelFacade(); //List<string> headerName = new List<string> { "OneVision EDi Application", "Date/Time" }; //excelFacade1.setColorforHeader<Package>(fileName, "BIZTALK", headerName); //List<Package> packages = new List<Package>(); foreach (ConfigurationSection section in group.Sections) { if (section.GetType() == typeof(MessageSection)) { MessageSection c = (MessageSection)section; MessageCollections coll = c.Messages; foreach (MessageElement item in coll) { int filesCount = 0; int failedFileCount = 0; if (Directory.Exists(item.ServerLocation + url)) { var file = new DirectoryInfo(item.ServerLocation + url).GetFiles().Where(x => (x.Attributes & FileAttributes.Hidden) == 0).ToList(); filesCount = file.Count; } if (((item.DirectionName == "OUT") || (item.DirectionName == "TRANS")) && (Directory.Exists(item.FailedFileCountPath + url))) { var file = new DirectoryInfo(item.FailedFileCountPath).GetFiles().Where(x => (x.Attributes & FileAttributes.Hidden) == 0).ToList(); failedFileCount = file.Count; } dataTable.Rows.Add(item.SerialNumber, item.MessageName, item.ApplicationName, item.ServerLocation, item.DirectionName, filesCount, failedFileCount); // List<Package> packages = // new List<Package>() // { // new Package() { SerialNumber = item.SerialNumber, MessageName = item.MessageName, ApplicationName = item.ApplicationName, ServerLocation = item.ServerLocation, DirectionName = item.DirectionName, filesCount = filesCount, failedFileCount = failedFileCount }, //}; // //packages.Add(SerialNumber = item.SerialNumber); //List<string> headerNames = new List<string> { "OneVision EDi Application", "Date/Time","S.NO", "Message Name", "Application Name", "Success Archive FolderLocation", "Direction", "Files Count", "Failed Count" }; //ExcelFacade excelFacade = new ExcelFacade(); //excelFacade.Create<Package>(fileName, packages, "BIZTALK", headerNames); } } } List <Package> packages = new List <Package>(); for (int i = 0; i < dataTable.Rows.Count; i++) { Package student = new Package(); student.SerialNumber = Convert.ToInt32(dataTable.Rows[i]["Sl.No"]); student.MessageName = dataTable.Rows[i]["Message Name"].ToString(); student.ApplicationName = dataTable.Rows[i]["Application Name"].ToString(); student.ServerLocation = dataTable.Rows[i]["Success Archive FolderLocation"].ToString(); student.DirectionName = dataTable.Rows[i]["Direction"].ToString(); student.filesCount = Convert.ToInt32(dataTable.Rows[i]["Files Count"]); student.failedFileCount = Convert.ToInt32(dataTable.Rows[i]["Failed Count"]); packages.Add(student); } List <string> headerNames = new List <string> { "OneVision EDi Application", "Date/Time", "S.NO", "Message Name", "Application Name", "Success Archive FolderLocation", "Direction", "Files Count", "Failed Count" }; ExcelFacade excelFacade = new ExcelFacade(); excelFacade.Create <Package>(fileName, packages, "BIZTALK", headerNames); //DataSet ds = new DataSet() { EnforceConstraints = false }; //ds.Tables.Add(dataTable); //var table = ds.Tables[0].Copy(); ////packages = table; //SendTo(emailFrom, emailTo, emailSubject, smtpPort, smtpServer, emailPwd, fileName, emailBody); Console.WriteLine("Completed"); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.Read(); }