using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


public partial class Admin_Account_LedgerDetail : System.Web.UI.Page
{
   // SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ToString());
   // string ToMail, FromMail, BodyMail, HeadMail;
    protected void Page_Load(object sender, EventArgs e)
    {
      
    }
//    private void mailSender2()
//    {

//        try
//        {
//            con.Open();

//            SqlCommand cmd = new SqlCommand("viewLedger", con);
//            cmd.CommandType = CommandType.StoredProcedure;

//            cmd.Parameters.AddWithValue("@sessionId", 1);
//            cmd.Parameters.AddWithValue("@branchId", 9426);
//            cmd.Parameters.AddWithValue("@ledgerId",1);
//            cmd.Parameters.AddWithValue("@startDate", TextBox2.Text);
//            cmd.Parameters.AddWithValue("@endDate", 16 / 07 / 2018);

//            // SqlDataReader dr = cmd.ExecuteReader();
//            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//            DataTable dt = new DataTable();
//            string textBody = "";
//            adapter.Fill(dt);

//            textBody = " <table border=" + 1 + " cellpadding=" + 0 + " cellspacing=" + 0 + " width = " + 900 + "><tr bgcolor='#4da6ff'><td><b>tdbId</b></td> <td> <b> masterAccount</b> </td><td> <b> voucherNo</b> </td><td> <b> voucherName</b> </td><td> <b> TransType</b> </td><td> <b> Credit</b> </td><td> <b> Debit</b> </td><td> <b> Date1</b> </td><td> <b> Remark</b> </td><td> <b> mAccountName</b> </td></tr>";
//            for (int loopCount = 0; loopCount < dt.Rows.Count-1; loopCount++)
//            {
//                textBody += "<tr><td>" + dt.Rows[loopCount]["tdbId"] + "</td><td> " + dt.Rows[loopCount]["masterAccount"] + "</td> <td> " + dt.Rows[loopCount]["voucherNo"] + "</td> <td> " + dt.Rows[loopCount]["voucherName"] + "</td> <td> " + dt.Rows[loopCount]["TransType"] + "</td> <td> " + dt.Rows[loopCount]["Credit"] + "</td> <td> " + dt.Rows[loopCount]["Debit"] + "</td> <td> " + dt.Rows[loopCount]["Date1"] + "</td> <td> " + dt.Rows[loopCount]["Remark"] + "</td> <td> " + dt.Rows[loopCount]["mAccountName"] + "</td> </tr>";
//            }
//            textBody += "<tr><td colspan="+3+"></td><td colspan=" +2+ ">Total</td><td>"+HiddenField1.Value+"</td><td>"+HiddenField2.Value+"</td></tr> </table>";

//            BodyMail = @"<div style='width:625px;border-top:#c0f solid 3px;padding-top:10px'>
//<span style='font-family:arial;width:270px;font-size:24px;font-weight:bold;color:#006'>
//<i>Gramin Shiksha</i>
//</span>
//<br/>
//<span style='vertical-align:bottom;font-family:arial;font-size:14px;text-align:right;color:#666'>Confirmation Mail</span>
//<div style='border-top:#ebebeb solid 1px'></div>
//<div style='border-top:#ebebeb solid 1px'></div>
//<div style='margin-top:20px;padding:10px;float:left;font-family:arial;font-size:18px;color:#666'>
//<img>
//</div>
//<div style='font-size:12px;width:512px;margin-left:10px;font-family:arial;margin-top:20px;float:right'>
//  "+textBody+@";

// </div>

//<div style='margin-top:20px;width:600px;font-family:arial;border-top:#09f 2px solid;color:#666;font-size:11px;float:left'>

//<div style='border-top:#ebebeb solid 1px'></div>

//This service is brought to you by -
//<br>
//<br>
//Copyright @ graminshiksha.com
//</div>
//</div>
//<div ></div>
//<div >
//<br><br>
//</div>
//</div>
//<div >&#10;&#10;</div>
//</div>
//</div>
//<div id=':6b'  style='display:none'>
//<div id=':6a'></div>
//</div>
//<div ></div>
//</div>";
//            HeadMail = "Gramin Shikha";
//            //ToMail = "booking.mij@gmail.com";
//            //booking.mij@gmail.com
//            ToMail = TextBox1.Text; //"kmahisarwebsite@gmail.com";//"";
//            //ToMail = "satnam.netkma@gmail.com";
//            FromMail = "admin@graminshiksha.com";

//            System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
//            SmtpClient SmtpServer = new SmtpClient();

//            mail.To.Add(ToMail);
//            mail.From = new System.Net.Mail.MailAddress(FromMail); mail.Subject = HeadMail;
//            mail.Body = BodyMail;
//            mail.IsBodyHtml = true;
//            SmtpServer.Send(mail);
//            // Response.Redirect("contact_us.html?msg=Succssfully-Submit-!");

//            Label1.Text = "Your Request Is Submitted Sucessfully";
//        }
//        catch
//        {
//            Label1.Text = "your request have an error";
//        }
//    }
    
  
    
 

//    protected void Button1_Click(object sender, EventArgs e)
//{
//    mailSender2();
//}
}