public void CsvExport(string path)
{
try {
var coffeeLogExport = new CsvExport();
coffeeLogExport.AddRow();
coffeeLogExport["Region"] = "Los Angeles, USA";
coffeeLogExport["Sales"] = 100000;
coffeeLogExport["Date Opened"] = new DateTime(2003, 12, 31);
coffeeLogExport.AddRow();
coffeeLogExport["Region"] = "Canberra \"in\" Australia";
coffeeLogExport["Sales"] = 50000;
coffeeLogExport["Date Opened"] = new DateTime(2005, 1, 1, 9, 30, 0);
coffeeLogExport.ExportToFile(path);
string myCsv = coffeeLogExport.Export();
byte[] myCsvData = coffeeLogExport.ExportToBytes();
// File(myExport.ExportToBytes(), "text/csv", "results.csv");
} catch (Exception ex) {
Console.WriteLine(String.Format("Error while Export CSV {0}", ex));
}
}
// print out the chemInventory as a pdf
public FileContentResult ExportCSV()
{
var dataTable = from m in _context.ChemInventory2.Include(c => c.Chemical).Include(c => c.Location).Include(c => c.Order)
select m;
var export = new CsvExport();
export.AddRow();
export["Barcode"] = "Barcode";
export["CAS"] = "CAS Number";
export["CAT"] = "CAT Number";
export["LOT"] = "LOT Number";
export["Chem"] = "Chemical Name";
export["Qty"] = "Quantity Left";
export["Units"] = "Units";
export["Department"] = "Department";
export["Location"] = "Location";
export["Manufacturer"] = "Manufacturer";
foreach (var item in dataTable)
{
export.AddRow();
export["Barcode"] = item.Barcode;
export["CAS"] = item.Chemical.CAS;
export["CAT"] = item.CAT;
export["LOT"] = item.LOT;
export["Chem"] = item.Chemical.FormulaName;
export["Qty"] = item.QtyLeft;
export["Units"] = item.Units;
export["Department"] = item.Department;
export["Location"] = item.NormalizedLocation;
export["Manufacturer"] = item.Manufacturer;
}
return(File(export.ExportToBytes(), "text/csv", "Chemical Inventory.csv"));
}
public async Task <ActionResult> ManCreate([Bind(Include = "Name, Filename")] mortal mortal)
{
AfisEngine Afis = new AfisEngine();
Afis.Threshold = 180;
var myExport = new CsvExport();
string apppath = System.IO.Path.Combine(Server.MapPath("~"), "images");
for (int i = 0; i < 40; i++)
{
string pathToImageO = (System.IO.Path.Combine(apppath, "original/" + (i + 1).ToString() + ".png"));
for (int j = 0; j < 40; j++)
{
string pathToImageM2 = (System.IO.Path.Combine(apppath, "augmented/" + (j + 1).ToString() + ".jpg"));
Fingerprint fp1 = new Fingerprint();
Fingerprint fp2 = new Fingerprint();
MyPerson personO = new MyPerson();
MyPerson personM = new MyPerson();
Bitmap bitmap1 = fp1.AsBitmap = new Bitmap(Image.FromFile(pathToImageO));
Bitmap bitmap2 = fp2.AsBitmap = new Bitmap(Image.FromFile(pathToImageM2));
personO.Fingerprints.Add(fp1);
personM.Fingerprints.Add(fp2);
Afis.Extract(personO);
Afis.Extract(personM);
float score = Afis.Verify(personO, personM);
if (score > Afis.Threshold)
{
myExport.AddRow();
myExport["Theshold"] = Afis.Threshold;
myExport["Match"] = 1;
myExport["FingerprintO"] = i + 1;
myExport["FingerprintM"] = j + 1;
}
else
{
myExport.AddRow();
myExport["Theshold"] = Afis.Threshold;
myExport["Match"] = 0;
myExport["FingerprintO"] = i + 1;
myExport["FingerprintM"] = j + 1;
}
}
}
///ASP.NET MVC action example
return(File(myExport.ExportToBytes(), "text/csv", "results(180).csv"));
//return View();
//Response.Write("<script>alert('Please Enter Filename');</script>");
}
private void OnExport()
{
// var type = typeof(Grade);
// var properties = type.GetProperties();
_fileDialog.SaveFileDialog.Filter = "CSV|*.csv";
_fileDialog.SaveFileDialog.Title = "Export Grades to CSV";
if (_fileDialog.SaveFileDialog.ShowDialog() == true)
{
var csvExport = new CsvExport();
foreach (var grade in _allGrades)
{
csvExport.AddRow();
csvExport["StudentID"] = grade.StudentID;
csvExport["Student"] = grade.Student.FullName;
csvExport["TestID"] = grade.TestID;
csvExport["Test"] = grade.Test.Name;
csvExport["Date"] = grade.Test.Date;
csvExport["Maximum Points"] = grade.Test.MaximumPoints;
csvExport["Points Achieved"] = grade.Points;
csvExport["Percentage"] = grade.PercentAverage;
}
csvExport.ExportToFile(_fileDialog.SaveFileDialog.FileName);
}
}
public FileContentResult DownloadCSV()
{
List <ApplicationUser> users = userManager.GetUsers();
var myExport = new CsvExport();
foreach (ApplicationUser au in users)
{
myExport.AddRow();
myExport["UserName"] = au.UserName;
myExport["Password"] = au.PasswordHash;
myExport["LastActivity"] = au.LastActivityDate;
myExport["AccessFailedCount"] = au.AccessFailedCount;
myExport["Email"] = au.Email;
myExport["EmailConfirmed"] = au.EmailConfirmed;
myExport["Facebook"] = au.Facebook;
myExport["Google"] = au.Google;
myExport["Lockoutenabled"] = au.LockoutEnabled;
myExport["Lockout einddatum"] = au.LockoutEndDateUtc;
myExport["telefoon"] = au.PhoneNumber;
myExport["2 factor"] = au.TwoFactorEnabled;
StringBuilder sb = new StringBuilder();
foreach (Item i in au.FollowedItems)
{
sb.Append(i.Name);
sb.Append("; ");
}
myExport["gevolgde paginas:"] = sb.ToString();
}
return(File(myExport.ExportToBytes(), "text/csv", "users.csv"));
}
public void EksportujDoPliku(string sciezka)
{
var myExport = new CsvExport(",", false);
for (int i = 0; i < punkty.Count; i++)
{
myExport.AddRow();
myExport["x"] = punkty[i][0];
myExport["y"] = punkty[i][1];
if (klasyWej[i][0] >= 0.0)
{
myExport["cls"] = Convert.ToInt32(klasyWej[i][0] * 2 + 1.0);
}
if (klasyWy[i] <= 0.33)
{
myExport["res"] = 1;
}
else if (klasyWy[i] <= 0.66)
{
myExport["res"] = 2;
}
else
{
myExport["res"] = 3;
}
}
myExport.ExportToFile(sciezka);
Console.WriteLine();
Console.WriteLine("Zapisano wyniki do w pliku {0}", sciezka);
Console.WriteLine();
}
public string ConsultaToCSV(IPrincipal user, string indexName, IList <string> selectFilter = null, IEnumerable <Tuple <string, string, string> > filterFilter = null, long numberEntries = 1000, bool allEntries = false)
{
try
{
int from = 0;
int size = 10000;
var tempDownloadFolderUser = Path.Combine(Configuration.DefaultTempFolder, user.Identity.Name, "downloadTemp");
Directory.CreateDirectory(tempDownloadFolderUser);
var fileName = Path.Combine(tempDownloadFolderUser, $"{indexName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.csv");
if (allEntries)
{
numberEntries = _unitOfWork.TotalDocuments(indexName: indexName);
}
do
{
using (var export = new CsvExport())
{
var result = this._unitOfWork.MatchAll(indexName: indexName, selectFilter: selectFilter, filterFilter: filterFilter, from: from, size: size);
foreach (var item in result)
{
export.AddRow();
foreach (var key in item.Keys)
{
export[key] = item[key];
}
}
result.Clear();
if (from == 0)
{
export.ExportToFile(fileName, includeHeader: true);
}
else
{
export.AddLinesToFile(fileName);
}
}
from += size;
if ((from + size) >= numberEntries)
{
size = (int)(numberEntries - from);
}
}while (from < numberEntries);
return(fileName);
}
catch (Exception erro)
{
throw erro;
}
}
public bool DownloadCSV(BONoticeSearchCriteria criteria)
{
var csvExport = new CsvExport();
try
{
var noticeList = criteria.NoticeList;
// noticeList = ReduceDuplicates(noticeList);
foreach (var Item in noticeList)
{
csvExport.AddRow();
csvExport["Subject"] = Item.Subject;
csvExport["Posted Date"] = Item.PostingDateTime;
}
Response.Clear();
MemoryStream Ms = new MemoryStream(csvExport.ExportToBytes());
Response.ContentType = "application/CSV";
Response.AddHeader("content-disposition", "attachment;filename=" + "NoticesDataTable.csv");
Response.Buffer = true;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Ms.WriteTo(Response.OutputStream);
Response.End();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void tsb_exportCsv_Click(object sender, EventArgs e)
{
var myExport = new CsvExport();
myExport.AddRow();
myExport["Region"] = "Los Angeles, USA";
myExport["Sales"] = 100000;
myExport["Date Opened"] = new DateTime(2003, 12, 31);
myExport.AddRow();
myExport["Region"] = "Canberra \"in\" Australia";
myExport["Sales"] = 50000;
myExport["Date Opened"] = new DateTime(2005, 1, 1, 9, 30, 0);
myExport.ExportToFile("Somefile.csv");
}
public HttpResponseMessage ExportUsersToExcel()
{
var users = userService.Find().Where(i => !i.IsDeleted).ToList();
var userCsv = new CsvExport();
foreach (var user in users)
{
userCsv.AddRow();
userCsv["Id"] = user.Id;
userCsv["FirstName"] = user.FirstName;
userCsv["LastName"] = user.LastName;
userCsv["Email"] = user.Email;
userCsv["LastLoginDate"] = user.LastLoginDateUtc.HasValue ? user.LastLoginDateUtc.Value.ToLocalTime().ToString("MM/dd/yyy hh:mm") : "";
}
var result = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(userCsv.ExportToBytes())
};
result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = "Users_" + DateTime.UtcNow.ToLocalTime().ToString("MMddyyyy_hhmm") + ".xls"
};
return(result);
}
private void metroButton1_Click(object sender, EventArgs e)
{
try
{
CsvExport myExport = new CsvExport();
foreach (DataGridViewRow row in metroGrid1.Rows)
{
myExport.AddRow();
myExport["Store"] = row.Cells["DG1_StoreName"].Value;
myExport["ASIN / ISBN"] = row.Cells["DG1_ASIN_ISBN"].Value;
myExport["Name"] = row.Cells["DG1_Name"].Value;
myExport["Preis: Neu"] = row.Cells["DG1_PreisNeu"].Value;
myExport["Preis: Wie Neu"] = row.Cells["DG1_PreisWieNeu"].Value;
myExport["Preis: Sehr Gut"] = row.Cells["DG1_PreisSehrGut"].Value;
myExport["Preis: Gut"] = row.Cells["DG1_PreisGut"].Value;
myExport["Preis: Akzeptabel"] = row.Cells["DG1_PreisAkzeptabel"].Value;
myExport["URL"] = row.Cells["DG1_URL"].Value;
myExport["Letzter Check"] = row.Cells["DG1_LetzterCheck"].Value;
}
string filename = "Export_" + DateTime.Now.ToString("dd.MM.yyyy_HH.mm.ss") + "_" + (metroComboBox2.SelectedIndex == -1 ? "ALLE" : metroComboBox2.Text) + ".csv";
myExport.ExportToFile(Path.Combine(FoldersFilesAndPaths.Export, filename));
MetroMessageBox.Show(this, "Du findest die Datei: " + filename + Environment.NewLine + "in deinem Export Ordner.", "Excel Export erfolgreich", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
catch (Exception ex)
{
Logger.Write("Escel Export Fehlgeschlagen - Grund: " + ex.Message);
MetroMessageBox.Show(this, "Bitte versuche es erneut oder Kontaktiere den Entwickler." + Environment.NewLine + Environment.NewLine + @"Fehlercode: " + ex.Message, "Excel Export Fehlgeschlagen", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
static void Main(string[] args)
{
CsvExport csv = new CsvExport();
int n = N;
double xi1, xi2;
xi_finder(n, out xi1, out xi2);
Console.WriteLine($" xi1 = {xi1}");
Console.WriteLine($" xi2 = {xi2}");
double t_i, x_i;
double h = 1d / n;
double delta;
double z = 0;
for (int i = 0; i <= n; i++)
{
t_i = i * h;
x_i = t_i;
csv.AddRow();
csv["x"] = x_i;
csv["B(t)"] = bez3_point(t_i, fun(0), xi1, xi2, fun(1));
csv["f(x)"] = fun(x_i);
delta = Math.Abs(bez3_point(t_i, fun(0), xi1, xi2, fun(1)) - fun(x_i));
if (delta > z)
{
z = delta;
}
}
Console.WriteLine($" z = {z}");
csv.ExportToFile("data.csv");
Console.WriteLine($"int = {integrate( xi1, xi2, 0, 1 )}");
Console.ReadLine();
}
public static string MakeCSV(List <CapturePacket> packets)
{
var csvExport = new CsvExport();
foreach (CapturePacket packet in packets)
{
csvExport.AddRow();
csvExport["Time"] = packet.Date; // + "." + l.Time.Millisecond;
csvExport["ms"] = packet.Date.Millisecond;
csvExport["Name"] = packet.Name;
if (packet.ParsedData != null)
{
csvExport["Data"] = Functions.MakeCommentString(packet.ParsedData.GetDataDictionary());
}
csvExport["Raw"] = BitConverter.ToString(packet.GetRawData());
}
string export = csvExport.Export();
return(export);
}
public byte[] GetPatientsExcel(IEnumerable <PatientDTO> patients)
{
HashSet <string> symptomNames = new HashSet <string>();
foreach (var patient in patients)
{
if (patient.Diagnose != null && patient.Diagnose.Symptoms != null)
{
symptomNames.UnionWith(new HashSet <string>(patient.Diagnose.Symptoms.Keys));
}
}
var myExport = new CsvExport(",", false);
foreach (var patient in patients)
{
myExport.AddRow();
myExport["Id"] = patient.Id;
myExport["Name"] = patient.Name;
if (patient.Diagnose != null && patient.Diagnose.Symptoms != null)
{
foreach (var symptom in symptomNames)
{
if (patient.Diagnose.Symptoms.ContainsKey(symptom))
{
if (patient.Diagnose.Symptoms[symptom] != null)
{
myExport[symptom] = patient.Diagnose.Symptoms[symptom].ToString();
}
}
}
}
}
return(myExport.ExportToBytes());
}
private async void OnSaveAsCommand(object obj)
{
var saveAsDialog = new ProSaveAsFormatView();
var vm = new ProSaveAsFormatViewModel();
saveAsDialog.DataContext = vm;
if (saveAsDialog.ShowDialog() == true)
{
var fcUtils = new FeatureClassUtils();
string path = fcUtils.PromptUserWithSaveDialog(vm.FeatureIsChecked, vm.ShapeIsChecked, vm.KmlIsChecked, vm.CSVIsChecked);
if (path != null)
{
try
{
string folderName = System.IO.Path.GetDirectoryName(path);
var mapPointList = CoordinateAddInPoints.Select(i => i.Point).ToList();
if (vm.FeatureIsChecked)
{
await fcUtils.CreateFCOutput(path,
SaveAsType.FileGDB,
mapPointList,
MapView.Active.Map.SpatialReference,
MapView.Active,
CoordinateConversionLibrary.GeomType.Point);
}
else if (vm.ShapeIsChecked || vm.KmlIsChecked)
{
await fcUtils.CreateFCOutput(path, SaveAsType.Shapefile, mapPointList, MapView.Active.Map.SpatialReference, MapView.Active, CoordinateConversionLibrary.GeomType.Point, vm.KmlIsChecked);
}
else if (vm.CSVIsChecked)
{
var aiPoints = CoordinateAddInPoints.ToList();
if (aiPoints == null || !aiPoints.Any())
{
return;
}
var csvExport = new CsvExport();
foreach (var point in aiPoints)
{
csvExport.AddRow();
csvExport["Coordinate"] = point.Text;
}
csvExport.ExportToFile(path);
System.Windows.Forms.MessageBox.Show(CoordinateConversionLibrary.Properties.Resources.CSVExportSuccessfulMessage + path,
CoordinateConversionLibrary.Properties.Resources.CSVExportSuccessfulCaption);
}
}
catch (Exception ex)
{
}
}
}
}
private void DownloadShopperVisitsDay(DateTime date)
{
string sql = "EXEC SelectShopperVisitsDay @Day, @Month, @Year";
var myExport = new CsvExport();
using (SqlConnection conn = Connection.GetConnection())
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@Day", date.Day);
cmd.Parameters.AddWithValue("@Month", date.Month);
cmd.Parameters.AddWithValue("@Year", date.Year);
try
{
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
myExport.AddRow();
myExport["Date"] = dr.GetValue(0).ToString();
myExport["Name"] = dr.GetValue(1).ToString();
myExport["Email"] = dr.GetValue(2).ToString();
myExport["Phone"] = dr.GetValue(3).ToString();
myExport["Address"] = dr.GetValue(4).ToString();
myExport["First"] = dr.GetValue(5).ToString();
myExport["Children"] = dr.GetValue(6).ToString();
myExport["Case Worker"] = dr.GetValue(7).ToString();
myExport["Relation"] = dr.GetValue(8).ToString();
myExport["Description"] = dr.GetValue(9).ToString();
}
myExport.ExportToFile(Server.MapPath("~/Data/ShopperVisits.csv"));
FileInfo file = new FileInfo(Server.MapPath("~/Data/ShopperVisits.csv"));
string a = file.Directory.ToString();
string b = file.FullName;
if (file.Exists)
{
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "filename=" + "ShopperVisits" + "-" + Session["Year"].ToString() + "-" + Session["Month"].ToString() + "-" + Session["Day"].ToString() + ".csv");
Response.TransmitFile(Server.MapPath("~/Data/ShopperVisits.csv"));
Response.End();
file.Delete();
}
}
}
}
catch (Exception exc)
{
throw exc;
}
}
}
}
public bool SaveFile(string path)
{
SaveLayout();
List <DataGridViewConsoleForm.Message> messageList;
DataGridViewConsoleForm.Level verifyLevel = VerifierUtility.VerifyWithVerifier(m_Layout.Verifier, m_DataGridView, out messageList);
DataGridViewConsoleForm.ShowForm(messageList, m_DataGridView, "保存文件");
bool canSave = false;
if (verifyLevel == DataGridViewConsoleForm.Level.Info)
{
canSave = true;
}
else if (verifyLevel == DataGridViewConsoleForm.Level.Warning)
{
if (MessageBox.Show("您现在有Warning，确定存储吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
canSave = true;
}
}
if (canSave)
{
// 保存文件
CsvExport myExport = new CsvExport(",", false);
try
{
for (int rowIdx = 0; rowIdx < m_DataTable.Rows.Count; rowIdx++)
{
myExport.AddRow();
DataRow dataRow = m_DataTable.Rows[rowIdx];
for (int colIdx = 0; colIdx < m_DataTable.Columns.Count; colIdx++)
{
string value = (string)dataRow[colIdx];
myExport[colIdx.ToString()] = value;
}
}
myExport.ExportToFile(path);
}
catch (Exception ex)
{
DebugUtility.ShowExceptionMessageBox(string.Format("保存文件({0})失败", path), ex);
return(false);
}
return(true);
}
else
{
MessageBox.Show(string.Format("保存文件({0})失败", path), "提示");
return(false);
}
}
private void DownloadVolunteerTimepunchesDay(DateTime date)
{
string sql = "EXEC SelectVolunteerShiftsDay @Day, @Month, @Year";
var myExport = new CsvExport();
using (SqlConnection conn = Connection.GetConnection())
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
//cmd.Parameters.AddWithValue("@Month", System.DateTime.Now.Month);
//cmd.Parameters.AddWithValue("@Year", System.DateTime.Now.Year);
cmd.Parameters.AddWithValue("@Day", date.Day);
cmd.Parameters.AddWithValue("@Month", date.Month);
cmd.Parameters.AddWithValue("@Year", date.Year);
try
{
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
myExport.AddRow();
myExport["Time In"] = dr.GetValue(0).ToString();
myExport["Name"] = dr.GetValue(1).ToString();
myExport["Email"] = dr.GetValue(2).ToString();
myExport["Phone"] = dr.GetValue(3).ToString();
myExport["Hours"] = dr.GetValue(4).ToString();
}
myExport.ExportToFile(Server.MapPath("~/Data/VolunteerTimepunches.csv"));
FileInfo file = new FileInfo(Server.MapPath("~/Data/VolunteerTimepunches.csv"));
if (file.Exists)
{
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "filename=VolunteerTimepunches" + "-" + Session["Year"].ToString() + "-" + Session["Month"].ToString() + "-" + Session["Day"].ToString() + ".csv");
Response.TransmitFile(Server.MapPath("~/Data/VolunteerTimepunches.csv"));
Response.End();
file.Delete();
}
}
}
}
catch (Exception exc)
{
throw exc;
}
}
}
}
// print out the chemInventory as a pdf
public FileContentResult ExportCSV()
{
var dataTable = from m in _context.ChemicalEquipments.Include(c => c.Location).Include(c => c.Order)
select m;
var export = new CsvExport();
export.AddRow();
export["ChemEqID"] = "Chemical Equipment ID";
export["ManfctName"] = "Manufacturer Name";
export["EquipModel"] = "Equipment Model";
export["S/N"] = "Serial Number";
export["Location"] = "Location";
export["InstallDate"] = "Installed Date";
export["InspectDate"] = "Inspection Date";
export["OrderID"] = "Order ID";
export["CAT"] = "CAT Number";
export["LOT"] = "LOT Number";
foreach (var item in dataTable)
{
export.AddRow();
export["ChemEqID"] = item.ChemEquipmentID;
export["ManfctName"] = item.EquipmentName;
export["EquipModel"] = item.EquipmentModel;
export["S/N"] = item.SerialNumber;
export["Location"] = item.Location.NormalizedStr;
export["InstallDate"] = item.InstalledDate;
export["InspectDate"] = item.InspectionDate;
export["OrderID"] = item.Order.OrderID;
export["CAT"] = item.CAT;
export["LOT"] = item.LOT;
}
return(File(export.ExportToBytes(), "text/csv", "Chemical Equipment Inventory.csv"));
}
public void SaveCSV(string path)
{
CsvExport csv = new CsvExport();
for (int i = 0; i < Length; i++)
{
csv.AddRow();
foreach (KeyValuePair <string, double> p in Points[i].kvPairs)
{
csv[p.Key] = p.Value;
}
}
csv.ExportToFile(@"" + path);
}
public void exportTickets(List <Ticket> tickets, String path)
{
var exporter = new CsvExport();
foreach (Ticket ticket in tickets)
{
exporter.AddRow();
exporter["Code"] = ticket.Code;
exporter["Spectacol"] = ticket.Spectacol;
exporter["Rand"] = ticket.Rand;
exporter["Numar"] = ticket.Numar;
}
File.WriteAllBytes(path, exporter.ExportToBytes());
}
private void toDefaulters()
{
ProcessStartInfo smsCaster = new ProcessStartInfo("smscaster.exe");
Process startCaster = new Process();
startCaster.StartInfo = smsCaster;
startCaster.Start();
var selectedItem = new List <DefaultersListResult>();
ProcessStartInfo cmdStartInfo = new ProcessStartInfo("cmd");
cmdStartInfo.FileName = @"C:\Windows\System32\cmd.exe";
cmdStartInfo.UseShellExecute = false;
cmdStartInfo.CreateNoWindow = true;
var myExport = new CsvExport();
foreach (DefaultersListResult item in SMSSearchGrid.ItemsSource)
{
//string command = $"/C smscaster.exe -Compose {item.Emergency} \"{selectedMessage}\" -Long";
//cmdStartInfo.Arguments = command;
//Process cmdProcess = new Process();
//cmdProcess.StartInfo = cmdStartInfo;
//cmdProcess.EnableRaisingEvents = true;
//cmdProcess.Start();
//cmdProcess.WaitForExit();
myExport.AddRow();
myExport["Name"] = item.Name;
myExport["Mobile"] = item.Emergency;
}
///ASP.NET MVC action example
myExport.ExportToFile("C:\\Program Files (x86)\\CognitiveDev\\TKS Management System\\contacts.csv");
myExport.ExportToBytes();
string command = $"/C smscaster.exe 'C:\\Users\\Haseeb\\Desktop\\contacts.csv'";
cmdStartInfo.Arguments = command;
Process cmdProcess = new Process();
cmdProcess.StartInfo = cmdStartInfo;
cmdProcess.EnableRaisingEvents = true;
cmdProcess.Start();
cmdProcess.WaitForExit();
}
public HttpResponseMessage ExportUserHistoryToCsv(int userK)
{
var userHistories = new List <UserHistoryDto>();
var systemLogs = systemLogService.FindByAffectedUser(null, userK);
foreach (var systemLog in systemLogs)
{
var user = systemLog.UserFK != null?userService.Read(systemLog.UserFK.Value) : null;
foreach (var item in systemLog.SystemLogItems)
{
if (item.FieldName != "ModifiedAtUtc" && item.FieldName != "ModifiedByUserFK" && item.FieldName != "CreatedByUserFK" && item.FieldName != "CreatedAtUtc")
{
var userHistory = new UserHistoryDto();
userHistory.DateTime = systemLog.TimestampUtc.ToLocalTime();
userHistory.FieldName = item.FieldName;
userHistory.PreChangeValue = item.PreChangeValue;
userHistory.PostChangeValue = item.PostChangeValue;
userHistory.ChangedBy = user != null ? (user.FirstName + " " + user.LastName) : "N/A";
userHistories.Add(userHistory);
}
}
}
var csv = new CsvExport();
foreach (var userHistory in userHistories)
{
csv.AddRow();
csv["Date Time"] = userHistory.DateTime.ToString("dd-MMM-yyyy hh:mm tt");
csv["Field Name"] = userHistory.FieldName;
csv["Pre Change Value"] = userHistory.PreChangeValue;
csv["Post Change Value"] = userHistory.PostChangeValue;
csv["Changed By"] = userHistory.ChangedBy;
}
var result = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(csv.ExportToBytes())
};
result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = "User_" + userK + "_Histories_" + DateTime.UtcNow.ToLocalTime().ToString("MMddyyyy_hhmm") + ".csv"
};
return(result);
}
static void EksportujBledyTreningu(string sciezka, List <double> bledy)
{
var myExport = new CsvExport(",", false);
for (int i = 0; i < bledy.Count; i++)
{
myExport.AddRow();
myExport["iter"] = i;
myExport["err"] = bledy[i];
}
myExport.ExportToFile(sciezka);
Console.WriteLine();
Console.WriteLine("Zapisano wyniki do w pliku {0}", sciezka);
Console.WriteLine();
}
private void writeDataInFile()
{
setUpDataGrid();
for (int i = 0; i < names.Count; i++)
{
dataGridView1.Rows.Add();
csvExport.AddRow();
csvExport["Name / Date"] = names[i];
dataGridView1.Rows[i].Cells[0].Value = names[i];
for (int j = 0; j < dates.Count; j++)
{
var info = foundHours_byFile(names[i], dates[j]);
csvExport[dates[j]] = info;
dataGridView1.Rows[i].Cells[j + 1].Value = info;
}
}
}
public IActionResult ExportPromoUsers(string promoId)
{
var myExport = new CsvExport(",", false);
List <PromotionEntries> promoEntries = new List <PromotionEntries>();
using (_dbContext)
{
promoEntries = (from x in _dbContext.PromotionEntries where x.Promotion.Id == promoId select x).ToList();
}
foreach (PromotionEntries entry in promoEntries)
{
myExport.AddRow();
myExport["Name"] = entry.Name;
myExport["Email"] = entry.EmailAddress;
}
return(File(myExport.ExportToBytes(), "text/csv", "PromoStats.csv"));
}
public void EksportujDoPliku(string sciezka)
{
var myExport = new CsvExport(",", false);
for (int i = 0; i < wejscioweX.Count; i++)
{
myExport.AddRow();
myExport["X"] = wejscioweX[i][0];
if (this.oczekiwaneY[i][0] >= -100.0)
{
myExport["oczY"] = oczekiwaneY[i][0] * 30;
}
myExport["wynY"] = otrzymaneY[i] * 30;
}
myExport.ExportToFile(sciezka);
Console.WriteLine();
Console.WriteLine("Zapisano wyniki do w pliku {0}", sciezka);
Console.WriteLine();
}
/// <summary>
/// Metodo para Exportar a Excel
/// </summary>
/// <returns></returns>
public FileResult DescargarCsv()
{
ConectionsDataBase dataBase = new ConectionsDataBase();
var fileName = "Listado_personas.csv";
var personas = dataBase.Peoples.ToList();
CsvExport Csv = new CsvExport();
foreach (var persona in personas)
{
Csv.AddRow();
Csv["ID"] = persona.Id_person;
Csv["Nombre"] = persona.Nombre;
Csv["Apellido"] = persona.Apellido;
Csv["Edad"] = persona.Edad;
Csv["Sexo"] = persona.Sexo;
Csv["Correo"] = persona.Correo;
}
return(File(Csv.ExportToBytes(), "application/csv;charset=utf-8", fileName));
}
public static void printCSVResults(Dictionary <String, List <Result> > results, String filename, String pathToTrim)
{
var csvExport = new CsvExport();
foreach (KeyValuePair <String, List <Result> > pair in results)
{
foreach (Result result in pair.Value)
{
csvExport.AddRow();
csvExport["Controller"] = pair.Key.Replace(pathToTrim, "");
csvExport["Method Name"] = result.MethodName;
csvExport["Route"] = result.Route;
csvExport["HTTP Method"] = string.Join(", ", result.HttpMethods.ToArray());
csvExport["Attributes"] = string.Join(", ", result.Attributes.ToArray());
}
}
File.Create(filename).Dispose();
csvExport.ExportToFile(filename);
Console.WriteLine("CSV output written to: " + filename);
}
private void SaveInfo(string link, string city, string year, string probeg, string kuzov, string color, string dvigatel, string box, string privod, string rul,
string status, string vladelec, string ptc, string tamoznya, string vin, string gosnomer)
{
myExport.AddRow();
myExport["Ссылка"] = link;
myExport["Город"] = city;
myExport["Год выпуска"] = year;
myExport["Пробен"] = probeg;
myExport["Кузов"] = kuzov;
myExport["Цвет"] = color;
myExport["Двигатель"] = dvigatel;
myExport["Коробка"] = box;
myExport["Привод"] = privod;
myExport["Руль"] = rul;
myExport["Состояние"] = status;
myExport["Владельцы"] = vladelec;
myExport["ПТС"] = ptc;
myExport["Таможня"] = tamoznya;
myExport["VIN"] = vin;
myExport["Госномер"] = gosnomer;
}
protected void btnExportProductsData_Click(object sender, EventArgs e)
{
List<ProductBase> products = WAFContext.Session.Query<ProductBase>().Where(AqlProductBase.SiteId == WAFContext.Session.SiteId).Where(AqlProductBase.IsDerived == false).OrderBy(AqlProductBase.Name).Execute();
CsvExport export = new CsvExport();
foreach (ProductBase p in products) {
export.AddRow();
export["Name"] = p.Name;
export["NodeId"] = p.NodeId;
export["SiteId"] = p.SiteId;
export["LCID"] = p.LCID;
export["TemplateId"] = p.TemplateId;
export["ItemNumber"] = p.ItemNumber;
export["NumberInStock"] = p.NumberInStock;
export["PriceExVat"] = p.PriceExVat;
export["ShippingCost"] = p.ShippingCost;
export["Currency1PriceExVat"] = p.Currency1PriceExVat;
export["Currency2PriceExVat"] = p.Currency2PriceExVat;
export["Currency3PriceExVat"] = p.Currency3PriceExVat;
export["Currency4PriceExVat"] = p.Currency4PriceExVat;
export["Currency5PriceExVat"] = p.Currency5PriceExVat;
}
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=products_" + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + ".csv");
Response.ContentEncoding = Encoding.Default;//Encoding.GetEncoding("iso-8859-1"); //Encoding.GetEncoding(System.Globalization.CultureInfo.CurrentCulture.TextInfo.OEMCodePage); //Encoding.Default;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "text/csv";
Response.Write(export.Export());
Response.End();
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
// Then you can do any of the following three output options:
DataTableReader reader = DataBase.dbDataTable(currentViewSQL).CreateDataReader();
while (reader.Read())
{
myExport.AddRow();
string resourceID = reader["ResourceToAccess"].ToString().Trim();
myExport["Date"] = reader["SubmissionDateandTime"].ToString().Trim();
myExport["Requestor"] = getResourceRequestsAdminUsers(resourceID);
myExport["Assignted To"] = getUserNameByPIN(reader["SubmittedByPIN"].ToString().Trim());
myExport["Status"] = reader["FormStatus"].ToString().Trim();
}
reader.Close();
myCsv = myExport.Export();
string attachment = "attachment; filename=resource-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
// Then you can do any of the following three output options:
DataTableReader reader = DataBase.dbDataTable(currentViewSQL.Value).CreateDataReader();
while (reader.Read())
{
myExport.AddRow();
string pindb = reader["UserPIN"].ToString().Trim();
//Dictionary<string, string> uDetails = loginSSA.GetUsersDetails(pindb);
myExport["LastName"] = reader["UserLastName"].ToString().Trim(); //uDetails["LastName"];
myExport["FirstName"] = reader["UserFirstName"].ToString().Trim(); //uDetails["FirstName"];
myExport["Email"] = reader["UserEmail"].ToString().Trim(); //uDetails["Email"];
myExport["PIN"] = pindb;
myExport["officeCode"] = reader["UserofficeCode"].ToString().Trim(); //uDetails["OfficeCode"];
}
reader.Close();
myCsv = myExport.Export();
string attachment = "attachment; filename=resource-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
protected void DownloadReport_Click(object sender, EventArgs e)
{
StartDateTxt = StartDate.Text;
EndDateTxt = EndDate.Text;
string CompareDataAgainstTxt = CompareDataAgainst.SelectedValue;
string DateRangeTxt = DateRange.SelectedValue;
Resources = getResources();
switch (ReportTypeDD.SelectedValue)
{
case "Comparative Resource Pricing":
showComparativeResults(Resources, CompareDataAgainstTxt, DateRangeTxt);
break;
case "Pricing Over Time":
showPricingOver(Resources, CompareDataAgainstTxt, DateRangeTxt);
break;
case "Procurement Method":
showProcurementMethod(Resources, CompareDataAgainstTxt, DateRangeTxt);
break;
case "Contract Expiration":
showExpirationContracts(Resources, CompareDataAgainstTxt, DateRangeTxt);
break;
}
//ResultsGridView.DataSource = dtResults;
CsvExport myExport = new CsvExport();
ArrayList columns = new ArrayList();
DataTableReader dtr = dtResults.CreateDataReader();
for (int i = 0; i < dtr.FieldCount; i++)
{
columns.Add(dtr.GetName(i));
}
if (dtr.HasRows)
{
while (dtr.Read())
{
// Then you can do any of the following three output options:
myExport.AddRow();
foreach (var ii in columns)
{
string columnName = ii.ToString();
myExport[columnName] = dtr[columnName].ToString();
}
}
}
myCsv = myExport.Export();
string attachment = "attachment; filename=AdHocResourcesReports-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
/// <summary>
/// Executa a Otimização.
/// </summary>
/// <param name="caminhoBibliotecaJs"></param>
/// <param name="caminhoTestesJs"></param>
/// <returns>
/// Verdadeiro se encontrar melhoria
/// </returns>
public bool Otimizar(string caminhoBibliotecaJs, string caminhoTestesJs)
{
bool otimizou = false;
_caminhoScriptTestes = caminhoTestesJs;
_caminhoBiblioteca = caminhoBibliotecaJs;
Console.WriteLine(string.Format("Iniciando Otimização do {0}", caminhoBibliotecaJs));
Console.WriteLine(string.Format(" SetTimeout {0}", _usarSetTimeout));
Console.WriteLine(string.Format(" Heuristica {0}", Heuristica));
_javascriptHelper = new JavascriptHelper(_diretorioFontes, _usarSetTimeout, false);
_javascriptHelper.ConfigurarGeracao();
var sw = new Stopwatch();
sw.Start();
if(Heuristica == "GA")
otimizou = OtimizarUsandoGa();
else if(Heuristica == "RD")
otimizou = OtimizarUsandoRd();
else if (Heuristica == "HC")
otimizou = OtimizarUsandoHc();
else if (Heuristica == "HCF")
otimizou = OtimizarUsandoHcPorFuncao();
else
throw new ApplicationException(string.Format("Heurística ainda não definida. {0}", Heuristica));
#region Gera o CSV da rodada
var myExport = new CsvExport();
myExport.AddRow();
myExport["Rodada"] = RodadaGlobalExterna;
myExport["Individuo"] = MelhorIndividuo.Arquivo;
myExport["Operacao"] = MelhorIndividuo.CriadoPor;
myExport["Fitness"] = MelhorIndividuo.Fitness;
myExport["Tempo"] = MelhorIndividuo.TempoExecucao;
myExport["Testes"] = MelhorIndividuo.TestesComSucesso;
myExport.ExportToFile("rodadas.csv");
#endregion
#region limpa o diretório de execução.
var files = new DirectoryInfo(_diretorioExecucao).EnumerateFiles("*.js").ToList();
files.ForEach(f => f.Delete());
#endregion
sw.Stop();
Console.WriteLine(" Tempo total: {0}", sw.Elapsed.ToString(@"hh\:mm\:ss\,ffff"));
return otimizou;
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
ArrayList columns = new ArrayList();
DataTableReader dtr = DataBase.dbDataTable(ReportSQLStatement).CreateDataReader();
for (int i = 0; i < dtr.FieldCount; i++)
{
columns.Add(dtr.GetName(i));
}
if (dtr.HasRows)
{
while (dtr.Read())
{
// Then you can do any of the following three output options:
myExport.AddRow();
foreach (var ii in columns)
{
string columnName = ii.ToString();
myExport[columnName] = dtr[columnName].ToString();
}
}
}
myCsv = myExport.Export();
string attachment = "attachment; filename=AdHocResourcesReports-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
// Then you can do any of the following three output options:
DataTableReader reader = DataBase.dbDataTable(currentViewSQL, "Admin.DbConnection").CreateDataReader();
while (reader.Read())
{
myExport.AddRow();
string ePass = "";
string SubjectAreasTaxonomyDB = reader["SubjectAreasTaxonomy"].ToString().Trim();
string AccessTypeTaxonomyDB = reader["AccessTypeTaxonomy"].ToString().Trim();
string ePassDB = reader["ePass"].ToString().Trim();
string SubjectAreasTaxonomyDisplay = string.Empty;
if (SubjectAreasTaxonomyDB != "")
{
string[] taxIds = SubjectAreasTaxonomyDB.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string taxId in taxIds)
{
SubjectAreasTaxonomyDisplay += commonfunctions.GetTaxonomyNameFromID(long.Parse(taxId)) + " , ";
}
}
ePass = ePassDB;
myExport["Resource Name"] = reader["ResourceName"].ToString().Trim();
myExport["Subject Areas"] = SubjectAreasTaxonomyDisplay.Trim().TrimEnd(',');
myExport["e-Pass"] = ePass;
myExport["Status"] = reader["ResourceDisplayStatus"].ToString().Trim();
}
reader.Close();
myCsv = myExport.Export();
string attachment = "attachment; filename=resource-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
/// <summary>
/// Processa a roda do GA
/// </summary>
/// <param name="directoryGa"></param>
/// <param name="biblioteca"></param>
/// <param name="resultsDirectory"></param>
private static List<RodadaMapper> ProcessarDiretorio(DirectoryInfo directoryGa, DirectoryInfo biblioteca, string resultsDirectory)
{
//pego o csv ou xsls
var rodadas = new List<RodadaMapper>();
var instanceFile = directoryGa.GetFiles().FirstOrDefault();
if (instanceFile == null)
{
Console.WriteLine("Deveria existir um arquivo com as rodadas | {0}", directoryGa.FullName);
Environment.Exit(-1);
}
Console.WriteLine(" Algoritmo {0}", directoryGa.Name);
ConverterTodosExceis(directoryGa);
if (instanceFile.Extension == ".csv")
{
rodadas = RecuperarRodadasDoGaNoCsv(instanceFile, biblioteca, directoryGa);
}
#region Exporta CSV
var myExport = new CsvExport();
foreach (var rodadaMapper in rodadas)
{
myExport.AddRow();
myExport["Rodada"] = rodadaMapper.Rodada;
myExport["TempoOriginalUnload"] = rodadaMapper.TempoOriginalComUnload;
myExport["TempoFinalUnload"] = rodadaMapper.TempoFinalComUnload;
myExport["TempoOriginalMS"] = rodadaMapper.Fitness;
myExport["TempoFinalMS"] = rodadaMapper.FitnessFinal;
myExport["LOCOriginal"] = rodadaMapper.LocOriginal;
myExport["LOCFinal"] = rodadaMapper.LocFinal;
myExport["CaracteresOrginal"] = rodadaMapper.CaracteresOriginal;
myExport["CaracteresFinal"] = rodadaMapper.CaracteresFinal;
myExport["Operacao"] = rodadaMapper.Operacao;
myExport["Arquivo"] = rodadaMapper.Individuo;
}
var fileName = Path.Combine(resultsDirectory, biblioteca.Name + directoryGa.Name + ".csv");
if (File.Exists(fileName))
File.Delete(fileName);
myExport.ExportToFile(fileName);
#endregion
return rodadas;
}
protected void btnExport_Click(object sender, EventArgs e)
{
int reportType = Utils.GetIntegerOnly(ddlReportType.SelectedValue);
CsvExport export = new CsvExport();
string fileName = "export";
if(reportType==0){
//Sales summary
QueryData qd = GetSalesSummaryQuery();
UniqueList<string> values = lstSalesSummary.GetAllValues();
//IAqlQuery
IAqlQuery q = new DataQuery(qd);
List<string> fieldNames = q.GetFieldNames();
AqlResultSet rs = q.Execute(true);
while(rs.Read()){
export.AddRow();
export[fieldNames[0]] = rs[0]; //Period
export[fieldNames[1]] = rs[1]; //Number of orders
export[fieldNames[2]] = rs[2]; //Total revenue
export[fieldNames[3]] = rs[3]; // Average order value
export[fieldNames[4]] = rs[4]; //biggest order
int mostSoldProductRevenue = Utils.GetIntegerOnly(rs[5].ToString());
if (mostSoldProductRevenue > 0) {
ProductBase pMostSoldRevenue = WAFContext.Session.GetContent<ProductBase>(mostSoldProductRevenue);
export[fieldNames[5]] = pMostSoldRevenue.Name + " (" + mostSoldProductRevenue + ")"; //MostPopularProductRevenue
} else {
export[fieldNames[5]] = "";
}
int mostSoldProductNumItems = Utils.GetIntegerOnly(rs[5].ToString());
if (mostSoldProductNumItems > 0) {
ProductBase pMostSoldItems = WAFContext.Session.GetContent<ProductBase>(mostSoldProductNumItems);
export[fieldNames[6]] = pMostSoldItems.Name + " (" + mostSoldProductNumItems + ")"; //MostPopularProductNumItems
} else {
export[fieldNames[6]] = "";
}
}
fileName = "sales_summary";
}else if(reportType ==1){
//Sales over time
AqlQuery q = null;
if (txtStartDate.Text.Length > 0) {
DateTime startDT = DateTime.Parse(txtStartDate.Text);
DateTime endDT = DateTime.Now;
if (txtEndDate.Text.Length > 0) {
endDT = DateTime.Parse(txtEndDate.Text);
}
ReportPeriod period = new ReportPeriod();
period.FromDate = startDT;
period.ToDate = endDT;
q = WebshopStatistics.GetGroupSalesData(period, GetDateTimePart());
} else {
q = WebshopStatistics.GetGroupSalesData(this.GetReportPeriod(DefaultReportPeriod.AllTime), GetDateTimePart());
}
List<string> fieldNames = q.GetFieldNames();
AqlResultSet rs = q.Execute(true);
while (rs.Read()) {
export.AddRow();
export["Period"] = GetPeriodDescription(Utils.GetIntegerOnly(rs[0]), Utils.GetIntegerOnly(rs[3])); //DateTimePart
export["Revenue in period"] = ((double)rs[1]).ToString("N2"); //Revenue
export["Number of orders in period"] = rs[2]; //NumOrders
}
fileName = "sales_over_time";
}else if(reportType == 2){
//stock list
AqlQuery q = null;
if (txtStartDate.Text.Length > 0) {
DateTime startDT = DateTime.Parse(txtStartDate.Text);
DateTime endDT = DateTime.Now;
if (txtEndDate.Text.Length > 0) {
endDT = DateTime.Parse(txtEndDate.Text);
}
ReportPeriod period = new ReportPeriod();
period.FromDate = startDT;
period.ToDate = endDT;
q = WebshopStatistics.GetProductStockReportData(period, null);
} else {
q = WebshopStatistics.GetProductStockReportData(this.GetReportPeriod(DefaultReportPeriod.AllTime), null);
}
List<string> fieldNames = q.GetFieldNames();
AqlResultSet rs = q.Execute(true);
while (rs.Read()) {
export.AddRow();
export["NodeId"] = rs[0];
export["Item number"] = rs[1];
export["Product name"] = rs[2];
export["Number in stock"] = rs[3];
}
fileName = "stock_list";
}else if(reportType == 3){
//product sales report
AqlQuery q = null;
if (txtStartDate.Text.Length > 0) {
DateTime startDT = DateTime.Parse(txtStartDate.Text);
DateTime endDT = DateTime.Now;
if (txtEndDate.Text.Length > 0) {
endDT = DateTime.Parse(txtEndDate.Text);
}
ReportPeriod period = new ReportPeriod();
period.FromDate = startDT;
period.ToDate = endDT;
q = WebshopStatistics.GetProductSalesData(period, null);
} else {
q = WebshopStatistics.GetProductSalesData(this.GetReportPeriod(DefaultReportPeriod.AllTime), null);
}
List<string> fieldNames = q.GetFieldNames();
q.IncludeUnpublished = true;
AqlResultSet rs = q.Execute(true);
while (rs.Read()) {
export.AddRow();
export["NodeId"] = rs[0];
export["Item number"] = rs[1];
export["Product name"] = rs[2];
export["Numberof items sold"] = rs[3];
export["Revenue"] = rs[4];
export["Last sale"] = rs[5];
export["First sale"] = rs[6];
}
fileName = "products";
}else if(reportType == 4){
//customers
fileName = "customers";
}
//foreach (ProductBase p in products) {
// export.AddRow();
// export["Name"] = p.Name;
// export["NodeId"] = p.NodeId;
// export["SiteId"] = p.SiteId;
// export["Currency5PriceExVat"] = p.Currency5PriceExVat;
//}
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename="+fileName+"_" + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + ".csv");
//Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;//Encoding.GetEncoding("iso-8859-1"); //Encoding.GetEncoding(System.Globalization.CultureInfo.CurrentCulture.TextInfo.OEMCodePage); //Encoding.Default;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "text/csv";
Response.Write(export.Export());
Response.End();
}
/// <summary>
/// Converte o excel em csv e apaga o excel
/// </summary>
/// <param name="instanceFile"></param>
private static void ConverterEmCsvEApagar(FileInfo instanceFile)
{
var myExport = new CsvExport();
FileStream stream = File.Open(instanceFile.FullName, FileMode.Open, FileAccess.Read);
// Reading from a OpenXml Excel file (2007 format; *.xlsx)
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
excelReader.IsFirstRowAsColumnNames = true;
var firstRow = false;
while (excelReader.Read())
{
if (firstRow)
{
myExport.AddRow();
myExport["Rodada"] = excelReader.GetString(0);
myExport["Individuo"] = excelReader.GetString(1);
myExport["Operacao"] = excelReader.GetString(2);
myExport["Fitness"] = excelReader.GetString(3);
myExport["Tempo"] = excelReader.GetString(4).Replace("31/12/1899 ", ""); //Bug na leitura do campo
myExport["Testes"] = excelReader.GetString(5);
}
firstRow = true;
}
// Free resources (IExcelDataReader is IDisposable)
excelReader.Close();
string output = instanceFile.FullName.Replace("xlsx", "csv");
if (File.Exists(output))
File.Delete(output);
myExport.ExportToFile(output);
File.Delete(instanceFile.FullName);
}
/// <summary>
/// Inclui a linha no excel
/// </summary>
/// <param name="indice"></param>
/// <param name="sujeito"></param>
/// <param name="testesComSucesso"></param>
/// <param name="tempoTotal"></param>
private void CriarLinhaExcel(int indice, Individuo sujeito, int testesComSucesso, string tempoTotal)
{
#region Inclui no CSV
var myExport = new CsvExport();
myExport.AddRow();
myExport["Geracao"] = _generationCount;
myExport["Individuo"] = sujeito.Arquivo;
myExport["Operacao"] = sujeito.CriadoPor.ToString();
myExport["Fitness"] = sujeito.Fitness;
myExport["Tempo"] = tempoTotal;
myExport["Testes"] = testesComSucesso;
myExport.ExportToFile(Path.Combine(_diretorioExecucao, "resultados.csv"));
#endregion
}
//public DataTable dtAllResouces ;
//private DataTable getAllResouces()
//{
// return DataBase.dbDataTable("Select * from Resources order by ResourceName");
//}
protected void ExcelClick_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("HelpRequests_Reports_By");
cmd.Parameters.AddWithValue("@BuildAllSQL", BuildAllSQL);
cmd.Parameters.AddWithValue("@DisplayBy", DisplayResultsBy);
CsvExport myExport = new CsvExport();
ArrayList columns = new ArrayList();
DataTableReader dtr = DataBase.executeStoreProcudure(cmd).CreateDataReader();
for (int i = 0; i < dtr.FieldCount; i++)
{
columns.Add(dtr.GetName(i));
}
if (dtr.HasRows)
{
while (dtr.Read())
{
// Then you can do any of the following three output options:
myExport.AddRow();
foreach (var ii in columns)
{
string columnName = ii.ToString();
myExport[columnName] = dtr[columnName].ToString();
}
}
}
myCsv = myExport.Export();
string attachment = "attachment; filename=AdHocResourcesReports-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
/// <summary>
/// Export the contents of the patient data record to the user's harddrive.
/// </summary>
/// <param name="patientDataId"></param>
/// <returns></returns>
public string ExportData(string patientDataId)
{
string path = @"c:\exports\" + Guid.NewGuid().ToString();
ExportPath = path;
//Create download directory
Directory.CreateDirectory(path);
PatientData patientData = _patientDataService.GetPatientData(patientDataId);
//Export any activity information associated with the patient data record.
if(patientData.Activities != null && patientData.Activities.Count > 0) {
CsvExport activityExport = new CsvExport();
foreach(Activity activity in patientData.Activities) {
activityExport.AddRow();
activityExport["Start Time"] = activity.StartTime;
activityExport["End Time"] = activity.EndTime;
activityExport["Activity Type"] = (ActivityType)activity.DataActivity;
}
activityExport.ExportToFile(@path + "\\Activities_" + patientData.Name);
}
List<string> columnNames = new List<string>();
CsvExport export = new CsvExport();
int count = 0;
int index = 1;
string fileIndex = string.Empty;
try {
switch (patientData.DataType) {
case (int)File_Type.Accelerometer:
Device_Type deviceType = PatientLogic.DetermineDeviceType(patientData.Name);
switch (deviceType) {
case Device_Type.Zephyr:
IEnumerable<ZephyrAccelerometer> zephyrAccelData = null;
index = 1;
do {
zephyrAccelData = _zephyrAccelService.GetZephyrAccelerometerData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrAccelerometer data in zephyrAccelData) {
export.AddRow();
export["Time"] = data.Time;
export["Vertical"] = data.Vertical;
export["Lateral"] = data.Lateral;
export["Sagittal"] = data.Sagittal;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (zephyrAccelData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case Device_Type.Microsoft_Band:
IEnumerable<MSBandAccelerometer> msAccelData = null;
index = 1;
do {
msAccelData = _msBandAccelService.GetMSBandAccelerometerData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandAccelerometer data in msAccelData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["X(m/s²)"] = data.Lateral;
export["Y(m/s²)"] = data.Vertical;
export["Z(m/s²)"] = data.Sagittal;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (msAccelData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
default:
break;
}
break;
case (int)File_Type.Breathing:
IEnumerable<ZephyrBreathingWaveform> zephyrBreathingData = null;
index = 1;
do {
zephyrBreathingData = _breathingService.GetZephyrBreathingWaveformData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrBreathingWaveform data in zephyrBreathingData) {
export.AddRow();
export["Time"] = data.Time;
export["BreathingWaveform"] = data.Data;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (zephyrBreathingData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Calorie:
IEnumerable<MSBandCalories> calorieData = null;
index = 1;
do {
calorieData = _msBandCaloriesService.GetMSBandCaloriesData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandCalories data in calorieData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["Total Calories(kCal)"] = data.Total;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (calorieData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Distance:
IEnumerable<MSBandDistance> distanceData = null;
index = 1;
do {
_msBandDistanceService.GetMSBandDistanceData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandDistance data in distanceData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["Motion Type"] = data.MotionType;
export["Pace(min/km)"] = data.Pace;
export["Speed(km/hr)"] = data.Speed;
export["Total(km)"] = data.Total;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (distanceData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.ECG:
IEnumerable<ZephyrECGWaveform> ecgData = null;
index = 1;
do {
ecgData = _ecgService.GetZephyrECGWaveFormData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrECGWaveform data in ecgData) {
export.AddRow();
export["Time Stamp"] = data.Time;
export["Motion Type"] = data.Data;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (ecgData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.EventData:
IEnumerable<ZephyrEventData> eventData = null;
index = 1;
do {
eventData = _eventDataService.GetZephyrEventData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrEventData data in eventData) {
export.AddRow();
export["SeqNo"] = "0";
export["Time Stamp"] = data.Date;
export["EventCode"] = data.EventCode;
export["Type"] = data.Type;
export["Source"] = data.Source;
export["EventID"] = data.EventId;
export["EventSpecificData"] = data.EventSpecificData;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (eventData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Gyroscope:
IEnumerable<MSBandGyroscope> gyroscopeData = null;
index = 1;
do {
gyroscopeData = _msBandGyroscopeService.GetMSBandGyroscopeData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandGyroscope data in gyroscopeData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["X-Axis(°/s)"] = data.X;
export["Y-Axis(°/s)"] = data.Y;
export["Z-Axis(°/s)"] = data.Z;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (gyroscopeData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.HeartRate:
IEnumerable<MSBandHeartRate> heartRateData = null;
index = 1;
do {
heartRateData = _msBandHeartRateService.GetMSBandHeartRateData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandHeartRate data in heartRateData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["Read Status"] = data.ReadStatus;
export["Heart Rate(bpm)"] = data.HeartRate;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (heartRateData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Pedometer:
IEnumerable<MSBandPedometer> pedometerData = null;
index = 1;
do {
pedometerData = _msBandPedometerService.GetMSBandPedometerData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandPedometer data in pedometerData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["Steps"] = data.Steps;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (pedometerData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Summary:
Device_Type summaryDevice = PatientLogic.DetermineDeviceType(patientData.Name);
switch (summaryDevice) {
case Device_Type.Zephyr:
IEnumerable<ZephyrSummaryData> zephyrSummaryData = null;
index = 1;
do {
zephyrSummaryData = _summaryService.GetZephyrSummaryData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrSummaryData data in zephyrSummaryData) {
export.AddRow();
export["Time"] = data.Date;
export["HR"] = data.HeartRate;
export["BR"] = data.BreathingRate;
export["SkinTemp"] = data.SkinTemp;
export["Posture"] = data.Posture;
export["Activity"] = data.Activity;
export["PeakAccel"] = data.PeakAccel;
export["BatteryVolts"] = data.BatteryVolts;
export["BatteryLevel"] = data.BatteryLevel;
export["BRAmplitude"] = data.BRAmplitude;
export["BRNoise"] = data.BRNoise;
export["BRConfidence"] = data.BRConfidence;
export["ECGAmplitude"] = data.ECGAmplitude;
export["ECGNoise"] = data.ECGNoise;
export["HRConfidence"] = data.HRConfidence;
export["HRV"] = data.HRV;
export["SystemConfidence"] = data.SystemConfidence;
export["GSR"] = data.GSR;
export["ROGState"] = data.ROGState;
export["ROGTime"] = data.ROGTime;
export["VerticalMin"] = data.VerticalMin;
export["VerticalPeak"] = data.VerticalPeak;
export["LateralMin"] = data.LateralMin;
export["LateralPeak"] = data.LateralPeak;
export["SagittalMin"] = data.SagittalMin;
export["SagittalPeak"] = data.SagittalPeak;
export["DeviceTemp"] = data.DeviceTemp;
export["StatusInfo"] = data.StatusInfo;
export["LinkQuality"] = data.LinkQuality;
export["RSSI"] = data.RSSI;
export["TxPower"] = data.TxPower;
export["CoreTemp"] = data.CoreTemp;
export["AuxADC1"] = data.AuxADC1;
export["AuxADC2"] = data.AuxADC2;
export["AuxADC3"] = data.AuxADC3;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (zephyrSummaryData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case Device_Type.BasisPeak:
IEnumerable<BasisPeakSummaryData> basisData = null;
index = 1;
do {
basisData = _basisPeakService.GetBasisPeakSummaryData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (BasisPeakSummaryData data in basisData) {
export.AddRow();
export["date"] = data.Date;
export["calories"] = data.Calories;
export["gsr"] = data.GSR;
export["heart-rate"] = data.HeartRate;
export["skin-temp"] = data.SkinTemp;
export["steps"] = data.Steps;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (basisData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
default:
break;
}
break;
case (int)File_Type.General:
IEnumerable<ZephyrSummaryData> zephyrGeneralData = null;
index = 1;
do {
zephyrGeneralData = _summaryService.GetZephyrSummaryData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrSummaryData data in zephyrGeneralData) {
export.AddRow();
export["Timestamp"] = data.Date;
export["HR"] = data.HeartRate;
export["BR"] = data.BreathingRate;
export["Temp"] = data.SkinTemp;
export["Posture"] = data.Posture;
export["Activity"] = data.Activity;
export["Acceleration"] = data.PeakAccel;
export["Battery"] = data.BatteryVolts;
export["BRAmplitude"] = data.BRAmplitude;
export["ECGAmplitude"] = data.ECGAmplitude;
export["ECGNoise"] = data.ECGNoise;
export["XMin"] = data.LateralMin;
export["XPeak"] = data.LateralPeak;
export["YMin"] = data.VerticalMin;
export["YPeak"] = data.VerticalPeak;
export["ZMin"] = data.SagittalMin;
export["ZPeak"] = data.SagittalPeak;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (zephyrGeneralData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.Temperature:
IEnumerable<MSBandTemperature> temperatureData = null;
index = 1;
do {
temperatureData = _msBandTemperatureService.GetMSBandTemperatureData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandTemperature data in temperatureData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["Temperature(°C)"] = data.Temperature;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (temperatureData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.UV:
IEnumerable<MSBandUV> uvData = null;
index = 1;
do {
uvData = _msBandUVService.GetMSBandUVData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (MSBandUV data in uvData) {
export.AddRow();
export["Time Stamp"] = data.Date;
export["UV Index (0-4)"] = data.UVIndex;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (uvData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
case (int)File_Type.BR_RR:
IEnumerable<ZephyrBRRR> brRrData = null;
index = 1;
do {
brRrData = _brRrService.GetZephyrBRRRData(patientData, ((index - 1) * count), SystemConstants.MAX_ITEMS_RETURNED);
count = 0;
foreach (ZephyrBRRR data in brRrData) {
export.AddRow();
export["Time Stamp"] = data.TimeStamp;
export["BR"] = data.BR;
export["RtoR"] = data.RR;
count++;
if (count == SystemConstants.MAX_ITEMS_RETURNED) {
export.ExportToFile(@path + "\\" + index + "_" + patientData.Name);
index++;
fileIndex = index.ToString() + "_";
export = new CsvExport();
}
}
} while (brRrData != null && count == SystemConstants.MAX_ITEMS_RETURNED);
break;
default:
break;
}
}
catch(OutOfMemoryException ex) {
//Don't need to do anything here just catch the exception and continue. Meant to prevent
//error screen but still allow some data to export. This would need to be troubleshooted
//by a future team.
}
export.ExportToFile(@path + "\\" + fileIndex + patientData.Name);
string zipFileName = "PatientDataRecord-" + patientData.Name + ".zip";
ZipArchive zip = ZipFile.Open(path + "\\" + zipFileName, ZipArchiveMode.Create);
foreach (var file in Directory.EnumerateFiles(path)) {
if (!file.Contains(".zip")) {
zip.CreateEntryFromFile(file, Path.GetFileName(file), CompressionLevel.Optimal);
}
}
zip.Dispose();
return zipFileName;
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
// Then you can do any of the following three output options:
myExport.AddRow();
myExport["Statistic"] = "Unique Visitors";
myExport["FY" + lastYearDisplay + "(Full)"] = long.Parse(uniqueVistor_LastYearFull).ToString("N0");
myExport["FY" + lastYearDisplay + "(to Date)"] = long.Parse(uniqueVistor_LastYeartoDate).ToString("N0");
myExport["FY" + thisYearDisplay + "(to Date)"] = long.Parse(uniqueVistor_thisYeartoDate).ToString("N0");
myExport["% Difference to Date"] = percentDetails_uniqueVisitor;
myExport.AddRow();
myExport["Statistic"] = "Number of Hits";
myExport["FY" + lastYearDisplay + "(Full)"] = long.Parse(NumberofHits_LastYearFull).ToString("N0");
myExport["FY" + lastYearDisplay + "(to Date)"] = long.Parse(NumberofHits_LastYeartoDate).ToString("N0");
myExport["FY" + thisYearDisplay + "(to Date)"] = long.Parse(NumberofHits_thisYeartoDate).ToString("N0");
myExport["% Difference to Date"] = percentDetails_NumberofHits;
myCsv = myExport.Export();
string attachment = "attachment; filename=uniqueVisitors-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
AqlQuery q = GetOrderSelectionQuery((OrderFilter)Utils.GetIntegerOnly(ddlFilterBy.SelectedValue));
List<Order> orders = new List<Order>();
AqlResultSet rs = q.Execute();
while (rs.Read()) {
orders.Add((Order)rs[0]);
}
Shop shop = WAFShopHelper.GetCurrentShop();
//List<Order> orders = WAFContext.Session.Query<Order>().Where(AqlOrder.SiteId == WAFContext.Session.SiteId).Where(AqlOrder.IsDerived == false).OrderBy(AqlOrder.Name).Execute();
CsvExport export = new CsvExport();
foreach (Order o in orders) {
export.AddRow();
export["OrderId"] = o.NodeId;
export["OrderStatus"] = WAFContext.Session.GetEnumName(o.OrderStatus);
export["Email"] = o.Email;
if (o.DateOrdered > o.CreateDate) {
export["DateOrdered"] = o.DateOrdered;
} else {
export["DateOrdered"] = " - ";
}
if (o.DateShipped > o.CreateDate) {
export["DateShipped"] = o.DateShipped;
} else {
export["DateShipped"] = " - ";
}
export["OrderTotal"] = o.OrderTotal;
export["VATAmount"] = o.VATAmount;
export["ItemsSubtotalExVat"] = o.ItemsSubtotalExVat;
double itemsIncVat = 0;
foreach (OrderItem item in o.OrderItems.Get()) {
itemsIncVat = itemsIncVat + item.ItemTotalIncVat;
}
export["ItemsSubtotalIncVat"] = o.ItemsSubtotalExVat;
export["PaymentTransactionId"] = o.PaymentTransactionId;
if (o.PaymentMethod.IsSet()) {
export["PaymentMethod"] = o.PaymentMethod.Get().Name;
} else {
export["PaymentMethod"] = "";
}
export["ShippingAmountExVat"] = o.ShippingAmount;
double taxPercetage = ((double)shop.DefaultTaxRate / (double)100);
export["ShippingAmountIncVat"] = o.ShippingAmount * (1 + taxPercetage);
if (o.ShippingMethod.IsSet()) {
export["ShippingMethod"] = o.ShippingMethod.Get().Name;
} else {
export["ShippingMethod"] = "";
}
string currency = "";
if (o.Currency.IsSet()) {
currency = o.Currency.Get().Code;
}
export["Currency"] = currency;
export["NumberOfItemsInOrder"] = o.GetNumberOfItemsInCart();
if (o.ClassId != Order.ContentClassId) {
//inherited class. add custom fields
ContentDefinition def = WAFContext.Engine.Definition;
var baseProp = def.ContentClass[Order.ContentClassId].GetAllPropertyIds();
var newPropIds = def.ContentClass[o.ClassId].GetAllPropertyIds().Where(p => !baseProp.Contains(p));
foreach (var p in newPropIds.Select(id => def.Property[id])) {
switch (p.BasePropertyClassId) {
case PropertyBaseClass.CheckBoxProperty:
case PropertyBaseClass.FloatProperty:
case PropertyBaseClass.ShortTextProperty:
// case PropertyBaseClass.LongTextProperty:
try { export[p.CodeName] = o.GetProperty(p.Id).ToString(); } catch { }
break;
case PropertyBaseClass.IntegerProperty:
if (p.PropertyClassId == -14) {
EnumerationPropertySettings enumPropSettings = (EnumerationPropertySettings)p.GetSettings(o.ClassId);
IntegerDataValue dv = (IntegerDataValue)o.GetDataValue(p.DataValueIdList[0]);
MemDefEnumeration defEnum = WAFContext.Session.Definitions.Enumeration[enumPropSettings.EnumerationTypeName];
if (dv.Value > 0) {
export[p.CodeName] = defEnum.Values[dv.Value].GetName(WAFContext.Session);
} else {
export[p.CodeName] = "";
}
//MemDefEnumerationValue value in o.Session.Definitions.Enumeration[s.EnumerationTypeName].Values.Values
} else {
IntegerDataValue dv = (IntegerDataValue)o.GetDataValue(p.DataValueIdList[0]);
export[p.CodeName] = dv.Value;
}
break;
default: break;
}
//customPropIds.Add(id);
}
}
export["BillingForename"] = o.BillingForename;
export["BillingSurname"] = o.BillingSurname;
export["BillingCompany"] = o.BillingCompany;
export["BillingAddress"] = o.BillingAddress;
export["BillingAddress2"] = o.BillingAddress2;
export["BillingState"] = WAFContext.Session.GetEnumName(o.BillingState);
export["BillingZip"] = o.BillingZip;
export["BillingCity"] = o.BillingCity;
string billingCountry = "";
if (o.BillingCountry.IsSet()) {
billingCountry = o.BillingCountry.Get().Name;
}
export["BillingCountry"] = billingCountry;
export["BillingMobile"] = o.BillingMobile;
export["BillingPhone"] = o.BillingPhone;
export["ShippingForename"] = o.ShippingForename;
export["ShippingSurname"] = o.ShippingSurname;
export["ShippingCompany"] = o.ShippingCompany;
export["ShippingAddress"] = o.ShippingAddress;
export["ShippingAddress2"] = o.ShippingAddress2;
export["ShippingState"] = WAFContext.Session.GetEnumName(o.ShippingState);
export["ShippingZip"] = o.ShippingZip;
export["ShippingCity"] = o.ShippingCity;
string shippingCountry = "";
if (o.ShippingCountry.IsSet()) {
shippingCountry = o.ShippingCountry.Get().Name;
}
export["ShippingCountry"] = shippingCountry;
export["ShippingMobile"] = o.ShippingMobile;
export["ShippingPhone"] = o.ShippingPhone;
export["InvoiceNotes"] = o.InvoiceNotes;
export["SiteId"] = o.SiteId;
export["LCID"] = o.LCID;
export["TemplateId"] = o.TemplateId;
export["CreateDate"] = o.CreateDate;
export["ChangeDate"] = o.ChangeDate;
export["PublishDate"] = o.PublishDate;
}
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=orders_" + DateTime.Now.Day + "_" + DateTime.Now.Month + "_" + DateTime.Now.Year + "_kl_" + DateTime.Now.Hour + "_" + DateTime.Now.Minute + ".csv");
//Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;//Encoding.GetEncoding("iso-8859-1"); //Encoding.GetEncoding(System.Globalization.CultureInfo.CurrentCulture.TextInfo.OEMCodePage); //Encoding.Default;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "text/csv";
Response.Write(export.Export());
Response.End();
}
protected void ExcelClick_Click(object sender, EventArgs e)
{
CsvExport myExport = new CsvExport();
// Then you can do any of the following three output options:
DataTableReader reader = DataBase.dbDataTable(currentViewSQL.Value).CreateDataReader();
while (reader.Read())
{
myExport.AddRow();
myExport["ResourceName"] = reader["ResourceName"].ToString().Trim();
myExport["PasswordActive"] = reader["PasswordActive"].ToString().Trim();
}
reader.Close();
myCsv = myExport.Export();
string attachment = "attachment; filename=resource-data-" + DateTime.Now.ToShortDateString() + ".csv";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "text/csv";
HttpContext.Current.Response.AddHeader("Pragma", "public");
HttpContext.Current.Response.Write(myCsv);
HttpContext.Current.Response.End();
}
public static void printCSVResults(Dictionary<String, List<Result>> results, String filename, String pathToTrim)
{
var csvExport = new CsvExport();
foreach (KeyValuePair<String, List<Result>> pair in results)
{
foreach (Result result in pair.Value)
{
csvExport.AddRow();
csvExport["Controller"] = pair.Key.Replace(pathToTrim, "");
csvExport["Method Name"] = result.MethodName;
csvExport["Route"] = result.Route;
csvExport["HTTP Method"] = string.Join(", ", result.HttpMethods.ToArray());
csvExport["Attributes"] = string.Join(", ", result.Attributes.ToArray());
}
}
File.Create(filename).Dispose();
csvExport.ExportToFile(filename);
Console.WriteLine("CSV output written to: " + filename);
}
