We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
|
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()
};
}
} |
