private void ExportUserstoCSV(string stringFileName)
        {
            //   File FileStream1 = new System.IO.File();
            StringBuilder StringBuilder1 = new StringBuilder(null);

            foreach (string string1 in User.StringArrayUesrProperties)
            {
                if (StringBuilder1.Length == 0)
                {
                    StringBuilder1.Append(string1);
                }
                StringBuilder1.Append(',' + string1);
            }
            StringBuilder1.AppendLine();
            foreach (User User1 in Users1)
            {
                StringBuilder StringBuilderTemp = new StringBuilder(null);
                foreach (string string1 in User1.Properties())
                {
                    if (StringBuilderTemp.Length == 0)
                    {
                        StringBuilderTemp.Append(string1);
                    }
                    StringBuilderTemp.Append(',' + string1);
                }
                //   StringBuilder1.AppendLine();
                StringBuilder1.AppendLine(StringBuilderTemp.ToString());
            }
            File.WriteAllText(stringFileName, StringBuilder1.ToString(), Encoding.UTF8);
            MessageBox.Show("Saved Successfully", "Active Directory", MessageBoxButton.OK, MessageBoxImage.Information);
        }
        private void ExportUserstoExcel(string stringFileName)
        {
            Excel._Application ExcelApplication;
            Excel.Workbook     ExcelWorkbook;
            Excel.Worksheet    ExcelWorksheet;
            object             objectMisValue = System.Reflection.Missing.Value;

            Excel.Range ExcelRangeCellinstance;
            ExcelApplication = new Excel.Application();
            ExcelWorkbook    = ExcelApplication.Workbooks.Add(objectMisValue);

            ExcelWorksheet = (Excel.Worksheet)ExcelWorkbook.Worksheets.get_Item(1);
            ExcelApplication.DisplayAlerts = false;
            ExcelRangeCellinstance         = ExcelWorksheet.get_Range("A1", Type.Missing);
            int intRow    = 1;
            int intColumn = 1;

            foreach (string string1 in User.StringArrayUesrProperties)
            {
                ExcelWorksheet.Cells[intRow, intColumn] = string1;
                intColumn++;
            }
            intRow++;
            foreach (User User1 in Users1)
            {
                intColumn = 1;
                foreach (string string1 in User1.Properties())
                {
                    ExcelWorksheet.Cells[intRow, intColumn] = string1;
                    intColumn++;
                }
                intRow++;
            }
            //Highlight first row
            Excel.Range ExcelRange1 = ExcelWorksheet.get_Range("A1", Type.Missing);
            ExcelRange1.EntireRow.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);
            ExcelRange1.Interior.Color       = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.LightSkyBlue);
            ExcelRange1.EntireRow.Font.Size  = 14;
            ExcelRange1.EntireRow.AutoFit();
            //Save Excel
            ExcelWorkbook.SaveAs(stringFileName, Excel.XlFileFormat.xlWorkbookNormal, objectMisValue, objectMisValue, objectMisValue, objectMisValue, Excel.XlSaveAsAccessMode.xlExclusive, objectMisValue, objectMisValue, objectMisValue, objectMisValue, objectMisValue);
            ExcelWorkbook.Close();
            MessageBox.Show("Saved Successfully", "Active Directory", MessageBoxButton.OK, MessageBoxImage.Information);
        }
Пример #3
0
        /// <summary>
        /// Export to CSV file
        /// </summary>
        public static void ExporttoCSV()
        {
            var dir = @"C:\Zones\";     // folder location

            if (!Directory.Exists(dir)) // if it doesn't exist, create
            {
                Directory.CreateDirectory(dir);
            }
            string stringFileName = dir + "UsersLog_" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + "_" + DateTime.Now.Hour + DateTime.Now.Minute + ".csv";

            //Save Users
            StringBuilder StringBuilder1 = new StringBuilder(null);

            foreach (string string1 in User.StringArrayUesrProperties)
            {
                if (StringBuilder1.Length == 0)
                {
                    StringBuilder1.Append(string1);
                }
                StringBuilder1.Append(',' + string1);
            }
            StringBuilder1.AppendLine();
            foreach (User User1 in Users1)
            {
                StringBuilder StringBuilderTemp = new StringBuilder(null);
                foreach (string string1 in User1.Properties())
                {
                    if (StringBuilderTemp.Length == 0)
                    {
                        StringBuilderTemp.Append(string1);
                    }
                    StringBuilderTemp.Append(',' + string1);
                }
                //  WriteErrorLog(StringBuilderTemp.ToString());
                StringBuilder1.AppendLine(StringBuilderTemp.ToString());
            }
            File.WriteAllText(stringFileName, StringBuilder1.ToString(), Encoding.UTF8);
        }
        //Find users in SQL Server who are not in Active directory
        private void ExportUserstoCSV(string stringFileName, Users Users1)
        {
            //   File FileStream1 = new System.IO.File();
            StringBuilder StringBuilder1 = new StringBuilder(null);

            foreach (string string1 in User.StringArrayUesrProperties)
            {
                if (StringBuilder1.Length == 0)
                {
                    StringBuilder1.Append(string1);
                }
                else
                {
                    StringBuilder1.Append(',' + string1);
                }
            }
            StringBuilder1.AppendLine();
            foreach (User User1 in Users1)
            {
                StringBuilder StringBuilderTemp = new StringBuilder(null);
                foreach (string string1 in User1.Properties())
                {
                    if (StringBuilderTemp.Length == 0)
                    {
                        StringBuilderTemp.Append(string1);
                    }
                    else
                    {
                        StringBuilderTemp.Append(',' + string1);
                    }
                }
                //   StringBuilder1.AppendLine();
                StringBuilder1.AppendLine(StringBuilderTemp.ToString());
            }
            System.IO.File.WriteAllText(stringFileName, StringBuilder1.ToString(), Encoding.UTF8);
        }