Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
151112 | Jan 31,2020 08:12 AM UTC | Feb 13,2020 09:47 AM UTC | ASP.NET MVC - EJ 2 | 9 |
![]() |
Tags: FileManager |
case "search":
if (args.CustomField.ToLower() =="true")
{
args.CustomField = "1";
}
else
{
args.CustomField = "0";
}
// gets the list of file(s) or folder(s) from a given path based on the searched key string.
return operation.ToCamelCase(operation.Search(args.Path, args.SearchString, args.ShowHiddenItems, args.CaseSensitive,args.CustomField, args.Data)); |
string searchQuery = "select * from " + this.TableName + " where isFile= " + customField;
SqlCommand searchcmd = new SqlCommand(searchQuery, sqlConnection);
SqlDataReader reader = searchcmd.ExecuteReader();
// SqlDataReader reader = (new SqlCommand("select * from " + this.TableName + " where Size like 30 "), sqlConnection).ExecuteReader();
while (reader.Read())
{
searchData = new FileManagerDirectoryContent
{
Name = reader["Name"].ToString().Trim(),
Size = (long)reader["Size"],
IsFile = (bool)reader["IsFile"],
DateModified = (DateTime)reader["DateModified"],
DateCreated = (DateTime)reader["DateCreated"],
Type = GetDefaultExtension(reader["MimeType"].ToString()),
HasChild = (bool)reader["HasChild"],
Id = reader["ItemId"].ToString().Trim()
};
if (searchData.Name != "Products") foundFiles.Add(searchData);
}
reader.Close();
foreach (var file in foundFiles)
{
file.FilterPath = GetFilterPath(file.Id);
file.FilterId = GetFilterId(file.Id);
}
}
searchResponse.Files = (IEnumerable<FileManagerDirectoryContent>)foundFiles;
return searchResponse; |
[Js]
function beforeSend(args) {
if (args.action == "Upload") {
var data = JSON.parse(args.ajaxSettings.data);
// Add custom parameter column
data.push({ reviewNumber: "1" });
// Add custom parameter in ajax settings
args.ajaxSettings.data = JSON.stringify(data);
}
}
[C#]
public void UploadQuery(string filename, string contentType, byte[] bytes, string parentId, string reviewNumber)
{
command.Parameters.Add(new SqlParameter("@ReviewNumber", reviewNumber));
} |
public object FileOperations([FromBody] FileManagerDirectoryContent args)
{
switch (args.Action)
{
case "search":
return this.search(args);
}
return null;
}
public object search(FileManagerDirectoryContent args)
{
FileResponse readResponse = new FileResponse();
try
{
// In the below serach operation you can perform the search based on review number
var value = this.operation.Search(args.Path, args.SearchString, args.ShowHiddenItems, args.CaseSensitive, args.Data);
// Tn the below class, you can add the review number as a additional attribute.
DirectoryContent cwd = new DirectoryContent();
}
}
// New property ReviewNumber is added to DirectoryContent class to perform this customization
public class DirectoryContent
{
public string ReviewNumber { get; set; }
public string Path { get; set; }
}
public FileManagerResponse Search(string path, string searchString, bool showHiddenItems, bool caseSensitive, params FileManagerDirectoryContent[] data)
{
// Search the item based on Review number
SqlDataReader reader = (new SqlCommand("select * from " + this.TableName + " where ReviewNumber like '" + searchString.Replace("*", "%") + "' AND ItemID IN(" + string.Join(", ", availableFiles.Select(f => "'" + f + "'")) + ")", sqlConnection)).ExecuteReader();
while (reader.Read())
{
searchData = new FileManagerDirectoryContent
{
// Add the review number field in serach data.
ReviewNumber = reader["ReviewNumber"].ToString(),
Id = reader["ItemId"].ToString().Trim()
};
}
} |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.