using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using nmsSetup;
using System.Collections.Generic;
using QRCoder;
using System.IO;
using System.Drawing;


public partial class Admin_office_certificateprint1 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
    SqlCommand cmd;
    public Int32 i = 1;
    clsBLSetup obj;
    PRPSetup objprp;
    String st;
    static string st1;
    Int32 total = 0, MaxMarks = 0, MinMarks = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        /*if (Session["OfficeAdmin"] == null)
        {
            Response.Redirect("../../Default.aspx?logout=session&path=employee/printPage.aspx");
        }*/

        //if (Session["investorList"] == null)
        //{
        //    Response.Redirect("PendingPrint.aspx", false);
        //}

        try
        {
            if (Page.IsPostBack == false)
            {
                st = Request.QueryString["memId"].ToString();
                st1 = Request.QueryString["memId"].ToString();
                st = st.Substring(0, 3).ToString();

                if (st == "BPPS/")
                {
                    bindLable();
                }
                else
                {
                    GetData(1);
                }
                 
            }
            lkprint.Attributes.Add("onClick", "printSpecial()");
        }
        catch (Exception ex)
        {
            Label1.Visible = true;
            Label1.Text = ex.Message.ToString();
        }
    }

    public void GetData(Int32 sno1)
    {
        clsBLSetup obj = new clsBLSetup();
        DataSet ds = new DataSet();
        try
        {
            //PRPSetup objmemprp = new PRPSetup();
            //objmemprp.id = Request.QueryString["memId"].ToString();
            //objmemprp.moduleId = "2";
            // ds = obj.viewprintICard(objmemprp);
            //string st = "";
            //int a;
            //ds = obj.viewprintDiplomaSubjectAll(objmemprp);

            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbNewBASPConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("viewPrintNTT", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@studentId", Request.QueryString["memId"].ToString());
            cmd.Parameters.AddWithValue("@moduleId", 2);

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(ds);

            lblSrNo.Text = ds.Tables[0].Rows[0]["loginSrNo"].ToString();
            lblIssueDate.Text = ds.Tables[0].Rows[0]["years"].ToString();
            lblName.Text = ds.Tables[0].Rows[0]["studentName"].ToString();
            lblFather.Text = ds.Tables[0].Rows[0]["studentFatherName"].ToString();
            //      lblMotherName.Text = ds.Tables[0].Rows[0]["studentMother"].ToString();
            //lblDOB.Text = ds.Tables[0].Rows[0]["studentDOB"].ToString();
            //lblPlanName.Text = ds.Tables[0].Rows[0]["courseName"].ToString();
            //lblBranchName.Text = ds.Tables[0].Rows[0]["cBranchName"].ToString();
            //lblCourseCode.Text = ds.Tables[0].Rows[0]["courseCode"].ToString();
            //lblDuration.Text = ds.Tables[0].Rows[0]["smMonth"].ToString();
            lblRegNo.Text = ds.Tables[0].Rows[0]["loginName"].ToString();
            //lbljoiningdate.Text = ds.Tables[0].Rows[0]["startDate"].ToString();
            //Image1.ImageUrl = ds.Tables[0].Rows[0]["imagePath"].ToString();
            //          lblIssuedOn.Text = ds.Tables[0].Rows[0]["issueDate"].ToString();
            //          lblDivision.Text = ds.Tables[0].Rows[0]["fs"].ToString();
            //          lblResult.Text = ds.Tables[0].Rows[0]["ps"].ToString();
            lbltotalthory.Text = ds.Tables[0].Rows[0]["TotalThoery"].ToString();
            lblpracticalmarks.Text = ds.Tables[0].Rows[0]["MaxPMark"].ToString();

            lblfirstyearmarks.Text = ds.Tables[0].Rows[0]["total"].ToString();
            lblsecondyearmarks.Text = ds.Tables[0].Rows[0]["MaxMarks"].ToString();
            lblgrandtotal.Text = ds.Tables[0].Rows[0]["grade"].ToString();

            datalist.DataSource = ds.Tables[1];
            datalist.DataBind();
            QRCode(lblRegNo.Text, lblName.Text, lblFather.Text);
        }

        catch (Exception ex)
        {
            Label1.Visible = true;
            Label1.Text = ex.Message.ToString();
        }
        // return ds;

    }
    private void bindLable()
    {
        if (con.State == ConnectionState.Closed)
            con.Open();
        cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "viewResult";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@regno", st);

        SqlDataReader dr = cmd.ExecuteReader();

        if (dr.HasRows)
        {
            dr.Read();

            lblSrNo.Text = dr["memberCodeId"].ToString();
            lblIssueDate.Text = dr["years"].ToString();
            lblName.Text = dr["memberName"].ToString();
            lblFather.Text = dr["memberFatherName"].ToString();
            //      lblMotherName.Text = dr["memberMotherName"].ToString();
            //lblDOB.Text = dr["memberDOB"].ToString();
            //lblPlanName.Text = dr["courseName"].ToString();
            //lblBranchName.Text = dr["branchName"].ToString();
            //lblCourseCode.Text = dr["courseCode"].ToString();
            //lblDuration.Text = dr["duration"].ToString();
            lblRegNo.Text = dr["regNo"].ToString();
            //lbljoiningdate.Text = dr["pSessionDate"].ToString();
            //Image1.ImageUrl = dr["imagePath"].ToString();
            //           lblIssuedOn.Text = dr["issuedOn"].ToString();
            //           lblDivision.Text = dr["division"].ToString();
            //           lblResult.Text = dr["result"].ToString();

            //   datalist.DataSource = ds.Tables[1];
            //    datalist.DataBind();

            lblMsg.Text = "";
        }
        else
        {
            Label1.Visible = true;
            Label1.Text = "Result Not Found!";
        }
    }

    public void rep()
    {
        try
        {
            //   string lst;
       //     List<clsPRPmemberId> lst = new List<clsPRPmemberId>();
       //     lst = (List<clsPRPmemberId>)(Session["investorList"]);   //(List<clsPRPmemberId>)(Session["investorList"]);

      //      objprp = new clsPRPprofile();
      //      obj = new clsBLprofile();
            //  objprp.memberId = lst;

            // Repeater1.DataSource = lst; //obj.SelectAgentPrintFinal(objprp);
            // Repeater1.DataBind();
        }
        catch (Exception ex)
        {
            Label1.Visible = true;
            Label1.Text = ex.Message.ToString();

        }

    }
  
    protected void lnkButton_Command(object sender, CommandEventArgs e)
    {
//        UpdateInfo();

    }

    protected void datalist_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
    //    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    //    {
    //     //   MaxMarks += Convert.ToInt32(((Label)e.Item.FindControl("lblMaxMarks")).Text);
    //        MinMarks += Convert.ToInt32(((Label)e.Item.FindControl("lblMinMarks")).Text);
    //        total += Convert.ToInt32(((Label)e.Item.FindControl("lblTotal")).Text); 
        
    //    }
    //    if (e.Item.ItemType == ListItemType.Footer)
    //    {
    //     //   ((Label)e.Item.FindControl("lblMaxTotal")).Text = MaxMarks.ToString();
    //     //   ((Label)e.Item.FindControl("lblMinTotal")).Text = MinMarks.ToString();
    //        ((Label)e.Item.FindControl("lblObtainMarks")).Text = total.ToString();
        
    //    }

    }
    protected void lkprint_Command(object sender, CommandEventArgs e)
    {
        //updateinfo();
        if (con.State == ConnectionState.Closed)
            con.Open();

        try
        {

            cmd = new SqlCommand();
            cmd.Connection = con;

            //  cmd.CommandText = "DeductWalletBalWithLimit";
            cmd.CommandText = "DeductWalletBal";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@studentCode", st1);

            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }

        con.Close();
        cmd.Dispose();
    }

    //private void updateinfo()
    //{

    //    try
    //    {
    //        obj=new clsBLSetup();
    //        objprp=new PRPSetup();
    //        objprp.title = Request.QueryString["memId"].ToString();
    //        objprp.status = "4";                
    //        obj.SendForConfirmation(objprp);           
    //    }
    //    catch (Exception )
    //    {

    //    }


    //}


    private void QRCode(string regNo, string name, string fname)
    {

        string code = "Registration No-:" + regNo + "" +
            " Student Name: " + name + " " +
            "Father Name : " + fname + " " +

            " HTTP://WWW.ieduptraining.org";
        QRCodeGenerator qrGenerator = new QRCodeGenerator();
        QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);
        System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
        imgBarCode.Height = 70;
        imgBarCode.Width = 70;
        using (Bitmap bitMap = qrCode.GetGraphic(20))
        {
            using (MemoryStream ms = new MemoryStream())
            {
                bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                byte[] byteImage = ms.ToArray();
                imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
            }
            plBarCode.Controls.Add(imgBarCode);
        }

    }


}