protected void btnView_Click(object sender, EventArgs e)
{
string date1 = string.Empty;
date1 = txtFromDate.Text.ToString();
DateTime dt1 = new DateTime();// Convert.ToDateTime(datefrom.ToString());
bool isValidDate = DateTime.TryParseExact(date1, "dd/MM/yyyy", null, DateTimeStyles.None, out dt1);
FpSpread1.Visible = false;
string SelectQ = "select distinct (c.Course_Name+'-'+de.Dept_Name) as courceName,r.Batch_Year,r.degree_code,COUNT(r.app_no) as totalStudent from Registration r,Degree d,course c,Department de,doubledayorder do where r.degree_code=d.Degree_Code and de.Dept_Code=d.Dept_Code and c.Course_Id=d.Course_Id and d.Degree_Code=do.degreeCode and r.Batch_Year=do.batchYear and do.doubledate='" + dt1.ToString("MM/dd/yyyy") + "' and r.college_code=c.college_code and d.college_code=de.college_code and d.college_code=c.college_code and r.college_code='" + Convert.ToString(ddlCollege.SelectedValue) + "' and CC=0 and DelFlag =0 and Exam_Flag <>'DEBAR' and delflag=0 group by (c.Course_Name+'-'+de.Dept_Name),r.Batch_Year,r.degree_code order by (c.Course_Name+'-'+de.Dept_Name),r.Batch_Year,r.degree_code,totalStudent";
DataTable dtsaveDate = dirAcc.selectDataTable(SelectQ);
if (dtsaveDate.Rows.Count > 0)
{
int sno = 0;
FpSpread1.Visible = true;
//lblexportxl.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].SheetCorner.ColumnCount = 0;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.Sheets[0].ColumnCount = 5;
FpSpread1.Sheets[0].Columns[0].Width = 70;
FpSpread1.Sheets[0].Columns[1].Width = 100;
FpSpread1.Sheets[0].Columns[2].Width = 250;
FpSpread1.Sheets[0].Columns[3].Width = 100;
//FpSpread1.Sheets[0].Columns[4].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Batch Year";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Department Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Student Count";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = System.Drawing.Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].RowCount = 0;
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].RowCount = FpSpread1.Sheets[0].RowCount + 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = chkcell1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, 4);
chkcell1.AutoPostBack = true;
FpSpread1.Sheets[0].FrozenRowCount = 1;
FpSpread1.Sheets[0].AutoPostBack = false;
foreach (DataRow dr in dtsaveDate.Rows)
{
string BatchYear = Convert.ToString(dr["batch_year"]).Trim();
string DegreeCode = Convert.ToString(dr["degree_code"]).Trim();
string CourceName = Convert.ToString(dr["courceName"]).Trim();
string torstudent = Convert.ToString(dr["totalStudent"]).Trim();
sno++;
FpSpread1.Sheets[0].RowCount = FpSpread1.Sheets[0].RowCount + 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = sno.ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = BatchYear;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = CourceName;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Note = DegreeCode;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = torstudent;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = chkcell;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
}
FpSpread1.Visible = true;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
FpSpread1.Width = 540;
FpSpread1.Height = 400;
Btndelete.Visible = true;
Div1.Visible = true;
}
else
{
Div1.Visible = false;
Btndelete.Visible = false;
}
btnSave.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["collegecode"] == null) //Aruna For Back Button
{
Response.Redirect("~/Default.aspx");
}
if (!IsPostBack)
{
if (flag == 0)
{
flag = 1;
CollegeCode = Session["CollegeCode"].ToString();
Session["Stud_Type1"] = "0";
Session["Stud_Type"] = "0";
Master1 = "select * from Master_Settings where usercode=" + Session["usercode"] + "";
setcon.Close();
setcon.Open();
SqlDataReader mtrdr;
Session["Rollflag"] = "0";
Session["Regflag"] = "0";
Session["Studflag"] = "0";
SqlCommand mtcmd = new SqlCommand(Master1, setcon);
mtrdr = mtcmd.ExecuteReader();
{
if (mtrdr.HasRows)
{
while (mtrdr.Read())
{
if (mtrdr["settings"].ToString() == "Roll No" && mtrdr["value"].ToString() == "1")
{
Session["Rollflag"] = "1";
}
if (mtrdr["settings"].ToString() == "Register No" && mtrdr["value"].ToString() == "1")
{
Session["Regflag"] = "1";
}
if (mtrdr["settings"].ToString() == "Student_Type" && mtrdr["value"].ToString() == "1")
{
Session["Studflag"] = "1";
}
if (mtrdr["settings"].ToString() == "Day Scholar" && mtrdr["value"].ToString() == "1")
{
Session["Stud_Type"] = "Day Scholar";
}
if (mtrdr["settings"].ToString() == "Hostel" && mtrdr["value"].ToString() == "1")
{
Session["Stud_Type1"] = "Hostler";
}
}
}
}
//individualsubstud.Sheets[0].AutoPostBack = true;
HAllSpread.Sheets[0].RowHeader.Visible = false;
HAllSpread.Sheets[0].ColumnCount = 10;
HAllSpread.Sheets[0].Columns[0].Locked = true;
HAllSpread.Sheets[0].Columns[1].Locked = true;
HAllSpread.Sheets[0].Columns[2].Locked = true;
HAllSpread.Sheets[0].Columns[3].Locked = true;
HAllSpread.Sheets[0].Columns[4].Locked = true;
HAllSpread.Sheets[0].Columns[5].Locked = true;
HAllSpread.Sheets[0].Columns[6].Locked = true;
HAllSpread.Sheets[0].Columns[7].Locked = true;
HAllSpread.Sheets[0].Columns[8].Locked = true;
HAllSpread.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
HAllSpread.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
HAllSpread.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
HAllSpread.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
HAllSpread.Sheets[0].RowCount = 0;
HAllSpread.Sheets[0].Columns[0].Width = 40;
HAllSpread.Sheets[0].Columns[1].Width = 40;
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
HAllSpread.Sheets[0].Columns[9].CellType = chkcell;
HAllSpread.Sheets[0].Columns[9].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].RowCount = HAllSpread.Sheets[0].RowCount + 1;
HAllSpread.Sheets[0].SpanModel.Add(HAllSpread.Sheets[0].RowCount - 1, 0, 1, 6);
HAllSpread.Sheets[0].Cells[HAllSpread.Sheets[0].RowCount - 1, 9].CellType = chkcell;
HAllSpread.Sheets[0].Cells[HAllSpread.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].FrozenRowCount = 1;
chkcell.AutoPostBack = true;
HAllSpread.Sheets[0].SheetCorner.RowCount = 2;
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 5, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 9, 2, 1);
HAllSpread.Sheets[0].ColumnHeaderSpanModel.Add(0, 6, 1, 3);
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Year";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Degree";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Course";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Sem";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Subjects";
HAllSpread.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Students";
HAllSpread.Sheets[0].ColumnHeader.Cells[1, 6].Text = "Regular";
HAllSpread.Sheets[0].ColumnHeader.Cells[1, 7].Text = "Arrear";
HAllSpread.Sheets[0].ColumnHeader.Cells[1, 8].Text = "Total";
HAllSpread.Sheets[0].ColumnHeader.Cells[1, 9].Text = "Select";
HAllSpread.Sheets[0].Columns[0].Width = 60;
HAllSpread.Sheets[0].Columns[1].Width = 60;
HAllSpread.Sheets[0].Columns[2].Width = 80;
HAllSpread.Sheets[0].Columns[3].Width = 150;
HAllSpread.Sheets[0].Columns[4].Width = 60;
HAllSpread.Sheets[0].Columns[5].Width = 150;
HAllSpread.Sheets[0].Columns[6].Width = 100;
HAllSpread.Sheets[0].Columns[7].Width = 100;
HAllSpread.Sheets[0].Columns[8].Width = 100;
HAllSpread.Sheets[0].Columns[9].Width = 60;
HAllSpread.Sheets[0].Columns[5].Font.Size = FontUnit.Medium;
HAllSpread.Sheets[0].Columns[5].Font.Underline = true;
HAllSpread.Sheets[0].Columns[5].ForeColor = Color.Blue;
HAllSpread.Sheets[0].Columns[5].Font.Size = FontUnit.Medium;
HAllSpread.Sheets[0].AutoPostBack = false;
HAllSpread.CommandBar.Visible = false;
SqlCommand cmd = new SqlCommand("ProcExamTimeTableSelectSubjectData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CollegeCode", CollegeCode);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet examds = new DataSet();
da.Fill(examds);
HAllSpread.Sheets[0].RowCount = 2;
int count;
int countp;
int countA;
int countAP;
int Sno = 0;
string Temp = "";
string Arear = "0";
string Regular = "0";
if (examds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < examds.Tables[0].Rows.Count; i++)
{
SqlCommand cd = new SqlCommand("ProcExamTimeTableCount", con);
cd.CommandType = CommandType.StoredProcedure;
cd.Parameters.AddWithValue("@DegreeCode", examds.Tables[0].Rows[i]["DegreeCode"].ToString());
cd.Parameters.AddWithValue("@BatchYear", examds.Tables[0].Rows[i]["BatchYear"].ToString());
cd.Parameters.AddWithValue("@Semester", examds.Tables[0].Rows[i]["Semester"].ToString());
cd.Parameters.AddWithValue("@CollegeCode", CollegeCode);
SqlDataAdapter da1 = new SqlDataAdapter(cd);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
if (ds1.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds1.Tables[0].Rows.Count; j++)
{
if (Temp != examds.Tables[0].Rows[i]["Department"].ToString())
{
Sno = Sno + 1;
}
count = HAllSpread.Sheets[0].RowCount - 1;
HAllSpread.Sheets[0].Cells[count, 0].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[count, 4].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[count, 6].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[count, 7].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[count, 8].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[count, 0].Text = Sno.ToString();
HAllSpread.Sheets[0].Cells[count, 1].Text = examds.Tables[0].Rows[i]["Year"].ToString();
HAllSpread.Sheets[0].Cells[count, 1].Note = examds.Tables[0].Rows[i]["BatchYear"].ToString();
HAllSpread.Sheets[0].Cells[count, 2].Text = examds.Tables[0].Rows[i]["Course"].ToString();
HAllSpread.Sheets[0].Cells[count, 3].Text = examds.Tables[0].Rows[i]["Department"].ToString();
HAllSpread.Sheets[0].Cells[count, 3].Note = examds.Tables[0].Rows[i]["deptacronym"].ToString();
HAllSpread.Sheets[0].Cells[count, 4].Text = examds.Tables[0].Rows[i]["Semester"].ToString();
HAllSpread.Sheets[0].Cells[count, 5].Text = ds1.Tables[0].Rows[j]["SubjectName"].ToString();
HAllSpread.Sheets[0].Cells[count, 5].Note = ds1.Tables[0].Rows[j]["SubjectNo"].ToString();
HAllSpread.Sheets[0].Cells[count, 5].Tag = 0;
HAllSpread.Sheets[0].Rows[count].ForeColor = Color.Blue;
HAllSpread.Sheets[0].Cells[count, 6].Text = ds1.Tables[0].Rows[j]["RegularTheoryCount"].ToString();
HAllSpread.Sheets[0].Cells[count, 7].Text = Arear.ToString();
HAllSpread.Sheets[0].Cells[count, 8].Text = Convert.ToString(Convert.ToInt16(ds1.Tables[0].Rows[j]["RegularTheoryCount"].ToString()) + Convert.ToInt16(Arear.ToString()));
HAllSpread.Sheets[0].RowCount++;
Temp = examds.Tables[0].Rows[i]["Department"].ToString();
}
}
if (ds1.Tables[1].Rows.Count > 0)
{
for (int jp = 0; jp < ds1.Tables[1].Rows.Count; jp++)
{
if (Temp != examds.Tables[0].Rows[i]["Department"].ToString())
{
Sno = Sno + 1;
}
countp = HAllSpread.Sheets[0].RowCount - 1;
HAllSpread.Sheets[0].Cells[countp, 0].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countp, 4].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countp, 6].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countp, 7].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countp, 8].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countp, 0].Text = Sno.ToString();
HAllSpread.Sheets[0].Cells[countp, 1].Text = examds.Tables[0].Rows[i]["Year"].ToString();
HAllSpread.Sheets[0].Cells[countp, 1].Note = examds.Tables[0].Rows[i]["BatchYear"].ToString();
HAllSpread.Sheets[0].Cells[countp, 2].Text = examds.Tables[0].Rows[i]["Course"].ToString();
HAllSpread.Sheets[0].Cells[countp, 3].Text = examds.Tables[0].Rows[i]["Department"].ToString();
HAllSpread.Sheets[0].Cells[countp, 3].Note = examds.Tables[0].Rows[i]["deptacronym"].ToString();
HAllSpread.Sheets[0].Cells[countp, 4].Text = examds.Tables[0].Rows[i]["Semester"].ToString();
HAllSpread.Sheets[0].Cells[countp, 5].Text = ds1.Tables[1].Rows[jp]["SubjectName"].ToString();
HAllSpread.Sheets[0].Cells[countp, 5].Note = ds1.Tables[1].Rows[jp]["SubjectNo"].ToString();
HAllSpread.Sheets[0].Cells[countp, 5].Tag = 0;
HAllSpread.Sheets[0].Rows[countp].ForeColor = Color.BlueViolet;
HAllSpread.Sheets[0].Cells[countp, 6].Text = ds1.Tables[1].Rows[jp]["RegularPracticalCount"].ToString();
HAllSpread.Sheets[0].Cells[countp, 7].Text = Arear.ToString();
HAllSpread.Sheets[0].Cells[countp, 8].Text = Convert.ToString(Convert.ToInt16(ds1.Tables[1].Rows[jp]["RegularPracticalCount"].ToString()) + Convert.ToInt16(Arear.ToString()));
HAllSpread.Sheets[0].RowCount++;
Temp = examds.Tables[0].Rows[i]["Department"].ToString();
}
}
if (ds1.Tables[2].Rows.Count > 0)
{
for (int k = 0; k < ds1.Tables[2].Rows.Count; k++)
{
if (Temp != examds.Tables[0].Rows[i]["Department"].ToString())
{
Sno = Sno + 1;
}
countA = HAllSpread.Sheets[0].RowCount - 1;
HAllSpread.Sheets[0].Cells[countA, 0].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countA, 4].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countA, 6].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countA, 7].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countA, 8].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countA, 0].Text = Sno.ToString();
HAllSpread.Sheets[0].Cells[countA, 1].Text = examds.Tables[0].Rows[i]["Year"].ToString();
HAllSpread.Sheets[0].Cells[countA, 1].Note = examds.Tables[0].Rows[i]["BatchYear"].ToString();
HAllSpread.Sheets[0].Cells[countA, 2].Text = examds.Tables[0].Rows[i]["Course"].ToString();
HAllSpread.Sheets[0].Cells[countA, 3].Text = examds.Tables[0].Rows[i]["Department"].ToString();
HAllSpread.Sheets[0].Cells[countA, 3].Note = examds.Tables[0].Rows[i]["deptacronym"].ToString();
HAllSpread.Sheets[0].Cells[countA, 4].Text = ds1.Tables[2].Rows[k]["semester"].ToString();
HAllSpread.Sheets[0].Cells[countA, 5].Text = ds1.Tables[2].Rows[k]["SubjectName"].ToString();
HAllSpread.Sheets[0].Cells[countA, 5].Note = ds1.Tables[2].Rows[k]["SubjectNo"].ToString();
HAllSpread.Sheets[0].Cells[countA, 5].Tag = 1;
HAllSpread.Sheets[0].Rows[countA].ForeColor = Color.Orange;
HAllSpread.Sheets[0].Cells[countA, 6].Text = Regular.ToString();
HAllSpread.Sheets[0].Cells[countA, 7].Text = ds1.Tables[2].Rows[k]["ArearTheoryCount"].ToString();
HAllSpread.Sheets[0].Cells[countA, 8].Text = Convert.ToString(Convert.ToInt16(ds1.Tables[2].Rows[k]["ArearTheoryCount"].ToString()) + Convert.ToInt16(Regular.ToString()));
HAllSpread.Sheets[0].RowCount++;
Temp = examds.Tables[0].Rows[i]["Department"].ToString();
}
}
if (ds1.Tables[3].Rows.Count > 0)
{
for (int kp = 0; kp < ds1.Tables[3].Rows.Count; kp++)
{
if (Temp != examds.Tables[0].Rows[i]["Department"].ToString())
{
Sno = Sno + 1;
}
countAP = HAllSpread.Sheets[0].RowCount - 1;
HAllSpread.Sheets[0].Cells[countAP, 0].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countAP, 4].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countAP, 6].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countAP, 7].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countAP, 8].HorizontalAlign = HorizontalAlign.Center;
HAllSpread.Sheets[0].Cells[countAP, 0].Text = Sno.ToString();
HAllSpread.Sheets[0].Cells[countAP, 1].Text = examds.Tables[0].Rows[i]["Year"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 1].Note = examds.Tables[0].Rows[i]["BatchYear"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 2].Text = examds.Tables[0].Rows[i]["Course"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 3].Text = examds.Tables[0].Rows[i]["Department"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 3].Note = examds.Tables[0].Rows[i]["deptacronym"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 4].Text = ds1.Tables[3].Rows[kp]["Semester"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 5].Text = ds1.Tables[3].Rows[kp]["SubjectName"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 5].Note = ds1.Tables[3].Rows[kp]["SubjectNo"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 5].Tag = 1;
HAllSpread.Sheets[0].Rows[countAP].ForeColor = Color.OrangeRed;
HAllSpread.Sheets[0].Cells[countAP, 6].Text = Regular.ToString();
HAllSpread.Sheets[0].Cells[countAP, 7].Text = ds1.Tables[3].Rows[kp]["ArearPracticalCount"].ToString();
HAllSpread.Sheets[0].Cells[countAP, 8].Text = Convert.ToString(Convert.ToInt16(ds1.Tables[3].Rows[kp]["ArearPracticalCount"].ToString()) + Convert.ToInt16(Regular.ToString()));
HAllSpread.Sheets[0].RowCount++;
Temp = examds.Tables[0].Rows[i]["Department"].ToString();
}
}
}
HAllSpread.Sheets[0].SetColumnMerge(0, FarPoint.Web.Spread.Model.MergePolicy.Always);
HAllSpread.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
HAllSpread.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
HAllSpread.Sheets[0].SetColumnMerge(3, FarPoint.Web.Spread.Model.MergePolicy.Always);
rowcount = HAllSpread.Sheets[0].RowCount * 20;
}
}
HAllSpread.Sheets[0].RowCount--;
HAllSpread.Sheets[0].PageSize = rowcount;
HAllSpread.Height = rowcount;
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
string valDegree = string.Empty;
string valBatch = string.Empty;
DataTable dtCourceInfo = new DataTable();
if (cblBatch.Items.Count > 0)
{
valBatch = rs.GetSelectedItemsValueAsString(cblBatch);
}
if (cblBranch.Items.Count > 0)
{
valDegree = rs.GetSelectedItemsValueAsString(cblBranch);
}
if (!string.IsNullOrEmpty(valBatch) && !string.IsNullOrEmpty(valDegree))
{
string SelectQ = "select distinct (c.Course_Name+'-'+de.Dept_Name) as courceName,r.Batch_Year,r.degree_code,COUNT(r.app_no) as totalStudent from Registration r,Degree d,course c,Department de where r.degree_code=d.Degree_Code and de.Dept_Code=d.Dept_Code and c.Course_Id=d.Course_Id and d.Degree_Code in('" + valDegree + "') and r.Batch_Year in('" + valBatch + "') and r.college_code=c.college_code and d.college_code=de.college_code and d.college_code=c.college_code and r.college_code='" + Convert.ToString(ddlCollege.SelectedValue) + "' and CC=0 and DelFlag =0 and Exam_Flag <>'DEBAR' and delflag=0 group by (c.Course_Name+'-'+de.Dept_Name),r.Batch_Year,r.degree_code order by (c.Course_Name+'-'+de.Dept_Name),r.Batch_Year,r.degree_code,totalStudent ";
dtCourceInfo = dirAcc.selectDataTable(SelectQ);
}
if (dtCourceInfo.Rows.Count > 0)
{
int sno = 0;
FpSpread1.Visible = true;
//lblexportxl.Visible = false;
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnCount = 0;
FpSpread1.Sheets[0].SheetCorner.ColumnCount = 0;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 1;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].ColumnCount = 5;
FpSpread1.Sheets[0].Columns[0].Width = 70;
FpSpread1.Sheets[0].Columns[1].Width = 100;
FpSpread1.Sheets[0].Columns[2].Width = 250;
FpSpread1.Sheets[0].Columns[3].Width = 100;
FpSpread1.Sheets[0].Columns[4].Width = 100;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Batch Year";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Department Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Student Count";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.CheckBoxCellType chkcell = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].RowCount = 0;
FarPoint.Web.Spread.CheckBoxCellType chkcell1 = new FarPoint.Web.Spread.CheckBoxCellType();
FpSpread1.Sheets[0].RowCount = FpSpread1.Sheets[0].RowCount + 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = chkcell1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, 4);
chkcell1.AutoPostBack = true;
FpSpread1.Sheets[0].FrozenRowCount = 1;
FpSpread1.Sheets[0].AutoPostBack = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = System.Drawing.Color.White;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
foreach (DataRow dr in dtCourceInfo.Rows)
{
string BatchYear = Convert.ToString(dr["batch_year"]).Trim();
string DegreeCode = Convert.ToString(dr["degree_code"]).Trim();
string CourceName = Convert.ToString(dr["courceName"]).Trim();
string torstudent = Convert.ToString(dr["totalStudent"]).Trim();
sno++;
FpSpread1.Sheets[0].RowCount = FpSpread1.Sheets[0].RowCount + 1;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = sno.ToString();
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = BatchYear;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = CourceName;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Note = DegreeCode;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = torstudent;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = chkcell;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
}
//FpSpread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
//FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
}
else
{
}
btnSave.Visible = true;
FpSpread1.Visible = true;
Btndelete.Visible = false;
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
FpSpread1.SaveChanges();
FpSpread1.Width = 640;
FpSpread1.Height = 400;
}