public string BulkCopyToSqlNoLower(DataTable dt, Dictionary <string, string> dicConfig, Dictionary <string, string> dicParr)
{
try
{
var prDt = new SqlParameter("@dt", SqlDbType.Structured);
prDt.Value = dt;
List <SqlParameter> lstParr = new List <SqlParameter>();
lstParr.Add(prDt);
if (dicParr != null)
{
foreach (var item in dicParr)
{
lstParr.Add(new SqlParameter("@" + item.Key, item.Value));
}
// trường hợp đặc biệt thêm mã hóa đăng nhập
// encode: true, passold: "PP01000111917", passnew: "PasswordEncrypt"
if (dicConfig.ContainsKey("encode") && Convert.ToBoolean(dicConfig["encode"]))
{
string passEncrypt = SLCommon.Security.EncryptString(dicConfig["passold"]);
lstParr.Add(new SqlParameter("@" + dicConfig["passnew"], passEncrypt));
}
}
string connect = ConfigurationManager.ConnectionStrings[dicConfig["connstr"]].ConnectionString;
var ds = DynamicSelectDataset(dicConfig["namesql"], lstParr.ToArray(), CommandType.StoredProcedure, connect);
var data = gn.ConvertDatasetToListJsonNoLower(ds);
if (data == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Lỗi khi ConvertDatasetToListJson\"}]}");
}
var json = gn.ConvertListToJson(data);
var strResult = "{\"result\":\"OK\",\"data\":" + json + "}";
return(strResult);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
}
public string ExecuteSqlDatasetNoLower(Dictionary <string, string> dicConfig, Dictionary <string, string> dicParr)
{
SqlConnection Conn = null;
SqlCommand command = null;
SqlDataAdapter adapter = null;
try
{
// SqlConnection Connection = new SqlConnection(ConfigurationManager.ConnectionStrings[_dicConfig["connstr"]].ConnectionString);
// var conStr = Connection != null ? Connection.ConnectionString : "";
general gn = new general();
var dicApp = gn.ReadAppseting();
string Connection = dicApp[dicConfig["connstr"].ToString().ToLower()];// dicApp["connectsql"];
var conStr = Connection != null ? Connection : "";
if (conStr == "")
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Lỗi khi gọi ConnectionString\"}]}");
}
Conn = new SqlConnection(conStr);
command = new SqlCommand {
Connection = Conn
};
command.CommandText = dicConfig["namesql"];
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
if (dicParr != null)
{
List <SqlParameter> lstParr = new List <SqlParameter>();
foreach (var item in dicParr)
{
lstParr.Add(new SqlParameter("@" + item.Key, item.Value));
}
// trường hợp đặc biệt thêm mã hóa đăng nhập
// encode: true, passold: "PP01000111917", passnew: "PasswordEncrypt"
if (dicConfig.ContainsKey("encode") && Convert.ToBoolean(dicConfig["encode"]))
{
string passEncrypt = SLCommon.Security.EncryptString(dicConfig["passold"]);
lstParr.Add(new SqlParameter("@" + dicConfig["passnew"], passEncrypt));
}
command.Parameters.AddRange(lstParr.ToArray());
}
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
adapter = new SqlDataAdapter(command);
var ds = new DataSet();
adapter.Fill(ds);
var data = gn.ConvertDatasetToListJsonNoLower(ds);
if (data == null)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"Lỗi khi ConvertDatasetToListJson\"}]}");
}
var json = gn.ConvertListToJson(data);
var strResult = "{\"result\":\"OK\",\"data\":" + json + "}";
return(strResult);
}
catch (Exception ex)
{
return("{\"result\":\"ERROR\",\"data\":[{\"status\":\"" + ex.Message.Replace("\n", "") + "\"}]}");
}
finally
{
if (command != null)
{
command.Dispose();
command = null;
}
if (adapter != null)
{
//if(adapter.is)
adapter.Dispose();
adapter = null;
}
if (Conn.State != ConnectionState.Closed)
{
Conn.Close();
}
}
}
public JsonResult ReadFileXml()
{
try
{
Dictionary <string, string> dicAppSet = null;
if (dicAppSet == null || dicAppSet.Count == 0)
{
general gn = new general();
dicAppSet = gn.ReadAppseting();
if (dicAppSet == null || dicAppSet.Count == 0)
{
Json("{\"result\":\"OK\",\"data\":\"Đọc appsetting lỗi\"}");
}
}
string fileName = "";
for (int i = 0; i < Request.Files.Count; i++)
{
HttpPostedFileBase file = Request.Files[i]; //Uploaded file
//Use the following properties to get file's name, size and MIMEType
int fileSize = file.ContentLength;
fileName = file.FileName;
string mimeType = file.ContentType;
System.IO.Stream fileContent = file.InputStream;
//To save file, use SaveAs method
string filePath = dicAppSet["path_saveonserver"] + fileName;
file.SaveAs(filePath); //File will be saved in application root
var itemp = this.Request.Form;
var parr = new Dictionary <string, string>();
foreach (var key in itemp.AllKeys)
{
parr.Add(key.ToLower(), itemp[key]);
}
XmlDocument doc = new XmlDocument();
doc.Load(filePath);
var dsHead = new DataSet();
DataSet ds = new DataSet();
ds.ReadXml(new XmlNodeReader(doc));
var dt = new DataTable("dt");
dt.Columns.Add("Header");
dt.Rows.Add(ds.GetXmlSchema());
ds.Tables.Add(dt);
general gn = new general();
var data = gn.ConvertDatasetToListJsonNoLower(ds);
if (data == null)
{
return(Json("{\"result\":\"ERROR\",\"data\":\"Lỗi khi ConvertDatasetToListJson\"}"));
}
var json = gn.ConvertListToJson(data);
var strResult = Json("{\"result\":\"OK\",\"data\":" + json + "}");
System.IO.File.Delete(filePath);
return(strResult);
}
return(Json("{\"result\":\"OK\",\"data\":\"Không nhận được file\"}"));
}
catch (Exception ex)
{
return(Json("{\"result\":\"ERROR\",\"data\":\"" + ex.Message + "\"}"));
}
}
