public virtual IActionResult ExportCsvFile([FromBody] ExportCsv exportSettings, [FromHeader][Required] string Authorization)
{
if (!ModelState.IsValid)
{
var error = ModelState.SelectMany(x => x.Value.Errors).First();
if (error.ErrorMessage != null && error.ErrorMessage != String.Empty)
{
return(BadRequest(error.ErrorMessage));
}
else if (error.Exception?.Message != null)
{
return(BadRequest("Faulty input"));
}
else
{
return(BadRequest(ModelState));
}
}
if (Authorization != settings.testToken)
{
return(BadRequest("Not allowed"));
}
string errorMessage = "";
string dataStreamInfo = "";
try
{
ExportCsvResult res = new ExportCsvResult();
string filename = System.Guid.NewGuid().ToString() + ".csv";
string filenameWithPath = "." + Path.DirectorySeparatorChar + "wwwroot" + Path.DirectorySeparatorChar + filename;
DatabaseInterface.DBObservation dBo = new DatabaseInterface.DBObservation();
if (!dBo.FindDataStreamId(int.Parse(exportSettings.ThingId), exportSettings.ObservationType, ref errorMessage, ref dataStreamInfo))
{
return(BadRequest("Internal Server Error:" + errorMessage));
}
// PArse out the ID
string tmp = dataStreamInfo.Substring(dataStreamInfo.IndexOf("(") + 1);
tmp = tmp.Substring(0, tmp.IndexOf(")"));
string url = "http://monappdwp3.monica-cloud.eu:8088/gost_wdom/" + tmp + "?from=" + exportSettings.StartTime.ToString("o") + "&to=" + exportSettings.EndTime.ToString("o");
try
{
WebClient wc = new WebClient();
wc.DownloadFile(url, filenameWithPath);
}
catch (WebException we)
{
// add some kind of error processing
BadRequest("Internal Server Error:" + we.ToString());
}
res.Path = filename;
return(new ObjectResult(res));
}
catch (Exception e)
{
return(BadRequest("Internal Server Error:" + e.Message));
}
}
public void ExportCsvs(string csvRoot)
{
foreach (var kvp in tables)
{
ExportCsv.Export(kvp.Value, csvRoot);
}
}
public void BRequest(Configurations config, int bonusId)
{
ExportCsv exportValues = new ExportCsv();
//String bonusParams = $"game={Configurations.gameName}&key={Configurations.TokenKey}" +
// $"&bonus={Configurations.BonusKey}¶m=0&ts={Configurations.TimeStamp}&platform=web";
String bonusParams = "";
var bonusCompleted = false;
int counter = 1;
String bonusValue;
int type = Convert.ToInt32(config.GameType);
do
{
switch (type)
{
case 0: // cascading
bonusValue = "0";
bonusParams = $"game={config.gameName}&key={config.TokenKey}" +
$"&bonus={bonusValue}¶m={bonusValue}&ts={config.TimeStamp}&platform=web";
break;
case 1:
var param = counter.ToString();
var mode = counter.ToString();
if (bonusId == 3 || bonusId == 4)
{
counter++;
}
bonusParams = $"game={config.gameName}&key={config.TokenKey}" +
$"&bonus={config.TokenKey}¶m={param}&mode={mode}&ts={config.TimeStamp}&platform=web";
break;
case 2:
bonusParams = $"game={config.gameName}&key={config.TokenKey}" +
$"&bonus={config.TokenKey}¶m=0&&ts={config.TimeStamp}&platform=web";
break;
}
var actualResult = SlotRequest <BonusResult>(Configurations.BonusEndpoint, bonusParams);
if (config.Export)
{
exportValues.ExportCSV(config, actualResult.TxnId.ToString(), "Bonus Request",
config.Bet, actualResult.TotalBet.ToString(), actualResult.TotalWin.ToString());
}
Console.WriteLine("Bonus Ongoing");
bonusCompleted = actualResult.BonusCompleted;
} while (!bonusCompleted);
}
private void btnExport_Click(object sender, EventArgs e)
{
//Configuration file header y declare variable;
string headerCsv, path = string.Empty;
headerCsv = "Nombre,Apellido,Cedula,Carnet,Tipo de personal,Tipo usuario,Estado,Activo";
//open dialog and get pathDirectory
path = Util.OpenSaveFileDialog();
if (path != null && !string.IsNullOrWhiteSpace(path))
{
ExportCsv exportCsv = new ExportCsv(path);
exportCsv.WriteFileHeader(headerCsv);
var dataToExport = audiovisualEntities.Users.ToList();
foreach (User data in dataToExport)
{
//Data to insert into body
string linea = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}",
data.FirstName,
data.LastName,
data.IdentificationCard,
data.Carnet,
data.PersonalType.Description,
data.UsersType.Description,
data.UsersState.Description,
data.Enabled);
exportCsv.WriteFileLine(linea);
}
}
;
}
private void btnExport_Click(object sender, EventArgs e)
{
//Configuration file header y declare variable;
string headerCsv, path = string.Empty;
headerCsv = "Nombre,Apellido,Cedula,Turno de trabajo,Fecha de contratación,Estado,Activo";
//open dialog and get pathDirectory
path = Util.OpenSaveFileDialog();
if (path != null && !string.IsNullOrWhiteSpace(path))
{
ExportCsv exportCsv = new ExportCsv(path);
exportCsv.WriteFileHeader(headerCsv);
var dataToExport = audiovisualEntities.Employees.ToList();
foreach (Employee data in dataToExport)
{
//Data to insert into body
string linea = string.Format("{0},{1},{2},{4},{5},{6}",
data.FirstName,
data.LastName,
data.IdentificationCard,
data.Workshift,
data.HiredDate,
data.EmployeesState.Description,
data.Enabled
);
exportCsv.WriteFileLine(linea);
}
}
;
}
private void btnExport_Click(object sender, EventArgs e)
{
//Configuration file header y declare variable;
string headerCsv, path = string.Empty;
headerCsv = "Descripcion,Serial,Tag Servicio,Modelo,Marca,Tecnologia Conexion,Estado,Activo";
//open dialog and get pathDirectory
path = Util.OpenSaveFileDialog();
if (path != null && !string.IsNullOrWhiteSpace(path))
{
ExportCsv exportCsv = new ExportCsv(path);
exportCsv.WriteFileHeader(headerCsv);
var dataToExport = audiovisualEntities.Equiments.ToList();
foreach (Model.Equiment data in dataToExport)
{
//Data to insert into body
string linea = string.Format("{0},{1},{2},{3},{4},{5},{6}",
data.Description,
data.Serial,
data.ServiceTag,
data.Model.Description,
data.Brand.Description,
data.TechnologiesConnection.Description,
data.EquimentsState.Description
);
exportCsv.WriteFileLine(linea);
}
}
;
}
public static void WriteCsVintoFile <T>(string filepath, ref List <T> list, ref bool blHeader)
{
if (list.Count > 0)
{
//MasterPageBase[] objaray= listmasterpagebase.ToArray();
string strCsv = ExportCsv.ToCsv(",", list, ref blHeader);
AppendTextintoFile(filepath, strCsv);
}
list.TrimExcess();
list = null;
}
//�Private�Methods�(1)�
private static ExportStrategy GetExportStrategyObject(ExportingOption exportOption)
{
ExportStrategy obj;
switch (exportOption)
{
case ExportingOption.Csv:
obj = new ExportCsv();
break;
default: throw new ArgumentException("Invalid export type specified = " + exportOption);
}
return(obj);
}
/// <summary>
/// Fonction appelé lorsque on souhaite exporter la base de donénes
/// </summary>
private void Exporter_Click(object sender, EventArgs e)
{
//On verifie que l'utilisateur a selectionné un dossier
if (this.label1.Text != null && this.label1.Text != "")
{
//On recupere le dossier selectionnée et on appel la fonction ExporterCsv
ExportCsv CsvExport = new ExportCsv();
int ResultatExport;
this.progressBar1.Increment(50);
ResultatExport = CsvExport.ExporterCsv(this.label1.Text);
this.progressBar1.Increment(100);
// Message affiché à la fin de l'importation
this.textStatus.Text = "Le fichier a été exporté avec succés";
}
}
// Function onclick of button export CSV
private void exportCsv_Click(object sender, EventArgs e)
{
ExportCsv.writeCsv(this.ViewModel.VMMain.Client, this.ViewModel.VMMain.UIMainForm);
}
