public static void SendMessage(TMSG _msg, ConnectorOnEventDelegate _onstart = null, ConnectorOnEventDelegate _onresponse = null, ConnectorOnEventDelegate _onerror = null)
{
if (_onstart != null)
_onstart(_msg);
SmtpClient smtp = new SmtpClient(Config.EMAILAuth.URL);
if (Config.EMAILAuth.Login != "")
smtp.Credentials = new System.Net.NetworkCredential(Config.EMAILAuth.Login, Config.EMAILAuth.Password);
else
smtp.UseDefaultCredentials = true;
_msg.ExternalID = _msg.ID;
try
{
MailMessage msg = new MailMessage();
msg.From = new MailAddress("ППФ Страхование Жизни <*****@*****.**>");
msg.IsBodyHtml = true;
msg.HeadersEncoding = Encoding.UTF8;
msg.BodyEncoding = Encoding.UTF8;
msg.To.Add(_msg.Address);
msg.Subject = _msg.TopicString;
msg.Body = _msg.Text;
smtp.Send(msg);
}
catch (Exception _ex)
{
TLogger.Add("Отправка сообщения EMail. Не удалось отправить сообщение EMail! EXCEPTION: " + _ex.Message, TLogger.MSGType.eEmail);
_msg.ExternalID = -1;
}
if (_onresponse != null) _onresponse(_msg);
}
public static void SendMessage(TMSG _msg, ConnectorOnEventDelegate _onstart = null, ConnectorOnEventDelegate _onresponse = null, ConnectorOnEventDelegate _onerror = null)
{
if (_onstart != null)
_onstart(_msg);
_msg.ExternalID = _msg.ID;
if (_onresponse != null)
_onresponse(_msg);
}
public static int InsertMSG(TMSG _msg)
{
SqlCommand sqlcmd = new SqlCommand("INSERT INTO MSGBody VALUES (0,'" + _msg.Address + "','" + _msg.Text + "',2,NULL,NULL,NULL,NULL," + (int)_msg.Channel + ",NULL); SELECT @@IDENTITY;");
int retval = -1;
try
{
retval = TMSSQLConnector.ExecuteSQLCommand(sqlcmd);
}
catch (Exception _ex)
{
TLogger.Add("Невозможно исполнить InsertMSG! EXCEPTION: " + _ex.Message, TLogger.MSGType.eEmail);
}
return retval;
}
public static void SendMessage(TMSG _msg, ConnectorOnEventDelegate _onstart = null, ConnectorOnEventDelegate _onresponse = null, ConnectorOnEventDelegate _onerror = null)
{
if (_onstart != null)
_onstart(_msg);
string retval = "";
try
{
string msg = "BitrixLogin="******"&BitrixPassMD5=" + Config.CABAuth.Password + "&ID=" + _msg.Address + "&TEXT=" + _msg.Text;
//UTF8Encoding encoding = new UTF8Encoding();
//byte[] postBytes = encoding.GetBytes(msg);
retval = THTTP.Post(Config.CABAuth.URL, msg, _onresponse, _onerror);
}
catch
{
_msg.ExternalID = -1;
}
if (retval == "created")
_msg.ExternalID = _msg.ID;
else
_msg.ExternalID = -1;
if (_onresponse != null)
_onresponse(_msg);
}
/// <summary>
/// Получить сообщения для отправки
/// </summary>
/// <returns>Массив сообщений для отправки</returns>
public static List<TMSG> GetMessages()
{
List<TMSG> retval = new List<TMSG>();
DataSet ds = new DataSet();
try
{
ds = TMSSQLConnector.ExecuteProcRetDS("MSGBodyGetToSend");
}
catch (Exception _ex)
{
TLogger.Add("Невозможно исполнить MSGBodyGetToSend! EXCEPTION: " + _ex.Message, TLogger.MSGType.eEmail);
}
if (ds != null && ds.Tables.Count>0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
retval.Add(TMSG.FromDataRow(dr));
}
catch (Exception _ex)
{
int id = -1;
int.TryParse(dr["ID"].ToString(), out id);
if (id > 0)
{
TMSG msg = new TMSG();
msg.ID = id;
msg.ExternalID = -1;
DBQuery.UpdateMSGStatus(msg);
}
TLogger.Add("Невозможно преобразовать строку БД к требуему виду! Сообщение ID=" + id + " EXCEPTION: " + _ex.Message, TLogger.MSGType.eEmail);
}
}
}
return retval;
}
/// <summary>
/// Обновить статус сообщения в БД
/// </summary>
/// <param name="_msg">Сообщение</param>
public static void UpdateMSGStatus(TMSG _msg)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(new SqlParameter("ID", _msg.ID));
param.Add(new SqlParameter("Status", (int)_msg.DBStatus));
param.Add(new SqlParameter("ExtID", _msg.ExternalID));
try
{
TMSSQLConnector.ExecuteProcRetString("MSGBodySetStatus", param);
}
catch (Exception _ex)
{
TLogger.Add("Невозможно исполнить MSGBodySetStatus с сообщением ID=" + _msg.ID + " EXCEPTION: " + _ex.Message, TLogger.MSGType.eEmail);
}
}
