private bool ExecuteImport(string ClientKey, string inputValue)
{
try
{
System.Data.DataSet ds = new CCoreDao().ExecuteAction(ClientKey, inputValue);
if (ds == null || ds.Tables.Count < 2)
{
return(false);
}
if (ds.Tables[1].Rows.Count == 0)
{
return(false);
}
if (!ds.Tables[0].Columns.Contains("Result"))
{
return(false);
}
var result = ds.Tables[0].Rows[0]["Result"];
if (result == null || result.ToString() == "0")
{
return(false);
}
return(true);
}
catch (Exception ex)
{
CLogManager.WritePL("ExecuteImport", ex.ToString());
}
return(false);
}
public string ExecuteAction(string ClientKey, string inputValue)
{
inputValue = CXML.HtmlDecode(inputValue);
DataSet ds = new CCoreDao().ExecuteAction(ClientKey, inputValue);
return(CDataParser.DataSetToCSV(ds));
}
public string GetContextData(string ClientKey, string inputValue)
{
inputValue = CXML.HtmlDecode(inputValue);
CLogManager.WritePL("GetContextData", "End write response");
DataSet ds = new CCoreDao().GetContextData(ClientKey, inputValue);
CLogManager.WritePL("GetContextData", "End write response");
return(CDataParser.DataSetToCSV(ds));
}
public JsonResult Statistics()
{
CCoreDao db = new CCoreDao();
GenerateData Render = new GenerateData();
//var userID = 0;
string xmlGetUser = Render.GenerateXmlFromObject <object>(null, new
{
Start = 0,
RowspPage = 0,
TickerID = 0,
Side = 0
}, "61", "", 13);
var ds = db.GetContextData(xmlGetUser);
var data = Render.ResponseMultiObject <Statistics>(ds.Tables[0]).ToList();
return(Json(data));
}
public string ExportReport(string ClientKey, string InputValue, string templatePath)
{
DataSet ds = new CCoreDao().GetContextData(ClientKey, InputValue);
DataTable data = ds.Tables[0];
DataTable title = null;
if (ds.Tables.Count > 1)
{
title = ds.Tables[1];
}
string exportType = CXmlUtils.GetXmlNodeValue(InputValue, "RequestParams/@ExportType");
bool isExportPdf = false;
if (exportType.Equals("pdf", StringComparison.OrdinalIgnoreCase))
{
isExportPdf = true;
}
return(new CExcelTemplateUtils().ExportTemplate(templatePath, title, data, 1, isExportPdf));
}
private DataTable GetSummaryResult(string ClientKey, string InputValue)
{
string MarketColumnName = "MarketName";
string StatusColumnName = "Status";
DataTable tblResult = CreateSummaryDataTable();
// string fileName = CXML.GetXmlNodeValue(InputValue, "RequestParams/@FilePath");
//fileName = HttpUtility.HtmlDecode(fileName);
//fileName = uploadPath + "\\" + fileName;
//DataTable data = ReadExcelFile(fileName);
InputValue = "<InputValue /><RequestParams Sys_ViewID=\"14\" />";
DataSet ds = new CCoreDao().GetContextData(ClientKey, InputValue);
//Du lieu tra ve dang
// Market;Color;Ton,...,Install
DataTable data = ds.Tables[0];
Hashtable columns = new Hashtable();
if (data != null)
{
if (data.Columns.Contains(MarketColumnName))
{
foreach (DataRow row in data.Rows)
{
if (row[MarketColumnName] != null)
{
string market = row[MarketColumnName].ToString();
if (!string.IsNullOrEmpty(market) && !columns.ContainsKey(market))
{
columns.Add(market, true);
tblResult.Columns.Add(market, typeof(int));
}
}
}
}
//Summary data
foreach (DataRow row in data.Rows)
{
string market = row[MarketColumnName].ToString();
//string status = row[StatusColumnName].ToString();
foreach (DataRow resultRow in tblResult.Rows)
{
string mappName = resultRow["MapName"].ToString();
if (data.Columns.Contains(mappName))
{
resultRow[market] = row[mappName];
}
//if (resultRow["MapName"].ToString().Contains(market))
//{
// if (tblResult.Columns.Contains(market))
// {
// resultRow[market] = (int)(row[resultRow["MapName"]] == DBNull.Value ? 0 : resultRow[market]) + 1;
// }
//}
}
}
}
return(tblResult);
//return "";
}
