/// <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); }