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