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