BoldDesk®Customer service software with ticketing, live chat & omnichannel support, starting at $99/mo for unlimited agents. Try for free!
|
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()
};
}
} |
