private void RemoveSales(SalesRangeRequestModel range, string filePath)
{
var dates = new List <string>();
var date = range.From;
do
{
dates.Add(date.ToString("ddMMyyyy"));
date = date.AddDays(1);
} while (range.To >= date);
context.Archivos.RemoveRange(from x in context.Archivos
where dates.Contains(x.Fecha) &&
x.Ruta == filePath &&
x.Tipo == "VTA"
select x);
context.SaveChanges();
}
public IActionResult Post([FromBody] SalesRangeRequestModel range)
{
var credentials = (from x in context.CLogid
where x.CLogPortal == "PH"
select x).FirstOrDefault();
var filePath = credentials.CLogRutaDescarga;
if (!filePath.EndsWith(@"\"))
{
filePath += @"\";
}
RemoveSales(range, filePath);
var explorer = new AwebExplorer();
var files = explorer.OnlyDownloadSales(credentials.CLogUsuario, credentials.CLogContrasenia, range.From, range.To);
WriteSales(filePath, files);
return(NoContent());
}
