private MailMessage SetTradeConfirmationInfoBody_Master(MailMessage message_dep, EmailTradeConfirmation_NotificationBO bo)
{
string someArrows = new string(new char[] { '\u2190', '\u2191', '\u2192', '\u2193' });
message_dep.Body = @"<!DOCTYPE html PUBLIC ""-//W3C//DTD XHTML 1.0 Transitional//EN"" ""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"">
<html xmlns=""http://www.w3.org/1999/xhtml"">
<head>
<meta http-equiv=""Content-Type"" content=""text/html; charset=iso-8859-1"" />
<title>Untitled Document</title>
<style type=""text/css"">
<!--
.style7 {font-family: ""Times New Roman"", Times, serif}
.style9 {font-family: ""Times New Roman"", Times, serif; font-weight: bold; }
.style13 {font-weight: bold; font-size: 29px;}
.style14 {font-weight: bold; font-size: 22px}
.style15 {font-size: small}
-->
</style>
</head>
<body>
<table width=""732"" border=""0"">
<tr>
<td height=""34"" valign=""bottom"" ><strong style=""font-size: 26px;"">K-Securities & Consultants Ltd. </strong></td>
</tr>
<tr>
<td><span class=""style15"">Head Office: Suite #604 (5th Floor), 158-160, Motijheel C/A, </span></td>
</tr>
<tr >
<td align=""left"" valign=""top"" ><span class=""style15"">Modhumita Building, Dhaka-1000.</span> <a href=""http://www.ksclbd.com"">www.ksclbd.com
<hr></a></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width=""732"" border=""0"">
<tr>
<td align=""center""><span class=""style14""><strong style=""font-size: 20px;"">TRADE CONFIRMATION</strong></span></td>
</tr>
</table>
<p> </p>
<table width=""732"" border=""0"">
<tr>
<th width=""89"" align=""left"" valign=""top"">Cust Code</th>
<th width=""18"" align=""center"" valign=""top""><strong>:</strong></th>
<th width=""590"" align=""left"" valign=""top""><div align=""left""> " + bo.Cust_Code + @" </div></th>
</tr>
<tr>
<th width=""89"" align=""left"" valign=""top"">Name</th>
<th width=""18"" align=""center"" valign=""top""><strong>: </strong></th>
<th width=""590"" align=""left"" valign=""top""><div align=""left""> " + bo.Cust_Name + @" </div></th>
</tr>
<tr>
<th align=""left"" valign=""top"">Trade Trade</th>
<th align=""center"" valign=""top""><strong>: </strong></th>
<th align=""left"" valign=""top""><div align=""left""> " + bo.Trade_Date.ToShortDateString() + @" </div></th>
</tr>
<tr>
<th align=""left"" valign=""top""> </th>
<th align=""center"" valign=""top""> </th>
<th align=""left"" valign=""top""> </th>
</tr>
</table>
<table width=""732"" border=""2"">
<tr>
<th width=""73"" rowspan=""2"" align=""center"" bgcolor=""#CCCCCC""><span class=""style7"">Instrument Name</span></th>
<th colspan=""3"" align=""center"" bgcolor=""#CCCCCC""><span class=""style7"">Buy</span></th>
<th colspan=""3"" align=""center"" bgcolor=""#CCCCCC""><span class=""style7"">Sell</span></th>
<th colspan=""3"" align=""center"" bgcolor=""#CCCCCC""><span class=""style7"">Balance</span></th>
</tr>
<tr>
<th width=""53"" align=""center""><span class=""style7"">Qty</span></th>
<th width=""53"" align=""center""><span class=""style7"">Avg</span></th>
<th width=""67"" align=""center""><span class=""style7"">Amount</span></th>
<th width=""53"" align=""center""><span class=""style7"">Qty</span></th>
<th width=""53"" align=""center""><span class=""style7"">Avg</span></th>
<th width=""67"" align=""center""><span class=""style7"">Amount</span></th>
<th width=""53"" align=""center""><span class=""style7"">Qty</span></th>
<th width=""53"" align=""center""><span class=""style7""> Amount</span></th>
<th width=""67"" align=""center""><span class=""style7"">Comm.</span></th>
</tr>";
// Include some non-ASCII characters in body and subject.
message_dep.Body += Environment.NewLine;// +someArrows;
message_dep.BodyEncoding = System.Text.Encoding.UTF8;
return(message_dep);
}
private MailMessage SetTradeConfirmationInfoBody_Footer(MailMessage message_dep, EmailTradeConfirmation_NotificationBO bo)
{
string someArrows = new string(new char[] { '\u2190', '\u2191', '\u2192', '\u2193' });
message_dep.Body = message_dep.Body +
@"<tr>
<td> </td>
<td colspan=""3"" align=""right""><span class=""style9"">" + bo.TotalOnBuyTotal.ToString("0.00") + @"</span></td>
<td colspan=""3"" align=""right""><span class=""style9"">" + bo.TotalOnSellToal.ToString("0.00") + @"</span></td>
<td colspan=""2"" align=""right""><span class=""style9"">" + bo.TotalOnAmount.ToString("0.00") + @"</span></td>
<td align=""right""><span class=""style9"">" + bo.TotalOnCommission.ToString("0.00") + @"</span></td>
</tr>
</table>
<table width=""732"" border=""0"">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width=""732"" border=""0"" bgcolor=""#CCCCCC"">
<tr>
<td width=""110""><strong>Interest Charge</strong></td>
<td width=""8"" align=""center""><strong>:</strong></td>
<td width=""94"" align=""right""><strong>" + bo.Interest.ToString("0.00") + @" </strong></td>
<td width=""80"" align=""left""> </td>
<td width=""289"" align=""left""> Ledger Balance Before Trading (" + bo.Trade_Date.ToShortDateString() + @")</td>
<td width=""114"" align=""right""> " + bo.Pre_Balance.ToString("0.00") + @" </td>
</tr>
<tr>
<td><strong>Amount Payable</strong></td>
<td align=""center""><strong>:</strong></td>
<td align=""right""><strong> " + bo.TotalOnPayable.ToString("0.00") + @" </strong></td>
<td> </td>
<td>Net Amount Of Trading </td>
<td align=""right"">" + bo.TotalOnPayable.ToString("0.00") + @" </td>
</tr>
<tr>
<td> </td>
<td align=""center""> </td>
<td> </td>
<td> </td>
<td><strong>Current Ledger Balance </strong></td>
<td align=""right""><strong>" + bo.CurrentBalance.ToString("0.00") + @" </strong></td>
</tr>
</table>
<blockquote>
<p> </p>
</blockquote>
<table width=""280"" border=""0"">
<tr>
<td width=""274"">Thanks a lot for your valuable transaction. </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><p>K-Securities & Consultants ltd.<br />
</p></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td>This website's information are based on our actual record. If any of the above details look incorrect, please advise immediately. This is however possible but highly unlikely to find your record inaccurate or missing. This may happened due to malfunction of any/some of web tools that we use to collect and display your data here such as internet connectivity, FTP software, web server malfunction, problem with web database and others. We assure you that our master record of actual information is not affected by any of these.</td>
</tr>
</table>
<blockquote>
<p> </p>
</blockquote>
</body>
</html>";
message_dep.BodyEncoding = System.Text.Encoding.UTF8;
return(message_dep);
}
public void SetMessages_TradeConfirmation()
{
DataTable dt_Master = new DataTable();
DataTable dt_Details = new DataTable();
CCSBAL bal = new CCSBAL();
MailMessage message;
messagesObjs_tradeConfirm = new List <MessageObject_TradeConfirm>();
dt_Master = bal.CCS_GetTemp_EmailTradeConfirmation_Master();
if (dt_Master.Rows.Count > 0)
{
foreach (DataRow drM in dt_Master.Rows)
{
MailAddress to = new MailAddress(drM["Email"].ToString());
message = new MailMessage(from, to);
message.Subject = "Trade Confirmation";
message.SubjectEncoding = System.Text.Encoding.UTF8;
message.IsBodyHtml = true;
EmailTradeConfirmation_NotificationBO bo = new EmailTradeConfirmation_NotificationBO();
bo.Cust_Code = drM["Cust_Code"].ToString();
bo.Cust_Name = drM["Cust_Name"].ToString();
bo.Trade_Date = Convert.ToDateTime(drM["Trade_Date"].ToString());
bo.Interest = Convert.ToDouble(drM["Interest"].ToString());
bo.Pre_Balance = Convert.ToDouble(drM["Pre_Balance"].ToString());
bo.TotalOnBuyTotal = Convert.ToDouble(drM["TotalOnBuyTotal"].ToString());
bo.TotalOnSellToal = Convert.ToDouble(drM["TotalOnSellTotal"].ToString());
bo.TotalOnBalance = Convert.ToDouble(drM["TotalOnBalance"].ToString());
bo.TotalOnAmount = Convert.ToDouble(drM["TotalOnAmount"].ToString());
bo.TotalOnCommission = Convert.ToDouble(drM["TotalOnCommission"].ToString());
bo.TotalOnPayable = Convert.ToDouble(drM["TotalPayable"].ToString());
bo.CurrentBalance = Convert.ToDouble(drM["CurrentBalance"].ToString());
SetTradeConfirmationInfoBody_Master(message, bo);
//Details Executed As Nested
dt_Details = bal.CCS_GetTemp_EmailTradeConfirmation_Detials(bo.Cust_Code);
if (dt_Details.Rows.Count > 0)
{
List <EmailTradeConfirmation_NotificationBO> bo_details_List = new List <EmailTradeConfirmation_NotificationBO>();
foreach (DataRow dr in dt_Details.Rows)
{
EmailTradeConfirmation_NotificationBO bo_detais = new EmailTradeConfirmation_NotificationBO();
bo_detais.Comp_Short_Code = dr["Comp_Short_Code"].ToString();
bo_detais.Buy_Qty = Convert.ToInt32(dr["Buy_Qty"].ToString());
bo_detais.Buy_Avg = Convert.ToDouble(dr["Buy_Avg"].ToString());
bo_detais.Buy_Total = Convert.ToDouble(dr["Buy_Total"].ToString());
bo_detais.Sell_Qty = Convert.ToInt32(dr["Sell_Qty"].ToString());
bo_detais.Sell_Avg = Convert.ToDouble(dr["Sell_Avg"].ToString());
bo_detais.Sell_Total = Convert.ToDouble(dr["Sell_Total"].ToString());
bo_detais.Balance = Convert.ToDouble(dr["Balance"].ToString());
bo_detais.Amount = Convert.ToDouble(dr["Amount"].ToString());
bo_detais.Commission = Convert.ToDouble(dr["Commission"].ToString());
bo_details_List.Add(bo_detais);
}
SetTradeConfirmationInfoBody_Details(message, bo_details_List);
}
//Footer Executed
SetTradeConfirmationInfoBody_Footer(message, bo);
messagesObjs_tradeConfirm.Add(new MessageObject_TradeConfirm()
{
Mail = message, MessageInfoBo = bo
});
}
}
}