public static void SendOutGoingFaxesV2()
{
string returnString = string.Empty;
try
{
using (SqlConnection cn = new SqlConnection(Database.WaldenConnect))
{
cn.Open();
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandText = "SELECT FaxName,FaxPath,"
+ " RecipientName,FaxNumber,SendID,FaxPath"
+ " from FaxesSendServer"
+ " where AccountID = " + Common.AccountID
+ " and FaxSent = 'N'"
+ " and sendid = 58263"
+ "order by faxsent,createtime desc";
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
sendMultiTechFax = new SendFaxMultitech();
returnString = string.Empty;
returnString = sendMultiTechFax.SendTheFax(dr.GetString(0), dr.GetString(1),
dr.GetString(2), dr.GetString(3),
dr.GetInt32(4).ToString(), applicationPath);
if (returnString == "OK")
{
//Debug.WriteLine("update FaxesSend "
// + " set FaxSent = 'Y'"
// + " where SendID = "
// + dr.GetInt32(4).ToString());
ExecuteInsertUpdateDelete(
"update FaxesSendServer "
+ " set FaxSent = 'Y'"
+ " where SendID = "
+ dr.GetInt32(4).ToString());
}
else
{
Logging.Log(returnString);
}
}
}
}
}
catch (Exception er)
{
try
{
//Debug.WriteLine(er.Message);
Common.Log(er.Message);
}
catch (Exception mer)
{
Common.Log(mer.Message);
}
}
}
