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