//
// GET: /Reports/QuoteCustomer/
public ActionResult Index()
{
if (!CheckToken(Request.Headers))
{
LogManager.Write("ERROR TOKEN");
return(RedirectToAction("Error"));
}
queryValues = Request.QueryString;
int page = 0;
int start = 0;
int limit = 0;
int id = Convert.ToInt32(queryValues["id"]);
int orden = Convert.ToInt32(queryValues["orden"]);
string filterDateField = queryValues["FilterDateField"];
string strDateFrom = queryValues["DateFrom"];
string strDateTo = queryValues["DateTo"];
int roleId = Convert.ToInt32(queryValues["Role"]);
string strFilterBalance = queryValues["FilterBalance"];
Decimal filterBalance = String.IsNullOrEmpty(strFilterBalance) ? 0 : Convert.ToDecimal(strFilterBalance);
string FilterShowWithInvoice = queryValues["FilterShowWithInvoice"];
FilterShowWithInvoice = !String.IsNullOrEmpty(FilterShowWithInvoice) ? FilterShowWithInvoice : "All";
#region Configuramos el orden de la consulta si se obtuvo como parametro
string strOrder = !string.IsNullOrWhiteSpace(queryValues["sort"]) ? queryValues["sort"] : "";
strOrder = strOrder.Replace('[', ' ');
strOrder = strOrder.Replace(']', ' ');
Sort sort;
if (!string.IsNullOrWhiteSpace(strOrder))
{
sort = JsonConvert.DeserializeObject <Sort>(strOrder);
}
else
{
sort = new Sort();
}
#endregion
#region Configuramos el filtro de la consulta si se obtuvo como parametro
string strFilter = !string.IsNullOrWhiteSpace(queryValues["filter"]) ? queryValues["filter"] : "";
strFilter = strFilter.Replace('[', ' ');
strFilter = strFilter.Replace(']', ' ');
Models.Filter filter;
if (!string.IsNullOrWhiteSpace(strFilter))
{
filter = JsonConvert.DeserializeObject <Models.Filter>(strFilter);
}
else
{
filter = new Models.Filter();
}
#endregion Configuramos el filtro de la consulta si se obtuvo como parametro
string query = !string.IsNullOrWhiteSpace(queryValues["query"]) ? queryValues["query"] : "";
//queryValues = Request.QueryString;
IList <QuoteHeader> lista;
int totalRecords = 0;
string msgError = "";
lista = quoteRepository.GetListHeader(roleId, filterDateField, filterBalance, strDateFrom, strDateTo, FilterShowWithInvoice, query, filter, sort, page, start, limit, ref totalRecords, ref msgError);
//DataTable dtHeader = GetQuotes(roleId, strDateFrom, strDateTo, query, filter, sort, page, start, limit);
LocalReport lr = new LocalReport();
try
{
lr.DataSources.Clear();
lr.DataSources.Add(new ReportDataSource("dsQuotes", lista));
if (roleId == -1)
{
lr.ReportPath = "bin/Areas/Reports/ReportDesign/ReportQuotesGY.rdlc";
}
else
{
lr.ReportPath = "bin/Areas/Reports/ReportDesign/ReportQuotes.rdlc";
}
string reportType = "EXCELOPENXML";
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + id + "</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.2in</MarginTop>" +
" <MarginLeft>0.2in</MarginLeft>" +
" <MarginRight>0.2in</MarginRight>" +
" <MarginBottom>0.2in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] bytes;
bytes = lr.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
string fileName = Utils.GetTempFileNameWithExt("xlsx");
FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
return(Content(Path.GetFileNameWithoutExtension(fileName)));
}
catch (Exception ex)
{
LogManager.Write(ex.Message);
return(RedirectToAction("Error"));
}
}
public object GetAll()
{
try
{
var queryValues = Request.RequestUri.ParseQueryString();
int page = Convert.ToInt32(queryValues["page"]);
int start = Convert.ToInt32(queryValues["start"]);
int limit = Convert.ToInt32(queryValues["limit"]);
int id = Convert.ToInt32(queryValues["id"]);
int orden = Convert.ToInt32(queryValues["orden"]);
string filterDateField = queryValues["FilterDateField"];
string strDateFrom = queryValues["DateFrom"];
string strDateTo = queryValues["DateTo"];
int roleId = Convert.ToInt32(queryValues["Role"]);
string strFilterBalance = queryValues["FilterBalance"];
Decimal filterBalance = String.IsNullOrEmpty(strFilterBalance) ? 0 : Convert.ToDecimal(strFilterBalance);
string FilterShowWithInvoice = queryValues["FilterShowWithInvoice"];
FilterShowWithInvoice = !String.IsNullOrEmpty(FilterShowWithInvoice) ? FilterShowWithInvoice : "All";
#region Configuramos el orden de la consulta si se obtuvo como parametro
string strOrder = !string.IsNullOrWhiteSpace(queryValues["sort"]) ? queryValues["sort"] : "";
strOrder = strOrder.Replace('[', ' ');
strOrder = strOrder.Replace(']', ' ');
Sort sort;
if (!string.IsNullOrWhiteSpace(strOrder))
{
sort = JsonConvert.DeserializeObject <Sort>(strOrder);
}
else
{
sort = new Sort();
}
#endregion
#region Configuramos el filtro de la consulta si se obtuvo como parametro
string strFilter = !string.IsNullOrWhiteSpace(queryValues["filter"]) ? queryValues["filter"] : "";
strFilter = strFilter.Replace('[', ' ');
strFilter = strFilter.Replace(']', ' ');
Filter filter;
if (!string.IsNullOrWhiteSpace(strFilter))
{
filter = JsonConvert.DeserializeObject <Filter>(strFilter);
}
else
{
filter = new Filter();
}
#endregion Configuramos el filtro de la consulta si se obtuvo como parametro
string query = !string.IsNullOrWhiteSpace(queryValues["query"]) ? queryValues["query"] : "";
int totalRecords = 0;
if (id == 0)
{
object json;
string msgError = "";
IList <QuoteHeader> lista;
lista = repository.GetListHeader(roleId, filterDateField, filterBalance, strDateFrom, strDateTo, FilterShowWithInvoice, query, filter, sort, page, start, limit, ref totalRecords, ref msgError);
json = new
{
total = totalRecords,
data = lista,
success = true
};
return(json);
}
else
{
string msgError = "";
Models.QuoteHeader estatus = repository.GetHeader(id, ref msgError);
object json = new
{
data = estatus,
success = true,
message = msgError
};
return(json);
}
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
object error = new { message = ex.Message };
object json = new
{
message = ex.Message,
success = false
};
return(json);
}
}