ASP.NET

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Logic;

public partial class Portfolio : System.Web.UI.Page
{
     

    protected void Page_Load(object sender, EventArgs e)
    {
 
       if(!IsPostBack)
       {
            Includes obj = new Includes(); 
            string str2 = "select A.SCHEME_NAME ,B.SCHEME_NAV ,B.SCHEME_UNITS ,B.AMT_INVESTED ,B.FOLIO_ID  FROM NAV A,PORTFOLIO_MASTER B WHERE  B.USER_ID='" + Session["user_id"] + "' and b.scheme_id =a.scheme_code";
           DataSet ds1 = obj.getDataSet(str2);

            GridView1.DataSource = ds1;
            GridView1.DataBind(); 
      } 

        if (Request.QueryString["scheme_name"]!=null) 
        {
            Response.Write(Request.QueryString["scheme_name"]);
            Button2.Visible = true;
            Button1.Visible = false;

            
       
            Includes obj4 = new Includes();
			string sch_name = Request.QueryString["scheme_name"].ToString();
       

            string str="select scheme_code,scheme_name from nav where scheme_name ="+sch_name +"";
       
			DataSet ds6 = obj4.getDataSet(str);
			DataRow dr = ds6.Tables[0].Rows[0];
			txt_schname.Text= dr["scheme_name"].ToString();
			string s_id=dr["scheme_code"].ToString();

			string str1 = "select scheme_nav,scheme_units,amt_invested,folio_id,purchase_date from portfolio_master where scheme_id=" + s_id;


            DataSet ds8 = obj4.getDataSet(str1);
            DataRow dr1 = ds8.Tables[0].Rows[0];


             
          scheme_nav.Text = dr1["scheme_nav"].ToString();
          txt_units.Text = dr1["scheme_units"].ToString();
          txt_amt.Text = dr1["amt_invested"].ToString();
          txt_folio.Text = dr1["folio_id"].ToString();
          txt_purchasedate.Text = dr1["purchase_date"].ToString();

        
        }
       if (Session["user_id"] == "")
        {
            Response.Write(Session["user_id"]);
            Response.Redirect("home.aspx");
            Session["exp"] = "y";

        }
        else
        {
              // this.txt_purchasedate.Text = DateTime.Now.ToShortDateString();
            this.txt_purchasedate.DataBind();
            this.ImageButton1.Attributes.Add("onclick", "openPopUp('Cd.aspx')");
            txt_amt.Attributes.Add("onkeypress", "return OnlyNums(event,this.value);");
   
    }
          
        
    }

    protected void Page_LoadComplete(object sender, EventArgs e)
    {

    }     

     
    protected void Button1_Click(object sender, EventArgs e)
    {
        Includes obj3 = new Includes();
         
        float nav = Convert.ToSingle(scheme_nav.Text);
        float units = Convert.ToSingle(txt_units.Text);
        float amt = Convert.ToSingle(txt_amt.Text);
        string folio=txt_folio.Text.Trim();
        string remarks = txt_remarks.Text.ToString().Trim();
         
        string po_date = txt_purchasedate.Text.ToString().Trim();
     
        DateTime dt;
        dt = Convert.ToDateTime(po_date);
        string sc_name = txt_schname.Text .ToString().Trim ();

        string str = "select scheme_code,scheme_name  from nav where scheme_name='" + sc_name + "' ";
        DataSet ds = obj3.getDataSet(str);
        DataTable dt1 = ds.Tables[0];
        int cnt = dt1.Rows.Count;
        string sch_code = "";
        for(int i=0;i<cnt;i++)
        {
            sch_code = dt1.Rows[i]["scheme_code"].ToString().Trim();
        }
         


        DateTime dt2 = DateTime.Now;
        DateTime dd=new DateTime ();
      
        string s = dt2.ToShortDateString();
        
        dd = Convert.ToDateTime(s);
        
        string str1="insert into portfolio_master values ('"+Session["user_id"]+"','"+sch_code+"',"+nav +","+units +","+amt +",'"+dt +"','"+folio+"','"+remarks +"','" + dd +"')";
        obj3.executeQuery(str1);
        
        this.Server.Transfer("portfolio.aspx?update=y");

        GridView1.DataBind();
           

    }
    
    
    
    protected void ImageButton2_Click2(object sender, ImageClickEventArgs e)
    {
        Calendar1.Visible = true;
    }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        txt_purchasedate.Text = Calendar1.SelectedDate.ToString();
        Calendar1.Visible = false;
    }

    protected void ImageButton2_Click3(object sender, ImageClickEventArgs e)
    {
        Calendar1.Visible = true;
    }


    
     

     


    
    protected void Edit(object sender, GridViewEditEventArgs e)
        
    {
         
        Includes obj = new Includes();

        object obj14 = GridView1.Rows[e.NewEditIndex].Cells[0].Text;
        
        Response.Redirect("portfolio.aspx?scheme_name='" + obj14+"'");
    }
    
  }
    protected void Button2_Click(object sender, EventArgs e)
    {
    
         

        Response.Write(Request.QueryString["scheme_name"]);
        Response.Write(Session["user_id"]);
         Includes obj22 = new Includes();
 
         string sname = txt_schname.Text.ToString().Trim();
        float nav1 = Convert.ToSingle(scheme_nav.Text);
       
        float amt = Convert.ToSingle(txt_amt.Text);
        float units = Convert.ToSingle(txt_units.Text);
        DateTime dt5;
        dt5 = Convert.ToDateTime(txt_purchasedate.Text);

        string str4 = "update portfolio_master set scheme_nav= " + nav1 + " where scheme_id in(select scheme_code from nav where scheme_name='" + sname + "')";
       
        obj22.executeQuery(str4);
       
        TextBox1.Text = str4; 
        GridView1.DataBind();
        Button2.Visible = false;
        Button1.Visible = true;
       Response.Redirect("portfolio.aspx");
    }


    protected void scheme_nav_TextChanged(object sender, EventArgs e)
    {
        
        string ss = scheme_nav.Text.Trim();
        Response.Write(ss);
    }
}