/// <summary> /// To Get File Path /// </summary> /// <param name="papDocumentID"></param> /// <param name="ProjectCode"></param> /// <returns></returns> public UploadDocumentBO getFilePath(string papDocumentID, string ProjectCode) { UploadDocumentList UploadDocumentList = new UploadDocumentList(); string projectCode = ProjectCode; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_DOCUMENTPATH"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("ProjectID_", pID); cmd.Parameters.Add("papDocumentID_", papDocumentID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); UploadDocumentBO objUploadDocument = null; while (dr.Read()) { objUploadDocument = new UploadDocumentBO(); //PAPDOCUMENTID string DocumnetPath_ = dr.GetString(dr.GetOrdinal("DOCUMENTPATH")); string projectName = projectCode; string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + projectName + "\\" + DocumnetPath_;// +DocPath; objUploadDocument.DocumentPath = main_strPath_user; } return(objUploadDocument); }
/// <summary> /// To Get Upload Document /// </summary> /// <returns></returns> public UploadDocumentList GetUploadDocument() { proc = "USP_MST_SEL_DOC_TYPE"; cnn = new OracleConnection(con); UploadDocumentBO objUploadDocument = null; UploadDocumentList UploadDocumentList = new UploadDocumentList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objUploadDocument = new UploadDocumentBO(); if (ColumnExists(dr, "DOCUMENTTYPEID") && !dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPEID"))) { objUploadDocument.DocumentTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("DOCUMENTTYPEID"))); } if (ColumnExists(dr, "DOCUMENTTYPE") && !dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPE"))) { objUploadDocument.DocumentType = dr.GetString(dr.GetOrdinal("DOCUMENTTYPE")); } if (ColumnExists(dr, "DOCUMENTCODE") && !dr.IsDBNull(dr.GetOrdinal("DOCUMENTCODE"))) { objUploadDocument.DocumentCode = dr.GetString(dr.GetOrdinal("DOCUMENTCODE")); } UploadDocumentList.Add(objUploadDocument); } dr.Close(); } catch (Exception ex) { throw ex; } return(UploadDocumentList); }
/// <summary> /// Bind Data to Drop Downs /// </summary> public void screenIntilation() { objUploadDocumentBLL = new UploadDocumentBLL(); objUploadDocument = new UploadDocumentBO(); UploadDocumentList objUploadDocumentList = new UploadDocumentList(); objUploadDocumentList = objUploadDocumentBLL.GetUploadDocument(); ListItem lstItem = DocTypeDropDownList.Items[0]; DocTypeDropDownList.Items.Clear(); DocTypeDropDownList.DataSource = objUploadDocumentList;//dt.Tables[0]; DocTypeDropDownList.DataTextField = "DocumentType"; DocTypeDropDownList.DataValueField = "DocumentTypeID"; DocTypeDropDownList.DataBind(); DocTypeDropDownList.Items.Insert(0, lstItem); }
/// <summary> /// Bind Data to Drop downs /// </summary> public void screenIntilation() { objUploadDocumentBLL = new UploadDocumentBLL(); objUploadDocument = new UploadDocumentBO(); UploadDocumentList objUploadDocumentList = new UploadDocumentList(); objUploadDocumentList = objUploadDocumentBLL.GetUploadDocument(); DocTypeDropDownList.DataSource = objUploadDocumentList;//dt.Tables[0]; DocTypeDropDownList.DataTextField = "DocumentType"; DocTypeDropDownList.DataValueField = "DocumentTypeID"; DocTypeDropDownList.DataBind(); DocTypeDropDownList.Items.Insert(0, new ListItem("-- Select --", "0")); DocTypeDropDownList.SelectedIndex = 0; string DocumentCode = Request.QueryString["DOCUMENT_CODE"].ToString(); DocTypeDropDownList.ClearSelection(); if (DocumentCode.Length > 0) { for (int i = 0; i < objUploadDocumentList.Count; i++) { if (DocumentCode == objUploadDocumentList[i].DocumentCode) { if (DocTypeDropDownList.Items.FindByValue(objUploadDocumentList[i].DocumentTypeID.ToString()) != null) { DocTypeDropDownList.Items.FindByValue(objUploadDocumentList[i].DocumentTypeID.ToString()).Selected = true; DocTypeDropDownList.Enabled = false; } else { DocTypeDropDownList.Items[0].Selected = true; } } } } else { DocTypeDropDownList.Items[0].Selected = true; } }
/// <summary> /// To Get Search Document /// </summary> /// <param name="KeyWord"></param> /// <param name="HHID"></param> /// <param name="DocumentCode"></param> /// <param name="ProjectID"></param> /// <param name="DOCSERVICEID"></param> /// <param name="userID"></param> /// <returns></returns> public UploadDocumentList GetSearchDocument(string KeyWord, int HHID, string DocumentCode, string ProjectID, int DOCSERVICEID, int userID) { UploadDocumentList UploadDocumentList = new UploadDocumentList(); string projectCode = ""; if (DocumentCode == "All") { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_SEARCHDOC"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PROJECTID_", Convert.ToInt32(ProjectID)); cmd.Parameters.Add("HHID_", HHID); cmd.Parameters.Add("userID_", userID); cmd.Parameters.Add("KeyWord_", KeyWord); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); UploadDocumentBO objUploadDocument = null; while (dr.Read()) { objUploadDocument = new UploadDocumentBO(); //PAPDOCUMENTID if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { objUploadDocument.HHID = dr.GetInt32(dr.GetOrdinal("HHID")); } if (HHID == 0 || objUploadDocument.HHID == HHID) { string DocumentPath_ = string.Empty; string getDate = string.Empty; if (!dr.IsDBNull(dr.GetOrdinal("PAPDOCUMENTID"))) { objUploadDocument.PAPDOCUMENTID = dr.GetInt32(dr.GetOrdinal("PAPDOCUMENTID")); } if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { objUploadDocument.HHID = dr.GetInt32(dr.GetOrdinal("HHID")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPEID"))) { objUploadDocument.DocumentTypeID = dr.GetInt32(dr.GetOrdinal("DOCUMENTTYPEID")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPE"))) { objUploadDocument.DocumentType = dr.GetString(dr.GetOrdinal("DOCUMENTTYPE")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTPATH"))) { objUploadDocument.DocumentCode = dr.GetString(dr.GetOrdinal("DOCUMENTPATH")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTPATH"))) { DocumentPath_ = dr.GetString(dr.GetOrdinal("DOCUMENTPATH")); } if (!dr.IsDBNull(dr.GetOrdinal("PROJECTCODE"))) { objUploadDocument.Projectcode = dr.GetString(dr.GetOrdinal("PROJECTCODE")); } if (HHID == 0 || objUploadDocument.HHID <= 0) { string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; //Edwin: 27MAY2016 To facilitate reading from alternative location string backup_strPath_user = ConfigurationManager.AppSettings["backup_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; string offsite_strPath_user = ConfigurationManager.AppSettings["offsite_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; if (File.Exists(main_strPath_user)) { objUploadDocument.DocumentPath = main_strPath_user; } else if (File.Exists(backup_strPath_user)) { objUploadDocument.DocumentPath = backup_strPath_user; } else { objUploadDocument.DocumentPath = offsite_strPath_user; } } else { string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; //Edwin: 27MAY2016 To facilitate reading from alternative location string backup_strPath_user = ConfigurationManager.AppSettings["backup_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; string offsite_strPath_user = ConfigurationManager.AppSettings["offsite_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; if (File.Exists(main_strPath_user)) { objUploadDocument.DocumentPath = main_strPath_user; } else if (File.Exists(backup_strPath_user)) { objUploadDocument.DocumentPath = backup_strPath_user; } else { objUploadDocument.DocumentPath = offsite_strPath_user; } } if (!dr.IsDBNull(dr.GetOrdinal("USERNAME"))) { objUploadDocument.UserName = dr.GetString(dr.GetOrdinal("USERNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("UPLOADEDDATE"))) { objUploadDocument.Date = dr.GetDateTime(dr.GetOrdinal("UPLOADEDDATE")).ToString(UtilBO.DateFormat); } if (!dr.IsDBNull(dr.GetOrdinal("KEYWORD"))) { objUploadDocument.KeyWord = dr.GetString(dr.GetOrdinal("KEYWORD")); } if (!dr.IsDBNull(dr.GetOrdinal("DESCRIPTION"))) { objUploadDocument.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION")); } UploadDocumentList.Add(objUploadDocument); } } dr.Close(); } else { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SELUPDDOCSEARCH"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PROJECTID_", Convert.ToInt32(ProjectID)); cmd.Parameters.Add("KeyWord_", KeyWord); cmd.Parameters.Add("HHID_", HHID); cmd.Parameters.Add("userID_", userID); cmd.Parameters.Add("DocumentCode_", DocumentCode); cmd.Parameters.Add("DOCSERVICEID_", DOCSERVICEID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); UploadDocumentBO objUploadDocument = null; while (dr.Read()) { string DocumentPath_ = string.Empty; objUploadDocument = new UploadDocumentBO(); //PAPDOCUMENTID if (!dr.IsDBNull(dr.GetOrdinal("PAPDOCUMENTID"))) { objUploadDocument.PAPDOCUMENTID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAPDOCUMENTID"))); } if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { objUploadDocument.HHID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID"))); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPEID"))) { objUploadDocument.DocumentTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("DOCUMENTTYPEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTTYPE"))) { objUploadDocument.DocumentType = dr.GetString(dr.GetOrdinal("DOCUMENTTYPE")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTPATH"))) { objUploadDocument.DocumentCode = dr.GetString(dr.GetOrdinal("DOCUMENTPATH")); } if (!dr.IsDBNull(dr.GetOrdinal("DOCUMENTPATH"))) { DocumentPath_ = dr.GetString(dr.GetOrdinal("DOCUMENTPATH")); } if (!dr.IsDBNull(dr.GetOrdinal("PROJECTCODE"))) { objUploadDocument.Projectcode = dr.GetString(dr.GetOrdinal("PROJECTCODE")); } if (HHID == 0 || objUploadDocument.HHID <= 0) { string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; //Edwin: 27MAY2016 To facilitate reading from alternative location string backup_strPath_user = ConfigurationManager.AppSettings["backup_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; string offsite_strPath_user = ConfigurationManager.AppSettings["offsite_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + DocumentPath_; // +DocPath; if (File.Exists(main_strPath_user)) { objUploadDocument.DocumentPath = main_strPath_user; } else if (File.Exists(backup_strPath_user)) { objUploadDocument.DocumentPath = backup_strPath_user; } else { objUploadDocument.DocumentPath = offsite_strPath_user; } } else { string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; //Edwin: 27MAY2016 To facilitate reading from alternative location string backup_strPath_user = ConfigurationManager.AppSettings["backup_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; string offsite_strPath_user = ConfigurationManager.AppSettings["offsite_strPath_user"].ToString() + objUploadDocument.Projectcode.ToString() + "\\" + objUploadDocument.HHID.ToString() + "\\" + DocumentPath_; // +DocPath; if (File.Exists(main_strPath_user)) { objUploadDocument.DocumentPath = main_strPath_user; } else if (File.Exists(backup_strPath_user)) { objUploadDocument.DocumentPath = backup_strPath_user; } else { objUploadDocument.DocumentPath = offsite_strPath_user; } } if (!dr.IsDBNull(dr.GetOrdinal("USERNAME"))) { objUploadDocument.UserName = dr.GetString(dr.GetOrdinal("USERNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("UPLOADEDDATE"))) { objUploadDocument.Date = dr.GetDateTime(dr.GetOrdinal("UPLOADEDDATE")).ToString(UtilBO.DateFormat); } ; if (!dr.IsDBNull(dr.GetOrdinal("KEYWORD"))) { objUploadDocument.KeyWord = dr.GetString(dr.GetOrdinal("KEYWORD")); } if (!dr.IsDBNull(dr.GetOrdinal("DESCRIPTION"))) { objUploadDocument.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION")); } UploadDocumentList.Add(objUploadDocument); } dr.Close(); } return(UploadDocumentList); }
/// <summary> /// Bind Search Data /// </summary> private void BindGridForSearch() { int HHID; string DocumentCode = string.Empty; string KeyWord = string.Empty; if ((Request.QueryString["HHID"]) != null) { HHID = Convert.ToInt32(Request.QueryString["HHID"]); } else { HHID = 0; DocumentCode = "All"; } if ((Request.QueryString["DOCUMENT_CODE"]) != null) { DocumentCode = Request.QueryString["DOCUMENT_CODE"].ToString(); } else { DocumentCode = "All"; } string ProjectCode = Request.QueryString["ProjectCode"].ToString(); //Convert.ToInt32(Session["HHID"].ToString()); int DocserviceID = 0; if (txtDocserviceID.Text.Trim().Length > 0) { DocserviceID = Convert.ToInt32(txtDocserviceID.Text.Trim()); } if (txtSearchKeyword.Text.ToString().Trim() == string.Empty) { KeyWord = "ALL"; } else { KeyWord = txtSearchKeyword.Text.ToString().Trim(); } // = txtSearchKeyword.Text.ToString().Trim(); UploadDocumentBLL UploadDocumentBLLobj = new UploadDocumentBLL(); //grdUploadDocument.DataSource = UploadDocumentBLLobj.GetSearchDocument(KeyWord, HHID, DocumentCode, upProjectIDTextBox.Text, DocserviceID); //grdUploadDocument.DataBind(); UploadDocumentList uplist = UploadDocumentBLLobj.GetSearchDocument(KeyWord, HHID, DocumentCode, upProjectIDTextBox.Text, DocserviceID, Convert.ToInt32(Session["USER_ID"])); System.Web.HttpBrowserCapabilities browser = Request.Browser; if (browser.Type.ToUpper().Contains("IE") || true) { UploadDocumentList uplist1 = new UploadDocumentList(); foreach (UploadDocumentBO upbo in uplist) { string FilePath = upbo.DocumentPath; if (FilePath != null) { if (upbo.HHID <= 0) { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + sFileName, true); string path = ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + sFileName; upbo.DocumentPath = path; } } else { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\" + sFileName, true); string path = ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + upbo.HHID.ToString() + "/" + sFileName; upbo.DocumentPath = path; } } } uplist1.Add(upbo); } grdUploadDocument.DataSource = uplist1; grdUploadDocument.DataBind(); grdUploadDocument.Columns[grdUploadDocument.Columns.Count - 3].Visible = false; } else { grdUploadDocument.Columns[grdUploadDocument.Columns.Count - 2].Visible = false; grdUploadDocument.DataSource = uplist; grdUploadDocument.DataBind(); } }
/// <summary> /// bind grid data for search /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BindGridForSearch() { Int32 HHID = 0; if (txtHHID.Text.Trim().Length > 0) { HHID = Convert.ToInt32(txtHHID.Text); } string DocumentCode = string.Empty; string KeyWord = string.Empty; DocumentCode = "All"; if (txtSearchKeyword.Text.ToString().Trim() == string.Empty) { KeyWord = "ALL"; } else { KeyWord = txtSearchKeyword.Text.ToString().Trim(); } UploadDocumentBLL UploadDocumentBLLobj = new UploadDocumentBLL(); //grdUploadDocument.DataSource = UploadDocumentBLLobj.GetSearchDocument(KeyWord, HHID, DocumentCode, drpProjectsearch.SelectedValue, 0); //grdUploadDocument.DataBind(); UploadDocumentList uplist = UploadDocumentBLLobj.GetSearchDocument(KeyWord, HHID, DocumentCode, drpProjectsearch.SelectedValue, 0, Convert.ToInt32(Session["USER_ID"])); UploadDocumentList uplist1 = new UploadDocumentList(); foreach (UploadDocumentBO upbo in uplist) { string FilePath = upbo.DocumentPath; if (FilePath != null) { if (upbo.HHID <= 0) { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + sFileName, true); string path = "../" + ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + sFileName; upbo.DocumentPath = path; } } else { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\" + sFileName, true); string path = "../" + ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + upbo.HHID.ToString() + "/" + sFileName; upbo.DocumentPath = path; } } } uplist1.Add(upbo); } grdUploadDocument.DataSource = uplist1; grdUploadDocument.DataBind(); grdUploadDocument.AllowPaging = true; }
//if the user search the record and other information private void BindGrid() { int HHID = 0; if (Session["HH_ID"] != null) { HHID = Convert.ToInt32(Session["HH_ID"]); } else { HHID = 0; } string projectID = drpProject.SelectedValue; string DocumentCode = string.Empty; //if (drpProject.SelectedIndex > 0) //{ // if (HHIDTextBox.Text.Trim().Length > 0) // HHID = Convert.ToInt32(HHIDTextBox.Text.Trim()); //} DocumentCode = "All"; UploadDocumentBLL UploadDocumentBLLobj = new UploadDocumentBLL(); //grdUploadDocument.DataSource = UploadDocumentBLLobj.GetALLUploadDocument(HHID, DocumentCode, projectID, 0); //grdUploadDocument.DataBind(); UploadDocumentList uplist = UploadDocumentBLLobj.GetALLUploadDocument(HHID, DocumentCode, projectID, 0, Convert.ToInt32(Session["USER_ID"])); UploadDocumentList uplist1 = new UploadDocumentList(); foreach (UploadDocumentBO upbo in uplist) { string FilePath = upbo.DocumentPath; if (FilePath != null) { if (upbo.HHID <= 0) { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + sFileName, true); string path = "../" + ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + sFileName; upbo.DocumentPath = path; } } else { string sTempPath = ConfigurationManager.AppSettings["TempDirectory"].ToString(); if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\"); } if (!Directory.Exists(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\")) { System.IO.Directory.CreateDirectory(sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\"); } string sFileName = Path.GetFileName(FilePath); if (File.Exists(FilePath)) { File.Copy(FilePath, sTempPath + upbo.Projectcode + @"\" + upbo.HHID.ToString() + @"\" + sFileName, true); string path = "../" + ConfigurationManager.AppSettings["TempFolder"].ToString() + upbo.Projectcode + "/" + upbo.HHID.ToString() + "/" + sFileName; upbo.DocumentPath = path; } } } uplist1.Add(upbo); } grdUploadDocument.DataSource = uplist1; grdUploadDocument.DataBind(); grdUploadDocument.AllowPaging = true; }