public string ExcuteStores(string config, string para, Dictionary <string, string> dicAppset)
{
try
{
var dicPara = gn.ParaConvertDicPara(para);
var dicConfig = gn.ConfigConvertToDicConfig(config);
if (dicPara == null && dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
if (dicConfig.ContainsKey("commandtype") && dicConfig["commandtype"].ToLower() == "text")
{
var json = "";
json = ExcuteReturnJson(dicConfig, null);
return(json);
}
else
{
var dsParaOnSql = DecodeProceduePara_New(dicConfig, dicAppset);
var paraOk = dicParaToOraclePara_New(dsParaOnSql, dicPara);
var json = "";
json = ExcuteReturnJson(dicConfig, paraOk);
return(json);
}
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// POST: api/BulkCopySqlRenameCol
public string Post(paraExportXml value)
{
try
{
general gn = new general();
var json = "";
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var table = JObject.Parse(value.para);
if (table == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
gnSqlNomal gns = new gnSqlNomal();
var para = gns.convertParaToDic(value.para);
DataTable dt = new DataTable("dt");
foreach (var val in table)
{
dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
break;
}
gn.ExportTable(dt, dicConfig);
return(json);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
public string ExcuteStores(string config, string para, Dictionary <string, string> dicAppset, Dictionary <string, string> dicProce)
{
try
{
var lstPara = gn.ParaConvertListPara(para);
var dicConfig = gn.ConfigConvertToDicConfig(config);
if (lstPara == null && dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var dicConfigOk = gn.DecodeProcedueConfig(dicConfig, dicProce);
if (dicConfigOk == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Chưa mã hóa thủ tục\"}]}");
}
var paraOk = DecodeProceduePara(lstPara, dicConfigOk, dicAppset, dicProce);
var json = "";
json = ExecuteSqlJson(dicConfig, paraOk);
return(json);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// POST: api/Convert_HtmlToWord
public string Post(HtmlToWord value)
{
try
{
Dictionary <string, string> dicAppSet;
general gn = new general();
dicAppSet = gn.ReadAppseting();
if (dicAppSet == null || dicAppSet.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
}
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
getTextInHtml html = new getTextInHtml();
string data = html.GetHTMLfromUrl(dicConfig["fromurl"]);
NoInkSoftware.HTMLtoDOCX NewFile = new NoInkSoftware.HTMLtoDOCX();
var namefile = dicAppSet["path_saveonserver"] + dicConfig["namefile"];
NewFile.CreateFileFromHTML(data, namefile);
return("{\"result\":\"OK\",\"data\":\"" + namefile + "\"}");
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// GET api/Xml_ExportOracle/5
public HttpResponseMessage Get(string idrandom)
{
general gn = new general();
var dicAppSet = gn.ReadAppseting();
var lst = JObject.Parse(_dicPara_xml["StrColumnNames" + idrandom]).SelectToken("kq").ToString();
var LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);
// lay du lieu
gnOracle or = new gnOracle();
if (dicAppSet == null || dicAppSet.Count == 0)
{
return(null);
}
var dicPara = gn.ParaConvertDicPara(_dicPara_xml["StrPara" + idrandom]);
var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_xml["StrConfig" + idrandom]);
if (dicPara == null && dicConfig == null)
{
return(null);
}
_dicPara_xml.Remove("StrPara" + idrandom);
_dicPara_xml.Remove("StrConfig" + idrandom);
_dicPara_xml.Remove("StrColumnNames" + idrandom);
var dsParaOnSql = or.DecodeProceduePara_New(dicConfig, dicAppSet);
var paraOk = or.dicParaToOraclePara_New(dsParaOnSql, dicPara);
var ds = or.ExcuteReturnDataSet(dicConfig["namesql"], paraOk.ToList(), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
var ds1 = gn.convertDatasetToLower(ds);
string filePath = dicAppSet["path_saveonserver"] + dicConfig["namefile"] + ".xml";
System.IO.StreamWriter xmlSW = new System.IO.StreamWriter(filePath);
ds1.WriteXml(xmlSW, XmlWriteMode.WriteSchema);
xmlSW.Close();
var response = new HttpResponseMessage();
FileStream fileStream = File.Open(filePath, FileMode.Open);
response.Content = new StreamContent(fileStream);
response.Content.Headers.ContentDisposition
= new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = dicConfig["namefile"] + ".xml";
response.Content.Headers.ContentType
= new System.Net.Http.Headers.MediaTypeHeaderValue("application/octet-stream");
response.Content.Headers.ContentLength
= fileStream.Length;
return(response);
//return System.Web.Mvc.Controller.(filePath, MimeMapping.GetMimeMapping(filePath));
}
// POST: api/BulkCopySqlRenameCol
public string Post(paraBulkTableSqlRename value)
{
try
{
general gn = new general();
var json = "";
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var table = JObject.Parse(value.table);
if (table == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
gnSqlNomal gns = new gnSqlNomal();
var para = gns.convertParaToDic(value.para);
DataTable dt = new DataTable("dt");
foreach (var val in table)
{
dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
break;
}
// thay doi ten cot
for (var c = 0; c < dt.Columns.Count; c++)
{
dt.Columns[c].ColumnName = "Col" + c;
}
var nextCol = dt.Columns.Count;
// ADD THEM COT RONG VAO BANG. CHO DU 30 COT
for (var j = nextCol; j < 50; j++)
{
try
{
DataColumn myColumn = new DataColumn();
myColumn.Caption = "Col" + j;
myColumn.ColumnName = "Col" + j;
myColumn.DefaultValue = "";
dt.Columns.Add(myColumn);
}
catch (Exception ex) { }
}
gnSql sql = new gnSql();
json = sql.BulkCopyToSqlNoLower(dt, dicConfig, para);
return(json);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// GET api/excel/5
public string Get(string id)
{
try
{
if (id == "")
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại userid\"}]}");
}
var user = id;
general gn = new general();
dicAppSet = gn.ReadAppseting();
var lst = JObject.Parse(_dicPara_exnom["StrColumnNames" + user]).SelectToken("kq").ToString();
var LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);
if (dicAppSet == null || dicAppSet.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
}
var lstPara = gn.ParaConvertListPara(_dicPara_exnom["StrPara" + user]);
var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_exnom["StrConfig" + user]);
if (lstPara == null && dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
_dicPara_exnom.Remove("StrPara" + user);
_dicPara_exnom.Remove("StrConfig" + user);
_dicPara_exnom.Remove("StrColumnNames" + user);
gnOracle orl = new gnOracle();
gnExcel exx = new gnExcel();
// var dtPara = orl.DecodeProceduePara(lstPara, dicConfigOk, dicAppSet);
var dtPara = orl.DecodeProceduePara(lstPara, dicConfig, dicAppSet);
var lstPrOrl = orl.dicParaToOraclePara(dtPara == null || dtPara.Tables.Count == 0 ? null : dtPara.Tables[0], lstPara);
var ds = orl.ExcuteReturnDataSet(dicConfig["namesql"], (lstPrOrl == null ?null: lstPrOrl), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);
if (ds == null || ds.Tables.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không có dữ liệu xuất excel\"}]}");
}
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
ds.Tables[0].Columns[i].ColumnName = ds.Tables[0].Columns[i].ColumnName.ToLower();
}
exx.ExporttoExcel(new List <string>(), ds.Tables[0], LstColumnNames, dicConfig.ContainsKey("namefile") ? dicConfig["namefile"] : "" + DateTime.Now.ToString("dd-MM-yyyy"), 1, false, true);
return("");
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// GET api/ExcelExportOracle/5
public string Get(string idrandom)
{
general gn = new general();
var dicAppSet = gn.ReadAppseting();
var lst = JObject.Parse(_dicPara_exoracle["StrColumnNames" + idrandom]).SelectToken("kq").ToString();
var LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);
// lay du lieu
gnOracle or = new gnOracle();
if (dicAppSet == null || dicAppSet.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
}
var dicPara = gn.ParaConvertDicPara(_dicPara_exoracle["StrPara" + idrandom]);
var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_exoracle["StrConfig" + idrandom]);
_dicPara_exoracle.Remove("StrPara" + idrandom);
_dicPara_exoracle.Remove("StrConfig" + idrandom);
_dicPara_exoracle.Remove("StrColumnNames" + idrandom);
if (dicPara == null && dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var dsParaOnSql = or.DecodeProceduePara_New(dicConfig, dicAppSet);
var paraOk = or.dicParaToOraclePara_New(dsParaOnSql, dicPara);
var ds = or.ExcuteReturnDataSet(dicConfig["namesql"], paraOk.ToList(), CommandType.StoredProcedure, dicAppSet[dicConfig["connstr"].ToLower()]);
if (ds == null || ds.Tables.Count == 0)
{
return("");
}
var ds1 = gn.convertDatasetToLower(ds);
gnExcel exx = new gnExcel();
var idtable = 0;
if (dicConfig.ContainsKey("exporttable"))
{
idtable = Convert.ToInt32(dicConfig["exporttable"]);
}
exx.ExporttoExcel(new List <string>(), ds1.Tables[idtable], LstColumnNames, dicConfig.ContainsKey("namefile") ? dicConfig["namefile"] : "" + DateTime.Now.ToString("dd-MM-yyyy"), 1, false, true);
return("");
}
// POST: api/Convert_HtmlToXml
public string Post(HtmlToXml value)
{
try
{
Dictionary <string, string> dicAppSet;
general gn = new general();
dicAppSet = gn.ReadAppseting();
if (dicAppSet == null || dicAppSet.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
}
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var namefile = dicAppSet["path_saveonserver"] + dicConfig["namefile"];
//requesting the particular web page
var httpRequest = (HttpWebRequest)WebRequest.Create(dicConfig["fromurl"]);
//geting the response from the request url
var response = (HttpWebResponse)httpRequest.GetResponse();
//create a stream to hold the contents of the response (in this case it is the contents of the XML file
var receiveStream = response.GetResponseStream();
//creating XML document
var mySourceDoc = new XmlDocument();
//load the file from the stream
mySourceDoc.Load(receiveStream);
mySourceDoc.Save(namefile);
//close the stream
receiveStream.Close();
return("{\"result\":\"OK\",\"data\":\"" + namefile + "\"}");
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// POST api/BulkcopyOracle
public string Post(paraBulkTable value)
{
try
{
Dictionary <string, string> dicAppSet;
Dictionary <string, string> dicProce;
general gn = new general();
dicAppSet = gn.ReadAppseting();
var json = "";
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var para = JObject.Parse(value.table);
if (para == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
Db_Access ac = new Db_Access();
var check = ac.checkRequertLienTuc(HttpContext.Current, dicAppSet, value.config, "");
if (!check)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không cho phép request liên tục\"}]}");
}
foreach (var val in para)
{
var dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
gnBulkCopyOracle or = new gnBulkCopyOracle();
json = or.BulkCopyToOracle(dt, dicConfig);
}
return(json);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// POST: api/BulkCopySql
public string Post(paraBulkTableSql value)
{
try
{
general gn = new general();
var dicAppSet = gn.ReadAppseting();
var json = "";
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var table = JObject.Parse(value.table);
if (table == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
Db_Access ac = new Db_Access();
var check = ac.checkRequertLienTuc(HttpContext.Current, dicAppSet, value.config, "");
if (!check)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Không cho phép request liên tục\"}]}");
}
gnSqlNomal gns = new gnSqlNomal();
var para = gns.convertParaToDic(value.para);
foreach (var val in table)
{
var dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
gnSql sql = new gnSql();
json = sql.BulkCopyToSql(dt, dicConfig, para);
}
return(json);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// GET api/ExcelExportTable/5
public string Get(string id)
{
try
{
if (id == "")
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại userid\"}]}");
}
var user = id;
general gn = new general();
dicAppSet = gn.ReadAppseting();
var lst = JObject.Parse(_dicPara_table["StrTableColumnNames" + user]).SelectToken("kq").ToString();
var LstColumnNames = JsonConvert.DeserializeObject <List <ListColumnExport> >(lst);
var dicConfig = gn.ConfigConvertToDicConfig(_dicPara_table["StrTableConfig" + user]);
DataTable dt = null;
foreach (var val in JObject.Parse(_dicPara_table["StrTableData" + user]))
{
dt = gn.ConvertJsonToDataTable(val.Value.ToString(), val.Key);
}
if (dt == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
_dicPara_table.Remove("StrTableColumnNames" + user);
_dicPara_table.Remove("StrTableConfig" + user);
_dicPara_table.Remove("StrTableData" + user);
gnExcel exx = new gnExcel();
exx.ExporttoExcel(new List <string>(), dt, LstColumnNames, dicConfig.ContainsKey("namefile") ? dicConfig["namefile"] : "" + DateTime.Now.ToString("dd-MM-yyyy"), 1, false, true);
return("");
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
// POST: api/Convert_WordToPdf
public string Post(WordToPdf value)
{
try
{
Dictionary <string, string> dicAppSet;
general gn = new general();
dicAppSet = gn.ReadAppseting();
if (dicAppSet == null || dicAppSet.Count == 0)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Đọc appsetting lỗi\"}]}");
}
var dicConfig = gn.ConfigConvertToDicConfig(value.config);
if (dicConfig == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
var pathFrom = dicConfig["fromfile"];
if (pathFrom.EndsWith(".doc") || pathFrom.EndsWith(".docx"))
{
var pathTo = pathFrom.Replace(".docx", ".pdf").Replace(".doc", ".pdf");
Word2Pdf objWorPdf = new Word2Pdf();
objWorPdf.InputLocation = pathFrom;
objWorPdf.OutputLocation = pathTo;
objWorPdf.Word2PdfCOnversion();
return("{\"result\":\"OK\",\"data\":\"" + pathTo + "\"}");
}
else
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Kiểm tra lại định dạng json đầu vào\"}]}");
}
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
