public virtual IActionResult ExportToExcel()
{
try
{
var data = _baseRepo.GetAll <T>(x => x.Where(y => y.Active == true));
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <T>(data, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (data != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new T().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}
public IActionResult ExportToExcel(long branchOfficeId = 0, long warehouseId = 0, long productId = 0)
{
try
{
var data = _baseRepo.GetAll <Inventory>(x => x.Include(i => i.Product)
.Include(i => i.Warehouse)
.Include(i => i.BranchOffice)
.Include(i => i.Unit)
, y => y.Active == true &&
(branchOfficeId > 0 ? y.BranchOfficeId == branchOfficeId : y.BranchOfficeId > 0) &&
(warehouseId > 0 ? y.WarehouseId == warehouseId : y.WarehouseId > 0) &&
(productId > 0 ? y.ProductId == productId : y.ProductId > 0));
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "ES";
var excelData = ExportUtility.GetExcelData <Inventory>(data, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (data != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}
public IActionResult GetTaxesReportExcel(string initialDate = "0", string endDate = "0")
{
try
{
DateTime?startDate = null;
startDate = initialDate != "0" ? Convert.ToDateTime(initialDate) : startDate;
DateTime?finalDate = null;
finalDate = endDate != "0" ? Convert.ToDateTime(endDate) : finalDate;
var data = businessStateRepository.GetTaxesReport(startDate, finalDate);
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <InvoiceTax>(data.SelectMany(x => x.Taxes), requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (data != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}
public IActionResult GetOwedExpensesReport(long branchOfficeId = 0, long supplierId = 0, long currencyId = 0, string startDate = "0", string endDate = "0")
{
try
{
DateTime?start = null;
start = startDate != "0" ? Convert.ToDateTime(startDate) : start;
DateTime?end = null;
end = endDate != "0" ? Convert.ToDateTime(endDate) : DateTime.Now;
var data = _repo.GetDebsToPay(start, end, supplierId, currencyId, branchOfficeId);
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <Expense>(data, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (data != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}
public Task <IActionResult> ExportState(string startDate = "0", string endDate = "0")
{
var t_result = Task.Factory.StartNew <IActionResult>((arg) => {
try
{
var t_inputs = arg as Tuple <string, string>;
var invoices = _customRepo.GetCompanyStatus(
t_inputs.Item1 == "0" ? DateTime.MinValue : Convert.ToDateTime(t_inputs.Item1),
t_inputs.Item2 == "0" ? DateTime.Now : Convert.ToDateTime(t_inputs.Item2));
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <CompanyStateModel>(invoices, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (invoices != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}, new Tuple <string, string>(startDate, endDate));
return(t_result);
}
public Task <IActionResult> ExportComissionsReport([FromBody] ComissionsSearch search)
{
var t_result = Task.Factory.StartNew <IActionResult>((arg) => {
try
{
var t_inputs = arg as Tuple <ComissionsSearch, ISellerRepository>;
var invoices = t_inputs.Item1.ReportType == 0 ?
t_inputs.Item2.SalesComissions(t_inputs.Item1) : t_inputs.Item2.PaymentsComissions(t_inputs.Item1);
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <ComissionDetail>(invoices.ComissionsByCyrrencies.SelectMany(x => x.Details), requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (invoices != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}, new Tuple <ComissionsSearch, ISellerRepository>(search, _repositoryFactory.GetCustomDataRepositories <ISellerRepository>()));
return(t_result);
}
public IActionResult AccountStateExport(long customerId)
{
try
{
var data = _repositoryFactory.GetCustomDataRepositories <ICustomerBalanceRepository>().CustomerState(customerId);
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <CustomerStateModel>(data.Data, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (data != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}
public virtual Task <IActionResult> ExportReceipts(long branchOfficeId = 0, long customerId = 0, long currencyId = 0, long paymentTypeId = 0, string startDate = "0", string endDate = "0")
{
DateTime?start = new DateTime();
if (startDate != "0")
{
start = Convert.ToDateTime(startDate);
}
else
{
start = null;
}
DateTime?end = new DateTime();
if (endDate != "0")
{
end = Convert.ToDateTime(endDate);
}
else
{
end = null;
}
var t_result = Task.Factory.StartNew <IActionResult>((arg) => {
try
{
var t_inputs = arg as Tuple <long, long, long, long, DateTime?, DateTime?>;
var invoices = base._repositoryFactory.GetCustomDataRepositories <ICustomerPaymentRepository>().IncomesReport(
t_inputs.Item3,
t_inputs.Item1,
t_inputs.Item2,
t_inputs.Item4,
t_inputs.Item5,
t_inputs.Item6
);
string requestLanguage = "EN";
var languageIdHeader = this.Request.Headers["languageid"];
requestLanguage = languageIdHeader.FirstOrDefault() ?? "es";
var excelData = ExportUtility.GetExcelData <CustomerPayment>(invoices, requestLanguage, this.languageKeys.ToList());
var excelStream = ExcelImport.CreateXlsStream(
excelData.Item1,
excelData.Item2
);
if (invoices != null && excelStream != null && excelStream.Length > 0)
{
return(File(excelStream.ToArray(), "application/octet-stream", $"{new Product().GetType().Name}-{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}.xls"));
}
return(BadRequest(new { status = -1, message = "Documento no existe" }));
}
catch (Exception ex)
{
return(Ok(new { status = -1, message = ex.Message }));
}
}, new Tuple <long, long, long, long, DateTime?, DateTime?>(customerId, currencyId, branchOfficeId, paymentTypeId, start, end));
return(t_result);
}
