//-------------------------------------------------------------------------------------------------------------------------
// logger
//-------------------------------------------------------------------------------------------------------------------------
/// <summary>
///
/// </summary>
/// <param name="p_certapp"></param>
/// <param name="p_exception"></param>
/// <param name="p_message"></param>
public void WriteLog(Guid p_certapp, string p_exception, string p_message)
{
if (IMailer.CheckValidApplication(p_certapp) == true)
{
ELogger.SNG.WriteLog(p_exception, p_message);
}
}
/// <summary>
///
/// </summary>
/// <param name="p_certapp"></param>
/// <param name="p_invoicerId"></param>
/// <param name="p_issueIds"></param>
/// <returns></returns>
public int SendWithIssueIDs(Guid p_certapp, string p_invoicerId, string[] p_issueIds)
{
int _result = 0;
try
{
if (IMailer.CheckValidApplication(p_certapp) == true)
{
if (p_issueIds.Length > 100)
{
throw new MailerException(String.Format("Issue-ids can not exceed 100-records. invoiceId->'{0}', length->{1})", p_invoicerId, p_issueIds.Length));
}
_result = EMailer.DoMailSend(p_invoicerId, p_issueIds);
}
}
catch (MailerException ex)
{
ELogger.SNG.WriteLog(ex);
}
catch (Exception ex)
{
ELogger.SNG.WriteLog(ex);
}
return(_result);
}
//-------------------------------------------------------------------------------------------------------------------------
//
//-------------------------------------------------------------------------------------------------------------------------
/// <summary>
///
/// </summary>
/// <param name="p_certapp"></param>
/// <param name="p_invoicerId"></param>
/// <param name="p_fromDay"></param>
/// <param name="p_tillDay"></param>
/// <returns></returns>
public int SendWithDateRange(Guid p_certapp, string p_invoicerId, DateTime p_fromDay, DateTime p_tillDay)
{
int _result = 0;
try
{
if (IMailer.CheckValidApplication(p_certapp) == true)
{
UTextHelper.SNG.GetSendingRange(ref p_fromDay, ref p_tillDay);
var _sqlstr
= "SELECT b.invoicerId, COUNT(b.invoicerId) as norec "
+ " FROM TB_eTAX_ISSUING a INNER JOIN TB_eTAX_INVOICE b "
+ " ON a.issueId=b.issueId "
+ " WHERE (a.isInvoiceeMail != @isInvoiceeMail OR a.isProviderMail != @isProviderMail) "
+ " AND ( "
+ " (RIGHT(b.typeCode, 2) IN ('01', '02', '04') AND b.invoicerId=@invoicerId) "
+ " OR "
+ " (RIGHT(b.typeCode, 2) IN ('03', '05') AND b.brokerId=@invoicerId) "
+ " ) "
+ " AND b.issueDate>=@fromDate AND b.issueDate<=@tillDate "
+ " GROUP BY b.invoicerId";
var _dbps = new PgDatParameters();
{
_dbps.Add("@invoicerId", NpgsqlDbType.Varchar, p_invoicerId);
_dbps.Add("@isInvoiceeMail", NpgsqlDbType.Varchar, "T");
_dbps.Add("@isProviderMail", NpgsqlDbType.Varchar, "T");
_dbps.Add("@fromDate", NpgsqlDbType.TimestampTZ, p_fromDay);
_dbps.Add("@tillDate", NpgsqlDbType.TimestampTZ, p_tillDay);
}
var _ds = LSQLHelper.SelectDataSet(UAppHelper.ConnectionString, _sqlstr, _dbps);
if (LSQLHelper.IsNullOrEmpty(_ds) == false)
{
var _rows = _ds.Tables[0].Rows;
for (int i = 0; i < _rows.Count; i++)
{
string _invoicerId = Convert.ToString(_rows[i]["invoicerId"]);
int _noIssuing = Convert.ToInt32(_rows[i]["norec"]);
_result += EMailer.DoMailSend(_invoicerId, _noIssuing, p_fromDay, p_tillDay);
}
}
}
}
catch (MailerException ex)
{
ELogger.SNG.WriteLog(ex);
}
catch (Exception ex)
{
ELogger.SNG.WriteLog(ex);
}
return(_result);
}
/// <summary>
///
/// </summary>
/// <param name="p_certapp"></param>
/// <param name="p_invoicerId"></param>
/// <returns></returns>
public int ClearXFlag(Guid p_certapp, string p_invoicerId)
{
int _result = 0;
try
{
if (IMailer.CheckValidApplication(p_certapp) == true)
{
_result = EMailer.ClearXFlag(p_invoicerId);
}
}
catch (MailerException ex)
{
ELogger.SNG.WriteLog(ex);
}
catch (Exception ex)
{
ELogger.SNG.WriteLog(ex);
}
return(_result);
}
/// <summary>
///
/// </summary>
/// <param name="p_certapp"></param>
/// <param name="p_invoicerId"></param>
/// <param name="p_issue_id"></param>
/// <param name="p_newMailAddress"></param>
/// <returns></returns>
public int ReSendWithIssueID(Guid p_certapp, string p_invoicerId, string p_issue_id, string p_newMailAddress)
{
int _result = 0;
try
{
if (IMailer.CheckValidApplication(p_certapp) == true)
{
_result = EMailer.DoMailReSend(p_invoicerId, p_issue_id, p_newMailAddress);
}
}
catch (MailerException ex)
{
ELogger.SNG.WriteLog(ex);
}
catch (Exception ex)
{
ELogger.SNG.WriteLog(ex);
}
return(_result);
}
