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