public void logo_set()
{
FpSpread1.Visible = true;
FpSpread1.Sheets[0].SheetName = " ";
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Sl. No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Roll No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Register No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Student Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Subject";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Attempts";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Semester";
FpSpread1.Sheets[0].ColumnHeader.Rows[0].HorizontalAlign = HorizontalAlign.Center;
FarPoint.Web.Spread.TextCellType txt = new TextCellType();
FpSpread1.Sheets[0].Columns[1].CellType = txt;
FpSpread1.Sheets[0].Columns[2].CellType = txt;
//=header
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
string str = "select isnull(collname, ' ') as collname,isnull(category,'') as category,isnull(affliatedby,'') as affliated,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(district, ' ') as district,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'";
con1.Close();
con1.Open();
SqlCommand comm = new SqlCommand(str, con1);
SqlDataReader drr = comm.ExecuteReader();
drr.Read();
string coll_name = Convert.ToString(drr["collname"]);
string coll_address1 = Convert.ToString(drr["address1"]);
string coll_address2 = Convert.ToString(drr["address2"]);
string coll_address3 = Convert.ToString(drr["address3"]);
string district = Convert.ToString(drr["district"]);
string pin_code = Convert.ToString(drr["pincode"]);
string catgory = drr["category"].ToString();
catgory = "(An " + catgory + " Institution" + " " + "-" + "";
string affliatedby = drr["affliated"].ToString();
string affliatedbynew = Regex.Replace(affliatedby, ",", " ");
string affiliated = catgory + " " + "Affiliated to" + " " + affliatedbynew + ")";
string address = coll_address1 + "," + " " + coll_address2 + "," + " " + district + "-" + " " + pin_code + ".";
Span1.InnerHtml = coll_name;
spnCollegeHeader.InnerHtml = address;
Span2.InnerHtml = affiliated;
Span3.InnerHtml = "Students Wise Arrears List";
// FpSpread1.Sheets[0].ColumnHeader.Rows[1].Visible = false;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].BackColor = Color.FromArgb(214, 235, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Font.Size = FontUnit.Medium;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["collegecode"] == null) //Aruna For Back Button
{
Response.Redirect("~/Default.aspx");
}
if (!Page.IsPostBack)
{
//Fpstaff.Width = 1000;
Fpstaff.Sheets[0].AutoPostBack = true;
Fpstaff.CommandBar.Visible = true;
Fpstaff.Sheets[0].SheetName = " ";
Fpstaff.Sheets[0].SheetCorner.Columns[0].Visible = false;
Fpstaff.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
Fpstaff.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left;
Fpstaff.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
Fpstaff.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
Fpstaff.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
Fpstaff.Sheets[0].DefaultStyle.Font.Bold = false;
FarPoint.Web.Spread.StyleInfo style1 = new FarPoint.Web.Spread.StyleInfo();
style1.Font.Size = 12;
style1.Font.Bold = true;
style1.HorizontalAlign = HorizontalAlign.Center;
style1.ForeColor = System.Drawing.Color.Black;
style1.BackColor = ColorTranslator.FromHtml("#0CA6CA");
Fpstaff.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1);
Fpstaff.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1);
Fpstaff.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center;
Fpstaff.Sheets[0].AllowTableCorner = true;
//---------------page number
Fpstaff.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom;
Fpstaff.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
Fpstaff.Pager.Align = HorizontalAlign.Right;
Fpstaff.Pager.Font.Bold = true;
Fpstaff.Pager.Font.Name = "Book Antiqua";
Fpstaff.Pager.ForeColor = System.Drawing.Color.DarkGreen;
Fpstaff.Pager.BackColor = System.Drawing.Color.Beige;
Fpstaff.Pager.BackColor = System.Drawing.Color.AliceBlue;
Fpstaff.Pager.PageCount = 100;
Fpstaff.Visible = false;
btnprintmaster.Visible = false;
btnxl.Visible = false;
txtrptname.Visible = false;
lblrptname.Visible = false;
BindDesignation();
BindDepartment();
BindCategory();
BindType();
BindDesignation();
}
errmsg.Visible = false;
}
public void logo_set()
{
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].Columns[0].Width = 50;
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[1].Width = 150;
FpSpread1.Sheets[0].Columns[2].Width = 40;
FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[3].Width = 40;
FpSpread1.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[4].Width = 30;
FpSpread1.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[5].Width = 30;
FpSpread1.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[6].Width = 30;
FpSpread1.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[7].Width = 30;
FpSpread1.Sheets[0].Columns[7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[8].Width = 30;
FpSpread1.Sheets[0].Columns[8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[9].Width = 30;
FpSpread1.Sheets[0].Columns[9].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[10].Width = 30;
FpSpread1.Sheets[0].Columns[10].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[11].Width = 30;
FpSpread1.Sheets[0].Columns[11].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 0, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Batch";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 1].Text = "Branch";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 2, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 2].Text = "Semester";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 3, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 3].Text = "Total No.of Student";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 4, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 4].Text = "Registered";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 4].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 5].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 6, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 6].Text = "Pass";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 6].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 7].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 8, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 8].Text = "Fail";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 8].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 9].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 10, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 10].Text = "Absent";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 10].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 11].Text = "%";
FpSpread1.Sheets[0].ColumnHeader.Rows[6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].HorizontalAlign = HorizontalAlign.Center;
//=header
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg1 mi2 = new MyImg1();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
string str = "select isnull(collname, ' ') as collname,isnull(category,'') as category,isnull(affliatedby,'') as affliated,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(district, ' ') as district,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'";
con1.Close();
con1.Open();
SqlCommand comm = new SqlCommand(str, con1);
SqlDataReader drr = comm.ExecuteReader();
drr.Read();
string coll_name = Convert.ToString(drr["collname"]);
string coll_address1 = Convert.ToString(drr["address1"]);
string coll_address2 = Convert.ToString(drr["address2"]);
string coll_address3 = Convert.ToString(drr["address3"]);
string district = Convert.ToString(drr["district"]);
string pin_code = Convert.ToString(drr["pincode"]);
string catgory = drr["category"].ToString();
catgory = "(An " + catgory + " Institution" + " " + "-" + "";
string affliatedby = drr["affliated"].ToString();
string affliatedbynew = Regex.Replace(affliatedby, ",", " ");
string affiliated = catgory + " " + "Affiliated to" + " " + affliatedbynew + ")";
string address = coll_address1 + "," + " " + coll_address2 + "," + " " + district + "-" + " " + pin_code + ".";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 0, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_name;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = address;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = affiliated;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Result Analysis";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].ForeColor = Color.FromArgb(64, 64, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorRight = Color.White;
// FpSpread1.Sheets[0].ColumnHeader.Cells[1, 16].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Rows[6].BackColor = Color.FromArgb(214, 235, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].BackColor = Color.FromArgb(214, 235, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].CellType = mi;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, FpSpread1.Sheets[0].ColumnCount - 2, 5, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 2].CellType = mi2;
}
public void logo_settings()
{
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].AllowTableCorner = true;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 5;
FpSpread1.Sheets[0].ColumnCount = 4;
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi2 = new MyImg();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
con_header.Close();
con_header.Open();
query_header = "select collname,category,affliatedby,address1,address2,address3,phoneno,faxno,email,website from collinfo where college_code=" + Session["collegecode"] + "";
SqlCommand com_header = new SqlCommand(query_header, con_header);
SqlDataReader sdr_header;
sdr_header = com_header.ExecuteReader();
while (sdr_header.Read())
{
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = sdr_header["collname"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, 2);
string cc =
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = sdr_header["category"].ToString() + ", Affliated to" + sdr_header["affliatedby"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = sdr_header["address1"].ToString() + "-" + sdr_header["address2"].ToString() + "-" + sdr_header["address1"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = "Phone : " + sdr_header["phoneno"].ToString() + " Fax : " + sdr_header["faxno"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, 2);//5th row span
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "E-Mail : " + sdr_header["email"].ToString() + " Web Site : " + sdr_header["website"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].CellType = mi2;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
individualsubstud.Sheets[0].ColumnCount = 6;
individualsubstud.Sheets[0].Columns[0].Locked = true;
individualsubstud.Sheets[0].Columns[1].Locked = true;
individualsubstud.Sheets[0].Columns[2].Locked = true;
individualsubstud.Sheets[0].Columns[3].Locked = true;
individualsubstud.Sheets[0].Columns[4].Locked = true;
individualsubstud.Sheets[0].Columns[5].Locked = true;
individualsubstud.Visible = false;
individualsubstud.Sheets[0].SheetCorner.RowCount = 11;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(7, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(8, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(9, 1, 1, 5);
individualsubstud.Sheets[0].Columns[0].Width = 70;
individualsubstud.Sheets[0].Columns[1].Width = 100;
individualsubstud.Sheets[0].Columns[2].Width = 150;
individualsubstud.Sheets[0].Columns[3].Width = 100;
individualsubstud.Sheets[0].Columns[4].Width = 170;
individualsubstud.Sheets[0].Columns[5].Width = 70;
individualsubstud.Sheets[0].AutoPostBack = true;
//if (Session["Rollflag"] == "0")
//{
// individualsubstud.Width = 700;
// individualsubstud.Sheets[0].Columns[1].Visible = false;
//}
if (Session["Regflag"] == "0")
{
individualsubstud.Width = 510;
individualsubstud.Sheets[0].Columns[2].Visible = false;
}
if (Session["Studflag"].ToString() == "0")
{
individualsubstud.Width = 570;
individualsubstud.Sheets[0].Columns[3].Visible = false;
}
if (Session["Regflag"].ToString() == "0" && Session["Rollflag"].ToString() == "0" && Session["Studflag"].ToString() == "0")
{
individualsubstud.Width = 510;
individualsubstud.Sheets[0].Columns[1].Width = 200;
individualsubstud.Sheets[0].Columns[1].Visible = true;
}
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
individualsubstud.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
individualsubstud.Sheets[0].AllowTableCorner = true;
individualsubstud.Sheets[0].SheetCorner.Cells[0, 0].Text = " ";
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi1 = new MyImg();
mi1.ImageUrl = "~/images/10BIT001.jpeg";
mi1.ImageUrl = "Handler/Handler5.ashx?";
string str = "select isnull(collname, ' ') as collname,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'";
con1.Close();
con1.Open();
SqlCommand comm = new SqlCommand(str, con1);
SqlDataReader drr = comm.ExecuteReader();
drr.Read();
string coll_name = Convert.ToString(drr["collname"]);
string coll_address1 = Convert.ToString(drr["address1"]);
string coll_address2 = Convert.ToString(drr["address2"]);
string coll_address3 = Convert.ToString(drr["address3"]);
string pin_code = Convert.ToString(drr["pincode"]);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 6, 1);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 1, 6);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Text = coll_name;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_address1;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Text = coll_address2;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Text = coll_address3 + "-" + " " + pin_code + ".";
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
//individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Salary Summary For-" + monname + "--" + cblbatchyear.Text + "";
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].ForeColor = Color.FromArgb(64, 64, 255);
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[10].BackColor = Color.FromArgb(214, 235, 255);
individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Bold = true;
individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 6, 1);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, individualsubstud.Sheets[0].ColumnCount - 1].CellType = mi1;
individualsubstud.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
individualsubstud.Sheets[0].RowCount = 0;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(10, 4, 1, 2);
individualsubstud.Sheets[0].ColumnHeader.Rows[10].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 0].Text = "S.No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 1].Text = "Roll No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 2].Text = "Reg No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 3].Text = "Student Type";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 4].Text = "Student Name";
individualsubstud.Sheets[0].RowHeader.Visible = false;
HAllSpread.SaveChanges();
int sno = 0;
int count = 0;
for (int res = 1; res <= Convert.ToInt32(HAllSpread.Sheets[0].RowCount) - 1; res++)
{
int isval = 0;
string s = HAllSpread.Sheets[0].Cells[res, 9].Text;
isval = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 9].Value);
if (isval == 1)
{
string year1 = "";
string semester1 = "";
string degreecourse1 = "";
string subject1 = "";
string subject_no = HAllSpread.Sheets[0].Cells[res, 5].Note;
int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 4].Text);
//individualsubstud.Sheets[0].AutoPostBack = true;
individualsubstud.CommandBar.Visible = true;
//string activerow = "";
//string activecol = "";
//activerow = HAllSpread.ActiveSheetView.ActiveRow.ToString();
//activecol = HAllSpread.ActiveSheetView.ActiveColumn.ToString();
//string subject_no = HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 5].Note;
//int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Text);
string year = HAllSpread.Sheets[0].Cells[res, 1].Text;
string degree = HAllSpread.Sheets[0].Cells[res, 2].Text;
string course = HAllSpread.Sheets[0].Cells[res, 3].Text;
string courseacro = HAllSpread.Sheets[0].Cells[res, 3].Note;
string subject = HAllSpread.Sheets[0].Cells[res, 5].Text;
string arreartag = Convert.ToString(HAllSpread.Sheets[0].Cells[res, 5].Tag);
string degreecourse = degree + "-" + courseacro;
individualsubstud.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Year";
individualsubstud.Sheets[0].ColumnHeader.Cells[7, 0].Text = "Branch";
individualsubstud.Sheets[0].ColumnHeader.Cells[8, 0].Text = "Semester";
individualsubstud.Sheets[0].ColumnHeader.Cells[9, 0].Text = "Subject";
if (hashyear.Contains(year))
{
}
else
{
hashyear.Add(year, count);
count++;
}
foreach (DictionaryEntry parameter in hashyear)
{
string selectyear = Convert.ToString(parameter.Key);
if (year1 == "")
{
year1 = selectyear;
}
else if (year1 != "")
{
if (year1 != year)
{
year1 = year1 + "," + " " + selectyear;
}
}
}
if (hash.Contains(degreecourse))
{
}
else
{
hash.Add(degreecourse, count);
count++;
}
foreach (DictionaryEntry parameter in hash)
{
string selectdegreecourse = Convert.ToString(parameter.Key);
if (degreecourse1 == "")
{
degreecourse1 = selectdegreecourse;
}
else if (degreecourse1 != "")
{
if (degreecourse1 != degreecourse)
{
degreecourse1 = degreecourse1 + "," + " " + selectdegreecourse;
}
}
}
if (hashsubject.Contains(subject))
{
}
else
{
hashsubject.Add(subject, count);
count++;
}
foreach (DictionaryEntry parameter in hashsubject)
{
string selectsubject = Convert.ToString(parameter.Key);
if (subject1 == "")
{
subject1 = selectsubject;
}
else if (subject1 != "")
{
if (subject1 != subject)
{
subject1 = subject1 + "," + " " + selectsubject;
}
}
}
if (hashsemester.Contains(semester))
{
}
else
{
hashsemester.Add(semester, count);
count++;
}
foreach (DictionaryEntry parameter in hashsemester)
{
string selectsemester = Convert.ToString(parameter.Key);
if (semester1 == "")
{
semester1 = Convert.ToString(selectsemester);
}
else if (semester1 != "")
{
if (semester1 != Convert.ToString(semester))
{
semester1 = semester1 + "," + Convert.ToString(selectsemester);
}
}
}
individualsubstud.Sheets[0].ColumnHeader.Cells[6, 1].Text = ":" + " " + year1;
individualsubstud.Sheets[0].ColumnHeader.Cells[7, 1].Text = ":" + " " + degreecourse1;
individualsubstud.Sheets[0].ColumnHeader.Cells[8, 1].Text = ":" + " " + semester1;
individualsubstud.Sheets[0].ColumnHeader.Cells[9, 1].Text = ":" + " " + subject1;
individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[9].Border.BorderColorRight = Color.White;
string type = "0";
int i = 0;
int j = 0;
// string type1 = "";
if (Session["Stud_Type"] != "0" && Session["Stud_Type1"] != "0")
{
j = 2;
}
if (Session["Stud_Type"] != "1" && Session["Stud_Type1"] != "1")
{
j = 2;
}
if (j != 2)
{
if (Session["Stud_Type1"] != "Hostler")
{
i = 1;
type = Session["Stud_Type1"].ToString();
}
else if (Session["Stud_Type"] != "Day Scholar")
{
i = 1;
type = Session["Stud_Type"].ToString();
}
}
if (arreartag == "0")
{
SqlCommand studentscmd = new SqlCommand("procindividualsubstud", con);
studentscmd.CommandType = CommandType.StoredProcedure;
studentscmd.Parameters.AddWithValue("@subject_no", subject_no);
studentscmd.Parameters.AddWithValue("@semester", semester);
if (type != "")
{
studentscmd.Parameters.AddWithValue("@stud_type", type);
}
studentscmd.Parameters.AddWithValue("@i", i);
//studentscmd.Parameters.AddWithValue("@stud_type1", type1);
SqlDataAdapter studentsda = new SqlDataAdapter(studentscmd);
DataSet studentsds = new DataSet();
studentsda.Fill(studentsds);
if (studentsds.Tables[0].Rows.Count > 0)
{
individualsubstud.Visible = true;
for (int dd = 0; dd < studentsds.Tables[0].Rows.Count; dd++)
{
sno++;
individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1;
individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2);
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + "";
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsds.Tables[0].Rows[dd]["roll_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsds.Tables[0].Rows[dd]["reg_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsds.Tables[0].Rows[dd]["Stud_type"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsds.Tables[0].Rows[dd]["Stud_name"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
}
}
}
if (arreartag == "1")
{
SqlCommand studentscmdforarrear = new SqlCommand("procindividualsubstudforarrear", con);
studentscmdforarrear.CommandType = CommandType.StoredProcedure;
studentscmdforarrear.Parameters.AddWithValue("@subject_no", subject_no);
if (type != "")
{
studentscmdforarrear.Parameters.AddWithValue("@stud_type", type);
}
studentscmdforarrear.Parameters.AddWithValue("@i", i);
SqlDataAdapter studentsdaforarrear = new SqlDataAdapter(studentscmdforarrear);
DataSet studentsdsforarrear = new DataSet();
studentsdaforarrear.Fill(studentsdsforarrear);
if (studentsdsforarrear.Tables[0].Rows.Count > 0)
{
individualsubstud.Visible = true;
for (int dd2 = 0; dd2 < studentsdsforarrear.Tables[0].Rows.Count; dd2++)
{
sno++;
individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1;
individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2);
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + "";
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsdsforarrear.Tables[0].Rows[dd2]["roll_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsdsforarrear.Tables[0].Rows[dd2]["reg_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_type"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_name"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
}
}
}
int totalrows = individualsubstud.Sheets[0].RowCount;
individualsubstud.Sheets[0].PageSize = totalrows * 100;
individualsubstud.Height = totalrows + 50 * 15;
}
}
}
public void logo_settings()
{
string query_header = "";
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
sprdviewrcrd.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
sprdviewrcrd.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
sprdviewrcrd.Sheets[0].AllowTableCorner = true;
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
sprdviewrcrd.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
sprdviewrcrd.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium;
sprdviewrcrd.Sheets[0].ColumnHeader.Rows[5].BackColor = Color.AliceBlue;
col_cnt = Convert.ToInt32(Session["col_cnt"].ToString());
sprdviewrcrd.Sheets[0].ColumnCount = 4 + col_cnt;
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi2 = new MyImg();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
con_header.Close();
con_header.Open();
query_header = "select collname,address3,pincode from collinfo where college_code=" + Session["collegecode"] + "";
SqlCommand com_header = new SqlCommand(query_header, con_header);
SqlDataReader sdr_header;
sdr_header = com_header.ExecuteReader();
while (sdr_header.Read())
{
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 2);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Text = sdr_header.GetString(0) + ".";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(1, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Text = sdr_header.GetString(1) + " - " + sdr_header.GetString(2) + ".";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(2, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Text = "";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(3, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Text = "Students Arrear Status";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(4, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);//5th row span
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].Text = "";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].ForeColor = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, sprdviewrcrd.Sheets[0].ColumnCount - 1, 5, 1);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, sprdviewrcrd.Sheets[0].ColumnCount - 1].CellType = mi2;
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
string valDegree = string.Empty;
string valBatch = string.Empty;
string valSem = string.Empty;
string collCode = Convert.ToString(ddlCollege.SelectedValue);
Label1.Visible = false;
Button2.Visible = false;
TextBox1.Visible = false;
Button1.Visible = false;
DataSet ds1 = new DataSet();
if (cblBatch.Items.Count > 0)
{
valBatch = rs.GetSelectedItemsValueAsString(cblBatch);
}
if (cblBranch.Items.Count > 0)
{
valDegree = rs.GetSelectedItemsValueAsString(cblBranch);
}
if (cbl_sem.Items.Count > 0)
{
valSem = rs.GetSelectedItemsValueAsString(cbl_sem);
}
string query1 = string.Empty;
query1 = "select r.reg_no,r.Batch_Year,r.degree_code,s.subject_no,s.subject_code,s.subject_name,ed.exam_code,r.Current_Semester,sy.semester, me.roll_no,me.external_mark,me.internal_mark,me.result,me.evaluation1,me.evaluation2,me.evaluation3,me.external_mark,me.total,c.Course_Name,de.Dept_Name from mark_entry me,Exam_Details ed,subject s,Registration r,syllabus_master sy,Degree d,Department de,course c where c.Course_Id=d.Course_Id and d.Dept_Code=de.Dept_Code and r.degree_code=d.degree_code and s.syll_code=sy.syll_code and r.Roll_No=me.roll_no and ed.degree_code=r.degree_code and ed.batch_year=r.Batch_Year and me.exam_code=ed.exam_code and me.subject_no=s.subject_no and r.batch_year=ed.batch_year and ed.Exam_Month='" + Convert.ToString(ddlmonth.SelectedValue) + "' and ed.Exam_year='" + Convert.ToString(ddlyear.SelectedValue) + "' and ed.degree_code in('" + valDegree + "') and ed.batch_year in('" + valBatch + "') and r.college_code='" + collCode + "' and result<>'pass' group by c.Course_Name,de.Dept_Name,r.reg_no,r.degree_code,r.batch_year,s.subject_no,s.subject_code,s.subject_name,ed.exam_code,r.Current_Semester,sy.semester, me.roll_no,me.external_mark,me.internal_mark,me.result,me.evaluation1,me.evaluation2,me.evaluation3,me.external_mark,me.total order by r.reg_no";//sy.semester=r.Current_Semester and
ds1 = da.select_method_wo_parameter(query1, "text");
if (ds1.Tables[0].Rows.Count > 0)
{
FpSpread1.Visible = true;
g1btnprint.Visible = false;
g1btnexcel.Visible = false;
Printcontrol.Visible = false;
txtexcelname.Visible = false;
//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 = 9;
FpSpread1.Width = 970;
FpSpread1.Height = 900;
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FarPoint.Web.Spread.StyleInfo MyStyle = new FarPoint.Web.Spread.StyleInfo();
MyStyle.Font.Size = FontUnit.Medium;
MyStyle.HorizontalAlign = HorizontalAlign.Center;
MyStyle.Font.Name = "Book Antiqua";
MyStyle.ForeColor = Color.Black;
MyStyle.Font.Bold = true;
MyStyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = MyStyle;
FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false;
FpSpread1.Sheets[0].RowHeader.Visible = false;
FpSpread1.Sheets[0].AutoPostBack = false;
FpSpread1.CommandBar.Visible = false;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Degree";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Department";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Reg. No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Subject Code";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Subject Name";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "INT";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "EXT";
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Text = "Final Mark";
FpSpread1.Sheets[0].Columns[0].Width = 70;
FpSpread1.Sheets[0].Columns[1].Width = 100;
FpSpread1.Sheets[0].Columns[2].Width = 150;
FpSpread1.Sheets[0].Columns[3].Width = 150;
FpSpread1.Sheets[0].Columns[4].Width = 120;
FpSpread1.Sheets[0].Columns[5].Width = 170;
FpSpread1.Sheets[0].Columns[6].Width = 70;
FpSpread1.Sheets[0].Columns[7].Width = 70;
FpSpread1.Sheets[0].Columns[8].Width = 70;
FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.Sheets[0].SetColumnMerge(3, FarPoint.Web.Spread.Model.MergePolicy.Always);
int sno = 0;
int maxarrCount = 0;
int.TryParse(txtMaxArrCount.Text, out maxarrCount);
if (maxarrCount > 0)
{
if (ds1.Tables[0].Rows.Count > 0)
{
DataTable dicStudent = ds1.Tables[0].DefaultView.ToTable(true, "reg_no", "roll_no");
foreach (DataRow dt in dicStudent.Rows)
{
string regNo = Convert.ToString(dt["reg_no"]);
string rollNo = Convert.ToString(dt["roll_no"]);
ds1.Tables[0].DefaultView.RowFilter = "reg_no='" + regNo + "'";
DataTable dtSubjectCount = ds1.Tables[0].DefaultView.ToTable();
if (dtSubjectCount.Rows.Count <= maxarrCount)
{
for (int j = 0; j < dtSubjectCount.Rows.Count; j++)
{
string cusem = Convert.ToString(dtSubjectCount.Rows[j]["Current_Semester"]);
string subSem = Convert.ToString(dtSubjectCount.Rows[j]["semester"]);
string subjectCode = Convert.ToString(dtSubjectCount.Rows[j]["subject_code"]);
string SubName = Convert.ToString(dtSubjectCount.Rows[j]["subject_name"]);
string Course = Convert.ToString(dtSubjectCount.Rows[j]["Course_Name"]);
string deptname = Convert.ToString(dtSubjectCount.Rows[j]["Dept_Name"]);
string CIA = loadmarkat(Convert.ToString(dtSubjectCount.Rows[j]["internal_mark"]));
string EXt = loadmarkat(Convert.ToString(dtSubjectCount.Rows[j]["external_mark"]));
string tot = loadmarkat(Convert.ToString(dtSubjectCount.Rows[j]["total"]));
if (subSem.Trim() == cusem.Trim())
{
FpSpread1.Sheets[0].RowCount = FpSpread1.Sheets[0].RowCount + 1;
sno++;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = sno + "";
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Course;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = deptname;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].VerticalAlign = VerticalAlign.Middle;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = regNo;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = subjectCode;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = SubName;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = CIA;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Text = EXt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].CellType = txt;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = tot;
FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Locked = true;
}
}
}
}
FpSpread1.Visible = true;
FpSpread1.SaveChanges();
FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount;
Label1.Visible = true;
TextBox1.Visible = true;
Button1.Visible = true;
Button2.Visible = true;
}
else
{
FpSpread1.Visible = false;
lblAlertMsg.Visible = true;
lblAlertMsg.Text = "No Record Found";
divPopAlert.Visible = true;
Label1.Visible = false;
TextBox1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
//lblerrormsg.Text = "No Records Found";
}
}
else
{
FpSpread1.Visible = false;
lblAlertMsg.Visible = true;
lblAlertMsg.Text = "Max.Arrear Count Not valid!";
divPopAlert.Visible = true;
Label1.Visible = false;
TextBox1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
else
{
FpSpread1.Visible = false;
lblAlertMsg.Visible = true;
lblAlertMsg.Text = "No Record Found";
divPopAlert.Visible = true;
Label1.Visible = false;
TextBox1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
//lblerrormsg.Text = "No Records Found";
}
}
catch (Exception ex)
{
}
}
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 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;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//****************************************************//
//string PageLogOut = "";
//string sess = Convert.ToString(Session["IsLogin"]);
//PageLogOut = Convert.ToString(Session["PageLogout"]);
//if (sess == "")
//{
//}
//else
//{
// if (!Request.FilePath.Contains("HRM"))
// {
// string strPreviousPage = "";
// if (Request.UrlReferrer != null)
// {
// strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
// }
// if (strPreviousPage == "")
// {
// string redrURI = ConfigurationManager.AppSettings["HR"].Trim();
// Response.Redirect(redrURI, false);
// return;
// }
// }
//}
//if (Session["collegecode"] == null)
//{
// string redrURI = ConfigurationManager.AppSettings["Logout"].Trim();
// Response.Redirect(redrURI, false);
// return;
//}
if (Session["collegecode"] == null)
{
Response.Redirect("~/Default.aspx");
}
if (!Request.FilePath.Contains("HRMenuIndex"))
{
string strPreviousPage = "";
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/HRMOD/HRMenuIndex.aspx");
return;
}
}
//****************************************************//
if (!Page.IsPostBack)
{
//Fpstaff.Width = 1000;
Fpstaff.Sheets[0].AutoPostBack = true;
Fpstaff.CommandBar.Visible = true;
Fpstaff.Sheets[0].SheetName = " ";
Fpstaff.Sheets[0].SheetCorner.Columns[0].Visible = false;
Fpstaff.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle;
Fpstaff.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left;
Fpstaff.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle;
Fpstaff.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
Fpstaff.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
Fpstaff.Sheets[0].DefaultStyle.Font.Bold = false;
FarPoint.Web.Spread.StyleInfo style1 = new FarPoint.Web.Spread.StyleInfo();
style1.Font.Size = 12;
style1.Font.Bold = true;
style1.HorizontalAlign = HorizontalAlign.Center;
style1.ForeColor = System.Drawing.Color.Black;
style1.BackColor = ColorTranslator.FromHtml("#0CA6CA");
Fpstaff.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1);
Fpstaff.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1);
Fpstaff.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center;
Fpstaff.Sheets[0].AllowTableCorner = true;
//---------------page number
Fpstaff.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom;
Fpstaff.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both;
Fpstaff.Pager.Align = HorizontalAlign.Right;
Fpstaff.Pager.Font.Bold = true;
Fpstaff.Pager.Font.Name = "Book Antiqua";
Fpstaff.Pager.ForeColor = System.Drawing.Color.DarkGreen;
Fpstaff.Pager.BackColor = System.Drawing.Color.Beige;
Fpstaff.Pager.BackColor = System.Drawing.Color.AliceBlue;
Fpstaff.Pager.PageCount = 100;
Fpstaff.Visible = false;
btnprintmaster.Visible = false;
btnxl.Visible = false;
txtrptname.Visible = false;
lblrptname.Visible = false;
BindDesignation();
BindDepartment();
BindCategory();
BindType();
BindDesignation();
}
errmsg.Visible = false;
}
catch (Exception ex) { }
}
