private void UploadFileProc()
{
try
{
string strFilePath = GetFilePath(uploadDocFile.PostedFile.FileName, Convert.ToByte(txtHFileType.Value));
if (System.IO.File.Exists(strFilePath))
{
System.IO.File.Delete(strFilePath);
}
strDocumentName = uploadDocFile.PostedFile.FileName;
uploadDocFile.PostedFile.SaveAs(strFilePath);
if (IsMovieFile(System.IO.Path.GetExtension(uploadDocFile.PostedFile.FileName))) // the type of document is VIDEO
{
Convert2FLVfile(strFilePath);
}
else
{
GetFileSize(strFilePath);
GetFileBinaryData(strFilePath);
strDocumentName = System.IO.Path.GetFileNameWithoutExtension(uploadDocFile.PostedFile.FileName);
strDocumentName += System.IO.Path.GetExtension(uploadDocFile.PostedFile.FileName);
}
SaveVisitDocumentData(strDocumentName, Convert.ToByte(txtHFileType.Value), txtDocLabel.Text.Trim(), txtDescription.Text.Trim());
gClass.AddDocumentEventLog(intOrganizationCode.ToString(), Convert.ToInt32(txtHDocumentID.Value), 1, intUserPracticeCode, Request.Url.Host, "Upload file");
listEventName.SelectedIndex = 0; // Set the eventname to baseline after saving
txtHUploadResult.Value = "1";
}
catch (Exception err)
{
txtTest.Value += err.ToString();
gClass.AddErrorLogData(Request.Cookies["UserPracticeCode"].Value, Request.Url.Host, Request.Cookies["Logon_UserName"].Value, "Upload Document Form", "Upload document", err.ToString());
txtHUploadResult.Value = "2";
}
Response.Clear();
return;
}
private void AddDocumentEventLog(int intDocumentID, byte intEventCode)
{
gClass.AddDocumentEventLog(gClass.OrganizationCode, intDocumentID, intEventCode, Convert.ToInt32(Request.Cookies["UserPracticeCode"].Value), Request.Url.Host, "");
}
protected void ExportFromSqlServerToMDB(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection cnnDest = new System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand cmdDest;
Char[] delimiter = { '\\' };
String[] SrcFileArr;
String strSql = "";
String SrcFileID = "";
String SrcFileName = "";
String SrcDocumentName = "";
String SrcUploadDate = "";
String SrcPatientID = "";
String SrcEventID = "0"; //0 for baseline, consultid for visit
String SrcEventLink = "B"; //V, B or O
String SrcFullFilePath = "";
String SrcFolderPath = "";
String DestFileName = "";
strLapdataPath = "";
strLapdataPath = txtFolder.Text;
String strDocID = "";
//notes
int fileNum = 0;
int fileSuccessNum = 0;
int fileFailNum = 0;
String fileFail = "";
String baselineNotes = "";
txtErrNotes.InnerHtml = "";
//need to escape "
String strMDBPath = strLapdataPath + "\\Lapdata.mdb";
//String strMDBPath = "C:\\Lapdata\\Lapdata.mdb;";
try
{
if (strLapdataPath == "")
{
txtErrNotes.InnerHtml = "Warning: Please enter the Lapdata folder path";
}
cnnDest.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMDBPath;
cnnDest.Open();
cmdDest = cnnDest.CreateCommand();
cmdDest.CommandType = CommandType.Text;
strSql = "Select * from tblDocuments where LinkName is not null and LinkName <> ''";
cmdDest.CommandText = strSql;
OleDbDataReader drSource = cmdDest.ExecuteReader(CommandBehavior.Default);
while (drSource.Read())
{
FileSize = 0;
strDocumentName = "";
SrcFileType = 0;
//for every data on tblDocuments in mdb file, upload file
SrcFileID = drSource["LinikId"].ToString();
SrcFullFilePath = drSource["LinkName"].ToString();
SrcDocumentName = drSource["Description"].ToString();
SrcUploadDate = drSource["Date"].ToString();
SrcPatientID = drSource["PatientId"].ToString();
SrcEventID = "0";
SrcEventLink = "B";
//remove # at the end of filename
if (SrcFullFilePath.Substring((SrcFullFilePath.Length) - 1) == "#")
{
SrcFullFilePath = SrcFullFilePath.Replace("#", "");
}
//split file path
SrcFileArr = SrcFullFilePath.Split(delimiter);
//get filename and folder path
SrcFileName = SrcFileArr[(SrcFileArr.Length) - 1];
SrcFolderPath = SrcFileArr[(SrcFileArr.Length) - 2];
//call function to copy file
DestFileName = copyFile(SrcFileName, SrcFolderPath);
//save to db
strDocID = SaveVisitDocumentData(SrcPatientID, SrcEventID, SrcUploadDate, SrcEventLink, SrcUploadDate, SrcFileType, DestFileName, SrcDocumentName);
if (strDocID != "")
{
gClass.AddDocumentEventLog(gClass.OrganizationCode, Convert.ToInt32(strDocID), 1, Convert.ToInt64(Request.Cookies["UserPracticeCode"].Value), Request.Url.Host, "Upload file");
}
//to be diplayed on notes
fileNum++;
if (strDocID != "")
{
fileSuccessNum++;
}
else
{
fileFailNum++;
fileFail += SrcFileID + " - ";
}
}
baselineNotes = "Finish Uploading baseline file\n";
baselineNotes += "-------------------------------------\n";
baselineNotes += "Total file: " + fileNum + "\n";
baselineNotes += "Success: " + fileSuccessNum + "\n";
baselineNotes += "Failed: " + fileFailNum + "\n";
baselineNotes += "Failed File (Link ID): " + fileFail + "\n\n\n";
//update notes
txtNotes.Value = txtNotes.Value + baselineNotes;
}
catch (Exception err)
{
ExportFlag = false;
gClass.AddErrorLogData(Request.Cookies["UserPracticeCode"].Value, Request.Url.Host,
Request.Cookies["Logon_UserName"].Value, "Import/Export data Form", "ExportFromSqlServerToMDB function",
strSql + " ... " + err.ToString());
}
finally { cnnDest.Close(); cnnDest.Dispose(); }
return;
}