Пример #1
0
    public void BindStudentDetailsGrid()
    {
        string[] stringdate1 = new string[3];
        if (TxtFromDate.Text != "")
        {
            stringdate1 = TxtFromDate.Text.Split('/');
        }
        else
        {
            stringdate1 = "01/01/1990".Split('/');
        }
        DateTime FromDate = new DateTime(Convert.ToInt32(stringdate1[2]), Convert.ToInt32(stringdate1[1]), Convert.ToInt32(stringdate1[0]));


        string[] stringdate2 = new string[3];
        if (txtTodate.Text != "")
        {
            stringdate2 = txtTodate.Text.Split('/');
        }
        else
        {
            stringdate2 = "01/01/1990".Split('/');
        }
        stringdate2 = txtTodate.Text.Split('/');

        String Operation = "";

        if (DrpReportOption.SelectedValue == "BOOK ISSUANCE")
        {
            Operation = "BOOK ISSUANCE";
        }
        else if (DrpReportOption.SelectedValue == "BOOKS NOTCOLLECTED")
        {
            Operation = "BOOKS NOTCOLLECTED";
        }
        else if (DrpReportOption.SelectedValue == "BOOKS RETURN STATUS")
        {
            Operation = "BOOKS RETURN STATUS";
        }
        else if (DrpReportOption.SelectedValue == "REFERENCE BOOKS UTILIZATION")
        {
            Operation = "REFERENCE BOOKS UTILIZATION";
        }
        else if (DrpReportOption.SelectedValue == "ALL BOOKS RETURN STATUS")
        {
            Operation = "BOOK ISSUANCE";
        }
        else if (DrpReportOption.SelectedValue == "TRANSACTION DETAILS")
        {
            Operation = "TRANSACTION DETAILS";
        }
        else if (DrpReportOption.SelectedValue == "BOOKS NOT RETURNED")
        {
            Operation = "BOOKS NOT RETURNED";
        }

        DateTime EndDate = new DateTime(Convert.ToInt32(stringdate2[2]), Convert.ToInt32(stringdate2[1]), Convert.ToInt32(stringdate2[0]));

        DataTable Dtb = P.BindFortNightlyReportStudentDetails(FromDate, EndDate, Operation, Convert.ToInt32(DrpProgram.SelectedValue),
                                                              Convert.ToInt32(DrpCurriculum.SelectedValue), Convert.ToInt32(DrpSemester.SelectedValue),
                                                              DDLBookType.SelectedValue, DrpUserType.SelectedValue, RdbReportOption.SelectedValue);

        GrvDetails.DataSource = Dtb;
        GrvDetails.DataBind();
    }