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) { } }