/// <summary>
/// Filter data
/// </summary>
/// <param name="drDataRows">Fetch details from </param>
/// <param name="UserID">Login user ID</param>
/// <returns>retrun again filter data</returns>
private DataTable getResultTable(DataRow[] drDataRows, int UserID)
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("FileID", typeof(string)));
dt.Columns.Add(new DataColumn("Filename", typeof(string)));
dt.Columns.Add(new DataColumn("File Size", typeof(int)));
dt.Columns.Add(new DataColumn("Read Date", typeof(string)));
dt.Columns.Add(new DataColumn("FilePath", typeof(string)));
dt.Columns.Add(new DataColumn("Write", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Version", typeof(string)));
DataRow dr;
BLL_FMS_Document objFMS = new BLL_FMS_Document();
foreach (DataRow dtR in drDataRows)
{
DataTable dt_FileDtl = objFMS.getFileIDByFullPath("uploads/fmsl/" + dtR["Filename"].ToString());
if (dt_FileDtl.Rows.Count > 0)
{
int fileID = Convert.ToInt32(dt_FileDtl.Rows[0]["FileID"].ToString());
int Access = objFMS.Get_UserAccess_OnFile(fileID, UserID);
if (Access > 0)
{
string LastVersion = "1";
DataTable dtVersionInfo = objFMS.getFileVersion(fileID).Tables[1];
if (dtVersionInfo.Rows.Count > 0)
{
LastVersion = dtVersionInfo.Rows[0][0].ToString();
}
for (int i = 0; i < int.Parse(LastVersion); i++)
{
if (dtR["Path"].ToString().IndexOf(fileID.ToString() + "\\" + i.ToString() + "\\" + dtR["Filename"].ToString()) > 0)
{
LastVersion = i.ToString();
}
}
dr = dt.NewRow();
dr["FileID"] = fileID.ToString();
//dr["Filename"] = dtR["Filename"].ToString();
dr["Filename"] = dt_FileDtl.Rows[0]["LogFileID"].ToString();
dr["File Size"] = Convert.ToInt32(dtR["size"].ToString()) / (1024);
dr["Read Date"] = ((DateTime)dtR["write"]).ToString("dd/MM/yyyy");
dr["FilePath"] = "../fmsl/" + Path.GetFileName(dtR["Path"].ToString());// FormatFilePath(dtR["Path"].ToString());
dr["Write"] = dtR["write"];
dr["Version"] = LastVersion;
dt.Rows.Add(dr);
}
}
}
return(dt);
}