/// <summary>
/// Get Attachment
/// </summary>
/// <param name="ctx">context</param>
/// <param name="AD_Table_ID">table id</param>
/// <param name="Record_ID">record id</param>
/// <returns>attachment or null</returns>
public static MMailAttachment1 Get(Ctx ctx, int AD_Table_ID, int Record_ID)
{
MMailAttachment1 retValue = null;
String sql = "SELECT * FROM mailattachment1 WHERE AD_Table_ID=" + AD_Table_ID + " AND Record_ID=" + Record_ID + "";
try
{
DataSet ds = DataBase.DB.ExecuteDataset(sql, null, null);
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
retValue = new MMailAttachment1(ctx, dr, null);
}
}
}
catch (Exception e)
{
_log.Log(Level.SEVERE, sql, e);
}
return(retValue);
}
/// <summary>
/// Send notice to user
/// </summary>
/// <param name="AD_User_ID">Id of user</param>
/// <param name="NotificationType"> Notification type</param>
/// <param name="client"> Tenant object</param>
/// <param name="from"> From user notice</param>
/// <param name="subject">Subject of notice.</param>
/// <param name="message">Message to be sent to user</param>
/// <param name="pdf"> Attachment</param>
private void SendNoticeNow(int AD_User_ID, String NotificationType,
MClient client, MUser from, String subject, String message, FileInfo pdf)
{
MUser to = MUser.Get(GetCtx(), AD_User_ID);
if (NotificationType == null)
{
NotificationType = to.GetNotificationType();
}
// Send Mail
if (X_AD_User.NOTIFICATIONTYPE_EMail.Equals(NotificationType) ||
X_AD_User.NOTIFICATIONTYPE_EMailPlusNotice.Equals(NotificationType))
{
VAdvantage.Model.MMailAttachment1 _mAttachment = new VAdvantage.Model.MMailAttachment1(GetCtx(), 0, null);
_mAttachment.SetAD_Client_ID(GetCtx().GetAD_Client_ID());
_mAttachment.SetAD_Org_ID(GetCtx().GetAD_Org_ID());
_mAttachment.SetAD_Table_ID(MTable.Get_Table_ID(Table_Name));
_mAttachment.IsActive();
_mAttachment.SetMailAddress("");
_mAttachment.SetAttachmentType("M");
_mAttachment.SetRecord_ID(_req.GetR_Request_ID());
_mAttachment.SetTextMsg(message);
_mAttachment.SetTitle(subject);
_mAttachment.SetMailAddress(to.GetEMail());
if (from != null && !string.IsNullOrEmpty(from.GetEMail()))
{
_mAttachment.SetMailAddressFrom(from.GetEMail());
}
else
{
_mAttachment.SetMailAddressFrom(client.GetRequestEMail());
}
_mAttachment.NewRecord();
if (client.SendEMail(from, to, subject, message.ToString(), pdf))
{
_success++;
if (_emailTo.Length > 0)
{
_emailTo.Append(", ");
}
_emailTo.Append(to.GetEMail());
_mAttachment.SetIsMailSent(true);
}
else
{
log.Warning("Failed: " + to);
_failure++;
NotificationType = X_AD_User.NOTIFICATIONTYPE_Notice;
_mAttachment.SetIsMailSent(false);
}
_mAttachment.Save();
}
// Send Note
if (X_AD_User.NOTIFICATIONTYPE_Notice.Equals(NotificationType) ||
X_AD_User.NOTIFICATIONTYPE_EMailPlusNotice.Equals(NotificationType))
{
int AD_Message_ID = 834;
MNote note = new MNote(GetCtx(), AD_Message_ID, AD_User_ID,
X_R_Request.Table_ID, _req.GetR_Request_ID(),
subject, message.ToString(), Get_TrxName());
if (note.Save())
{
_notices++;
}
}
}
/// <summary>
/// this method actually send mail, both static and dynamic.... and save info in MailAttachment....
/// </summary>
/// <param name="mails"></param>
/// <param name="AD_User_ID"></param>
/// <param name="AD_Client_ID"></param>
/// <param name="AD_Org_ID"></param>
/// <param name="attachment_ID"></param>
/// <param name="fileNames"></param>
/// <param name="fileNameForOpenFormat"></param>
/// <param name="mailFormat"></param>
/// <param name="notify"></param>
/// <returns></returns>
public string SendMailstart(List <NewMailMessage> mails, int AD_User_ID, int AD_Client_ID, int AD_Org_ID, int attachment_ID, List <string> fileNames, List <string> fileNameForOpenFormat, string mailFormat, bool notify, VAdvantage.Utility.EMail sendmails, List <int> documentID)
{
if (ctx == null)
{
return(null);
}
UserInformation userinfo = new UserInformation();
SMTPConfig config = null;
config = MailConfigMethod.GetUSmtpConfig(AD_User_ID, ctx);
// var config = "";
if (config == null)
{
MClient client = new MClient(ctx, AD_Client_ID, null);
userinfo.Email = client.GetRequestEMail();
}
else
{
//Add user info to list..
userinfo.Email = config.Email;
}
string[] to = null;
string[] bc = null;
string[] cc = null;
string sub = null;
string message = null;
// int _record_id = 0;
int _table_id = 0;
string[] records = null;
StringBuilder res = new StringBuilder();
List <NewMailMessage> mail = mails.GetRange(0, mails.Count);
for (int j = 0; j < mails.Count; j++)
{
VAdvantage.Utility.EMail sendmail = new VAdvantage.Utility.EMail(ctx, "", "", "", "", "", "",
true, false);
to = mails[j].To.Split(';');
bc = mails[j].Bcc;
cc = mails[j].Cc.Split(';');
StringBuilder bcctext = new StringBuilder();
sub = mails[j].Subject;
message = mailFormat;
if (mails[j].Body != null && mails[j].Body.Count > 0)
{
List <string> keysss = mails[j].Body.Keys.ToList();
for (int q = 0; q < keysss.Count; q++)
{
message = message.Replace(keysss[q], mails[j].Body[keysss[q]]);
}
}
if (mails[j].Recordids != null) //in case of static mail
{
records = mails[j].Recordids.Split(',');
}
_table_id = Convert.ToInt32(mail[j].TableID);
VAdvantage.Model.MMailAttachment1 _mAttachment = new VAdvantage.Model.MMailAttachment1(ctx, 0, null);
if (sub == null || sub.Length == 0 || sub == "")
{
sendmail.SetSubject("."); // pass validation
}
else
{
sendmail.SetSubject(sub);
}
sendmail.SetMessageHTML(message);
//used to get attachments uploaded by user.....
if (mail[j].AttachmentFolder != null && mail[j].AttachmentFolder.Trim().Length > 0)
{
string storedAttachmentPath = Path.Combine(HostingEnvironment.ApplicationPhysicalPath, AttachmentsUploadFolderName + "\\" + mail[j].AttachmentFolder);
if (Directory.Exists(storedAttachmentPath))
{
DirectoryInfo info = new DirectoryInfo(storedAttachmentPath);
if (info.GetFiles().Length > 0)
{
FileInfo[] files = info.GetFiles();
for (int a = 0; a < files.Length; a++)
{
if (fileNames.Contains(files[a].Name))
{
FileStream attachmentStream = File.OpenRead(files[a].FullName);
BinaryReader binary = new BinaryReader(attachmentStream);
byte[] buffer = binary.ReadBytes((int)attachmentStream.Length);
sendmail.AddAttachment(buffer, files[a].Name);
_mAttachment.AddEntry(files[a].Name, buffer);
}
}
}
}
}
//used to get attachments of saved formats.. Currently not Supporting......
if (attachment_ID > 0)
{
VAdvantage.Model.MMailAttachment1 _mAttachment1 = new VAdvantage.Model.MMailAttachment1(ctx, attachment_ID, null);
if (_mAttachment1.GetEntryCount() > 0)
{
MAttachmentEntry[] entries = _mAttachment1.GetEntries();
for (int m = 0; m < entries.Count(); m++)
{
//if (fileNameForOpenFormat.Contains(entries[m].GetName()))
//{
byte[] buffer = entries[m].GetData();
sendmail.AddAttachment(buffer, entries[m].GetName());
_mAttachment.AddEntry(entries[m].GetName(), buffer);
//}
}
}
}
if (documentID != null || documentID.Count > 0)
{
for (int i = 0; i < documentID.Count; i++)
{
try
{
int attachmentID = AttachmentID(documentID[i]);
//MAttachment objAttachment = new MAttachment(ctx, attachmentID, null, Common.GetPassword(), ctx.GetAD_Client_ID());
//objAttachment.Force = false;
////objAttachment.AD_Client_ID = ctx.GetAD_Client_ID();
//byte[] fileByte = objAttachment.GetEntryData(0);
//string fileName = objAttachment.GetEntryName(0);
List <AttachedFileInfo> lstAttchments = GetBytes(ctx, attachmentID, "");
sendmail.AddAttachment(lstAttchments[0].FileBytes, lstAttchments[0].FileName);
}
catch (Exception ex)
{
res.Append(Msg.GetMsg(ctx, "VADMS_AttachmentNotFound for : " + documentID[i]) + ex.Message);
}
}
}
if (to != null)
{
for (int i = 0; i < to.Length; i++)
{
if (to[i].ToString() != "")
{
sendmail.AddTo(to[i].ToString(), "");
// totext.Append(to[i].ToString() + ",");
}
}
}
if (bc != null)
{
for (int i = 0; i < bc.Length; i++)
{
if (bc[i].ToString() != "")
{
sendmail.AddBcc(bc[i].ToString(), "");
bcctext.Append(bc[i].ToString() + ",");
}
}
}
if (cc != null)
{
for (int i = 0; i < cc.Length; i++)
{
if (cc[i].ToString() != "")
{
sendmail.AddCc(cc[i].ToString(), "");
/// cctext.Append(cc[i].ToString() + ",");
}
}
}
string res1 = sendmail.Send();
if (records != null && records.Length > 0)//save entery in MailAttachment......
{
for (int k = 0; k < records.Length; k++)
{
if (records[k] == null || records[k] == "" || records[k] == "0")
{
continue;
}
if (res1 != "OK")
{
_mAttachment.SetIsMailSent(false);
}
else
{
_mAttachment.SetIsMailSent(true);
}
int AD_Client_Id = ctx.GetAD_Client_ID();
int iOrgid = ctx.GetAD_Org_ID();
_mAttachment.SetAD_Client_ID(AD_Client_Id);
_mAttachment.SetAD_Org_ID(iOrgid);
_mAttachment.SetAD_Table_ID(_table_id);
_mAttachment.IsActive();
_mAttachment.SetMailAddress(bcctext.ToString());
_mAttachment.SetAttachmentType("M");
_mAttachment.SetRecord_ID(Convert.ToInt32(records[k]));
_mAttachment.SetTextMsg(message);
_mAttachment.SetTitle(sub);
_mAttachment.SetMailAddressBcc(bcctext.ToString());
_mAttachment.SetMailAddress(mails[j].To);
_mAttachment.SetMailAddressCc(mails[j].Cc);
_mAttachment.SetMailAddressFrom(userinfo.Email);
if (_mAttachment.GetEntries().Length > 0)
{
_mAttachment.SetIsAttachment(true);
}
else
{
_mAttachment.SetIsAttachment(false);
}
_mAttachment.NewRecord();
if (_mAttachment.Save())
{
}
else
{
// log.SaveError(Msg.GetMsg(Env.GetCtx(), "RecordNotSaved"), "");
}
}
}
if (res1 != "OK") // if mail not sent....
{
if (res1 == "AuthenticationFailed.")
{
res.Append("AuthenticationFailed");
return(res.ToString());
}
else if (res1 == "ConfigurationIncompleteOrNotFound")
{
res.Append("ConfigurationIncompleteOrNotFound");
return(res.ToString());
}
else
{
res.Append(" " + Msg.GetMsg(ctx, "MailNotSentTo") + ": " + mails[j].To + " " + bcctext + " " + mails[j].Cc);
}
}
else
{
{
if (!res.ToString().Contains("MailSent"))
{
res.Append("MailSent");
}
}
}
bcctext = null;
}
if (notify) // make an entry in Notice window.....
{
MNote note = new MNote(ctx, "SentMailNotice", AD_User_ID,
AD_Client_ID, AD_Org_ID, null);
// Reference
note.SetReference(ToString()); // Document
// Text
note.SetTextMsg(res.ToString());
note.Save();
}
userinfo = null;
cc = null;
bc = null;
to = null; records = null;
sub = null; message = null;
records = null;
return(res.ToString());
}
