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()); }