//[TestMethod]
public void ExportData()
{
using (var context = new VnrHrmDataContext())
{
#region Cat_Export
List <Cat_Export> listExport = new List <Cat_Export>();
Cat_Export _export = new Cat_Export()
{
Id = 1,
ExportName = "Test Export",
ExportCode = "Test",
ScreenName = "Test Screen",
ObjectName = "Hre_Profile",
IsReadOnly = true,
IsProtected = true,
SheetIndex = 1,
StartColumnIndex = 1,
StartRowIndex = 2,
TemplateFile = "Test Template File",
IsGroup = true
};
listExport.Add(_export);
#endregion
#region Cat_ExportItem
List <Cat_ExportItem> listExportItem = new List <Cat_ExportItem>();
Cat_ExportItem _exportItemEntity1 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "ProfileName",
ExcelField = "B"
};
Cat_ExportItem _exportItemEntity2 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "CodeEmp",
ExcelField = "C"
};
Cat_ExportItem _exportItemEntity3 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "DateHire",
ExcelField = "D"
};
listExportItem.Add(_exportItemEntity1);
listExportItem.Add(_exportItemEntity2);
listExportItem.Add(_exportItemEntity3);
#endregion
context.Cat_ExportItem.Add(_exportItemEntity1);
context.Cat_ExportItem.Add(_exportItemEntity2);
context.Cat_ExportItem.Add(_exportItemEntity3);
context.Cat_Export.Add(_export);
context.SaveChanges();
}
string passwordwrite = "123";
string passwordread = "123";
string filename = "D:\\New Microsoft Excel Worksheet.xls";
string templatePath = "D:\\Template";
#region Datasource
List <Hre_ProfileEntity> listdataProfile = new List <Hre_ProfileEntity>();
Hre_ProfileEntity _Profile1 = new Hre_ProfileEntity()
{
ProfileName = "Name1",
CodeEmp = "001",
DateHire = DateTime.Now
};
Hre_ProfileEntity _Profile2 = new Hre_ProfileEntity()
{
ProfileName = "Name2",
CodeEmp = "002",
DateHire = DateTime.Now
};
listdataProfile.Add(_Profile1);
listdataProfile.Add(_Profile2);
#endregion
ExportService service = new ExportService();
service.ExportByTemplate(1, filename, passwordwrite, passwordread, templatePath, null, listdataProfile);
Process.Start(filename);
}
//[TestMethod]
public void ExportData()
{
using (var context = new VnrHrmDataContext())
{
#region Cat_Export
List<Cat_Export> listExport = new List<Cat_Export>();
Cat_Export _export = new Cat_Export()
{
Id = 1,
ExportName = "Test Export",
ExportCode = "Test",
ScreenName = "Test Screen",
ObjectName = "Hre_Profile",
IsReadOnly = true,
IsProtected = true,
SheetIndex = 1,
StartColumnIndex = 1,
StartRowIndex = 2,
TemplateFile = "Test Template File",
IsGroup = true
};
listExport.Add(_export);
#endregion
#region Cat_ExportItem
List<Cat_ExportItem> listExportItem = new List<Cat_ExportItem>();
Cat_ExportItem _exportItemEntity1 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "ProfileName",
ExcelField = "B"
};
Cat_ExportItem _exportItemEntity2 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "CodeEmp",
ExcelField = "C"
};
Cat_ExportItem _exportItemEntity3 = new Cat_ExportItem()
{
ExportID = 1,
DataField = "DateHire",
ExcelField = "D"
};
listExportItem.Add(_exportItemEntity1);
listExportItem.Add(_exportItemEntity2);
listExportItem.Add(_exportItemEntity3);
#endregion
context.Cat_ExportItem.Add(_exportItemEntity1);
context.Cat_ExportItem.Add(_exportItemEntity2);
context.Cat_ExportItem.Add(_exportItemEntity3);
context.Cat_Export.Add(_export);
context.SaveChanges();
}
string passwordwrite = "123";
string passwordread = "123";
string filename = "D:\\New Microsoft Excel Worksheet.xls";
string templatePath = "D:\\Template";
#region Datasource
List<Hre_ProfileEntity> listdataProfile = new List<Hre_ProfileEntity>();
Hre_ProfileEntity _Profile1 = new Hre_ProfileEntity()
{
ProfileName = "Name1",
CodeEmp = "001",
DateHire = DateTime.Now
};
Hre_ProfileEntity _Profile2 = new Hre_ProfileEntity()
{
ProfileName = "Name2",
CodeEmp = "002",
DateHire = DateTime.Now
};
listdataProfile.Add(_Profile1);
listdataProfile.Add(_Profile2);
#endregion
ExportService service = new ExportService();
service.ExportByTemplate(1, filename, passwordwrite, passwordread, templatePath, null, listdataProfile);
Process.Start(filename);
}