protected void btnView_OnClick(object sender, EventArgs e)
 {
     dtinfo.ShortDatePattern = "dd/MM/yyyy";
     dtinfo.DateSeparator    = "/";
     if (rbtndate.Checked == true)
     {
         fillgrid("date", Convert.ToDateTime(txtDate.Text, dtinfo));
     }
     else if (rbtnFollowupDate.Checked == true)
     {
         fillgrid("nextdate", Convert.ToDateTime(txtDate.Text, dtinfo));
     }
     GridCounselling.Focus();
 }
 protected void Grid_OnselectedIndexChanged(object sender, EventArgs e)
 {
     if (GridCounselling.Rows.Count > 0)
     {
         pnlCounselling.Visible = true; pnlhome.Visible = false;
         fillProfile(Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString()));
         rbtnFollowupDate.Checked = true;
         SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(GridCounselling.SelectedRow.Cells[1].Text.ToString()) + "'", con);
         DataSet        ds = new DataSet();
         ad.Fill(ds);
         GridCounselling.DataSource = ds;
         GridCounselling.DataBind();
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
         {
             Response.Redirect("../Login.aspx");
         }
         else
         {
             if (!IsPostBack)
             {
                 dtinfo.ShortDatePattern = "dd/MM/yyyy";
                 dtinfo.DateSeparator    = "/";
                 pnlCounselling.Visible  = false;
                 rbtndate.Checked        = true;
                 maikal mk  = new maikal();
                 int    lvl = mk.returnlevel(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"]).ToString(), Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]).ToString());
                 txtDate.Text        = DateTime.Now.ToString("dd/MM/yyyy");
                 txtCurrentDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
                 SqlDataAdapter ad = new SqlDataAdapter("select * from Counselling where Date Between '" + Convert.ToDateTime(txtDate.Text, dtinfo).AddMonths(-1) + "' and '" + Convert.ToDateTime(txtDate.Text, dtinfo) + "'", con);
                 DataSet        ds = new DataSet();
                 ad.Fill(ds);
                 GridCounselling.DataSource = ds;
                 GridCounselling.DataBind();
                 GridCounselling.Focus();
             }
             if (rbtnFollowupDate.Checked == true)
             {
                 if (lblCID.Text.ToString() == null)
                 {
                     SqlDataAdapter ad = new SqlDataAdapter("select * from Followup where CID='" + Convert.ToInt32(lblCID.Text) + "'", con);
                     DataSet        ds = new DataSet();
                     ad.Fill(ds);
                     GridCounselling.DataSource = ds;
                     GridCounselling.DataBind();
                 }
             }
             btnView.Focus();
         }
     }
     catch (NullReferenceException ex)
     {
         Response.Redirect("../Login.aspx");
     }
 }
    private void fillgrid(string type, DateTime dt)
    {
        string qry = "";

        if (type == "date")
        {
            qry = "select * from Counselling where Date='" + dt + "'";
        }
        else if (type == "nextdate")
        {
            qry = "select * from Followup where FollowUpDate='" + dt + "'";
        }
        SqlDataAdapter ad = new SqlDataAdapter(qry, con);
        DataSet        ds = new DataSet();

        ad.Fill(ds);
        GridCounselling.DataSource = ds;
        GridCounselling.DataBind();
    }
    protected void btnSubmit_Onclick(object sender, EventArgs e)
    {
        con.Close();
        con.Open();
        dtinfo.DateSeparator    = "/";
        dtinfo.ShortDatePattern = "dd/MM/yyyy";
        SqlCommand cmd   = new SqlCommand("select max(CounsellingNo) from Followup where CID='" + lblCID.Text.ToString() + "'", con);
        int        inCid = Convert.ToInt32(cmd.ExecuteScalar());

        cmd = new SqlCommand("update Followup set Response=@Response,Comments=@Comments,Counselor=@Counselor where CID='" + Convert.ToInt32(lblCID.Text) + "' and CounsellingNo='" + inCid + "'", con);
        cmd.Parameters.AddWithValue("@Response", ddlResponse.SelectedValue.ToString());
        cmd.Parameters.AddWithValue("@Comments", txtdetail.Text.ToString());
        cmd.Parameters.AddWithValue("@Counselor", txtCounselor.Text.ToString());
        cmd.ExecuteNonQuery();

        cmd = new SqlCommand("insert into Followup(CounsellingNo,FollowUpDate,Response,Comments,Counselor,CID) Values(@CounsellingNo,@FollowUpDate,@Response,@Comments,@Counselor,@CID)", con);
        cmd.Parameters.AddWithValue("@CounsellingNo", inCid + 1);
        if (string.IsNullOrEmpty(txtNextDate.Text) || txtNextDate.Text == "")
        {
            cmd.Parameters.AddWithValue("@FollowUpDate", DBNull.Value);
        }
        else
        {
            cmd.Parameters.AddWithValue("@FollowUpDate", Convert.ToDateTime(txtNextDate.Text.ToString(), dtinfo));
        }
        //cmd.Parameters.AddWithValue("@FollowUpDate", Convert.ToDateTime(txtNextDate.Text.ToString(), dtinfo));
        cmd.Parameters.AddWithValue("@Response", ddlResponse.SelectedValue.ToString());
        cmd.Parameters.AddWithValue("@Comments", txtdetail.Text.ToString());
        cmd.Parameters.AddWithValue("@Counselor", txtCounselor.Text.ToString());
        cmd.Parameters.AddWithValue("@CID", Convert.ToInt32(lblCID.Text));
        cmd.ExecuteNonQuery();
        con.Close();
        GridCounselling.Focus();
        txtdetail.Text    = "";
        txtCounselor.Text = "";
    }