}//getFiles()
public String Import(String file) {
String Status = "ok";
String StatusMessage = "Completed Successfully";
String UploadPath = Server.MapPath(Url.Content(RootUploadDir));
BlackBox Process = new BlackBox();
StringBuilder JsonText = new StringBuilder();
int ImportedRows = 0;
//String newFile = Process.FixImportFile(UploadPath + file);
try {
ImportedRows = Process.BulkInsert(UploadPath + file);
StatusMessage = "Imported " + ImportedRows + " Rows";
} catch (Exception ex) {
Status = "error";
StatusMessage = ex.Message;
}
JsonText.AppendLine("{");
JsonText.AppendLine(Util.Pair("status", Status, true));
JsonText.AppendLine(Util.Pair("message", StatusMessage, false));
JsonText.AppendLine("}");
return JsonText.ToString();
}