public void BindGrid()
{
DataTable DTB = P.BookReturnDueDateEntry("SelectAll");
GrvDetails.DataSource = DTB;
GrvDetails.DataBind();
}
public void BindGrid()
{
DataTable DTB = P.INSERTBOOKPRICE("SELECT", 0, DateTime.Now, 0, Convert.ToInt32(Session["UserId"]));
GrvDetails.DataSource = DTB;
GrvDetails.DataBind();
}
public void BindGrid()
{
DataTable DTB = P.INSERTCOURSEMAPPING("SELECT", 0, 0, "", "", DateTime.Now, 0);
GrvDetails.DataSource = DTB;
GrvDetails.DataBind();
}
public void LoadEMailData(int Id)
{
String DueDateForMail = Session["Duedateforemail"].ToString();
DataSet Ds = P.LoadEMailData("LoadEMailData", DueDateForMail, Id, ddlUserType.SelectedValue.ToString());
if (Ds != null && Ds.Tables[0].Rows.Count > 0)
{
TxtSemester.Text = Convert.ToString(Ds.Tables[0].Rows[0]["Semester"]);
TxtDueDate.Text = Convert.ToDateTime(Ds.Tables[0].Rows[0]["DueDate"]).ToString("dd/MM/yyyy");
}
if (Ds != null && Ds.Tables[1].Rows.Count > 0)
{
GrvDetails.DataSource = Ds.Tables[1];
GrvDetails.DataBind();
}
}
//public void LoadBookValidityReport()
//{
// System.IO.MemoryStream stream1 = new System.IO.MemoryStream();
// try
// {
// string Path = Server.MapPath("BooksValidity.rpt");
// Path = Path.Substring(0, Path.LastIndexOf('\\'));
// Path = Path.Substring(0, Path.LastIndexOf('\\'));
// Path = Path + "\\Reports\\BooksValidity.rpt";
// myReportDocument.Load(Path);
// myReportDocument.SetParameterValue("@copyrightdate", 0);
// myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea");
// System.IO.Stream oStream = null;
// byte[] byteArray = null;
// oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
// byteArray = new byte[oStream.Length];
// oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
// Response.ClearContent();
// Response.ClearHeaders();
// Response.ContentType = "application/pdf";
// Response.BinaryWrite(byteArray);
// Response.Flush();
// Response.Close();
// myReportDocument.Close();
// myReportDocument.Dispose();
// GC.Collect();
// }
// catch (Exception Ex)
// {
// }
// finally
// {
// }
//}
//public void LoadBookBookIssueSummary()
//{
// System.IO.MemoryStream stream1 = new System.IO.MemoryStream();
// try
// {
// DateTime DtFromDate = new DateTime();
// DateTime DtToDate = new DateTime();
// DtFromDate = FromDate(TxtFromDate);
// DtToDate = FromDate(txtTodate);
// string Path = Server.MapPath("BOOKISSUESUMMARY.rpt");
// Path = Path.Substring(0, Path.LastIndexOf('\\'));
// Path = Path.Substring(0, Path.LastIndexOf('\\'));
// Path = Path + "\\Reports\\BOOKISSUESUMMARY.rpt";
// myReportDocument.Load(Path);
// myReportDocument.SetParameterValue("@FromDate", DtFromDate);
// myReportDocument.SetParameterValue("@ToDate", DtToDate);
// myReportDocument.SetParameterValue("@DegreeTypeID", ddlDegreeType.SelectedValue);
// myReportDocument.SetParameterValue("@CurriculumID", ddlCurriculum.SelectedValue);
// myReportDocument.SetParameterValue("@School", ddlSchools.SelectedValue);
// myReportDocument.SetDatabaseLogon("software", "DelFirMENA$idea");
// System.IO.Stream oStream = null;
// byte[] byteArray = null;
// oStream = myReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
// byteArray = new byte[oStream.Length];
// oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
// Response.ClearContent();
// Response.ClearHeaders();
// Response.ContentType = "application/pdf";
// Response.BinaryWrite(byteArray);
// Response.Flush();
// Response.Close();
// myReportDocument.Close();
// myReportDocument.Dispose();
// GC.Collect();
// }
// catch (Exception Ex)
// {
// }
// finally
// {
// }
//}
public void BindGrid()
{
DateTime DtFromDate = new DateTime();
DateTime DtToDate = new DateTime();
DtFromDate = FromDate(TxtFromDate);
DtToDate = FromDate(txtTodate);
//if (RbtCancelledStudent.Checked)
if (DrpReportOption.SelectedValue == "CANCELLED STUDENTS")
{
Dtb = S.BindCancelledStudentsReport(DtFromDate, DtToDate, ddlSchools.SelectedValue, Convert.ToInt32(ddlDegreeType.SelectedValue), Convert.ToInt32(ddlDegreeCode.SelectedValue));
GrvDetails.DataSource = Dtb;
GrvDetails.DataBind();
LoadExcel();
}
//else if (RbtBookValidity.Checked)
else if (DrpReportOption.SelectedValue == "BOOK VALIDITY")
{
Dtb = S.BindBooksValidityReport(Convert.ToInt32(ddlCopyrightFromDate.SelectedValue));
GrvDetails.DataSource = Dtb;
GrvDetails.DataBind();
LoadExcel();
}
else if (DrpReportOption.SelectedValue == "BOOK ISSUE SUMMARY")
{
Dtb = S.BindBookIssueSummaryReport(DtFromDate, DtToDate, ddlSchools.SelectedValue, Convert.ToInt32(ddlDegreeType.SelectedValue), Convert.ToInt32(ddlCurriculum.SelectedValue));
GrvDetails.DataSource = Dtb;
GrvDetails.DataBind();
LoadExcel();
}
else if (DrpReportOption.SelectedValue == "BOOKS NOT COLLECTED STATISTICS")
{
Dtb = S.BindBookNotCollectStatsticsReport(DtFromDate, DtToDate, ddlSchools.SelectedValue, Convert.ToInt32(ddlDegreeType.SelectedValue), Convert.ToInt32(ddlCurriculum.SelectedValue));
GrvDetails.DataSource = Dtb;
GrvDetails.DataBind();
LoadExcel();
}
}
public void BindGrid()
{
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.BindFortNightlyReport(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();
}