コード例 #1
0
        /// <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);
        }
コード例 #2
0
        /// <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);
        }
コード例 #3
0
        /// <summary>
        /// To Insert Upload Document
        /// </summary>
        /// <param name="objUploadDocument"></param>
        /// <returns></returns>
        public string InsertUploadDocument(UploadDocumentBO objUploadDocument)
        {
            UploadDocumentDAL UploadDocumentDAL = new UploadDocumentDAL(); //Data pass -to Database Layer

            try
            {
                return(UploadDocumentDAL.InsertUploadDocument(objUploadDocument));
            }
            catch
            {
                throw;
            }
            finally
            {
                UploadDocumentDAL = null;
            }
        }
コード例 #4
0
ファイル: UploadDocument.aspx.cs プロジェクト: abigabaw/wis
        /// <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);
        }
コード例 #5
0
ファイル: UploadDocPop.aspx.cs プロジェクト: abigabaw/wis
        /// <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;
            }
        }
コード例 #6
0
ファイル: ViewUploadDoc.aspx.cs プロジェクト: abigabaw/wis
        protected void Page_Load(object sender, EventArgs e)
        {
            string            papDocumentID        = (Request.QueryString["papDocumentID"]);
            string            ProjectCode          = (Request.QueryString["ProjectCode"]);
            UploadDocumentBLL UploadDocumentBLLobj = new UploadDocumentBLL();
            UploadDocumentBO  UploadDocumentBOObj  = new UploadDocumentBO();
            string            sTempPath            = ConfigurationManager.AppSettings["TempDirectory"].ToString();

            UploadDocumentBOObj = UploadDocumentBLLobj.getFilePath(papDocumentID, ProjectCode);
            if (File.Exists(UploadDocumentBOObj.DocumentPath))
            {
                string sFileName = Path.GetFileName(UploadDocumentBOObj.DocumentPath);
                File.Copy(UploadDocumentBOObj.DocumentPath, sTempPath + sFileName, true);
                this.spncontent.Style.Add("display", "");
                this.contentPanel1.Attributes["src"] = ConfigurationManager.AppSettings["TempFolder"].ToString() + sFileName;
                lblMessage.Visible = false;
            }
            else
            {
                this.spncontent.Style.Add("display", "none");
                lblMessage.Visible = true;
            }
        }
コード例 #7
0
        /// <summary>
        /// To Insert Upload Document
        /// </summary>
        /// <param name="objUploadDocument"></param>
        /// <returns></returns>
        public string InsertUploadDocument(UploadDocumentBO objUploadDocument)
        {
            string           returnResult;
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);

            cnn.Open();
            OracleCommand dcmd = new OracleCommand("USP_TRN_PAP_DOCUMENT_TYPE", cnn);

            dcmd.CommandType = CommandType.StoredProcedure;
            int count = Convert.ToInt32(dcmd.CommandType);

            try
            {
                dcmd.Parameters.Add("HHID_", objUploadDocument.HHID);
                dcmd.Parameters.Add("DocumentType_", objUploadDocument.DocumentTypeID);
                dcmd.Parameters.Add("DocumentPath_", objUploadDocument.DocumentPath);
                dcmd.Parameters.Add("UserID_", objUploadDocument.UserID);
                if (objUploadDocument.DOCSERVICEID > -1) // add By Reddy
                {
                    dcmd.Parameters.Add("DOCSERVICEIDIN", objUploadDocument.DOCSERVICEID);
                }
                else
                {
                    dcmd.Parameters.Add("DOCSERVICEIDIN", 0);
                }
                if (objUploadDocument.KeyWord != null)
                {
                    dcmd.Parameters.Add("KeyWord_", objUploadDocument.KeyWord);
                }
                else
                {
                    dcmd.Parameters.Add("KeyWord_", Oracle.DataAccess.Types.OracleString.Null);
                }
                if (objUploadDocument.Description != null)
                {
                    dcmd.Parameters.Add("Description_", objUploadDocument.Description);
                }
                else
                {
                    dcmd.Parameters.Add("Description_", Oracle.DataAccess.Types.OracleString.Null);
                }
                if (objUploadDocument.ProjectID > 0)
                {
                    dcmd.Parameters.Add("PROJECTID_", objUploadDocument.ProjectID);
                }

                dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;

                dcmd.ExecuteNonQuery();

                if (dcmd.Parameters["errorMessage_"].Value != null)
                {
                    returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
                }
                else
                {
                    returnResult = string.Empty;
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                dcmd.Dispose();
                cnn.Close();
                cnn.Dispose();
            }
            return(returnResult);
        }
コード例 #8
0
        /// <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);
        }
コード例 #9
0
ファイル: UploadDocPop.aspx.cs プロジェクト: abigabaw/wis
        // Writes file to current folder
        private void WriteToFile(string strNewFileName, ref byte[] Buffer)
        {
            //Decleraton local Varabiles
            string message      = string.Empty;
            string AlertMessage = string.Empty;

            //created object to BO layer and BLL layer
            objUploadDocument    = new UploadDocumentBO();
            objUploadDocumentBLL = new UploadDocumentBLL();

            //get the value using seesion and UI Screen
            string uID = userIDTextBox.Text;
            // userIDTextBox.Text
            //Session["USER_ID"].ToString();
            string pID = upProjectIDTextBox.Text;
            //upProjectIDTextBox.Text;
            int HHID = Convert.ToInt32(upHHIDTextBox.Text);
            //upHHIDTextBox.Text

            // Store it in database
            HttpPostedFile myFile                 = fileMyFile.PostedFile; // to get user selected file
            string         strFilename            = Path.GetFileName(myFile.FileName);
            string         ServerProposalFilePath = strNewFileName;        // Store it in database file Name
            string         filepath               = System.IO.Path.GetFullPath(fileMyFile.PostedFile.FileName);

            //create Object for save Data
            objUploadDocument.HHID      = HHID;
            objUploadDocument.ProjectID = Convert.ToInt32(upProjectIDTextBox.Text);
            if (txtDocserviceID.Text.Trim().Length > 0)
            {
                objUploadDocument.DOCSERVICEID = Convert.ToInt32(txtDocserviceID.Text.Trim());
            }
            else
            {
                objUploadDocument.DOCSERVICEID = 0;
            }
            objUploadDocument.KeyWord        = txtKeyword.Text.ToString().Trim();
            objUploadDocument.Description    = txtDescription.Text.ToString().Trim();
            objUploadDocument.DocumentTypeID = Convert.ToInt32(DocTypeDropDownList.SelectedItem.Value.ToString());
            objUploadDocument.DocumentPath   = ServerProposalFilePath;
            objUploadDocument.UserID         = Convert.ToInt32(uID);

            message      = objUploadDocumentBLL.InsertUploadDocument(objUploadDocument);
            AlertMessage = "alert('" + message + "');";
            if (string.IsNullOrEmpty(message) || message == "" || message == "null")
            {
                message = "Document uploaded successfully";

                //Copy the file to file server path
                //pID
                //ProjectCodeTextBox.Text
                string projectName = ProjectCodeTextBox.Text;
                string activeDir   = ConfigurationManager.AppSettings["activeDir"].ToString(); //Path is defined in webapp
                string newPath     = System.IO.Path.Combine(activeDir, projectName);
                if (!Directory.Exists(newPath))
                {
                    System.IO.Directory.CreateDirectory(newPath);
                }
                string newFileName = System.IO.Path.GetRandomFileName();
                newPath = System.IO.Path.Combine(newPath, newFileName);

                //string strPath_user = ConfigurationManager.AppSettings["strPath_user"].ToString() + projectName + "\\" + strFilename;
                //string cpy_strPath_user = ConfigurationManager.AppSettings["cpy_strPath_user"].ToString() + projectName + "\\";
                //File.Copy(strPath_user, cpy_strPath_user + strNewFileName, true);

                // To save file in destination path
                if (HHID == 0)
                {
                    string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + projectName + "\\";
                    fileMyFile.SaveAs(main_strPath_user + strNewFileName);
                }
                else
                {
                    string main_strPath_user = ConfigurationManager.AppSettings["main_strPath_user"].ToString() + projectName + "\\" + HHID.ToString() + "\\";
                    newPath = System.IO.Path.Combine(activeDir, projectName);
                    string HHIDpath = System.IO.Path.Combine(newPath, HHID.ToString());
                    if (!Directory.Exists(HHIDpath))
                    {
                        System.IO.Directory.CreateDirectory(HHIDpath);
                    }
                    fileMyFile.SaveAs(main_strPath_user + strNewFileName);
                }
                // end
                BindGrid(false, false);
                txtKeyword.Text     = string.Empty;
                txtDescription.Text = string.Empty;
            }

            AlertMessage = "alert('" + message + "');";
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
        }