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", "") + "\"}]}"); } }