public DataTable GetPhysicalPath(PlReports plRpt)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plRpt.Ind);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable GetRptFoilCFValidity(PlReports plRpt)
{
cmd = new SqlCommand("SPReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plRpt.Ind);
//cmd.Parameters.AddWithValue("@RptInd", plRpt.RptInd);
//cmd.Parameters.AddWithValue("@ExamYear", plRpt.ExamYear);
//cmd.Parameters.AddWithValue("@Session", plRpt.Session);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable GetReport(PlReports plRpt)
{
cmd = new SqlCommand("SPReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plRpt.Ind);
//cmd.Parameters.AddWithValue("@RptInd", plRpt.RptInd);
cmd.Parameters.AddWithValue("@DateFrom", plRpt.DateFrom);
cmd.Parameters.AddWithValue("@DateTo", plRpt.DateTo);
cmd.CommandTimeout = 0;
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
internal DataTable ShowRegAllotedStatus(PlReports PlRpt)
{
cmd = new SqlCommand("SPReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 10000;
cmd.Parameters.AddWithValue("@Ind", PlRpt.Ind);
cmd.Parameters.AddWithValue("@RptInd", PlRpt.RptInd);
cmd.Parameters.AddWithValue("@ExamYear", PlRpt.ExamYear);
cmd.Parameters.AddWithValue("@SessionType", Convert.ToInt16(PlRpt.Session));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
internal DataTable ShowErrorValidity(PlReports plrep)
{
cmd = new SqlCommand("SPReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 10000;
cmd.Parameters.AddWithValue("@Ind", plrep.Ind);
int EntryByRegNo = Convert.ToInt32(plrep.EntryByRegNo);
cmd.Parameters.AddWithValue("@EntryByRegNo", EntryByRegNo);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ShowRegister(PlReports plrep)
{
cmd = new SqlCommand("SPReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plrep.Ind);
int session = Convert.ToInt32(plrep.Session);
int Year = Convert.ToInt32(plrep.ExamYear);
cmd.Parameters.AddWithValue("@SessionType", session); //Convert.ToInt32(plrep.Session));@SessionType
cmd.Parameters.AddWithValue("@ExamYear", Year); //Convert.ToInt32(plrep.ExamYear));ExamYear
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
internal DataTable ErroInDuplicateEntry(PlReports PlRpt)
{
cmd = new SqlCommand("SPDataValidity", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 10000;
cmd.Parameters.AddWithValue("@RptInd", PlRpt.RptInd);
cmd.Parameters.AddWithValue("@Ctrls", PlRpt.Ctrls);
cmd.Parameters.AddWithValue("@AllCtrls", PlRpt.AllCtrls);
cmd.Parameters.AddWithValue("@ExamYear", PlRpt.ExamYear);
cmd.Parameters.AddWithValue("@ExamSessionID", Convert.ToInt16(PlRpt.Session));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
DataTable BindMissingPageNo()
{
PlRpt = new PlReports()
{
RptInd = 4,
ExamYear = ddlExamYear.SelectedItem.Text,
Session = ddlSession.SelectedIndex.ToString(),
AllCtrls = cbSelectAll.Checked ? true : false,
Ctrls = cbSelectAll.Checked ? "" : Register.Value,
};
dt = new DataTable();
dt = BlRpt.ErroInDuplicateEntry(PlRpt);
if (dt.Rows.Count > 0)
{
gvMissingPage.DataSource = dt;
gvMissingPage.DataBind();
tblGvMissingPage.Visible = true;
}
return(dt);
}
DataTable BindWrongRollNo()
{
PlRpt = new PlReports()
{
RptInd = ddlValidityReport.SelectedIndex == 3 ? 3 : 5, //RptInd: 3 For Duplicate Roll No / 5 For Roll Length > 5.
ExamYear = ddlExamYear.SelectedItem.Text,
Session = ddlSession.SelectedIndex.ToString(),
AllCtrls = cbSelectAll.Checked ? true : false,
Ctrls = cbSelectAll.Checked ? "" : Register.Value,
};
dt = new DataTable();
dt = BlRpt.ErroInDuplicateEntry(PlRpt);
if (dt.Rows.Count > 0)
{
gvWrongRollNo.DataSource = dt;
gvWrongRollNo.DataBind();
tblGvWrongRollEntry.Visible = true;
}
return(dt);
}
protected void btnShow_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (ddlExamYear.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Exam Name";
return;
}
if (ddlSession.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Exam Session";
return;
}
PlRpt = new PlReports()
{
Ind = 14,
ExamYear = ddlExamYear.SelectedItem.Text,
Session = ddlSession.SelectedIndex.ToString(),
RptInd = rbFilterStatus.SelectedIndex + 1,
};
dt = BlRpt.ShowRegAllotedStatus(PlRpt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
//dr[0] = 0;
dr[1] = dt.Rows.Count;
//dr[2] = "";
dt.Rows.Add(dr);
gvAllotmentStatus.DataSource = dt;
gvAllotmentStatus.DataBind();
//ArrangeGrid();
divGrid.Visible = true;
grdHeader.Text = "Status For " + rbFilterStatus.SelectedItem.Text + " Registers";
}
}
public DataTable ShowRegAllotedStatus(PlReports PlRpt)
{
return(dlRpt.ShowRegAllotedStatus(PlRpt));
}
public DataTable GetExamYear(PlReports plRpt)
{
return(dlRpt.GetExamYear(plRpt));
}
public DataTable GetExamSession(PlReports plrep)
{
return(dlRpt.GetExamSession(plrep));
}
public DataTable MISReport(PlReports plrep)
{
return(dlRpt.MISReport(plrep));
}
public DataTable GetPhysicalPath(PlReports plRpt)
{
return(dlRpt.GetPhysicalPath(plRpt));
}
public DataTable GetRptFoilCFValidity(PlReports plRpt)
{
return(dlRpt.GetRptFoilCFValidity(plRpt));
}
public DataTable GetReport(PlReports plRpt)
{
return(dlRpt.GetReport(plRpt));
}
public DataTable ShowRegister(PlReports plrep)
{
return(dlRpt.ShowRegister(plrep));
}
public DataTable ErroInDuplicateEntry(PlReports PlRpt)
{
return(dlRpt.ErroInDuplicateEntry(PlRpt));
}
public DataTable ShowErrorValidity(PlReports plrep)
{
return(dlRpt.ShowErrorValidity(plrep));
}