static void Main(string[] args)
{
Student myrecord = new Student {
StudentId = "200429019", FirstName = "Pranav", LastName = "Sharma"
};
List <Student> students = new List <Student>();
List <string> directories = FTP.GetDirectory(Constants.FTP.BaseUrl);
foreach (var directory in directories)
{
Student student = new Student()
{
AbsoluteUrl = Constants.FTP.BaseUrl
};
student.FromDirectory(directory);
Console.WriteLine(student);
string infoFilePath = student.FullPathUrl + "/" + Constants.Locations.InfoFile;
bool fileExists = FTP.FileExists(infoFilePath);
if (fileExists == true)
{
string csvPath = $@"/Users/pranavsharma/Desktop/Student Data/{directory}.csv";
// FTP.DownloadFile(infoFilePath, csvPath);
byte[] bytes = FTP.DownloadFileBytes(infoFilePath);
string csvData = Encoding.Default.GetString(bytes);
string[] csvlines = csvData.Split("\r\n", StringSplitOptions.RemoveEmptyEntries);
if (csvlines.Length != 2)
{
Console.WriteLine("Error in CSV format");
}
else
{
student.FromCSV(csvlines[1]);
}
Console.WriteLine("Found info file:");
student.MyRecord = "yes";
}
else
{
Console.WriteLine("Could not find info file:");
student.MyRecord = "No";
}
Console.WriteLine("\t" + infoFilePath);
string imageFilePath = student.FullPathUrl + "/" + Constants.Locations.ImageFile;
bool imageFileExists = FTP.FileExists(imageFilePath);
//try
//{
//var imageBytes = FTP.DownloadFileBytes(imageFilePath);
//Image myimage = Imaging.ByteArrayToImage(imageBytes);
//myimage.Save($@"/Users/pranavsharma/Desktop/student/{student.StudentId}.jpg");
//string base64 = Imaging.ImageToBase64(myimage, ImageFormat.Jpeg);
if (imageFileExists == true)
{
Console.WriteLine("Found image file : ");
}
else
{
Console.WriteLine("Could not find image file:");
}
//}
//catch (Exception )
//{
//}
Console.WriteLine("\t" + imageFilePath);
students.Add(student);
//Console.WriteLine(directory);
Console.WriteLine(" \t Count of student : {0}", students.Count);
Console.WriteLine(" \t Age of Student : {0} ", student.age);
Console.WriteLine(" \t Student Record : {0} ", student.MyRecord);
}
Student me = students.SingleOrDefault(x => x.StudentId == myrecord.StudentId);
Student meUsingFind = students.Find(x => x.StudentId == myrecord.StudentId);
var avgage = students.Average(x => x.age);
var minage = students.Min(x => x.age);
var maxage = students.Max(x => x.age);
Console.WriteLine(" \n\t Name Searched With Query: {0} ", meUsingFind);
Console.WriteLine(" \t Average of Student age is: {0} ", avgage);
Console.WriteLine(" \t Minimum of Student age is: {0} ", minage);
Console.WriteLine(" \t Maximum of Student age is: {0} ", maxage);
//save to csv
string studentsCSVPath = $"{Constants.Locations.DataFolder}//students.csv";
//Establish a file stream to collect data from the response
using (StreamWriter fs = new StreamWriter(studentsCSVPath))
{
foreach (var student in students)
{
fs.WriteLine(student.ToCSV());
}
}
string studentsWordPath = $"{Constants.Locations.DataFolder}//students.docx";
string studentsImagePath = $"{Constants.Locations.ImagesFolder}//myimage.jpg";
using (WordprocessingDocument wordDocument =
WordprocessingDocument.Create(studentsWordPath, WordprocessingDocumentType.Document))
{
// Add a main document part.
MainDocumentPart mainPart = wordDocument.AddMainDocumentPart();
// Create the document structure and add some text.
mainPart.Document = new Document();
Body body = mainPart.Document.AppendChild(new Body());
ImagePart imagePart = mainPart.AddImagePart(ImagePartType.Jpeg);
Paragraph para = body.AppendChild(new Paragraph());
Run run = para.AppendChild(new Run());
foreach (var student in students)
{
run.AppendChild(new Text("My name : "));
run.AppendChild(new Text(student.FirstName.ToString()));
run.AppendChild(new Text(" , "));
run.AppendChild(new Text("My Student id : "));
run.AppendChild(new Text(student.StudentId.ToString()));
run.AppendChild(new Text(" , "));
using (FileStream stream = new FileStream(studentsImagePath, FileMode.Open))
{
imagePart.FeedData(stream);
}
AddImageToBody(wordDocument, mainPart.GetIdOfPart(imagePart));
run.AppendChild(new Break()
{
Type = BreakValues.Page
});
}
}
// Create Excel sheet and fetch data from FTP
string studentsExcelPath = $"{Constants.Locations.DataFolder}//students.xlsx";
using SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.
Create(studentsExcelPath, SpreadsheetDocumentType.Workbook);
// Add a WorkbookPart to the document.
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();
// Add a WorksheetPart to the WorkbookPart.
WorksheetPart worksheetPart = workbookpart.AddNewPart <WorksheetPart>();
worksheetPart.Worksheet = new DocumentFormat.OpenXml.Spreadsheet.Worksheet(new DocumentFormat.OpenXml.Spreadsheet.SheetData());
// Add Sheets to the Workbook.
DocumentFormat.OpenXml.Spreadsheet.Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.
AppendChild <DocumentFormat.OpenXml.Spreadsheet.Sheets>(new DocumentFormat.OpenXml.Spreadsheet.Sheets());
// Append a new worksheet and associate it with the workbook.
DocumentFormat.OpenXml.Spreadsheet.Sheet sheet = new DocumentFormat.OpenXml.Spreadsheet.Sheet()
{
Id = spreadsheetDocument.WorkbookPart.
GetIdOfPart(worksheetPart),
SheetId = 1,
Name = "mySheet"
};
DocumentFormat.OpenXml.Spreadsheet.SheetData sheetData = worksheetPart.Worksheet.GetFirstChild <DocumentFormat.OpenXml.Spreadsheet.SheetData>();
var excelRows = sheetData.Descendants <DocumentFormat.OpenXml.Spreadsheet.Row>().ToList();
//var excelcolumns = sheetData.Descendants<DocumentFormat.OpenXml.Spreadsheet.Column>().ToList();
int rowindex = 1;
//int columnindex = 1;
foreach (var student in students)
{
DocumentFormat.OpenXml.Spreadsheet.Row row = new DocumentFormat.OpenXml.Spreadsheet.Row();
DocumentFormat.OpenXml.Spreadsheet.Columns cs = new DocumentFormat.OpenXml.Spreadsheet.Columns();
row.RowIndex = (UInt32)rowindex;
DocumentFormat.OpenXml.Spreadsheet.Cell cell = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(student.FirstName.ToString())
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell1 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(student.LastName.ToString())
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell2 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(student.StudentId.ToString())
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell3 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(Convert.ToString(student.MyRecord.ToString()))
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell4 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(student.age.ToString())
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell5 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(Convert.ToString(student.DateOfBirthDT.ToString()))
};
DocumentFormat.OpenXml.Spreadsheet.Cell cell6 = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String,
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(Convert.ToString(Guid.NewGuid().ToString()))
};
row.Append(cell);
row.Append(cell1);
row.Append(cell2);
row.Append(cell3);
row.Append(cell4);
row.Append(cell5);
row.Append(cell6);
sheetData.Append(row);
//how to write the data in cell
rowindex++;
}
sheets.Append(sheet);
workbookpart.Workbook.Save();
// Close the document.
spreadsheetDocument.Close();
string studentsxmlPath = $"{Constants.Locations.DataFolder}//students.xml";
//Establish a file stream to collect data from the response
using (StreamWriter fs = new StreamWriter(studentsxmlPath))
{
XmlSerializer x = new XmlSerializer(students.GetType());
x.Serialize(fs, students);
Console.WriteLine();
}
//4.Upload the files to My FTP
foreach (var student in students)
{
//FTP.UploadFile(studentsxmlPath, Constants.FTP.BaseUrl + "/200429013 Pranav Sharma/students.csv");
FTP.UploadFile(studentsxmlPath, Constants.FTP.BaseUrl + "/200429013 Pranav Sharma/students.xml");
FTP.UploadFile(studentsxmlPath, Constants.FTP.BaseUrl + "/200429019 Pranav Sharma/students.word");
FTP.UploadFile(studentsxmlPath, Constants.FTP.BaseUrl + "/200429019 Pranav Sharma/students.xlsx");
}
return;
}
//export excel
private void exportExcel(DataGridView grid, string filepath)
{
// Create a spreadsheet document by supplying the filepath.
// By default, AutoSave = true, Editable = true, and Type = xlsx.
var spreadsheetDocument = DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.
Create(filepath, DocumentFormat.OpenXml.SpreadsheetDocumentType.Workbook);
// Add a WorkbookPart to the document.
var workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();
// Add a WorksheetPart to the WorkbookPart.
var worksheetPart = workbookpart.AddNewPart <DocumentFormat.OpenXml.Packaging.WorksheetPart>();
var sheetData = new DocumentFormat.OpenXml.Spreadsheet.SheetData();
worksheetPart.Worksheet = new DocumentFormat.OpenXml.Spreadsheet.Worksheet(sheetData);
// Add Sheets to the Workbook.
var sheets = spreadsheetDocument.WorkbookPart.Workbook.
AppendChild(new DocumentFormat.OpenXml.Spreadsheet.Sheets());
// Append a new worksheet and associate it with the workbook.
var sheet = new DocumentFormat.OpenXml.Spreadsheet.Sheet()
{
Id = spreadsheetDocument.WorkbookPart.
GetIdOfPart(worksheetPart),
SheetId = 1,
Name = "mySheet"
};
sheets.Append(sheet);
var row_header = new DocumentFormat.OpenXml.Spreadsheet.Row()
{
RowIndex = 1
};
for (var j = 0; j < grid.ColumnCount; j++)
{
if (!(grid.Columns[j] is DataGridViewTextBoxColumn))
{
continue;
}
var cell = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(grid.Columns[j].HeaderText),
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String
};
row_header.Append(cell);
}
sheetData.Append(row_header);
for (var i = 0; i < grid.RowCount; i++)
{
var row = new DocumentFormat.OpenXml.Spreadsheet.Row();
for (var j = 0; j < grid.ColumnCount; j++)
{
var grid_cell = grid.Rows[i].Cells[j];
if (grid_cell.Value == null)
{
continue;
}
var cell = new DocumentFormat.OpenXml.Spreadsheet.Cell()
{
CellValue = new DocumentFormat.OpenXml.Spreadsheet.CellValue(grid_cell.Value.ToString()),
DataType = DocumentFormat.OpenXml.Spreadsheet.CellValues.String
};
row.Append(cell);
}
sheetData.Append(row);
}
workbookpart.Workbook.Save();
// Close the document.
spreadsheetDocument.Close();
spreadsheetDocument.Dispose();
}
