public OperationResult DeleteFaxEntry(int sendToFaxID)
{
OperationResult operationResult = new OperationResult();
using (IDbConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
{
try
{
const string query = "delete from FaxSendingInformation "
+ " where SendFaxID = @SendFaxID";
int rowsAffectd = db.Execute(query, new
{
@SendFaxID = sendToFaxID.ToString()
});
operationResult.Success = true;
return operationResult;
}
catch (Exception er)
{
operationResult.Success = true;
operationResult.AddMessage(er.ToString());
return operationResult;
}
}
}
public OperationResult CreateFaxSendTo(string firstName, string lastName, string faxNumber)
{
OperationResult operationResult = new OperationResult();
try
{
faxNumber = faxNumber.Replace("(", "")
.Replace(")", "")
.Replace(" ", "")
.Replace("-", "");
string query = "INSERT INTO [FaxSendingInformation]("
+ "[AccountID],[FirstName],[LastName],[Name],[FaxNumber]"
+ ")VALUES("
+ "@AccountID,@FirstName,@LastName,@Name,@FaxNumber)";
using (SqlConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
{
int rowsAffectd = db.Execute(query, new
{
@AccountID = "1001",
@FirstName = firstName,
@LastName = lastName,
@Name = firstName + " " + lastName,
@FaxNumber = faxNumber
}
);
}
operationResult.Success = true;
return operationResult;
}
catch (Exception er)
{
operationResult.Success = false;
operationResult.AddMessage(er.Message);
return operationResult;
}
}
public OperationResult ArchiveScannedDocument(ReviewScannedDocuments reviewScannedDocuments, string archived, string errorMessage)
{
OperationResult operationResult = new OperationResult();
string dateTime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
using (IDbConnection db = new SqlConnection(ConfigurationValues.DeskTopConnection))
{
try
{
const string query = "INSERT INTO [ScannedDocumentsArchive]"
+ " ([UserName],[CopierDataLocation],[PageCount],[Archive],[SubmittedDate],[CreationDate],[ViewDocumentLocation],[ErrorMessage],[SubmittedToGreenway])"
+ " VALUES("
+ "@UserName,@CopierDataLocation,@PageCount,@Archive,@SubmittedDate,@CreationDate,@ViewDocumentLocation,@ErrorMessage,@SubmittedToGreenway);"
+ " SELECT CAST(SCOPE_IDENTITY() as int)";
var newIDCreated = db.Query<int>(query, new
{
@UserName = Utility.GetUserName(),
@CopierDataLocation = reviewScannedDocuments.CopierLocation,
@PageCount = reviewScannedDocuments.PageCount,
@Archive = archived,
@SubmittedDate = dateTime,
@CreationDate = reviewScannedDocuments.CreationDate,
@ViewDocumentLocation = ConfigurationValues.ViewErrorDocumentPath + reviewScannedDocuments.DocumentName,
@ErrorMessage = errorMessage,
@SubmittedToGreenway = "F"
});
operationResult.AddMessage(newIDCreated.ElementAt(0).ToString());
return operationResult;
}
catch (Exception er)
{
EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
operationResult.AddMessage("0");
operationResult.Success = false;
operationResult.ErrorMessage = er.ToString();
return operationResult;
}
}
//try
//{
// using (IDbConnection db = new SqlConnection(ConfigurationValues.DeskTopConnection))
// {
// const string query = "SELECT max(ID) from ScannedDocumentsArchive";
// operationResult.AddMessage(db.Query<int>(query).Single().ToString());
// }
//}
//catch (Exception er)
//{
// EmployeeDesktop.API.Exceptions.ExceptionHandling.InsertErrorMessage(er.ToString());
// EmployeeDesktop.API.Exceptions.ExceptionHandling.SendErrorEmail(er.ToString(), ConfigurationValues.EmailFromFriendly, ConfigurationValues.EmailSendToFriendly, ConfigurationValues.EmailSubject);
// operationResult.AddMessage("0");
//}
//return operationResult;
}
public OperationResult SendTheFax(string faxName, string faxPath, string recipientName,
string faxNumber,string sendID,string applicationPath)
{
OperationResult operationResult = new OperationResult();
FileStream fileStream;
StreamReader reader = null; ;
Stream data = null;
WebResponse response = null;
StreamWriter streamWriter = null;
faxName = faxName.Replace("&", "");
recipientName = recipientName.Replace("&", "");
try
{
fileName = applicationPath + "\\schedule.xml";
fileStream = File.Create(fileName);
fileStream.Close();
streamWriter = File.AppendText(fileName);
streamWriter.WriteLine("<?xml version=”1.0” encoding=”UTF-8”?>");
streamWriter.WriteLine("<schedule_fax>");
streamWriter.WriteLine("<cover_page>");
streamWriter.WriteLine("<enabled>false</enabled>");
streamWriter.WriteLine("</cover_page>");
streamWriter.WriteLine("<sender>");
streamWriter.WriteLine("<name>" + faxName + "</name>");
streamWriter.WriteLine("<email_address>" + sendID + "</email_address>");
streamWriter.WriteLine("</sender>");
streamWriter.WriteLine("<recipient>");
streamWriter.WriteLine("<name>" + recipientName + "</name>");
streamWriter.WriteLine("<fax_number>" + faxNumber + "</fax_number>");
streamWriter.WriteLine("</recipient>");
streamWriter.WriteLine("<attachment>");
streamWriter.WriteLine("<location>inline</location>");
streamWriter.WriteLine("<name>test.pdf</name>");
streamWriter.WriteLine("<receipt_attachment>never</receipt_attachment>");
streamWriter.WriteLine("<content_type>application/pdf</content_type>");
streamWriter.WriteLine("<content_transfer_encoding>base64</content_transfer_encoding>");
streamWriter.WriteLine("<content>");
streamWriter.WriteLine(EncodePDFDocument(faxPath));
streamWriter.WriteLine("</content>");
streamWriter.WriteLine("</attachment>");
streamWriter.WriteLine("<max_tries>3</max_tries>");
streamWriter.WriteLine("<priority>1</priority>");
streamWriter.WriteLine("<try_interval>600</try_interval>");
streamWriter.WriteLine("<receipt>never</receipt>");
streamWriter.WriteLine("<receipt_attachment>none</receipt_attachment>");
streamWriter.WriteLine("</schedule_fax>");
streamWriter.Close();
ServicePointManager.Expect100Continue = false;
//Create a request using a URL that can receive a post.
//WebRequest request = WebRequest.Create("http://216.133.69.247/ffws/v1/ofax");
WebRequest request = WebRequest.Create("http://192.168.105.92/ffws/v1/ofax");
string authInfo = "admin:admin";
//string authInfo = userName + ":" + userPassword;
authInfo = Convert.ToBase64String(Encoding.Default.GetBytes(authInfo));
request.Headers["Authorization"] = "Basic " + authInfo;
//Add authentication to request
//request.Credentials = new NetworkCredential("admin", "admin");
//Set the Method property of the request to POST.
request.Method = "POST";
//Set the ContentType property of the WebRequest.
request.ContentType = "application/xml";
//Get File size
//FileInfo fileSize = new FileInfo("C:/Users/test/Documents/Visual Studio 2008/Projects/sendFax/sendFax/schedule.xml");
FileInfo fileSize = new FileInfo(fileName);
int len = (int)fileSize.Length;
//Set the ContentLength property of the WebRequest.
request.ContentLength = len;
//Get the request stream.
Stream dataStream = request.GetRequestStream();
StreamReader textIn = new StreamReader(new FileStream(fileName,
FileMode.Open, FileAccess.Read));
string TextLines = textIn.ReadToEnd();
byte[] byteArray = Encoding.UTF8.GetBytes(TextLines);
//Write the data to the request stream.
dataStream.Write(byteArray, 0, byteArray.Length);
textIn.Close();
//Close the Stream object.
dataStream.Close();
//Get the response.
response = request.GetResponse();
//Display the status.
Console.WriteLine(((HttpWebResponse)response).StatusDescription);
//Get the stream containing content returned by the server.
data = response.GetResponseStream();
//Open the stream using a StreamReader for easy access.
reader = new StreamReader(data);
//Read the content.
string responseFromServer = reader.ReadToEnd();
//Display the content.
Console.WriteLine(responseFromServer);
//Clean up the streams.
reader.Close();
data.Close();
response.Close();
operationResult.Success = true;
return operationResult;
}
catch(Exception er)
{
try
{
//Clean up the streams.
reader.Close();
}
catch { }
try
{
data.Close();
}
catch { }
try
{
response.Close();
}
catch { }
try
{
streamWriter.Close();
}
catch { }
operationResult.Success = false;
operationResult.AddMessage(er.ToString());
return operationResult;
}
}
public OperationResult AddFaxAddressbookEntry(FaxToInformation faxToInformation)
{
OperationResult operationResult = new OperationResult();
try
{
string query = "INSERT INTO [FaxSendingInformation]("
+ "[AccountID],[FirstName],[LastName],[Name],[FaxNumber],[Prefix],[Suffix]"
+ ")VALUES("
+ "@AccountID,@FirstName,@LastName,@Name,@FaxNumber,@Prefix,@Suffix)";
using (SqlConnection db = new SqlConnection(ConfigurationValues.WaldenFaxConnection))
{
int rowsAffectd = db.Execute(query, new
{
@AccountID = "1001",
@FirstName = faxToInformation.FirstName,
@LastName = faxToInformation.LastName,
@Name = faxToInformation.Name,
@FaxNumber = faxToInformation.FaxNumber,
@Prefix = faxToInformation.Prefix,
@Suffix = faxToInformation.Suffix
}
);
}
operationResult.Success = true;
return operationResult;
}
catch (Exception er)
{
operationResult.Success = false;
operationResult.AddMessage(er.Message);
return operationResult;
}
}