public int UpdatePatientDocument(Int64 CategoryID, paraPatientDocument para) { int returnValue = 0; OracleDataAccess.OracleCommandData _data = new OracleDataAccess.OracleCommandData(); try { _data._CommandType = CommandType.Text; // _data.CommandText = "UPDATE PATIENT_DOCUMENT SET NAME='" + para.Name + "',TITLE='" + para.Title + "',DESCRIPTION='" + para.Description + "',DOC_CATEGORY_ID=" + para.CategoryID + ",ELECTRONIC_LINK='" + para.ElectronicLink + "',PATIENT_ID='" + para.PatientID + "' WHERE PATIENT_DOCUMENT_ID=" + para.PatientDocumentID + " AND DOC_CATEGORY_ID=" + CategoryID + " "; _data.CommandText = "UPDATE PATIENT_DOCUMENT SET NAME='" + para.Name + "',TITLE='" + para.Title + "',DESCRIPTION='" + para.Description + "',DOC_CATEGORY_ID=" + para.CategoryID + ",ELECTRONIC_LINK='" + para.ElectronicLink + "',PATIENT_ID='" + para.PatientID + "' WHERE PATIENT_DOCUMENT_ID=" + para.PatientDocumentID + ""; // _data.CommandText = " "; _data.OpenWithOutTrans(); //Executing Query object obj = _data.Execute(OracleDataAccess.ExecutionType.ExecuteNonQuery); returnValue = Convert.ToInt16(obj); //if (returnValue > 0) //{ // string FileType = para.Path.ToString(); // int posn = FileType.IndexOf("."); // if (posn > 0) // FileType = FileType.Substring(posn + 1, FileType.Length - posn - 1); // else // FileType = ""; // string FileName = para.Title.Trim() + "." + FileType; // FileHelper.CheckOrCreateDirectory("C:\\inetpub\\wwwroot\\Upload"); // // FileHelper.BytesToDisk(para.attachement, "C:\\inetpub\\wwwroot\\Upload" + "\\" + FileName); // FileHelper.BytesToDisk(para.attachement, para.Path.ToString()); //} } catch (Exception ex) { //data.Error = ex.Message.ToString(); //throw; } finally { _data.Close(); } return(returnValue); }
public int AddPatientDocument(Int64 CategoryID, paraPatientDocument para) { int returnValue = 0; OracleDataAccess.OracleCommandData _data = new OracleDataAccess.OracleCommandData(); try { _data._CommandType = CommandType.Text; _data.CommandText = "INSERT INTO PATIENT_DOCUMENT (PATIENT_DOCUMENT_ID,NAME,TITLE,DESCRIPTION,DOC_CATEGORY_ID,ELECTRONIC_LINK,EXTENSION,PATH,PATIENT_ID)" + " values(PATIENT_DOCUMENT_SEQ.NEXTVAL,'" + para.Name + "','" + para.Title + "','" + para.Description + "'," + para.CategoryID + ",'" + para.ElectronicLink + "','" + para.Extension + "','" + para.Path + "','" + para.PatientID + "')"; _data.OpenWithOutTrans(); //Executing Query object obj = _data.Execute(OracleDataAccess.ExecutionType.ExecuteNonQuery); returnValue = Convert.ToInt16(obj); if (returnValue > 0) { string FileType = para.Path.ToString(); int posn = FileType.IndexOf("."); if (posn > 0) { FileType = FileType.Substring(posn + 1, FileType.Length - posn - 1); } else { FileType = ""; } string FileName = para.Title.Trim() + "." + FileType; FileHelper.CheckOrCreateDirectory("C:\\inetpub\\wwwroot\\Upload\\PHICDocument"); //FileHelper.BytesToDisk(para.attachement, "C:\\inetpub\\wwwroot\\Upload" + "\\" + FileName); FileHelper.BytesToDisk(para.attachement, para.Path.ToString()); } } catch (Exception ex) { //data.Error = ex.Message.ToString(); //throw; } finally { _data.Close(); } return(returnValue); }
public paraPatientDocument GetPatientDocumentByPatientDocumentID(Int64 PatientDocumentID) { paraPatientDocument data = new paraPatientDocument(); OracleDataAccess.OracleCommandData _data = new OracleDataAccess.OracleCommandData(); try { _data._CommandType = CommandType.Text; _data.CommandText = "SELECT * FROM PATIENT_DOCUMENT where Patient_Document_ID=" + PatientDocumentID + "";// trim(DOC_CATEGORY_ID)=" + CategoryID + " AND trim(Patient_ID)='" + PatientID + "'"; _data.OpenWithOutTrans(); //Executing Query DataSet _ds = _data.Execute(OracleDataAccess.ExecutionType.ExecuteDataSet) as DataSet; if (_ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in _ds.Tables[0].Rows) { data.Name = Path.GetFileName(item["Path"].ToString()); string _path = Server.MapPath("/Upload/PHICDocument/" + data.Name); byte[] fileBytes = System.IO.File.ReadAllBytes(_path); data.attachement = fileBytes; // return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, FileName); } } // data.dt = _ds.Tables[0]; // data.isValid = true; //string sQuery = "SELECT * FROM PatientTable "; // data.dt= new DBAction().ExecuteDataSetInline(sQuery).Tables[0]; } catch (Exception ex) { // data.Error = ex.Message.ToString(); //throw; } finally { _data.Close(); } return(data); }