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 Renewal11 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
    SqlCommand cmd;
    public Int32 i = 1;
    clsBLSetup obj;
    PRPSetup objprp;

    Int32 total = 0, MaxMarks = 0, MinMarks = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        if(IsPostBack!=true)
        {
            DataSet ds1 = new DataSet();

            ds1 = GetSPResult();
            ReportViewer1.Visible = true;
            ReportViewer1.LocalReport.ReportPath = "Report.rdlc";
            ReportViewer1.LocalReport.DataSources.Clear();
            ReportViewer1.LocalReport.EnableExternalImages = true;
            ReportDataSource datasourceI = new ReportDataSource("DataSet1", ds1.Tables[1]);
            //ReportDataSource datasourceII = new ReportDataSource("DataSet2", ds1.Tables[1]);
            ReportViewer1.LocalReport.DataSources.Add(datasourceI);
            //ReportViewer1.LocalReport.DataSources.Add(datasourceII);
        }
        if (Session["OfficeAdmin"] == null)
        {
            //Response.Redirect("../../Default.aspx?logout=session&path=employee/printPage.aspx");

        }
       

        try
        {
            if (Page.IsPostBack == false)
            {
                GetData();
            }
            lkprint.Attributes.Add("onClick", "printSpecial()");
        }
        catch (Exception ex)
        {
            Label1.Visible = true;
            Label1.Text = ex.Message.ToString();
        }
        
    }
    private DataSet GetSPResult()
    {
        DataSet ds = new DataSet();

        DataTable ResultsTable = new DataTable();


        SqlConnection conn = new SqlConnection(ConfigurationManager
          .ConnectionStrings["cn"].ConnectionString);

        try
        {
            SqlCommand cmd = new SqlCommand("viewBranchRenewal", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@id", 9579);
            cmd.Parameters.AddWithValue("@status", -1);
            cmd.Parameters.AddWithValue("@date", "2019-01-01");
            cmd.Parameters.AddWithValue("@brdId",5);
        
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(ds);
        }

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

        return ds;
    }


    protected void btnerno_Click1(object sender, EventArgs e)
    {
        


    }

    public void GetData()
    {
        clsBLSetup obj = new clsBLSetup();

        try
        {

        SqlDataAdapter adp = new SqlDataAdapter("viewBranchRenewal", con);
            if (Request.QueryString["Id"] != null)
            {
                adp.SelectCommand.Parameters.AddWithValue("@brdId", Request.QueryString["Id"].ToString());
                adp.SelectCommand.Parameters.AddWithValue("@id", Request.QueryString["branchId"].ToString());
                adp.SelectCommand.Parameters.AddWithValue("@status", "-1");
            }

            adp.SelectCommand.CommandType = CommandType.StoredProcedure;
            DataSet ds = new DataSet();
            adp.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {

                lblCode.Text = ds.Tables[0].Rows[0]["branchCode"].ToString();
                lblName.Text = ds.Tables[0].Rows[0]["branchContactPerson"].ToString();
                lblAddress.Text = ds.Tables[0].Rows[0]["branchAddress"].ToString();
                lblEmailID.Text = ds.Tables[0].Rows[0]["branchEmail"].ToString();
                lblPhoneNo.Text = ds.Tables[0].Rows[0]["branchPhone"].ToString();  
                lblBranchName.Text = ds.Tables[0].Rows[0]["branchName"].ToString();
                lblSDate.Text = ds.Tables[0].Rows[0]["brdStartDate"].ToString();
                lblEDate.Text = ds.Tables[0].Rows[0]["brdEndDate"].ToString();
     
            }
                       
            }
                  
        catch (Exception ex)
        {
            Label1.Visible = true;
            Label1.Text = ex.Message.ToString();
        }
        // return ds;

    }



    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();
    }

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

    }
}