Friday, 8 November 2013

<%@ Page Language="C#" MasterPageFile="~/Worksheet.master"  AutoEventWireup="true" CodeFile="sisStudentWorksheet.aspx.cs" Inherits="sisStudentWorksheet" Title=":: SIS - Student Worksheet" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content2" runat="server"  ContentPlaceHolderID="Headers">
    <script type="text/javascript" src="js/ExpandAllCollapseAll.js"></script>
<script type="text/javascript">
    $(document).ready(function () {
        $(".toggle_container").hide();
        $("h2.expand_heading").toggle(function () {
            $(this).addClass("active");
        }, function () {
            $(this).removeClass("active");
        });
        $("h2.expand_heading").click(function () {
            $(this).next(".toggle_container").slideToggle("slow");
        });
        $(".expand_all").toggle(function () {
            $(this).addClass("expanded");
        }, function () {
            $(this).removeClass("expanded");
        });
        $(".expand_all").click(function () {
            $(".toggle_container").slideToggle("slow");
        });
    });
</script>
<style type="text/css">
    .Details
    {
        font-family:Verdana;
        font-size:11px;
        font-weight:bold;
    }
    .DetailsContent
    {
        font-family:Verdana;
        font-size:11px;
    }
  
</style>
<style type="text/css">
.modalBackground
{
background-color:#333333;

  filter:alpha(opacity=80);
  opacity:0.8;
}
.ModalWindow
{
  border: solid1px#c0c0c0;
  padding: 100px10px10px10px;
  position:fixed;

}
 </style>
<style type="text/css">
html {
    overflow-Y: scroll;
}
.wrapper {
    width: 600px;
    margin: 0 auto;
}
.expand_top,.expand_wrapper
{
    width: 600px;
    padding:0px;
    margin:0px 0px 5px 0px;
    float:left;
}
h1 {
    font: 4em normal Georgia, 'Times New Roman', Times, serif;
    text-align:center;
    padding: 20px 0;
    color: #ffffff;
}

h2.expand_heading {
    padding: 0 0 0 20px;
    margin: 0 0 5px 0;   
    width: 600px;   
    float: left;
}
.expand_all
{
cursor:default;
}
h2.expand_heading a {
    /*color: black;*/
    text-decoration: none;
    display: block;
}
h2.expand_heading a:hover
{
    /*color: #ccc;*/
}
h2.active {background-position: left bottom;}
.toggle_container {
    margin: 0 0 5px;
    padding: 0;
    border-top: 1px solid #d6d6d6;
    background: #ffffff;
    overflow: hidden;
    font-size: 1.2em;
    width: 600px;
    clear: both;
}
.toggle_container .box {
    padding: 5px;
}
.toggle_container .box p {
    padding: 5px 0;
    margin: 5px 0;
}
.toggle_container h3 {
    font: 2.0em normal Georgia, "Times New Roman", Times, serif;
    margin: 0 0 5px;
    padding: 0 0 5px 0;
    color:#000000;
    border-bottom: 1px dotted #ccc;
}
.toggle_container img {
    float: left;
    margin: 10px 15px 15px 0;
    padding: 5px;
    background: #ddd;
    border: 1px solid #ccc;
}
.expand_all
{
width:116px;
height:29px;
background:url(extra_buttons.png) no-repeat top left;
float:right;
cursor: pointer;
}
.expanded
{
background-position:bottom left;
}
</style>
<script type="text/javascript">
    function pageLoad() {
        $addHandler(document, 'keydown', onKeypress);     
        var mpe1 = $find("MPE1");
        mpe1.add_shown(onShown);
        var mpe2 = $find("MPE2");
        mpe2.add_shown(onShown2);
        var mpe3 = $find("MPE3");
        mpe3.add_shown(onShown3);
        var mpe4 = $find("MPE4");
        mpe4.add_shown(onShown4);
        var mpe5 = $find("MPE5");
        mpe5.add_shown(onShown5);
        var mpe6 = $find("MPE6");
        mpe6.add_shown(onShown6);
        var mpe7 = $find("MPE7");
        mpe7.add_shown(onShown7);
        var mpe8 = $find("MPE8");
        mpe8.add_shown(onShown8);
        var mpe9 = $find("MPE9");
        mpe9.add_shown(onShown9);
        var mpe10 = $find("MPE10");
        mpe10.add_shown(onShown10);
        var mpe11 = $find("MPE11");
        mpe11.add_shown(onShown11);
        var mpe12 = $find("MPE12");
        mpe12.add_shown(onShown12);
        var mpe13 = $find("MPE13");
        mpe13.add_shown(onShown13);
        var mpe14 = $find("MPE14");
        mpe14.add_shown(onShown14);
        var mpe15 = $find("MPE15");
        mpe15.add_shown(onShown15);
      
    }
    function onShown() {
        var background = $find("MPE1")._backgroundElement;
        background.onclick = function () {
            $find("MPE1").hide();
        }
    }
    function onShown2() {
        var background = $find("MPE2")._backgroundElement;
        background.onclick = function () {
            $find("MPE2").hide();
        }
    }
    function onShown3() {
        var background = $find("MPE3")._backgroundElement;
        background.onclick = function () {
            $find("MPE3").hide();
        }
    }
    function onShown4() {
        var background = $find("MPE4")._backgroundElement;
        background.onclick = function () {
            $find("MPE4").hide();
        }
    }
    function onShown5() {
        var background = $find("MPE5")._backgroundElement;
        background.onclick = function () {
            $find("MPE5").hide();
        }
    }
    function onShown6() {
        var background = $find("MPE6")._backgroundElement;
        background.onclick = function () {
            $find("MPE6").hide();
        }
    }
    function onShown7() {
        var background = $find("MPE7")._backgroundElement;
        background.onclick = function () {
            $find("MPE7").hide();
        }
    }
    function onShown8() {
        var background = $find("MPE8")._backgroundElement;
        background.onclick = function () {
            $find("MPE8").hide();
        }
    }
    function onShown9() {
        var background = $find("MPE9")._backgroundElement;
        background.onclick = function () {
            $find("MPE9").hide();
        }
    }
    function onShown10() {
        var background = $find("MPE10")._backgroundElement;
        background.onclick = function () {
            $find("MPE10").hide();
        }
    }
    function onShown11() {
        var background = $find("MPE11")._backgroundElement;
        background.onclick = function () {
            $find("MPE11").hide();
        }
    }
    function onShown12() {
        var background = $find("MPE12")._backgroundElement;
        background.onclick = function () {
            $find("MPE12").hide();
        }
    }
    function onShown13() {
        var background = $find("MPE13")._backgroundElement;
        background.onclick = function () {
            $find("MPE13").hide();
        }
    }
    function onShown14() {
        var background = $find("MPE14")._backgroundElement;
        background.onclick = function () {
            $find("MPE14").hide();
        }
    }
    function onShown15() {
        var background = $find("MPE15")._backgroundElement;
        background.onclick = function () {
            $find("MPE15").hide();
        }
    }
    function onKeypress(args) {
        if (args.keyCode == Sys.UI.Key.esc)
        {
            var mdl = $find('MPE1');
            var md2 = $find('MPE2');
            var md3 = $find('MPE3');
            var md4 = $find('MPE4');
            var md5 = $find('MPE5');
            var md6 = $find('MPE6');
            var md7 = $find('MPE7');
            var md8 = $find('MPE8');
            var md9 = $find('MPE9');
            var md10 = $find('MPE10');
            var md11 = $find('MPE11');
            var md12 = $find('MPE12');
            var md13 = $find('MPE13');
            var md14 = $find('MPE14');
            var md15 = $find('MPE15');
            if (mdl != null || md2 != null || md3 != null || md4 != null || md4 != null || md6 != null || md7 != null || md8 != null || md9 != null || md10 != null || md11 != null || md12 != null || md13 != null || md14 != null || md15 != null)
            {
                mdl.hide();
                md2.hide();
                md3.hide();
                md4.hide();
                md5.hide();
                md6.hide();
                md7.hide();
                md8.hide();
                md9.hide();
                md10.hide();
                md11.hide();
                md12.hide();
                md13.hide();
                md14.hide();
                md15.hide();

            }
        }
    }
    </script>
<style type="text/css">
.HideBackGround
{
background-color: #696969;
filter: alpha(opacity=40);
opacity: 0.7;
xindex:-1;
}
</style>
</asp:Content>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

 <table align ="center"  cellpadding="0" cellspacing="0" style=" border:1px solid #669999;" width="100%" height="100%">
<tr>
<td style="background-image: url(JupImages/tableheading2.gif); height: 25px" class="Pageheader">
<strong><span  class="TableHeader">
&nbsp; Student Worksheet / Assignments</span>
</strong>

</td>
</tr>
<tr>
<td style="height:20px;"></td>
</tr>   
<tr>
<td align="center" style="height: 10px">
<asp:Label ID="recMsgPat" runat="server" class="Details" style="color:Red "
Text="No Worksheet Information for this class" Visible="False"></asp:Label></td>
</tr>
<tr>
<td>
<div class="wrapper">
    <table id="tablesent" runat ="server">
    <tr>
    <td>      
    <div class="expand_top">
    <div class="expand_all">
    </div>
    </div>
    </td>
    </tr>   
 <tr>
    <td>
    <table width="100%" cellpadding="0" cellspacing="0" style="border:1px solid Gray">
    <tr>
    <td>
    <div style="margin-left:0px;width:630px"> 
   <table width="100%" cellpadding="0" cellspacing="0">
    <tr style="background-image: url(JupImages/tableheading2.gif); height:25px">
<td width="5%" class="Details" align="right">Sno</td> 
<td width="15%" class="Details" style="padding-left:25px">Posted On</td>
<td width="15%" class="Details" style="padding-left:20px">Posted By</td>
<td width="50%" class="Details" style="padding-left:20px">Worksheet Title</td>  
<td width="15%" class="Details" style="padding-left:50px">Open</td>   
</tr>
   </table>
   </div>
    </td>
    </tr>
    <tr>
    <td>
   <asp:Repeater id="rptWorksheet" runat="server"
            OnItemDataBound="rptWorksheet_ItemDataBound"
            onitemcommand="rptWorksheet_ItemCommand" >                                                  
<ItemTemplate>
<table width="100%" cellpadding="0" cellspacing="0">
<tr onmouseover="this.style.backgroundColor='Silver'" onmouseout="this.style.backgroundColor=''" valign="top">
<td width="90%">
 <div class="expand_wrapper">
<h2 class="expand_heading">
<a href="#">
<table width="100%">
<tr >
<td align="left"  valign="top" width="5%" style="font-family:Verdana; font-size:11px;" >
<asp:Label ID="lblsn" runat="server" Font-Bold="True" ForeColor="black"></asp:Label>
</td>  
<td align="left" width="15%" style="font-family:Verdana;font-size:10px;font-weight:bold;color:#000066">
<%#Eval("PostedDate")%>
</td>
<td align="left" width="15%" style="font-family:Verdana;font-size:10px;font-weight:bold;color:#000066">
<%#Eval("UserName")%>
</td>                                                      
<td align="left" width="50%" style="font-family:Verdana;font-size:10px;font-weight:bold;color:#000066">
<%#Eval("WorksheetTitle")%>
</td>
<td align="center" width="15%" style="font-family:Verdana;font-size:10px;font-weight:bold;color:#000066">

</td>
</tr>
</table>
</a>
</h2>
<div class="toggle_container">
    <div class="box">
    <table>
    <tr>
    <td style="padding-left:210px">
        <font style="font-family:Verdana;font-weight:bold;font-size:11px">Description :</font><br />
        <font style="font-family:Verdana;font-size:11px"><%#Eval("Description")%></font><br />
        <font style="font-family:Verdana;font-weight:bold;font-size:11px">File Name :</font>
        <asp:HyperLink ID="hpldwn" CssClass="Details" runat="server" NavigateUrl="" Text='<%# DataBinder.Eval(Container.DataItem, "worksheetfilename")%>'>
        </asp:HyperLink>
        <%--<asp:HyperLink ID="hpldwnWord" CssClass="Details" runat="server" NavigateUrl="" Text='<%# DataBinder.Eval(Container.DataItem, "worksheetfilename")%>'>></asp:HyperLink>--%>   
        <cc1:ModalPopupExtender ID="ModalPopupExtender1" runat="server"
    BackgroundCssClass="ModalBackground" CancelControlID="btnCancel" TargetControlID="hpldwn" PopupControlID="panOpen" 
    PopupDragHandleControlID="panOpen"   Enabled="false"> </cc1:ModalPopupExtender>
  
        </td>
        </tr>
        </table>
    </div>
</div>


</div>
</td>
<td width="10%">

<%--<a id="a_redirect" runat="server">--%>
<asp:ImageButton ID="img_open" runat="server" ImageUrl="~/JupImages/download.gif" CommandName="Download"/>
<%--</a>--%>

</td>
</tr>
<tr>
<td width="100%">
<asp:Panel ID="panOpen" runat="server" Height="550px" Width="800px" CssClass="ModalWindow" style="margin-top:10px;">
<table width="100%" style="height:100%;border:#000 2px solid;background-color:Gray" cellpadding="0" cellspacing="0">
<tr>
<td align="right" style="background-image: url(JupImages/tableheading2Modified.gif); height: 30px" >
<table width="100%">
<tr>
<td width="80%">
<asp:Label ID="lbl_PopUPHeader" runat="server" CssClass="Details" style="color:White"></asp:Label>
</td>
<td width="20%" align="right">
<asp:Image ID="btnCancel" runat="server" ImageUrl="~/NewImages/minus.png" />
</td>
</tr>
</table>

</td>
</tr>
<tr>
<td align="right"   >
<iframe id="Frame1" runat="server" scrolling="auto" height="550px" width="770px"></iframe>
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
</table>    
</ItemTemplate>

</asp:Repeater>
</td>

</tr>
</table>
 </td>
    </tr>
</table>
</div>
</td>
</tr>
<tr>
<td>
<table id="tblsentfooter" runat="server" border="0" cellpadding="0" cellspacing="0"
visible="false" width="652" >
<tr>
<td align="left" height="10">
</td>
</tr>
                               
                               
<tr>
<td style="padding-left:70px">
&nbsp;&nbsp;
<asp:Button ID="btnsentrefresh" runat="server" OnClick="btnsentrefresh_Click"
Text="Refresh" CssClass="submit btn primary-btn" /></td>
</tr>
</table>
</td>
</tr>
</table>

</asp:Content>





















using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using Telerik.Web.UI;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Jupsoft.sisPortal.BO;
using Jupsoft.sisPortal.Bll;
using Jupsoft.sisPortal.Dal;
using SISBusinessObject;
using System.IO;
using AjaxControlToolkit;

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

    SqlConnection sconn = new SqlConnection(AppConfiguration.ConnectionString);
    clsSchoolId objclid = new clsSchoolId();
    clsWorksheetAddEditManager objclsadedit = new clsWorksheetAddEditManager();
    string PageName = "";
    clsException objException = new clsException();
    protected void Page_Load(object sender, EventArgs e)
    {
        //Frame1.Attributes["src"] = "modal.aspx";
        PageName = objException.GetCurrentPageName();
        try
        {
            DataSet dsStnd = new DataSet();
            DataSet dsClassid = new DataSet();
            string uid = Convert.ToString(Session["msguserid"]);
            dsStnd = objclid.selectstandard(uid, Session["SchoolId"].ToString());
            if (dsStnd.Tables[0].Rows.Count < 0)
            {
                Response.Redirect("ErrorMessagePage.aspx");
            }
            else if (dsStnd.Tables[0].Rows.Count > 0)
            {

                string strstand = Convert.ToString(dsStnd.Tables[0].Rows[0][0]);
                //strstand = strstand.ToLower();
                dsClassid = objclid.selectclassidfromstandard(strstand, Session["SchoolId"].ToString());
                int classid = Convert.ToInt16(dsClassid.Tables[0].Rows[0][0]);
                Session["cid"] = classid;
            }
            if (!IsPostBack)
            {
                bindgridview();
            }
        }
        catch (Exception ex)
        {
            //objException.keepExceptionDetails(PageName, "Page_Load()", ex.Message);
            // Response.Redirect("SisError.aspx");
        }
    }
    public DataTable bindgridview()
    {
        DataTable dt = new DataTable();
        try
        {
            string scid = Convert.ToString(Session["SchoolId"]);
            dt = objclid.ShowDataFromWorksheet(scid, Convert.ToInt16(Session["cid"]), Convert.ToString(Session["Section"]));
            if (dt.Rows.Count <= 0)
            {
                recMsgPat.Visible = true;
                recMsgPat.Text = "No Worksheet Found For This Class";
                tablesent.Visible = false;
                tblsentfooter.Visible = false;
            }
            else
            {
                tblsentfooter.Visible = true;
                tablesent.Visible = true;
                rptWorksheet.DataSource = dt;
                rptWorksheet.DataBind();

            }
        }
        catch (Exception ex)
        {
            objException.keepExceptionDetails(PageName, "bindgridview()", ex.Message);
            Response.Redirect("SisError.aspx");
        }
        return dt;
    }

    private void GoToBack()
    {
        string strScript = "<script language ='javascript'>";
        strScript = strScript + "fnback();";
        strScript = strScript + "</script>";
        ClientScript.RegisterStartupScript(this.GetType(), "", strScript, false);
    }

    int i = 0;
    int j = 0;
    protected void rptWorksheet_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
        {

            Label lblsn = (Label)e.Item.FindControl("lblsn");
            i += 1;
            lblsn.Text = i.ToString();
            HyperLink Link = (HyperLink)e.Item.FindControl("hpldwn");
           // HyperLink LinkWord = (HyperLink)e.Item.FindControl("hpldwnWord");
            ImageButton img_Available = (ImageButton)e.Item.FindControl("img_open");
            string fname = "http://sisonline.in/Worksheet/" + (Session["SchoolId"]).ToString() + "/" + Link.Text;
            string filepath = "Worksheet/" + (Session["SchoolId"]).ToString() + "/" + Link.Text;
            bool available = File.Exists(Server.MapPath(filepath));
           
            if (available)
            {
                //if (Link.Text.Contains(".pdf"))
                //{
                    if (Request.Browser.Browser.Contains("Mozilla") || Request.Browser.Browser.Contains("Firefox"))
                    {
                        //LinkWord.Visible = false;                       
                        Link.ForeColor = System.Drawing.Color.Blue;                      
                        Link.Attributes["style"] = "cursor:pointer";                     
                        img_Available.Visible = true;
                        Link.NavigateUrl = fname;
                        Link.Target = "_blank";
                      
                    }
                    else
                    {
                        //LinkWord.Visible = false;
                        j += 1;
                        Link.ForeColor = System.Drawing.Color.Blue;
                        HtmlGenericControl control = (HtmlGenericControl)e.Item.FindControl("Frame1");
                        control.Attributes["src"] = fname;
                        ModalPopupExtender modal = (ModalPopupExtender)e.Item.FindControl("ModalPopupExtender1");
                        modal.Enabled = true;
                        modal.BehaviorID = "MPE" + j + "";
                        Link.Attributes["style"] = "cursor:pointer";
                        Label lbl_Header = (Label)e.Item.FindControl("lbl_PopUPHeader");
                        lbl_Header.Text = Link.Text;
                        img_Available.Visible = true;

                    }
                //}
                //else
                //{
                    //LinkWord.Visible = true;
                    //Link.Visible = false;
                    //LinkWord.ForeColor = System.Drawing.Color.Blue;
                    //LinkWord.Attributes["style"] = "cursor:pointer";
                    //LinkWord.NavigateUrl = fname;
                    //LinkWord.Target = "_blank";
                //}
            }
            else
            {
                Link.Text = "No Attachment";
                Link.ForeColor = System.Drawing.Color.Red;
                Link.Style.Add("text-decoration", "none");
                img_Available.Visible = false;
                //LinkWord.Visible = false;
            }
        }

    }

    protected void btnsentrefresh_Click(object sender, EventArgs e)
    {
        bindgridview();
    }

    protected void rptWorksheet_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandName == "Download")
        {
            //bindgridview();
            HyperLink Link = (HyperLink)e.Item.FindControl("hpldwn");
            string fname = "http://sisonline.in/Worksheet/" + (Session["SchoolId"]).ToString() + "/" + Link.Text;
            string filepath = "Worksheet/" + (Session["SchoolId"]).ToString() + "/" + Link.Text;
            if (Link.Text.Contains(".pdf"))
            {
                if (Request.Browser.Browser.Contains("Mozilla") || Request.Browser.Browser.Contains("Firefox"))
                {
                    Response.Write("<script>");
                    Response.Write("window.open('" + fname + "','height=300, width=250','_blank')");
                    Response.Write("</script>");
                }
                else
                {
                    HtmlGenericControl control = (HtmlGenericControl)e.Item.FindControl("Frame1");
                    control.Attributes["src"] = fname;
                    ModalPopupExtender modal = (ModalPopupExtender)e.Item.FindControl("ModalPopupExtender1");
                    modal.Enabled = true;
                    //modal.BehaviorID = "MPE1";
                    Label lbl_Header = (Label)e.Item.FindControl("lbl_PopUPHeader");
                    lbl_Header.Text = Link.Text;
                    modal.Show();
                }
            }
            else
            {

                Response.Write("<script>");
                Response.Write("window.open('" + fname + "','height=300, width=250','_blank')");
                Response.Write("</script>");
                //HtmlAnchor anchor = (HtmlAnchor)e.Item.FindControl("a_redirect");
                //anchor.HRef = fname;
                //anchor.Target = "_blank";
               

            }
          
        }
    }   
}



http://www.aspsnippets.com/Articles/ASPNet-Nested-GridViews-GridView-inside-GridView-with-Expand-and-Collapse-feature.aspx


http://www.aspdotnet-suresh.com/2012/05/gridview-with-in-gridview-or-nested.html


http://forums.asp.net/p/1673163/4385339.aspx?Re+Javascript+ASP+expand+collapse+nested+gridview


http://mosesofegypt.net/post/Building-a-grouping-Grid-with-GridView-and-ASPNET-AJAX-toolkit-CollapsiblePanel.aspx
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)