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 Microsoft.Reporting.WebForms;

public partial class Admin_Fee_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["officeAdmin"] != null)
            {
                CreateICard();
            }
        }
    }
    private DataSet GetSPResult()
    {
        DataSet ds = new DataSet();

        DataTable ResultsTable = new DataTable();

        //if(Request.QueryString["uid"]!=null)
        //{
        txterno.Text =Session["officeAdmin"].ToString();//Request.QueryString["uid"].ToString();
        //}
        SqlConnection conn = new SqlConnection(ConfigurationManager
          .ConnectionStrings["dbnewgsFMobConnectionString"].ConnectionString);
        try
        {
            SqlCommand cmd = new SqlCommand("select*from masterBranch where branchStatus=1 and branchcodeid="+ txterno.Text + "", conn);
            cmd.CommandType = CommandType.Text;
            //cmd.Parameters.AddWithValue("@id", txterno.Text);
            //cmd.Parameters.AddWithValue("@branchId", 1);
            //cmd.Parameters.AddWithValue("@sessionId", 1);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(ds);
        }

        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }

        return ds;
    }
    public void CreateICard()
    {
        DataSet ds1 = new DataSet();

        ds1 = GetSPResult();
       
        //ds1.Tables[0].Columns.Add("plBarCode", typeof(System.Byte[]));
        //ds1.Tables[0].Rows[0].SetField("plBarCode", stringtobyte(st));
        //   DataTable dt = GetSPResult();
        ReportViewer1.LocalReport.EnableExternalImages = true;
        ReportViewer1.LocalReport.ReportPath = "Report.rdlc";
        ReportViewer1.LocalReport.DataSources.Clear();
        //ReportDataSource datasourceI = new ReportDataSource("DataSet2", ds1.Tables[0]);
        ReportDataSource datasourceII = new ReportDataSource("DataSet8", ds1.Tables[0]);
        //ReportViewer1.LocalReport.DataSources.Add(datasourceI);
        ReportViewer1.LocalReport.DataSources.Add(datasourceII);
    }
    //protected void btnerno_Click1(object sender, EventArgs e)
    //{
    //    DataSet ds1 = new DataSet();

    //    ds1 = GetSPResult();
    //    //ds1.Tables[0].Columns.Add("plBarCode", typeof(System.Byte[]));
    //    //ds1.Tables[0].Rows[0].SetField("plBarCode", stringtobyte(st));
    //    //   DataTable dt = GetSPResult();
    //    ReportViewer1.LocalReport.EnableExternalImages = true;
    //    ReportViewer1.LocalReport.ReportPath = "Report3.rdlc";
    //    ReportViewer1.LocalReport.DataSources.Clear();
    //    //ReportDataSource datasourceI = new ReportDataSource("DataSet2", ds1.Tables[0]);
    //    ReportDataSource datasourceII = new ReportDataSource("DataSet4", ds1.Tables[0]);
    //    //ReportViewer1.LocalReport.DataSources.Add(datasourceI);
    //    ReportViewer1.LocalReport.DataSources.Add(datasourceII);
    //}
}