protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } usercode = Session["usercode"].ToString(); collegecode1 = Session["collegecode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!IsPostBack) { Bindcollege(); collegecode = ddlcollege.SelectedValue.ToString(); BindBatch(); BindDegree(singleuser, group_user, collegecode, usercode); BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode); FarPoint.Web.Spread.StyleInfo MyStyle = new FarPoint.Web.Spread.StyleInfo(); MyStyle.Font.Bold = true; MyStyle.Font.Size = FontUnit.Medium; MyStyle.HorizontalAlign = HorizontalAlign.Center; MyStyle.ForeColor = Color.Black; MyStyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) //Aruna For Back Button { Response.Redirect("~/Default.aspx"); } usercode = Session["usercode"].ToString(); collegecode = Session["collegecode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!IsPostBack) { FpSpread1.Width = 1000; FpSpread1.Sheets[0].AutoPostBack = true; FpSpread1.CommandBar.Visible = true; FpSpread1.Sheets[0].SheetName = " "; FpSpread1.Sheets[0].SheetCorner.Columns[0].Visible = false; FpSpread1.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FpSpread1.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; FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].AllowTableCorner = true; //---------------page number FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom; FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both; FpSpread1.Pager.Align = HorizontalAlign.Right; FpSpread1.Pager.Font.Bold = true; FpSpread1.Pager.Font.Name = "Book Antiqua"; FpSpread1.Pager.ForeColor = System.Drawing.Color.DarkGreen; FpSpread1.Pager.BackColor = System.Drawing.Color.Beige; FpSpread1.Pager.BackColor = System.Drawing.Color.AliceBlue; FpSpread1.Pager.PageCount = 100; FpSpread1.Visible = false; btnxl.Visible = false; Button1.Visible = false; LabelE.Visible = false; lblnorec.Visible = false; errmsg.Visible = false; BindBatch(); BindDegree(singleuser, group_user, collegecode, usercode); BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode); BindSectionDetailmult(collegecode); Bindmultiseme(collegecode); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } if (!IsPostBack) { rbplainsheet.Checked = true; chkfootersign.Checked = true; chk_terms.Checked = true; loadprintdetails(); loadtermssp(); loadtermssp2(); showterms(); showstaffdesc(); txtstaff.Attributes.Add("Readonly", "Readonly"); FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = System.Drawing.Color.White; // darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Size = FontUnit.Medium; darkstyle.Border.BorderSize = 1; darkstyle.Border.BorderColor = System.Drawing.Color.White; fsstaff.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; retrive(); } }
private void loadsprcolumns() { try { FpSpread.Sheets[0].RowCount = 0; FpSpread.Sheets[0].ColumnCount = 5; FpSpread.CommandBar.Visible = false; FpSpread.RowHeader.Visible = false; FpSpread.Sheets[0].AutoPostBack = false; FpSpread.Sheets[0].ColumnHeader.RowCount = 1; FarPoint.Web.Spread.TextCellType textcell = new FarPoint.Web.Spread.TextCellType(); FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.Black; FpSpread.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread.Columns[0].Locked = true; FpSpread.Columns[0].Width = 50; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Staff Code"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; FpSpread.Columns[1].Locked = true; FpSpread.Columns[1].Width = 150; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Name"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; FpSpread.Columns[2].Locked = true; FpSpread.Columns[2].Width = 300; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Device ID"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; FpSpread.Columns[3].Locked = true; FpSpread.Columns[3].Width = 150; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Finger ID"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].CellType = textcell; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; FpSpread.Columns[4].Locked = true; FpSpread.Columns[4].Width = 150; } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (Session["collegecode"] == null) //Aruna For Back Button { Response.Redirect("~/Default.aspx"); } usercode = Session["usercode"].ToString(); collegecode = Session["collegecode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!IsPostBack) { setLabelText(); Fpstudenttransport.Width = 1000; Fpstudenttransport.Sheets[0].AutoPostBack = true; Fpstudenttransport.CommandBar.Visible = true; Fpstudenttransport.Sheets[0].SheetName = " "; Fpstudenttransport.Sheets[0].SheetCorner.Columns[0].Visible = false; Fpstudenttransport.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; Fpstudenttransport.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left; Fpstudenttransport.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; Fpstudenttransport.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; Fpstudenttransport.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; Fpstudenttransport.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; Fpstudenttransport.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1); Fpstudenttransport.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1); Fpstudenttransport.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center; Fpstudenttransport.Sheets[0].AllowTableCorner = true; Fpstudenttransport.Visible = false; //btnxl.Visible = false; //btnprintmaster.Visible = false; LabelE.Visible = false; lblnorec.Visible = false; errmsg.Visible = false; BindBatch(); BindDegree(singleuser, group_user, collegecode, usercode); BindBranch(singleuser, group_user, course_id, collegecode, usercode); BindSectransport(strbatch, strbranch); BindSectionDetail(strbatch, strbranch); // BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode); } }
public void bindspread() { FpExternal.Sheets[0].ColumnCount = 10; FpExternal.Sheets[0].AutoPostBack = true; FpExternal.Sheets[0].ColumnHeader.RowCount = 2; FpExternal.Sheets[0].RowCount = 0; FpExternal.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium; FpExternal.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; FpExternal.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true; FpExternal.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; FpExternal.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; FpExternal.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpExternal.Sheets[0].DefaultStyle.Font.Bold = false; FpExternal.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FpExternal.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1); FpExternal.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Sub Code"; FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 2, 1); FpExternal.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Sub Name"; FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 2, 1); FpExternal.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Staff Name"; FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 2, 1); FpExternal.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Before Revaluation"; FpExternal.Sheets[0].ColumnHeader.Cells[0, 7].Text = "After Revaluation"; FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 4, 1, 3); FpExternal.Sheets[0].ColumnHeaderSpanModel.Add(0, 7, 1, 3); FpExternal.Sheets[0].ColumnHeader.Cells[1, 4].Text = "No Of Students Appear"; FpExternal.Sheets[0].ColumnHeader.Cells[1, 5].Text = "No Of Students Passed"; FpExternal.Sheets[0].ColumnHeader.Cells[1, 6].Text = "% Of Pass"; FpExternal.Sheets[0].ColumnHeader.Cells[1, 7].Text = "No Of Students Appear"; FpExternal.Sheets[0].ColumnHeader.Cells[1, 8].Text = "No Of Students Passed"; FpExternal.Sheets[0].ColumnHeader.Cells[1, 9].Text = "% Of Pass"; FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo(); style.Font.Size = 11; style.Font.Name = "Book Antiqua"; FpExternal.Sheets[0].DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style); FpExternal.Sheets[0].RowHeader.Visible = false; FpExternal.Visible = true; btnExcel.Visible = true; txtexcelname.Visible = true; lblrptname.Visible = true; btnprintmaster.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { lblerror.Visible = false; if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } collegecode = Session["collegecode"].ToString(); if (!IsPostBack) { ss2 = ""; p = ""; FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo(); style2.Font.Size = 13; style2.Font.Name = "Trebuchet MS"; style2.Font.Bold = true; style2.HorizontalAlign = HorizontalAlign.Center; style2.ForeColor = Color.White; style2.BackColor = Color.Teal; FpSpread2.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2); style2 = new FarPoint.Web.Spread.StyleInfo(); style2.VerticalAlign = VerticalAlign.Middle; style2.HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2); // ddlsubtype.Items.Add(new ListItem("")); bindbatch(); binddegree(); bindbranch(); //bindsem(); clear(); clear(); } }
public void loadspreadHeader(DataSet ds) { try { Fpload1.Sheets[0].RowCount = 0; Fpload1.Sheets[0].ColumnCount = 4; Fpload1.CommandBar.Visible = false; Fpload1.Sheets[0].AutoPostBack = true; Fpload1.Sheets[0].ColumnHeader.RowCount = 1; Fpload1.Sheets[0].RowHeader.Visible = false; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.Black; Fpload1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Size = FontUnit.Medium; darkstyle.HorizontalAlign = HorizontalAlign.Center; darkstyle.VerticalAlign = VerticalAlign.Middle; Fpload1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "SNo"; Fpload1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpload1.Sheets[0].ColumnHeader.Cells[0, 0].VerticalAlign = VerticalAlign.Bottom; Fpload1.Sheets[0].ColumnHeader.Cells[0, 0].Locked = true; Fpload1.Sheets[0].Columns[0].Width = 20; Fpload1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Gym_Name"; Fpload1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpload1.Sheets[0].ColumnHeader.Cells[0, 1].VerticalAlign = VerticalAlign.Bottom; Fpload1.Sheets[0].ColumnHeader.Cells[0, 1].Locked = true; Fpload1.Sheets[0].Columns[1].Width = 10; Fpload1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Gym_Acroynm"; Fpload1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpload1.Sheets[0].ColumnHeader.Cells[0, 2].VerticalAlign = VerticalAlign.Bottom; Fpload1.Sheets[0].ColumnHeader.Cells[0, 2].Locked = true; Fpload1.Sheets[0].Columns[2].Width = 50; Fpload1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Gym_PK"; Fpload1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; Fpload1.Sheets[0].ColumnHeader.Cells[0, 3].VerticalAlign = VerticalAlign.Bottom; Fpload1.Sheets[0].ColumnHeader.Cells[0, 3].Locked = true; } catch (Exception ex) {} }
public void loadtermssp2() { FpSpread2.Sheets[0].RowHeader.Visible = false; FpSpread2.CommandBar.Visible = false; FpSpread2.Width = 380; FpSpread2.Height = 150; FpSpread2.Sheets[0].ColumnCount = 4; FpSpread2.Sheets[0].ColumnHeader.RowCount = 1; FpSpread2.Sheets[0].AutoPostBack = false; FpSpread2.Sheets[0].Columns[0].Locked = true; FpSpread2.Sheets[0].Columns[1].Locked = true; FpSpread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Staff"; FpSpread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Description"; FpSpread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select"; FpSpread2.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].Columns[0].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Left; FpSpread2.Sheets[0].Columns[1].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].ColumnHeader.Columns[0].HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].ColumnHeader.Columns[0].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].ColumnHeader.Columns[1].HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].ColumnHeader.Columns[1].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].ColumnHeader.Columns[2].HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].ColumnHeader.Columns[2].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].ColumnHeader.Columns[3].HorizontalAlign = HorizontalAlign.Center; FpSpread2.Sheets[0].ColumnHeader.Columns[3].VerticalAlign = VerticalAlign.Middle; FpSpread2.Sheets[0].Columns[0].Width = 40; FpSpread2.Sheets[0].Columns[1].Width = 100; FpSpread2.Sheets[0].Columns[2].Width = 180; FpSpread2.Sheets[0].Columns[3].Width = 40; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = System.Drawing.Color.White; // darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Size = FontUnit.Medium; darkstyle.Border.BorderSize = 1; darkstyle.Border.BorderColor = System.Drawing.Color.White; FpSpread2.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread2.Sheets[0].RowCount = 0; }
protected void Page_Load(object sender, EventArgs e) { //****************************************************// if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } if (!Request.FilePath.Contains("hostelindex")) { string strPreviousPage = ""; if (Request.UrlReferrer != null) { strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1]; } if (strPreviousPage == "") { Response.Redirect("~/HostelMod/hostelindex.aspx"); return; } } //****************************************************// if (!IsPostBack) { rbplainsheet.Checked = true; chkfootersign.Checked = true; chk_terms.Checked = true; loadprintdetails(); loadtermssp(); loadtermssp2(); showterms(); showstaffdesc(); txtstaff.Attributes.Add("Readonly", "Readonly"); FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = System.Drawing.Color.White; // darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Size = FontUnit.Medium; darkstyle.Border.BorderSize = 1; darkstyle.Border.BorderColor = System.Drawing.Color.White; fsstaff.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; retrive(); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["collegecode"] == null) { Response.Redirect("~/Default.aspx"); } if (!Request.FilePath.Contains("CAMHome")) { string strPreviousPage = ""; if (Request.UrlReferrer != null) { strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1]; } if (strPreviousPage == "") { Response.Redirect("~/MarkMod/CAMHome.aspx"); return; } } usercode = Session["usercode"].ToString(); collegecode1 = Session["collegecode"].ToString(); singleuser = Session["single_user"].ToString(); group_user = Session["group_code"].ToString(); if (!IsPostBack) { Bindcollege(); collegecode = ddlcollege.SelectedValue.ToString(); BindBatch(); BindDegree(singleuser, group_user, collegecode, usercode); BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode); FarPoint.Web.Spread.StyleInfo MyStyle = new FarPoint.Web.Spread.StyleInfo(); MyStyle.Font.Bold = true; MyStyle.Font.Size = FontUnit.Medium; MyStyle.HorizontalAlign = HorizontalAlign.Center; MyStyle.ForeColor = Color.Black; MyStyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); } } catch (Exception ex) { } }
public void GridHeader() { FpStudent.Sheets[0].AutoPostBack = false; FpStudent.CommandBar.Visible = false; FpStudent.Sheets[0].SheetCorner.ColumnCount = 0; FpStudent.Sheets[0].ColumnCount = 0; FpStudent.Sheets[0].RowCount = 0; FpStudent.Sheets[0].ColumnCount = 5; FpStudent.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpStudent.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Degree"; FpStudent.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Branch"; FpStudent.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always); FpStudent.Sheets[0].ColumnHeader.Cells[0, 3].Text = "MaxCredit"; FpStudent.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Pass Credits For Consolidated Mark Sheet"; FpStudent.Sheets[0].Columns[0].Width = 37; FpStudent.Sheets[0].Columns[1].Width = 100; FpStudent.Sheets[0].Columns[2].Width = 350; FpStudent.Sheets[0].Columns[3].Width = 100; FpStudent.Sheets[0].Columns[4].Width = 100; FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo(); style2.Font.Size = 13; style2.Font.Name = "Book Antiqua"; style2.Font.Bold = true; style2.HorizontalAlign = HorizontalAlign.Center; style2.ForeColor = System.Drawing.Color.Black; // style2.BackColor = System.Drawing.Color.Teal; style2.BackColor = ColorTranslator.FromHtml("#0CA6CA"); FpStudent.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2); FpStudent.Sheets[0].SheetName = "Settings"; FpStudent.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; FpStudent.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Center; FpStudent.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; FpStudent.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpStudent.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FpStudent.Sheets[0].DefaultStyle.Font.Bold = false; }
private void LoadHeader() { FpSpread.CommandBar.Visible = false; FpSpread.RowHeader.Visible = false; FpSpread.Sheets[0].AutoPostBack = false; FpSpread.Sheets[0].ColumnHeader.RowCount = 1; FpSpread.Sheets[0].RowCount = 0; FpSpread.Sheets[0].ColumnCount = 6; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Size = FontUnit.Medium; darkstyle.Font.Bold = true; darkstyle.HorizontalAlign = HorizontalAlign.Center; darkstyle.ForeColor = Color.Black; darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); FpSpread.Sheets[0].ColumnHeader.DefaultStyle = darkstyle; FpSpread.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No."; FpSpread.Columns[0].Width = 75; FpSpread.Columns[0].Locked = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Select"; FpSpread.Columns[1].Width = 75; FpSpread.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Code"; FpSpread.Columns[2].Width = 100; FpSpread.Columns[2].Locked = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Staff Name"; FpSpread.Columns[3].Width = 250; FpSpread.Columns[3].Locked = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Department"; FpSpread.Columns[4].Width = 300; FpSpread.Columns[4].Locked = true; FpSpread.Sheets[0].ColumnHeader.Cells[0, 5].Text = "In Time"; FpSpread.Columns[5].Width = 150; FpSpread.Columns[5].Locked = true; }
private void loadrepsprcolumns() { try { Fpspreadpop.Sheets[0].RowCount = 0; Fpspreadpop.Sheets[0].ColumnCount = 7; Fpspreadpop.CommandBar.Visible = false; Fpspreadpop.RowHeader.Visible = false; Fpspreadpop.Sheets[0].AutoPostBack = false; Fpspreadpop.Sheets[0].ColumnHeader.RowCount = 1; Fpspreadpop.Sheets[0].FrozenRowCount = 1; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.Black; Fpspreadpop.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[0].Locked = true; Fpspreadpop.Columns[0].Width = 50; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Select"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[1].Width = 75; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Code"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[2].Locked = true; if (rbnofingerid.Checked == true) { Fpspreadpop.Columns[2].Width = 165; } else { Fpspreadpop.Columns[2].Width = 115; } Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Staff Name"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[3].Locked = true; if (rbnofingerid.Checked == true) { Fpspreadpop.Columns[3].Width = 215; } else { Fpspreadpop.Columns[3].Width = 165; } Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Designation"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[4].Locked = true; if (rbnofingerid.Checked == true) { Fpspreadpop.Columns[4].Width = 240; } else { Fpspreadpop.Columns[4].Width = 190; } Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Department"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[5].Locked = true; if (rbnofingerid.Checked == true) { Fpspreadpop.Columns[5].Width = 240; } else { Fpspreadpop.Columns[5].Width = 190; } Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Finger ID"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 6].HorizontalAlign = HorizontalAlign.Center; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua"; Fpspreadpop.Sheets[0].ColumnHeader.Cells[0, 6].Font.Size = FontUnit.Medium; Fpspreadpop.Columns[6].Locked = true; Fpspreadpop.Columns[6].Width = 115; if (rbnofingerid.Checked == true) { Fpspreadpop.Columns[1].Visible = false; Fpspreadpop.Columns[6].Visible = false; btndelete.Visible = false; } else { Fpspreadpop.Columns[1].Visible = true; Fpspreadpop.Columns[6].Visible = true; btndelete.Visible = true; } } catch { } }
protected void btn_go(object sender, EventArgs e) { try { clear(); FpSpread1.Sheets[0].SheetCorner.ColumnCount = 0; FpSpread1.Sheets[0].ColumnHeader.RowCount = 2; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.Sheets[0].RowCount = 0; FpSpread1.CommandBar.Visible = false; 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.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FarPoint.Web.Spread.StyleInfo style2 = new FarPoint.Web.Spread.StyleInfo(); style2.Font.Size = 13; style2.Font.Name = "Book Antiqua"; style2.Font.Bold = true; style2.HorizontalAlign = HorizontalAlign.Center; style2.ForeColor = Color.White; style2.BackColor = Color.Teal; FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style2); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style2); FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType(); DataSet dsrank = new DataSet(); Hashtable hatstutotal = new Hashtable(); DataSet dsexam = new DataSet(); DataView dvcount = new DataView(); string batchcount = ""; string sqlbatch = ""; string branchcount = ""; string sqlbranch = ""; string exam_year = ""; string exam_month = ""; collegecode = ddlclg.SelectedItem.Value; for (int itemcount = 0; itemcount < chklsbatch.Items.Count; itemcount++) { if (chklsbatch.Items[itemcount].Selected == true) { if (batchcount == "") { batchcount = "'" + chklsbatch.Items[itemcount].Value.ToString() + "'"; } else { batchcount = batchcount + ",'" + chklsbatch.Items[itemcount].Value.ToString() + "'"; } } } if (batchcount != "") { sqlbatch = " and r.batch_year in(" + batchcount + ")"; } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Batch And Then Proceed"; return; } for (int itemcount = 0; itemcount < chklstbranch.Items.Count; itemcount++) { if (chklstbranch.Items[itemcount].Selected == true) { if (branchcount == "") { branchcount = "'" + chklstbranch.Items[itemcount].Value.ToString() + "'"; } else { branchcount = branchcount + ",'" + chklstbranch.Items[itemcount].Value.ToString() + "'"; } } } if (branchcount != "") { sqlbranch = " and r.degree_code in(" + branchcount + ")"; } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Degree and Branch And Then Proceed"; return; } if (ddlyear.Items.Count > 0) { if (ddlyear.SelectedItem.ToString().Trim() != "") { exam_year = ddlyear.SelectedValue.ToString(); } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Exam Year And Then Proceed"; return; } } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Exam Year And Then Proceed"; return; } if (ddlmonth.Items.Count > 0) { if (ddlmonth.SelectedItem.ToString().Trim() != "") { exam_month = ddlmonth.SelectedValue.ToString(); } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Exam Month And Then Proceed"; return; } } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The Exam Month And Then Proceed"; return; } Double cgpafrom = 0; Double cgpato = 0; string strfrange = txt_rangefrom.Text.ToString(); if (strfrange.Trim() != "") { cgpafrom = Convert.ToDouble(strfrange); } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The CGPA From Range And Then Proceed"; return; } string strtrange = txt_to.Text.ToString(); if (strtrange.Trim() != "") { cgpato = Convert.ToDouble(strtrange); } else { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Select The CGPA To Range And Then Proceed"; return; } if (cgpato < cgpafrom) { lbl_errmsg.Visible = true; lbl_errmsg.Text = "Please Enter The CGPA To Range Must Be Greater Then From Range"; return; } string query = "select distinct r.stud_name,r.Reg_No,r.batch_year,dg.Acronym,course.Course_Name,ed.current_semester,r.sections,r.degree_code,d.dept_name,course.course_name,dg.course_id,r.mode ,r.roll_no,r.degree_code,r.mode from registration r,mark_entry me ,department d,course,degree dg,Exam_Details ed where me.roll_no=r.roll_no and r.degree_code=dg.degree_code and dg.course_id = course.course_id and dg.dept_code = d.dept_code and ed.degree_code=r.degree_code and ed.batch_year=r.Batch_Year and me.result='pass' and ed.Exam_Month='" + exam_month + "' and ed.Exam_year='" + exam_year + "' " + sqlbatch + " " + sqlbranch + " order by r.degree_code,r.Batch_Year"; string getbranchvalue = "select distinct d.dept_acronym,c.Course_Name,dg.Degree_Code from registration r,mark_entry me ,department d,course c,degree dg,Exam_Details ed where me.roll_no=r.roll_no and r.degree_code=dg.degree_code and dg.course_id = c.course_id and dg.dept_code = d.dept_code and ed.degree_code=r.degree_code and ed.batch_year=r.Batch_Year and me.result='pass' and ed.Exam_Month='" + exam_month + "' and ed.Exam_year='" + exam_year + "' " + sqlbatch + " " + sqlbranch + " order by c.Course_Name,d.dept_acronym"; ds.Dispose(); ds.Reset(); ds = d2.select_method(query, hat, "Text"); if (ds.Tables[0].Rows.Count > 0) { DataSet dstable = d2.select_method("select * from sysobjects where name='tbl_Topperrank' and Type='U'", hat, "text "); if (dstable.Tables[0].Rows.Count == 0) { int p = d2.insert_method("create table tbl_Topperrank (roll_no nvarchar(50),cgpa float (8),stud_name nvarchar(200),degree nvarchar(500),user_code nvarchar(25))", hat, "text"); } else { int p = d2.insert_method("IF not EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tbl_Topperrank' AND COLUMN_NAME = 'user_code') alter table tbl_Topperrank add user_code nvarchar(15)", hat, "text"); } ds.Dispose(); dsfind = d2.select_method("select name from sysobjects where xtype='p' and name='sp_ins_upd_topperrank' ", hat, "text"); if (dsfind.Tables[0].Rows.Count == 0) { string spcreation = " CREATE procedure sp_ins_upd_topperrank (@RollNumber varchar(50), @cgpa varchar(20), @stud_name varchar(20), @degree varchar(200) ,@user_code nvarchar(25)) as declare @cou_nt int set @cou_nt=(select count(Roll_no)from tbl_Topperrank where Roll_no=@RollNumber) if @cou_nt=0 BEGIN insert into tbl_Topperrank(Roll_no,cgpa,stud_name,degree,user_code) values (@RollNumber,@cgpa,@stud_name,@degree,@user_code) End Else BEGIN update tbl_Topperrank set cgpa=@cgpa where Roll_no=@RollNumber and user_code=@user_code end"; int s = d2.insert_method(spcreation, hat, "Text"); } else { string spalter = " alter procedure sp_ins_upd_topperrank (@RollNumber varchar(50), @cgpa varchar(20), @stud_name varchar(20), @degree varchar(200) ,@user_code nvarchar(25)) as declare @cou_nt int set @cou_nt=(select count(Roll_no)from tbl_Topperrank where Roll_no=@RollNumber) if @cou_nt=0 BEGIN insert into tbl_Topperrank(Roll_no, cgpa,stud_name,degree,user_code)values(@RollNumber,@cgpa,@stud_name,@degree, @user_code) End Else BEGIN update tbl_Topperrank set cgpa=@cgpa where Roll_no=@RollNumber and user_code=@user_code End"; int gf = d2.insert_method(spalter, hat, "Text"); } Boolean rowflag = false; FpSpread1.Sheets[0].ColumnCount++; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "CGPA"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1); string tempdegree = ""; DataSet dsdegree = d2.select_method_wo_parameter(getbranchvalue, "text"); int spancolumn = 0; Boolean valkflag = false; for (int d = 0; d < dsdegree.Tables[0].Rows.Count; d++) { string strdegree = dsdegree.Tables[0].Rows[d]["dept_acronym"].ToString(); string Course = dsdegree.Tables[0].Rows[d]["Course_Name"].ToString(); if (tempdegree != Course || d == dsdegree.Tables[0].Rows.Count - 1) { if (tempdegree != "") { if (tempdegree == Course && d == dsdegree.Tables[0].Rows.Count - 1) { spancolumn++; valkflag = true; FpSpread1.Sheets[0].ColumnCount++; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Course; FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Text = strdegree; FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Note = dsdegree.Tables[0].Rows[d]["Degree_Code"].ToString(); } FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread1.Sheets[0].ColumnCount - spancolumn, 1, spancolumn); } spancolumn = 0; tempdegree = Course; } if (valkflag == false) { spancolumn++; FpSpread1.Sheets[0].ColumnCount++; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Course; FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Text = strdegree; FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 1].Note = dsdegree.Tables[0].Rows[d]["Degree_Code"].ToString(); } } FpSpread1.Sheets[0].ColumnCount++; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Total"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, FpSpread1.Sheets[0].ColumnCount - 1, 2, 1); for (int y = 0; y < chklsbatch.Items.Count; y++) { if (chklsbatch.Items[y].Selected == true) { string batch = chklsbatch.Items[y].Text.ToString(); FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].CellType = txt; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = "Batch " + batch + ""; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].BackColor = Color.AliceBlue; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, FpSpread1.Sheets[0].ColumnCount); int startow = FpSpread1.Sheets[0].RowCount; for (Double dc = cgpato; dc >= cgpafrom; dc = dc - 0.5) { FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].CellType = txt; if (dc == cgpato) { FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = ">" + dc.ToString(); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Note = " and cgpa >" + dc + ""; } else { Double doc1 = dc + 0.5; Double doc2 = dc + 0.001; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = dc + " - " + doc1; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Note = " and cgpa between " + doc2 + " and " + doc1 + ""; } } for (int c = 1; c < FpSpread1.Sheets[0].ColumnCount - 1; c++) { string degreecode = FpSpread1.Sheets[0].ColumnHeader.Cells[1, c].Note.ToString(); ds.Tables[0].DefaultView.RowFilter = "Batch_year='" + batch + "' and degree_code='" + degreecode + "'"; DataView dvstud = ds.Tables[0].DefaultView; for (int s = 0; s < dvstud.Count; s++) { string rollno = dvstud[s]["roll_no"].ToString(); string sem = dvstud[s]["current_semester"].ToString(); string mode = dvstud[s]["mode"].ToString(); string name = dvstud[s]["stud_name"].ToString(); string degreevalue = dvstud[s]["Acronym"].ToString(); int failcount = Convert.ToInt32(d2.GetFunction(" Select COUNT(*) from Mark_Entry,Subject where Mark_Entry.Subject_No = Subject.Subject_No and roll_no='" + rollno + "' and result='fail' and result='Fail' ")); if (failcount == 0) { string cgpav = d2.Calculete_CGPA(rollno, sem, degreecode, batch, mode, collegecode); if (cgpav != "0" && cgpav != "" && cgpav != "-" && cgpav != "NaN") { Double num = 0; if (Double.TryParse(cgpav, out num)) { hat.Clear(); hat.Add("RollNumber", rollno); hat.Add("cgpa", cgpav.ToString()); hat.Add("stud_name", name.ToString()); hat.Add("degree", degreevalue.ToString()); hat.Add("user_code", usercode.ToString()); int o = d2.insert_method("sp_ins_upd_topperrank", hat, "sp"); } } } } for (int r = startow; r < FpSpread1.Sheets[0].RowCount; r++) { string valran = FpSpread1.Sheets[0].Cells[r, 0].Note; string getstucount = d2.GetFunction("select count(roll_no) from tbl_Topperrank where user_code='" + usercode + "' " + valran + ""); if (getstucount.Trim() != "0" && getstucount.Trim() != "") { rowflag = true; } FpSpread1.Sheets[0].Cells[r, c].CellType = txt; FpSpread1.Sheets[0].Cells[r, c].Text = getstucount; FpSpread1.Sheets[0].Cells[r, c].HorizontalAlign = HorizontalAlign.Center; } int p = d2.insert_method("Delete from tbl_Topperrank where user_code='" + usercode + "' ", hat, "text"); } } } for (int r = 1; r < FpSpread1.Sheets[0].RowCount; r++) { int totalstudent = 0; for (int c = 1; c < FpSpread1.Sheets[0].ColumnCount - 1; c++) { string rowsvalue = FpSpread1.Sheets[0].Cells[r, c].Text.ToString(); if (rowsvalue.Trim() != "") { totalstudent = totalstudent + Convert.ToInt32(rowsvalue); } FpSpread1.Sheets[0].Cells[r, FpSpread1.Sheets[0].ColumnCount - 1].Text = totalstudent.ToString(); FpSpread1.Sheets[0].Cells[r, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; } } if (rowflag == true) { FpSpread1.Visible = true; lbl_rptname.Visible = true; btn_excel.Visible = true; btn_print.Visible = true; txt_rpt.Visible = true; } else { lbl_errmsg.Text = "No Records Found"; lbl_errmsg.Visible = true; } } else { lbl_errmsg.Text = "No Records Found"; lbl_errmsg.Visible = true; } FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; } catch (Exception ex) { lbl_errmsg.Text = ex.ToString(); lbl_errmsg.Visible = true; } }
void load_click() { fpattendance.Visible = true; btnprintmaster.Visible = true; string date1; string datefrom; string date2; string dateto; string date6; string year; int day3; string monyear; DateTime monyear1; int day5; date1 = Txtentryfrom.Text.ToString(); string[] split = date1.Split(new Char[] { '/' }); datefrom = split[1].ToString() + "/" + split[0].ToString() + "/" + split[2].ToString(); // monyearfrom= split[1].ToString() +"/" + split[2].ToString(); // day5= year = split[2].ToString(); date2 = Txtentryto.Text.ToString(); string[] split1 = date2.Split(new Char[] { '/' }); dateto = split1[1].ToString() + "/" + split1[0].ToString() + "/" + split1[2].ToString(); date6 = split[1].ToString(); DateTime dt1 = Convert.ToDateTime(datefrom.ToString()); DateTime dt2 = Convert.ToDateTime(dateto.ToString()); TimeSpan t = dt2.Subtract(dt1); long days = t.Days; day3 = Convert.ToInt32(days); fpattendance.Sheets[0].RowCount = 0; fpattendance.Sheets[0].ColumnCount = 0; //fpattendance.CommandBar.Visible = false; //fpattendance.Sheets[0].SheetCorner.Cells[0, 0].Text = "S.No"; //fpattendance.Sheets[0].SheetCorner.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; //fpattendance.Sheets[0].SheetCorner.Cells[0, 0].Border.BorderColorBottom = Color.White; //fpattendance.Sheets[0].SheetCorner.Cells[0, 0].Font.Bold = true; //fpattendance.Sheets[0].SheetCorner.Cells[0, 0].Font.Size = FontUnit.Large; fpattendance.Sheets[0].PageSize = 10; fpattendance.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom; fpattendance.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both; fpattendance.Pager.Align = HorizontalAlign.Right; fpattendance.Pager.Font.Bold = true; fpattendance.Pager.Font.Name = "Book Antiqua"; fpattendance.Pager.ForeColor = Color.DarkGreen; fpattendance.Pager.BackColor = Color.AliceBlue; fpattendance.Pager.PageCount = 5; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.Font.Name = "Book Antiqua"; darkstyle.HorizontalAlign = HorizontalAlign.Center; darkstyle.Font.Bold = true; darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); fpattendance.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; //=============Added by Manikandan 08/05/2013 fpattendance.Sheets[0].ColumnHeader.RowCount = 2; 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() + "'"; con.Close(); con.Open(); SqlCommand comm = new SqlCommand(str, con); SqlDataReader drr = comm.ExecuteReader(); drr.Read(); coll_name = Convert.ToString(drr["collname"]); coll_address1 = Convert.ToString(drr["address1"]); coll_address2 = Convert.ToString(drr["address2"]); coll_address3 = Convert.ToString(drr["address3"]); pin_code = Convert.ToString(drr["pincode"]); fpattendance.Sheets[0].ColumnCount = 7; fpattendance.Sheets[0].ColumnHeader.Rows[0].BackColor = ColorTranslator.FromHtml("#0CA6CA"); fpattendance.Sheets[0].ColumnHeader.Rows[1].BackColor = ColorTranslator.FromHtml("#0CA6CA"); //========================= fpattendance.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; fpattendance.Sheets[0].SetColumnWidth(0, 50); fpattendance.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 2, 1); fpattendance.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Department"; fpattendance.Sheets[0].SetColumnWidth(1, 200); fpattendance.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Total No Of Staff"; fpattendance.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Present"; fpattendance.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 1, 2); fpattendance.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Absent"; fpattendance.Sheets[0].ColumnHeaderSpanModel.Add(0, 5, 1, 2); fpattendance.Sheets[0].ColumnHeader.Cells[0, 1, 1, 5].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].ColumnHeader.Cells[1, 1, 1, 5].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 2, 1); fpattendance.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 3, 1); fpattendance.Sheets[0].ColumnHeader.Cells[1, 0].Text = " "; fpattendance.Sheets[0].ColumnHeader.Cells[1, 1].Text = " "; fpattendance.Sheets[0].ColumnHeader.Cells[1, 3].Text = "Morning"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 3].Tag = "Present"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 4].Text = "Evening"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 4].Tag = "Present"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 5].Text = "Morning"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 5].Tag = "Absent"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 6].Text = "Evening"; fpattendance.Sheets[0].ColumnHeader.Cells[1, 6].Tag = "Absent"; // added staffcategorizer table in below query by jairam 08-11-2014 Modififed By delsi 10.01.2018 Added join Date sql = "SELECT distinct staffmaster.staff_code , staff_name,desig_master.desig_name,dept_name,stafftrans.dept_code,desig_master.priority, stafftrans.smdate, staffmaster.staff_code FROM staffmaster INNER JOIN stafftrans ON staffmaster.staff_code = stafftrans.staff_code INNER JOIN hrdept_master ON stafftrans.dept_code = hrdept_master.dept_code inner join hr_privilege on hr_privilege.dept_code=hrdept_master.dept_code"; sql = sql + " AND staffmaster.college_code = hrdept_master.college_code INNER JOIN desig_master ON stafftrans.desig_code = desig_master.desig_code and hrdept_master.dept_code=stafftrans.dept_code inner join staffcategorizer on staffcategorizer.college_code =hrdept_master.college_code and staffcategorizer.college_code=staffmaster.college_code and staffcategorizer.category_code =stafftrans.category_code and hrdept_master.college_code=" + Session["collegecode"] + " and desig_master.collegecode='" + Session["collegecode"] + "' where stafftrans.latestrec<>0 and ISNULL(DispReports,0) =1 and (staffmaster.resign=0 and staffmaster.settled=0) and join_date<='" + datefrom + "' and staffmaster.college_code=" + Session["collegecode"] + ""; if (cbldepttype.SelectedItem.Value.ToString() != "All") { sql = sql + " and hrdept_master.dept_code = '" + cbldepttype.SelectedItem.Value.ToString() + "'"; } sql = sql + " order by hrdept_master.dept_name"; con1.Open(); SqlCommand cmd = new SqlCommand(sql, con1); SqlDataReader dr14; dr14 = cmd.ExecuteReader(); tempdept_ = ""; int sno = 0; while (dr14.Read()) { if (dr14.HasRows == true) { string staffcode = ""; staffcode = dr14["staff_code"].ToString(); if (tempdept_ == "") { sno++; tempdept_ = dr14["dept_name"].ToString(); rowstr = fpattendance.Sheets[0].RowCount++; } else if ((tempdept_ != "") && (tempdept_ != dr14["dept_name"].ToString())) { //spreadrowcnt++; sno++; rowstr = fpattendance.Sheets[0].RowCount++; fpattendance.Sheets[0].Cells[rowstr, 0].Text = sno.ToString(); fpattendance.Sheets[0].Cells[rowstr, 1].Text = tempdept_.ToString(); fpattendance.Sheets[0].Cells[rowstr, 2].Text = countstaff.ToString(); fpattendance.Sheets[0].Cells[rowstr, 3].Text = totalmorningpresent.ToString(); //Modified By Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 4].Text = totaleveningpresent.ToString(); //Added by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 5].Text = totalmorningabsent.ToString(); //Modified by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 6].Text = totalevenngabsent.ToString(); //Added by Manikandan 08/05/2013 totaleveningpresent = 0; totalmorningpresent = 0; counttotalpresent = 0; totalmorningabsent = 0; totalevenngabsent = 0; counttotalabsent = 0; countstaff = 0; tempdept_ = dr14["dept_name"].ToString(); SbStringMrngP = new StringBuilder(); SbStringEveP = new StringBuilder(); SbStringMrngA = new StringBuilder(); SbStringEveA = new StringBuilder(); } string totalpresent = getfunction(staffcode, datefrom); fpattendance.Sheets[0].Cells[rowstr, 0].Text = sno.ToString(); fpattendance.Sheets[0].Cells[rowstr, 0].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[rowstr, 1].Text = tempdept_.ToString(); fpattendance.Sheets[0].Cells[rowstr, 1].HorizontalAlign = HorizontalAlign.Left; fpattendance.Sheets[0].Cells[rowstr, 2].Text = countstaff.ToString(); fpattendance.Sheets[0].Cells[rowstr, 2].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[rowstr, 3].Text = totalmorningpresent.ToString();//Modified by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 3].Tag = SbStringMrngP.ToString(); fpattendance.Sheets[0].Cells[rowstr, 4].Text = totaleveningpresent.ToString();//Added by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 4].Tag = SbStringEveP.ToString(); fpattendance.Sheets[0].Cells[rowstr, 3].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[rowstr, 4].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[rowstr, 5].Text = totalmorningabsent.ToString();//Modified by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 5].Tag = SbStringMrngA.ToString(); fpattendance.Sheets[0].Cells[rowstr, 6].Text = totalevenngabsent.ToString();//Modified by Manikandan 08/05/2013 fpattendance.Sheets[0].Cells[rowstr, 6].Tag = SbStringEveA.ToString(); fpattendance.Sheets[0].Cells[rowstr, 5].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[rowstr, 6].HorizontalAlign = HorizontalAlign.Center; lblexcel.Visible = true; txtxl.Visible = true; btnxl.Visible = true; btnprintmaster.Visible = true; lblnorec.Visible = false; } //spreadrowcnt = fpattendance.Sheets[0].RowCount; } fpattendance.Sheets[0].RowCount++; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, 1].Text = "Total"; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, 1].Font.Bold = true; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Right; for (int tot = 2; tot < fpattendance.Sheets[0].ColumnCount; tot++) { int total = 0; for (int tot_row = 0; tot_row < fpattendance.Sheets[0].RowCount - 1; tot_row++) { total = total + Convert.ToInt32(fpattendance.Sheets[0].Cells[tot_row, tot].Text.ToString()); } fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, tot].Text = total.ToString(); fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, tot].HorizontalAlign = HorizontalAlign.Center; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, tot].Font.Bold = true; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, tot].Font.Name = "Book Antiqua"; fpattendance.Sheets[0].Cells[fpattendance.Sheets[0].RowCount - 1, tot].Font.Size = FontUnit.Medium; } Double totalRows = 0; totalRows = Convert.ToInt32(fpattendance.Sheets[0].RowCount); if (totalRows >= 10) { fpattendance.Sheets[0].PageSize = Convert.ToInt32(totalRows); fpattendance.Height = 350; fpattendance.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; fpattendance.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; } else if (totalRows == 0) { fpattendance.Height = 300; } else { fpattendance.Sheets[0].PageSize = Convert.ToInt32(totalRows); fpattendance.Height = 75 + (75 * Convert.ToInt32(totalRows)); } Session["totalPages"] = (int)Math.Ceiling(totalRows / fpattendance.Sheets[0].PageSize); if (dr14.HasRows == false) { fpattendance.Visible = false; lblexcel.Visible = false; txtxl.Visible = false; btnxl.Visible = false; btnprintmaster.Visible = false; lblnorec.Visible = true; lblnorec.Text = "No Records Found!"; } //fpattendance.Sheets[0].RowHeader.Cells[fpattendance.Sheets[0].RowCount - 1, 0].Text = " "; }
public void Prioriry() { try { CreateGroup.Visible = false; CreatePriority.Visible = true; CreateMapping.Visible = false; string Query = "select GroupName,ITGroupPK,Priority from IT_GroupMaster where parentCode=0 and collegeCode ='" + ddlcolload.SelectedValue + "'"; ds.Clear(); ds = d2.select_method_wo_parameter(Query, "Text"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { FpSpread1.Visible = true; FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].AutoPostBack = false; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].ColumnCount = 4; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread1.Columns[0].Locked = true; FpSpread1.Columns[0].Width = 50; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Group Name"; 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].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; FpSpread1.Columns[1].Width = 200; FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType(); chkall.AutoPostBack = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Set Priority"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; FpSpread1.Columns[2].Width = 75; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Priority"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; FpSpread1.Columns[3].Locked = true; FpSpread1.Columns[3].Width = 75; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(i + 1); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[i]["GroupName"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[i]["ITGroupPK"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = chkall; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Value = 0; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; string Prioriry = Convert.ToString(ds.Tables[0].Rows[i]["Priority"]); if (Prioriry.Trim() != "" && Prioriry.Trim() != "0") { FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Prioriry.ToString(); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Locked = true; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Value = 1; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Locked = true; } else { FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = ""; } FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; } FpSpread1.Visible = true; FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; FpSpread1.SaveChanges(); FpSpread1.Height = 400; FpSpread1.Width = 600; lblalert.Visible = false; } else { FpSpread1.Visible = false; imgdiv2.Visible = true; lbl_alerterr.Text = "Not Updated"; } } catch { } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["collegecode"] == null) //Aruna For Back Button { Response.Redirect("~/Default.aspx"); } errmsg.Visible = false; FpSpread1.SaveChanges(); if (!IsPostBack) { FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].SheetName = " "; FpSpread1.Sheets[0].SheetCorner.Columns[0].Visible = false; FpSpread1.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FpSpread1.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; FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].AllowTableCorner = true; FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom; FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both; FpSpread1.Pager.Align = HorizontalAlign.Right; FpSpread1.Pager.Font.Bold = true; FpSpread1.Pager.Font.Name = "Book Antiqua"; FpSpread1.Pager.ForeColor = System.Drawing.Color.DarkGreen; FpSpread1.Pager.BackColor = System.Drawing.Color.Beige; FpSpread1.Pager.BackColor = System.Drawing.Color.AliceBlue; FpSpread1.Pager.PageCount = 5; FpSpread1.Visible = false; FpSpread1.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom; FpSpread1.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both; FpSpread1.Pager.Align = HorizontalAlign.Left; FpSpread1.Pager.Font.Bold = true; FpSpread1.Pager.Font.Name = "Book Antiqua"; FpSpread1.Pager.ForeColor = Color.DarkGreen; // FpSpread1.Pager.BackColor = Color.Beige; // FpSpread1.Pager.BackColor = Color.AliceBlue; FpSpread1.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false; FpSpread1.SheetCorner.Columns[0].Visible = false; FpSpread1.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].DefaultStyle.Font.Bold = false; FpSpread1.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; loadstage(); } } catch { } }
protected void btngo_Click(object sender, EventArgs e) { try { clear(); fpsalary.CommandBar.Visible = false; fpsalary.Sheets[0].RowCount = 0; fpsalary.Sheets[0].ColumnCount = 0; fpsalary.Sheets[0].SheetCorner.ColumnCount = 0; fpsalary.Sheets[0].ColumnCount = 15; fpsalary.Sheets[0].ColumnHeader.RowCount = 1; fpsalary.Sheets[0].ColumnHeader.Rows[0].BackColor = Color.AliceBlue; fpsalary.Sheets[0].SheetName = " "; fpsalary.Sheets[0].Columns.Default.VerticalAlign = VerticalAlign.Middle; fpsalary.Sheets[0].Rows.Default.HorizontalAlign = HorizontalAlign.Center; fpsalary.Sheets[0].Rows.Default.VerticalAlign = VerticalAlign.Middle; fpsalary.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; fpsalary.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; fpsalary.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 = Color.Black; style1.BackColor = ColorTranslator.FromHtml("#0CA6CA"); fpsalary.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style1); fpsalary.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style1); fpsalary.Sheets[0].ColumnHeader.DefaultStyle.HorizontalAlign = HorizontalAlign.Center; fpsalary.Sheets[0].AllowTableCorner = true; fpsalary.Pager.Position = FarPoint.Web.Spread.PagerPosition.Bottom; fpsalary.Pager.Mode = FarPoint.Web.Spread.PagerMode.Both; fpsalary.Pager.Align = HorizontalAlign.Right; fpsalary.Pager.Font.Bold = true; fpsalary.Pager.Font.Name = "Book Antiqua"; fpsalary.Pager.ForeColor = Color.DarkGreen; fpsalary.Pager.BackColor = Color.Beige; fpsalary.Pager.BackColor = Color.AliceBlue; fpsalary.Pager.PageCount = 5; fpsalary.CommandBar.Visible = false; fpsalary.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Staff Code"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Name"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Department"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Designation"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Category"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Type"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Date Of Joining"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 8].Text = "PF Join Date"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 9].Text = "Date Of Relive"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 10].Text = "Father/Husband Name"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 11].Text = "Date Of Birth"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 12].Text = "Age"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 13].Text = "PF A/C Number"; fpsalary.Sheets[0].ColumnHeader.Cells[0, 14].Text = "Remarks"; fpsalary.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center; fpsalary.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[7].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[8].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[9].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[10].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[11].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[12].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[13].HorizontalAlign = HorizontalAlign.Left; fpsalary.Sheets[0].Columns[0].Width = 50; fpsalary.Sheets[0].Columns[1].Width = 200; fpsalary.Sheets[0].Columns[2].Width = 200; fpsalary.Sheets[0].Columns[3].Width = 200; fpsalary.Sheets[0].Columns[4].Width = 200; fpsalary.Sheets[0].Columns[5].Width = 200; fpsalary.Sheets[0].Columns[6].Width = 200; fpsalary.Sheets[0].Columns[7].Width = 80; fpsalary.Sheets[0].Columns[8].Width = 80; fpsalary.Sheets[0].Columns[9].Width = 80; fpsalary.Sheets[0].Columns[10].Width = 200; fpsalary.Sheets[0].Columns[11].Width = 80; fpsalary.Sheets[0].Columns[12].Width = 200; fpsalary.Sheets[0].Columns[13].Width = 80; FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType(); fpsalary.Sheets[0].Columns[0].CellType = txt; fpsalary.Sheets[0].Columns[1].CellType = txt; fpsalary.Sheets[0].Columns[2].CellType = txt; fpsalary.Sheets[0].Columns[3].CellType = txt; fpsalary.Sheets[0].Columns[4].CellType = txt; fpsalary.Sheets[0].Columns[5].CellType = txt; fpsalary.Sheets[0].Columns[6].CellType = txt; fpsalary.Sheets[0].Columns[7].CellType = txt; fpsalary.Sheets[0].Columns[8].CellType = txt; fpsalary.Sheets[0].Columns[9].CellType = txt; fpsalary.Sheets[0].Columns[10].CellType = txt; fpsalary.Sheets[0].Columns[11].CellType = txt; fpsalary.Sheets[0].Columns[12].CellType = txt; fpsalary.Sheets[0].Columns[13].CellType = txt; fpsalary.Width = 1200; string strdeptcode = ""; for (int i = 0; i < chklsdept.Items.Count; i++) { if (chklsdept.Items[i].Selected == true) { if (strdeptcode == "") { strdeptcode = "'" + chklsdept.Items[i].Value + "'"; } else { strdeptcode = strdeptcode + ",'" + chklsdept.Items[i].Value + "'"; } } } if (strdeptcode.Trim() != "") { strdeptcode = " and st.dept_code in(" + strdeptcode + ")"; } string strdesignquery = ""; for (int i = 0; i < chklsdesgination.Items.Count; i++) { if (chklsdesgination.Items[i].Selected == true) { if (strdesignquery == "") { strdesignquery = "'" + chklsdesgination.Items[i].Value + "'"; } else { strdesignquery = strdesignquery + ",'" + chklsdesgination.Items[i].Value + "'"; } } } if (strdesignquery.Trim() != "") { strdesignquery = " and st.desig_code in(" + strdesignquery + ")"; } string strcatequery = ""; for (int i = 0; i < chklscategory.Items.Count; i++) { if (chklscategory.Items[i].Selected == true) { if (strcatequery == "") { strcatequery = "'" + chklscategory.Items[i].Value + "'"; } else { strcatequery = strcatequery + ",'" + chklscategory.Items[i].Value + "'"; } } } if (strcatequery.Trim() != "") { strcatequery = " and st.category_code in(" + strcatequery + ")"; } string strtypequery = ""; for (int i = 0; i < chklsstafftype.Items.Count; i++) { if (chklsstafftype.Items[i].Selected == true) { if (strtypequery == "") { strtypequery = "'" + chklsstafftype.Items[i].Value + "'"; } else { strtypequery = strtypequery + ",'" + chklsstafftype.Items[i].Value + "'"; } } } if (strtypequery.Trim() != "") { strtypequery = " and st.stftype in(" + strtypequery + ")"; } string strquery = "select s.staff_code,LEN(s.staff_code),s.staff_name,sa.father_name,sa.husband_name,sa.sex,convert(nvarchar(15),sa.date_of_birth,103) dob,convert(nvarchar(15),s.relieve_date,103) relivedate,convert(nvarchar(15),s.join_date,103) joindate,h.dept_name,d.desig_name,sc.category_name,st.stftype,s.Is_PF,s.pfnumber from staffmaster s,stafftrans st,hrdept_master h,desig_master d,staffcategorizer sc,staff_appl_master sa where sa.appl_no=s.appl_no and s.staff_code=st.staff_code and st.dept_code=h.dept_code and st.desig_code=d.desig_code and st.category_code=sc.category_code and st.latestrec=1 "; if (ddltype.Text.ToString() == "New Staff List") { fpsalary.Sheets[0].Columns[9].Visible = false; fpsalary.Sheets[0].Columns[7].Visible = true; fpsalary.Sheets[0].Columns[8].Visible = true; fpsalary.Sheets[0].Columns[11].Visible = true; fpsalary.Sheets[0].Columns[12].Visible = true; strquery = strquery + " and MONTH(s.join_date) = '" + ddlmonth.SelectedValue.ToString() + "' AND YEAR(s.join_date) = '" + ddlyear.SelectedItem.ToString() + "'"; } else { fpsalary.Sheets[0].Columns[9].Visible = true; fpsalary.Sheets[0].Columns[7].Visible = false; fpsalary.Sheets[0].Columns[8].Visible = false; fpsalary.Sheets[0].Columns[11].Visible = false; fpsalary.Sheets[0].Columns[12].Visible = false; strquery = strquery + " and MONTH(s.relieve_date) = '" + ddlmonth.SelectedValue.ToString() + "' AND YEAR(s.relieve_date) = '" + ddlyear.SelectedItem.ToString() + "' and ((s.resign=1 and s.settled=1) or (s.Discontinue=1))"; } strquery = strquery + strdeptcode + strdesignquery + strcatequery + strtypequery + " order by s.join_date,LEN(s.staff_code),s.staff_code,s.staff_name"; ds.Dispose(); ds.Reset(); ds.Clear(); ds = d2.select_method_wo_parameter(strquery, "Text"); if (ds.Tables[0].Rows.Count > 0) { fpsalary.Visible = true; lblexcel.Visible = true; txtexcel.Visible = true; btnprintmaster.Visible = true; btnexcel.Visible = true; int srno = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string staffcode = ds.Tables[0].Rows[i]["staff_code"].ToString(); string name = ds.Tables[0].Rows[i]["staff_name"].ToString(); string dob = ds.Tables[0].Rows[i]["dob"].ToString(); string jdate = ds.Tables[0].Rows[i]["joindate"].ToString(); string deptname = ds.Tables[0].Rows[i]["dept_name"].ToString(); string designname = ds.Tables[0].Rows[i]["desig_name"].ToString(); string catname = ds.Tables[0].Rows[i]["category_name"].ToString(); string stftypenme = ds.Tables[0].Rows[i]["stftype"].ToString(); string fname = ds.Tables[0].Rows[i]["father_name"].ToString(); string hname = ds.Tables[0].Rows[i]["husband_name"].ToString(); if (hname.Trim() != "" && hname == null) { fname = hname; } string pfnumber = ds.Tables[0].Rows[i]["pfnumber"].ToString(); string relivedate = ds.Tables[0].Rows[i]["relivedate"].ToString(); string age = ""; string[] spdate = dob.Split('/'); if (spdate.GetUpperBound(0) == 2) { int curemonth = 0, cureyear; DateTime dtdob = Convert.ToDateTime(spdate[1] + '/' + spdate[0] + '/' + spdate[2]); DateTime dtnow = DateTime.Now; int cury = Convert.ToInt32(dtnow.ToString("yyyy")); int jyear = Convert.ToInt32(dtdob.ToString("yyyy")); cureyear = cury - jyear; int curmon = Convert.ToInt32(dtnow.ToString("MM")); int jmon = Convert.ToInt32(dtdob.ToString("MM")); if (curmon < jmon) { curemonth = (curmon + 12) - jmon; cureyear--; } else { curemonth = curmon - jmon; } age = cureyear.ToString() + " Years "; if (curemonth > 0) { age = age + curemonth + " Months"; } } fpsalary.Sheets[0].RowCount++; srno++; fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 0].Text = srno.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 1].Text = staffcode.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 2].Text = name.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 3].Text = deptname.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 4].Text = designname.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 5].Text = catname.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 6].Text = stftypenme.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 7].Text = jdate.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 8].Text = jdate.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 9].Text = relivedate.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 10].Text = fname.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 11].Text = dob.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 12].Text = age.ToString(); fpsalary.Sheets[0].Cells[fpsalary.Sheets[0].RowCount - 1, 13].Text = pfnumber.ToString(); } } else { errmsg.Text = "No Records Found"; errmsg.Visible = true; } fpsalary.Sheets[0].PageSize = fpsalary.Sheets[0].RowCount; } catch (Exception ex) { errmsg.Visible = true; errmsg.Text = ex.ToString(); d2.sendErrorMail(ex, "13", "StaffSalarydetails.aspx"); } }
protected void btn_go_Click(object sender, EventArgs e) { try { hide(); FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].AutoPostBack = true; FpSpread1.Height = 1000; FpSpread1.Width = 600; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].ColumnCount = 8; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread1.Visible = true; FarPoint.Web.Spread.CheckBoxCellType chkall = new FarPoint.Web.Spread.CheckBoxCellType(); FarPoint.Web.Spread.CheckBoxCellType chk = new FarPoint.Web.Spread.CheckBoxCellType(); chkall.AutoPostBack = false; string selqry = "select category,shortname,status,LeaveMasterPK from leave_category where college_Code='" + collegecode1 + "'"; ds.Clear(); ds = d2.select_method_wo_parameter(selqry, "text"); if (ds.Tables[0].Rows.Count > 0) { FpSpread1.Sheets[0].Rows.Count = ds.Tables[0].Rows.Count; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { FpSpread1.Sheets[0].Cells[i, 3].CellType = chk; FpSpread1.Sheets[0].Cells[i, 4].CellType = chk; FpSpread1.Sheets[0].Cells[i, 5].CellType = chk; FpSpread1.Sheets[0].Cells[i, 6].CellType = chk; FpSpread1.Sheets[0].Cells[i, 3].Locked = true; FpSpread1.Sheets[0].Cells[i, 4].Locked = true; FpSpread1.Sheets[0].Cells[i, 5].Locked = true; FpSpread1.Sheets[0].Cells[i, 6].Locked = true; FpSpread1.Sheets[0].Cells[i, 0].Text = Convert.ToString(i + 1); FpSpread1.Sheets[0].Cells[i, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 1].Text = ds.Tables[0].Rows[i]["category"].ToString(); FpSpread1.Sheets[0].Cells[i, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 2].Text = ds.Tables[0].Rows[i]["shortname"].ToString(); FpSpread1.Sheets[0].Cells[i, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 7].Value = ds.Tables[0].Rows[i]["LeaveMasterPK"].ToString(); FpSpread1.Sheets[0].Cells[i, 7].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 4].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[i, 5].Font.Name = "Book Antiqua"; string statusss = ds.Tables[0].Rows[i]["status"].ToString(); if (statusss.Trim() == "2") { FpSpread1.Sheets[0].Cells[i, 3].Value = 1; } if (statusss.Trim() == "0") { FpSpread1.Sheets[0].Cells[i, 4].Value = 1; } if (statusss.Trim() == "1") { FpSpread1.Sheets[0].Cells[i, 5].Value = 1; } } FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 60; FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 244; FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 150; FpSpread1.Sheets[0].ColumnHeader.Columns[3].Width = 102; FpSpread1.Sheets[0].ColumnHeader.Columns[4].Width = 102; FpSpread1.Sheets[0].ColumnHeader.Columns[5].Width = 102; FpSpread1.Sheets[0].ColumnHeader.Columns[6].Width = 102; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Leave Name"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Short Form"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Earn Leave"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Treated As Present"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Treated As LOP"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Select"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Id"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Columns[7].Visible = false; FpSpread1.Sheets[0].Columns[6].Visible = false; for (int i = 0; i < FpSpread1.Sheets[0].Columns.Count; i++) { FpSpread1.Sheets[0].ColumnHeader.Columns[i].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Columns[i].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[i].HorizontalAlign = HorizontalAlign.Center; } FpSpread1.Sheets[0].Columns[1].HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Left; FpSpread1.SaveChanges(); FpSpread1.Sheets[0].PageSize = ds.Tables[0].Rows.Count; FpSpread1.Visible = true; addnew.Visible = false; div1.Visible = true; rptprint.Visible = true; lbl_error.Visible = false; } else { lbl_error.Visible = true; lbl_error.Text = "No Records Found"; } } catch (Exception ex) { d2.sendErrorMail(ex, collegecode1, "LeaveMaster_Alter.aspx"); } }
protected void btn_go_Click(object sender, EventArgs e) { string collcode = Convert.ToString(ddlclg.SelectedItem.Value); try { int count = 0; for (int i = 0; i < cbl_dptname.Items.Count; i++) { if (cbl_dptname.Items[i].Selected == true) { count++; } } if (count == 0) { lbl_alert.Text = "Please Select Atleast One Department"; lbl_alert.Visible = true; imgdiv2.Visible = true; hide(); return; } string deptcod = ""; if (cbl_dptname.Items.Count > 0) { for (int i = 0; i < cbl_dptname.Items.Count; i++) { if (cbl_dptname.Items[i].Selected == true) { if (deptcod == "") { deptcod = Convert.ToString(cbl_dptname.Items[i].Value); } else { deptcod = deptcod + "','" + Convert.ToString(cbl_dptname.Items[i].Value); } } } } count = 0; string sql = ""; DataView dvfil = new DataView(); Fpspread1.Sheets[0].Rows.Count = 0; Fpspread1.Sheets[0].Columns.Count = 6; Fpspread1.Height = 340; Fpspread1.Width = 800; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].AutoPostBack = false; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Columns[0].Width = 75; Fpspread1.Sheets[0].ColumnHeader.Columns[1].Width = 310; Fpspread1.Sheets[0].ColumnHeader.Columns[2].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Columns[3].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Columns[4].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Columns[5].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Designation"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Available Staff"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "No.of Req Staff"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "No.of Vacancy"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "No.of Additional Req Staff"; FarPoint.Web.Spread.DoubleCellType intgrcel = new FarPoint.Web.Spread.DoubleCellType(); intgrcel.FormatString = System.Windows.Forms.MaskFormat.ExcludePromptAndLiterals.ToString(); intgrcel.MinimumValue = 0; intgrcel.ErrorMessage = "Enter valid Required Staff"; string desigcod = d2.GetFunction(" Select desig_code from desig_master where desig_name='" + txt_search.Text.ToString() + "' and collegeCode='" + collcode + "'"); string selquery = ""; selquery = "select t.desig_code,t.dept_code,count(s.staff_code)as count from staffmaster s,stafftrans t where s.staff_code =t.staff_code and t.latestrec ='1' and resign=0 and settled =0 and isnull(Discontinue,'0') ='0' and s.college_code ='" + collcode + "' group by t.desig_code,t.dept_code"; selquery = selquery + " select DeptCode,DesigCode,No_ofPersons from VacancyMaster where Collegecode ='" + collcode + "'"; DataSet dsnew = new DataSet(); dsnew.Clear(); dsnew = d2.select_method_wo_parameter(selquery, "Text"); int sno = 1; int rowcount = 0; if (cbl_dptname.Items.Count > 0 && txt_dptname.Text.Trim() != "--Select--") { for (int st = 0; st < cbl_dptname.Items.Count; st++) { if (cbl_dptname.Items[st].Selected == true) { rowcount = 0; Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(cbl_dptname.Items[st].Text); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Bold = true; Fpspread1.Sheets[0].SpanModel.Add(Fpspread1.Sheets[0].RowCount - 1, 0, 1, 6); string selq = "select desig_code,desig_name from desig_master where ((dept_code like '" + Convert.ToString(cbl_dptname.Items[st].Value) + ";%') or (dept_code like '%;" + Convert.ToString(cbl_dptname.Items[st].Value) + "%') or (dept_code like '%" + Convert.ToString(cbl_dptname.Items[st].Value) + "') or (dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "'))"; ds.Clear(); ds = d2.select_method_wo_parameter(selq, "Text"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int ik = 0; ik < ds.Tables[0].Rows.Count; ik++) { if (txt_search.Text.Trim() != "") { if (Convert.ToString(ds.Tables[0].Rows[ik]["desig_code"]) == desigcod) { rowcount++; Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno++); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(txt_search.Text.Trim()); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(desigcod); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(cbl_dptname.Items[st].Value); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; if (dsnew.Tables.Count > 0 && dsnew.Tables[0].Rows.Count > 0) { DataView dvnew = new DataView(); dsnew.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and desig_code='" + desigcod + "'"; dvnew = dsnew.Tables[0].DefaultView; if (dvnew.Count > 0) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dvnew[0]["count"]); } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-"; } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; if (dsnew.Tables.Count > 0 && dsnew.Tables[1].Rows.Count > 0) { DataView dvmynew = new DataView(); dsnew.Tables[1].DefaultView.RowFilter = " DeptCode='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and DesigCode='" + desigcod + "'"; dvmynew = dsnew.Tables[1].DefaultView; if (dvmynew.Count > 0) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dvmynew[0]["No_ofPersons"]); } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-"; } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; Double availcount = 0; Double noofreq = 0; Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text), out availcount); Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text), out noofreq); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(noofreq - availcount); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].CellType = intgrcel; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; } } else { for (int jk = 0; jk < cbl_desname.Items.Count; jk++) { if (cbl_desname.Items[jk].Selected == true) { if (Convert.ToString(ds.Tables[0].Rows[ik]["desig_code"]) == Convert.ToString(cbl_desname.Items[jk].Value)) { rowcount++; Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno++); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(cbl_desname.Items[jk].Text); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(cbl_desname.Items[jk].Value); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(cbl_dptname.Items[st].Value); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; if (dsnew.Tables.Count > 0 && dsnew.Tables[0].Rows.Count > 0) { DataView dvnew = new DataView(); dsnew.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and desig_code='" + Convert.ToString(cbl_desname.Items[jk].Value) + "'"; dvnew = dsnew.Tables[0].DefaultView; if (dvnew.Count > 0) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dvnew[0]["count"]); } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-"; } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = "-"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; if (dsnew.Tables.Count > 0 && dsnew.Tables[1].Rows.Count > 0) { DataView dvmynew = new DataView(); dsnew.Tables[1].DefaultView.RowFilter = " DeptCode='" + Convert.ToString(cbl_dptname.Items[st].Value) + "' and DesigCode='" + Convert.ToString(cbl_desname.Items[jk].Value) + "'"; dvmynew = dsnew.Tables[1].DefaultView; if (dvmynew.Count > 0) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dvmynew[0]["No_ofPersons"]); } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-"; } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = "-"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; Double availcount = 0; Double noofreq = 0; Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text), out availcount); Double.TryParse(Convert.ToString(Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text), out noofreq); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(noofreq - availcount); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].CellType = intgrcel; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; } } } } } if (rowcount == 0) { Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove(); } } else { Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove(); } } } } for (int ii = 0; ii < Fpspread1.Sheets[0].Columns.Count; ii++) { Fpspread1.Sheets[0].ColumnHeader.Columns[ii].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Columns[ii].Font.Size = FontUnit.Medium; } for (int kl = 0; kl < Fpspread1.Sheets[0].ColumnCount - 1; kl++) { Fpspread1.Sheets[0].Columns[kl].Locked = true; } if (Fpspread1.Sheets[0].RowCount > 1) { Fpspread1.Visible = true; rptprint.Visible = true; div1.Visible = true; Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; Fpspread1.SaveChanges(); txt_search.Text = ""; } else { txt_search.Text = ""; lbl_alert.Text = "No Records Found"; lbl_alert.Visible = true; imgdiv2.Visible = true; hide(); } //} //else //{ // txt_search.Text = ""; // lbl_alert.Text = "No Records Found"; // lbl_alert.Visible = true; // imgdiv2.Visible = true; // hide(); //} } catch (Exception ex) { d2.sendErrorMail(ex, collcode, "manpower_Alter.aspx"); } }
protected void btngoclick(object sender, EventArgs e) { try { Printcontrol.Visible = false; string hostelname = ""; for (int i = 0; i < ddlhos.Items.Count; i++) { if (ddlhos.Items.Count > 0) { hostelname = ddlhos.SelectedItem.Text; } } string vendor = ""; for (int i = 0; i < Cblven.Items.Count; i++) { if (Cblven.Items[i].Selected == true) { if (vendor == "") { vendor = "" + Cblven.Items[i].Value.ToString() + ""; } else { vendor = vendor + "'" + "," + "'" + Cblven.Items[i].Value.ToString() + ""; } } } string itemname = ""; for (int i = 0; i < Cblitm.Items.Count; i++) { if (Cblitm.Items[i].Selected == true) { if (itemname == "") { itemname = "" + Cblitm.Items[i].Value.ToString() + ""; } else { itemname = itemname + "'" + "," + "'" + Cblitm.Items[i].Value.ToString() + ""; } } } string firstdate = Convert.ToString(txtfrom.Text); string seconddate = Convert.ToString(txtto.Text); DateTime dt = new DateTime(); DateTime dt1 = new DateTime(); string[] split = firstdate.Split('/'); dt = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); split = seconddate.Split('/'); dt1 = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); DataView dv = new DataView(); if (vendor.Trim() != "" && itemname.Trim() != "") { // string q = "select distinct v.vendor_code, item_name,i.item_code,i.item_unit,(app_qty-isnull(waiting_app_qty,0)) as app_qty,(app_qty-isnull(waiting_app_qty,0))- ISNULL(inward_qty,0) as rej_qty,inward_qty,rpu ,(rpu * inward_qty)as value,gi_date from item_master i,vendor_details v,Vendor_ItemDetails vi ,purchase_order p,purchaseorder_items pi,goods_inward g,goodsinward_items gi where v.vendor_code =vi.Vendor_Code and i.item_code =vi.Item_Code and p.order_code =pi.order_code and pi.item_code =i.item_code and pi.item_code =vi.Item_Code and vi.Vendor_Code =pi.vendor_code and pi.vendor_code =v.vendor_code and order_approval ='Approved' and goods_in ='1' and g.gi_code =gi.gi_code and gi.item_code =i.item_code and gi.item_code =vi.Item_Code and gi.item_code =pi.item_code and g.Order_Code =p.order_code and v.vendor_code in ('" + vendor + "') and i.item_code in ('" + itemname + "') and g.gi_date between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' order by v.vendor_code, i.item_code"; string q = " select p.OrderCode,i.ItemPK,i.ItemName,i.ItemCode,i.ItemUnit,(pi.RPU*g.InwardQty) as value,pi.RPU,convert(varchar(10),g.GoodsInwardDate,103) as GoodsInwardDate,v.VendorPK,(pi.AppQty -ISNULL(pi.RejQty,0))as appQty,g.InwardQty,((pi.AppQty -ISNULL(pi.RejQty,0))-InwardQty) as Pending from IM_ItemMaster i,CO_VendorMaster v,IT_PurchaseOrder p,IT_PurchaseOrderDetail pi,IT_GoodsInward g where v.VendorPK =p.VendorFK and p.PurchaseOrderPK =pi.PurchaseOrderFK and i.ItemPK =pi.ItemFK and g.PurchaseOrderFK =p.PurchaseOrderPK and g.itemfk =i.ItemPK and ApproveStatus ='1' and InwardStatus ='1' and g.GoodsInwardDate between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' and i.ItemPK in ('" + itemname + "') and v.VendorPK in ('" + vendor + "') order by OrderCode "; ds = da.select_method_wo_parameter(q, "Text"); if (ds.Tables[0].Rows.Count > 0) { spreaddiv.Visible = true; FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].AutoPostBack = true; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].ColumnCount = 9; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[0].Width = 50; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Item Code"; 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].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[1].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Item Name"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[2].Width = 200; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Item Measure"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[3].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Rate Per Unit"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[4].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Approved Quantity"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[5].Width = 100; FpSpread1.Columns[5].ForeColor = Color.Blue; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Received Quantity"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[6].Width = 100; FpSpread1.Columns[6].ForeColor = Color.Green; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Text = "Pending Quantity"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 7].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[7].Width = 100; FpSpread1.Columns[7].ForeColor = Color.Red; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Text = "Total Value"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 8].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[8].Width = 100; int sno = 0; for (int ir = 0; ir < Cblven.Items.Count; ir++) { if (Cblven.Items[ir].Selected == true) { split = firstdate.Split('/'); dt = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); split = seconddate.Split('/'); dt1 = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); while (dt <= dt1) { ds.Tables[0].DefaultView.RowFilter = "VendorPK='" + Cblven.Items[ir].Value + "' and GoodsInwardDate='" + dt.ToString("dd/MM/yyyy") + "' "; dv = ds.Tables[0].DefaultView; if (dv.Count > 0) { FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(Cblven.Items[ir].Text) + " - " + Convert.ToString(dt.ToString("dd/MM/yyyy")); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].SpanModel.Add(FpSpread1.Sheets[0].RowCount - 1, 0, 1, FpSpread1.Sheets[0].ColumnCount); for (int rd = 0; rd < dv.Count; rd++) { sno++; FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(sno); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dv[rd]["ItemCode"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dv[rd]["ItemName"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dv[rd]["ItemUnit"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dv[rd]["RPU"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dv[rd]["appQty"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dv[rd]["InwardQty"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dv[rd]["Pending"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua"; if (Convert.ToString(dv[rd]["Pending"]) != "0") { FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 7].ForeColor = Color.Red; } FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dv[rd]["value"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua"; } } dt = dt.AddDays(1); } } } FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; spreaddiv.Visible = true; lblerror.Visible = false; rptprint.Visible = true; } else { lblerror.Visible = true; lblerror.Text = "No Record Found"; spreaddiv.Visible = false; rptprint.Visible = false; } } else { lblerror.Visible = true; lblerror.Text = "Please Select All Fields"; spreaddiv.Visible = false; rptprint.Visible = false; } } catch { } }
protected void btn_go_Click(object sender, EventArgs e) { try { Printcontrol.Visible = false; Hashtable totalvalue_dic = new Hashtable(); if (txt_seat.Text != "--Select--" && txt_degree.Text != "--Select--" && txt_branch.Text != "--Select--") { Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 0; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].AutoPostBack = true; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].Columns.Count = 2; string firstdate = Convert.ToString(txt_fromdate.Text); string seconddate = Convert.ToString(txt_todate.Text); string[] split = firstdate.Split('/'); dt = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); string[] split1 = seconddate.Split('/'); dt1 = Convert.ToDateTime(split1[1] + "/" + split1[0] + "/" + split1[2]); FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[0].Width = 50; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = lbl_branch.Text; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[1].Width = 200; if (cbl_seat.Items.Count > 0) { for (i = 0; i < cbl_seat.Items.Count; i++) { if (cbl_seat.Items[i].Selected == true) { Fpspread1.Sheets[0].ColumnCount++; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(cbl_seat.Items[i].Text); Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(cbl_seat.Items[i].Value); Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 160; } } } Fpspread1.Sheets[0].ColumnCount++; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Text = "Available"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, Fpspread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[Fpspread1.Sheets[0].ColumnCount - 1].Width = 150; if (cbl_branch.Items.Count > 0) { q1 = ""; q1 = " select count(seattype) countseat,seattype,degree_code from applyn where date_applied between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' group by seattype,degree_code"; q1 += " select d.No_Of_seats,COUNT(r.degree_code)filled,(d.No_Of_seats-COUNT(r.degree_code)) available,r.degree_code from Registration r, Degree d,department dt,course c where c.Course_Id=d.Course_Id and dt.Dept_Code=d.Dept_Code and c.college_code=d.college_code and dt.college_code=d.college_code and r.degree_code=d.Degree_Code and r.college_code=d.college_code and r.Batch_Year='" + ddl_batch.SelectedItem.Value + "' and r.college_code='" + Convert.ToString(ddl_college.SelectedValue) + "' group by r.degree_code ,No_Of_seats"; ds.Clear(); ds = d2.select_method_wo_parameter(q1, "text"); int r = 1; int availabletotal = 0; for (i = 0; i < cbl_branch.Items.Count; i++) { if (cbl_branch.Items[i].Selected == true) { Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(r++); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(cbl_branch.Items[i].Text); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(cbl_branch.Items[i].Value); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; for (int k = 2; k < Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1; k++) { string seattypevalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, k].Tag); if (ds.Tables[0].Rows.Count > 0) { ds.Tables[0].DefaultView.RowFilter = " seattype='" + seattypevalue + "'and degree_code=" + Convert.ToString(cbl_branch.Items[i].Value) + " "; DataView dv = ds.Tables[0].DefaultView; if (dv.Count > 0) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Text = Convert.ToString(dv[0]["countseat"]); if (totalvalue_dic.Contains(seattypevalue)) { string value = totalvalue_dic[seattypevalue].ToString(); totalvalue_dic.Remove(seattypevalue); int total = Convert.ToInt32(value) + Convert.ToInt32(dv[0]["countseat"]); totalvalue_dic.Add(seattypevalue, total); } else { totalvalue_dic.Add(seattypevalue, Convert.ToInt32(dv[0]["countseat"])); } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Text = "0"; } } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Text = "0"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Name = "Book Antiqua"; } ds.Tables[1].DefaultView.RowFilter = " degree_code='" + Convert.ToString(cbl_branch.Items[i].Value) + "'"; DataView dv1 = ds.Tables[1].DefaultView; string avilable = ""; if (dv1.Count > 0) { avilable = dv1[0]["available"].ToString(); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Text = avilable; availabletotal += Convert.ToInt32(avilable); } else { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Text = "0"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Name = "Book Antiqua"; } } Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = "Grant Total"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; for (int k = 2; k < Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1; k++) { string seattypevalue = Convert.ToString(Fpspread1.Sheets[0].ColumnHeader.Cells[0, k].Tag); if (totalvalue_dic.Count > 0) { string value = ""; if (totalvalue_dic.Contains(seattypevalue)) { value = totalvalue_dic[seattypevalue].ToString(); } else { value = "0"; } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Text = value; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, k].Font.Name = "Book Antiqua"; } } Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Text = availabletotal.ToString(); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, Fpspread1.Sheets[0].ColumnHeader.Columns.Count - 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].BackColor = Color.Bisque; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].ForeColor = Color.IndianRed; Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; Fpspread1.Visible = true; rptprint.Visible = true; lbl_error.Visible = false; } } else { lbl_error.Visible = true; lbl_error.Text = "Please select All Fields"; Fpspread1.Visible = false; rptprint.Visible = false; } } catch (Exception ex) { lbl_error.Visible = true; lbl_error.Text = ex.ToString(); d2.sendErrorMail(ex, collegecode1, "Enquiry_report"); } }
protected void btn_go_Click(object sender, EventArgs e) { try { string itemheadercode = ""; for (int i = 0; i < cbl_itemname.Items.Count; i++) { if (cbl_itemname.Items[i].Selected == true) { if (itemheadercode == "") { itemheadercode = "" + cbl_itemname.Items[i].Value.ToString() + ""; } else { itemheadercode = itemheadercode + "'" + "," + "'" + cbl_itemname.Items[i].Value.ToString() + ""; } } } if (itemheadercode.Trim() != "") { string selectquery = ""; if (txt_searchby.Text.Trim() != "") { selectquery = "select i.item_code,i.item_name,CONVERT(varchar(10), RPUdate,103) as RPUdate,RPU from ItemRateMaster im,item_master i where i.item_code =im.item_Code and i.item_name ='" + txt_searchby.Text + "'"; } else if (txt_searchitemcode.Text.Trim() != "") { selectquery = "select i.item_code,i.item_name,CONVERT(varchar(10), RPUdate,103) as RPUdate,RPU from ItemRateMaster im,item_master i where i.item_code =im.item_Code and i.item_code ='" + txt_searchitemcode.Text + "'"; } else if (txt_searchheadername.Text.Trim() != "") { selectquery = "select i.item_code,i.item_name,CONVERT(varchar(10), RPUdate,103) as RPUdate,RPU from ItemRateMaster im,item_master i where i.item_code =im.item_Code and i.itemheader_name ='" + txt_searchheadername.Text + "'"; } else { selectquery = "select i.item_code,i.item_name,CONVERT(varchar(10), RPUdate,103) as RPUdate,RPU from ItemRateMaster im,item_master i where i.item_code =im.item_Code and i.item_code in ('" + itemheadercode + "') "; } ds.Clear(); ds = d2.select_method_wo_parameter(selectquery, "Text"); if (ds.Tables[0].Rows.Count > 0) { Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 0; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].AutoPostBack = true; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].ColumnCount = 5; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[0].Width = 50; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Item Code"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[1].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Item Name"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[2].Width = 200; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Date"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Cost Per Unit"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; for (int row = 0; row < ds.Tables[0].Rows.Count; row++) { Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[row]["item_code"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["item_name"]); //Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(ds.Tables[0].Rows[row]["rpu"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["RPUdate"]); // Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Tag = Convert.ToString(ds.Tables[0].Rows[row]["Stock_Value"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[row]["RPU"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; } Fpspread1.Visible = true; rptprint.Visible = true; div1.Visible = true; lbl_error.Visible = false; Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Records Found"; } } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; imgdiv2.Visible = true; lbl_alert.Visible = true; lbl_alert.Text = "Please Select Any one Item Name"; // lbl_error.Visible = true; // lbl_error.Text = "Please Select Any one Item Name"; } } catch { } }
protected void btn_go_Click(object sender, EventArgs e) { try { lbl_error.Visible = false; FpSpread1.SaveChanges(); FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].AutoPostBack = true; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].ColumnCount = 4; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Header"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Questions"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Question Option"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Columns[0].Width = 59; FpSpread1.Sheets[0].ColumnHeader.Columns[1].Width = 150; FpSpread1.Sheets[0].ColumnHeader.Columns[2].Width = 328; string headercode = rs.GetSelectedItemsValueAsString(cbl_header1); string questionfk = rs.GetSelectedItemsValueAsString(cbl_question1); string markmasterfk = rs.GetSelectedItemsValueAsString(cbl_option1); string q1 = " select FeedBackMasterPK from CO_FeedBackMaster where FeedBackName='" + ddl_feedback1.SelectedItem.Value + "'"; ds.Clear(); ds = d2.select_method_wo_parameter(q1, "text"); string FeedBackMasterPK = GetdatasetRowstring(ds, "FeedBackMasterPK"); q1 = " select distinct t.TextVal,q.Question,m.MarkType,qt.QuestionmasterFK,qt.HeaderCode,qt.MarkMasterFK,q.CollegeCode from Co_Question_Type qt,CO_MarkMaster m,CO_QuestionMaster q,TextValTable t,CO_FeedBackQuestions fq where q.QuestionMasterPK=fq.QuestionMasterFK and t.TextCode= qt.HeaderCode and qt.MarkMasterFK=m.MarkMasterPK and qt.QuestionmasterFK=q.QuestionMasterPK and qt.HeaderCode=q.HeaderCode and m.CollegeCode=q.CollegeCode and q.HeaderCode in('" + headercode + "') and qt.MarkMasterFK in('" + markmasterfk + "') and qt.FeedbackFk=fq.FeedBackMasterFK and qt.FeedbackFk in('" + FeedBackMasterPK + "') and qt.QuestionmasterFK in('" + questionfk + "') order by TextVal"; ds.Clear(); ds = d2.select_method_wo_parameter(q1, "text"); int row = 0; if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < cbl_header1.Items.Count; i++) { if (cbl_header1.Items[i].Selected == true) { for (int j = 0; j < cbl_question1.Items.Count; j++) { if (cbl_question1.Items[j].Selected == true) { ds.Tables[0].DefaultView.RowFilter = " HeaderCode='" + cbl_header1.Items[i].Value + "' and QuestionmasterFK='" + cbl_question1.Items[j].Value + "'"; //and MarkType='"++"' and DataView dv = ds.Tables[0].DefaultView; if (dv.Count > 0) { foreach (DataRowView dr in dv) { row++; FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = row.ToString(); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["TextVal"]); 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].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["Question"]); 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].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["MarkType"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; FpSpread1.Visible = true; rptprint1.Visible = true; } } } } } } FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].Rows.Count; FpSpread1.Sheets[0].SetColumnMerge(1, FarPoint.Web.Spread.Model.MergePolicy.Always); FpSpread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always); } else { lbl_error.Visible = true; lbl_error.Text = "No Records Found"; FpSpread1.Visible = false; rptprint1.Visible = false; } } else { lbl_error.Visible = true; lbl_error.Text = "No Records Found"; FpSpread1.Visible = false; rptprint1.Visible = false; } FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; } catch { } }
private void loadSpreadValues(DataSet dsVal, string dateEnding) { try { #region Design Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 0; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].AutoPostBack = true; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].ColumnCount = 0; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.Black; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; ArrayList arColumn = getColumn(); foreach (string columN in arColumn) { Fpspread1.Sheets[0].ColumnCount++; int colCnt = Fpspread1.Sheets[0].ColumnCount - 1; Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].Text = columN; Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].ForeColor = ColorTranslator.FromHtml("#000000"); Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Columns[colCnt].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Columns[colCnt].Width = 40; switch (columN) { case "Year Ending(₹)": Fpspread1.Sheets[0].ColumnHeader.Cells[0, colCnt].Text = columN + "-" + dateEnding; Fpspread1.Sheets[0].Columns[colCnt].Width = 150; Fpspread1.Sheets[0].Columns[colCnt].HorizontalAlign = HorizontalAlign.Right; break; case "Particulars": Fpspread1.Sheets[0].Columns[colCnt].Width = 200; Fpspread1.Sheets[0].Columns[colCnt].HorizontalAlign = HorizontalAlign.Left; break; case "Debit(₹)": Fpspread1.Sheets[0].Columns[colCnt].Width = 80; Fpspread1.Sheets[0].Columns[colCnt].HorizontalAlign = HorizontalAlign.Right; break; case "Credit(₹)": Fpspread1.Sheets[0].Columns[colCnt].HorizontalAlign = HorizontalAlign.Right; Fpspread1.Sheets[0].Columns[colCnt].Width = 80; break; } } #endregion #region Value Hashtable htSubTot = new Hashtable(); int rowNum = 0; Dictionary <string, string> fnalYear = getFinancialYear(); Dictionary <string, string> hdName = getHeadername(); Dictionary <string, string> feesName = getFeeName(); int rowCnt = 0; //foreach (KeyValuePair<string, string> financialYear in fnalYear) //{ // int rowCnt = 0; // Fpspread1.Sheets[0].RowCount++; // rowCnt = Fpspread1.Sheets[0].RowCount - 1; // Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = Convert.ToString(financialYear.Value); // Fpspread1.Sheets[0].SpanModel.Add(rowCnt, 0, 1, Fpspread1.Sheets[0].ColumnCount - 1); // Fpspread1.Sheets[0].Rows[rowCnt].BackColor = Color.Green; bool boolCheck = false; if (rblType.SelectedIndex == 0) { #region header foreach (KeyValuePair <string, string> headName in feesName) { //for (int hd = 0; hd < chkl_studhed.Items.Count; hd++) //{ // if (!chkl_studhed.Items[hd].Selected) // continue; Fpspread1.Sheets[0].RowCount++; rowCnt = Fpspread1.Sheets[0].RowCount - 1; Fpspread1.Sheets[0].Cells[rowCnt, 0].Text = Convert.ToString(++rowNum); double ob = 0; double openBalhead = 0; if (dsVal.Tables[3].Rows.Count > 0 || dsVal.Tables[6].Rows.Count > 0) { dsVal.Tables[3].DefaultView.RowFilter = " headerfk='" + headName.Key + "' ";//and finyearfk='" + financialYear.Key + "' dsVal.Tables[6].DefaultView.RowFilter = "headerpk='" + headName.Key + "' "; DataTable dtOpen = dsVal.Tables[3].DefaultView.ToTable(); DataTable dtopenhead = dsVal.Tables[6].DefaultView.ToTable(); if (dtOpen.Rows.Count > 0 || dtopenhead.Rows.Count > 0) { double.TryParse(Convert.ToString(dtOpen.Compute("sum(credit)", "")), out ob); } double.TryParse(Convert.ToString(dtopenhead.Compute("sum(openbal)", "")), out openBalhead); } double openBal = 0; openBal = ob + openBalhead; Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = Convert.ToString(openBal); if (openBal == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = "-"; } if (!htSubTot.ContainsKey("OpenBal")) { htSubTot.Add("OpenBal", openBal); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["OpenBal"]), out amount); amount += openBal; htSubTot.Remove("OpenBal"); htSubTot.Add("OpenBal", Convert.ToString(amount)); } Fpspread1.Sheets[0].Cells[rowCnt, 2].Text = Convert.ToString(headName.Value); double debitAmt = 0; if (dsVal.Tables[0].Rows.Count > 0) { dsVal.Tables[0].DefaultView.RowFilter = " headerfk='" + headName.Key + "' ";//and finyearfk='" + financialYear.Key + "' DataTable dtDebit = dsVal.Tables[0].DefaultView.ToTable(); if (dtDebit.Rows.Count > 0) { double.TryParse(Convert.ToString(dtDebit.Compute("sum(debit)", "")), out debitAmt); } } Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = Convert.ToString(debitAmt); if (debitAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = "-"; } if (!htSubTot.ContainsKey("Debit")) { htSubTot.Add("Debit", debitAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Debit"]), out amount); amount += debitAmt; htSubTot.Remove("Debit"); htSubTot.Add("Debit", Convert.ToString(amount)); } double creditAmt = 0; if (dsVal.Tables[0].Rows.Count > 0) { dsVal.Tables[0].DefaultView.RowFilter = " headerfk='" + headName.Key + "' ";//and finyearfk='" + financialYear.Key + "' DataTable dtCredit = dsVal.Tables[0].DefaultView.ToTable(); if (dtCredit.Rows.Count > 0) { double.TryParse(Convert.ToString(dtCredit.Compute("sum(credit)", "")), out creditAmt); } } Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = Convert.ToString(creditAmt); if (creditAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = "-"; } if (!htSubTot.ContainsKey("Credit")) { htSubTot.Add("Credit", creditAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Credit"]), out amount); amount += creditAmt; htSubTot.Remove("Credit"); htSubTot.Add("Credit", Convert.ToString(amount)); } boolCheck = true; } #endregion } else { #region ledger string lastName = string.Empty; foreach (KeyValuePair <string, string> ldName in feesName) { // } //for (int hd = 0; hd < chkl_studled.Items.Count; hd++) //{ // if (!chkl_studled.Items[hd].Selected) // continue; if (hdName.ContainsKey(ldName.Key)) { string NewName = Convert.ToString(hdName[ldName.Key]); if (lastName != NewName) { Fpspread1.Sheets[0].RowCount++; rowCnt = Fpspread1.Sheets[0].RowCount - 1; lastName = NewName; Fpspread1.Sheets[0].Cells[rowCnt, 0].Text = lastName; Fpspread1.Sheets[0].SpanModel.Add(rowCnt, 0, 1, Fpspread1.Sheets[0].ColumnCount - 1); Fpspread1.Sheets[0].Rows[rowCnt].BackColor = Color.YellowGreen; } } Fpspread1.Sheets[0].RowCount++; rowCnt = Fpspread1.Sheets[0].RowCount - 1; Fpspread1.Sheets[0].Cells[rowCnt, 0].Text = Convert.ToString(++rowNum); double ob = 0; double openBalhead = 0; if (dsVal.Tables[3].Rows.Count > 0) { dsVal.Tables[3].DefaultView.RowFilter = " ledgerfk='" + ldName.Key + "' "; //and finyearfk='" + financialYear.Key + "' // dsVal.Tables[6].DefaultView.RowFilter = "headerpk='" + headName.Key + "' "; DataTable dtOpen = dsVal.Tables[3].DefaultView.ToTable(); DataTable dtopenhead = dsVal.Tables[6].DefaultView.ToTable(); if (dtOpen.Rows.Count > 0 || dtopenhead.Rows.Count > 0) { double.TryParse(Convert.ToString(dtOpen.Compute("sum(credit)", "")), out ob); } double.TryParse(Convert.ToString(dtopenhead.Compute("sum(openbal)", "")), out openBalhead); } double openBal = 0; openBal = ob + openBalhead; Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = Convert.ToString(openBal); if (openBal == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = "-"; } if (!htSubTot.ContainsKey("OpenBal")) { htSubTot.Add("OpenBal", openBal); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["OpenBal"]), out amount); amount += openBal; htSubTot.Remove("OpenBal"); htSubTot.Add("OpenBal", Convert.ToString(amount)); } Fpspread1.Sheets[0].Cells[rowCnt, 2].Text = Convert.ToString(ldName.Value); double debitAmt = 0; if (dsVal.Tables[0].Rows.Count > 0) { dsVal.Tables[0].DefaultView.RowFilter = " ledgerfk='" + ldName.Key + "' ";//and finyearfk='" + financialYear.Key + "' DataTable dtDebit = dsVal.Tables[0].DefaultView.ToTable(); if (dtDebit.Rows.Count > 0) { double.TryParse(Convert.ToString(dtDebit.Compute("sum(debit)", "")), out debitAmt); } } Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = Convert.ToString(debitAmt); if (debitAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = "-"; } if (!htSubTot.ContainsKey("Debit")) { htSubTot.Add("Debit", debitAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Debit"]), out amount); amount += debitAmt; htSubTot.Remove("Debit"); htSubTot.Add("Debit", Convert.ToString(amount)); } double creditAmt = 0; if (dsVal.Tables[0].Rows.Count > 0) { dsVal.Tables[0].DefaultView.RowFilter = " ledgerfk='" + ldName.Key + "' ";//and finyearfk='" + financialYear.Key + "' DataTable dtCredit = dsVal.Tables[0].DefaultView.ToTable(); if (dtCredit.Rows.Count > 0) { double.TryParse(Convert.ToString(dtCredit.Compute("sum(credit)", "")), out creditAmt); } } Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = Convert.ToString(creditAmt); if (creditAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = "-"; } if (!htSubTot.ContainsKey("Credit")) { htSubTot.Add("Credit", creditAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Credit"]), out amount); amount += creditAmt; htSubTot.Remove("Credit"); htSubTot.Add("Credit", Convert.ToString(amount)); } boolCheck = true; } #endregion } if (boolCheck) { bool boolBank = false; for (int bnK = 0; bnK < ds.Tables[2].Rows.Count; bnK++) { ds.Tables[1].DefaultView.RowFilter = "bankfk='" + Convert.ToString(ds.Tables[2].Rows[bnK]["bankpk"]) + "'"; DataTable dtBank = ds.Tables[1].DefaultView.ToTable(); if (dtBank.Rows.Count > 0) { if (!boolBank) { Fpspread1.Sheets[0].RowCount++; rowCnt = Fpspread1.Sheets[0].RowCount - 1; Fpspread1.Sheets[0].Cells[rowCnt, 0].Text = "Bank Balances"; Fpspread1.Sheets[0].SpanModel.Add(rowCnt, 0, 1, Fpspread1.Sheets[0].ColumnCount - 1); Fpspread1.Sheets[0].Rows[rowCnt].BackColor = Color.Gray; boolBank = true; } Fpspread1.Sheets[0].RowCount++; rowCnt = Fpspread1.Sheets[0].RowCount - 1; Fpspread1.Sheets[0].Cells[rowCnt, 0].Text = Convert.ToString(++rowNum); // double openBal = 0; double ob = 0; double openBalhead = 0; if (dsVal.Tables[4].Rows.Count > 0) { dsVal.Tables[4].DefaultView.RowFilter = " bankfk='" + Convert.ToString(ds.Tables[2].Rows[bnK]["bankpk"]) + "' ";//and finyearfk='" + financialYear.Key + "' DataTable dtOpen = dsVal.Tables[3].DefaultView.ToTable(); DataTable dtopenhead = dsVal.Tables[6].DefaultView.ToTable(); if (dtOpen.Rows.Count > 0 || dtopenhead.Rows.Count > 0) { double.TryParse(Convert.ToString(dtOpen.Compute("sum(credit)", "")), out ob); } double.TryParse(Convert.ToString(dtopenhead.Compute("sum(openbal)", "")), out openBalhead); } double openBal = 0; openBal = ob + openBalhead; Fpspread1.Sheets[0].Cells[rowCnt, 1].Text = Convert.ToString(openBal); if (!htSubTot.ContainsKey("OpenBal")) { htSubTot.Add("OpenBal", openBal); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["OpenBal"]), out amount); amount += openBal; htSubTot.Remove("OpenBal"); htSubTot.Add("OpenBal", Convert.ToString(amount)); } Fpspread1.Sheets[0].Cells[rowCnt, 2].Text = Convert.ToString(ds.Tables[2].Rows[bnK]["bankname"]); double debitAmt = 0; double.TryParse(Convert.ToString(dtBank.Rows[0]["credit"]), out debitAmt); Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = Convert.ToString(debitAmt); if (debitAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 3].Text = "-"; } if (!htSubTot.ContainsKey("Debit")) { htSubTot.Add("Debit", debitAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Debit"]), out amount); amount += debitAmt; htSubTot.Remove("Debit"); htSubTot.Add("Debit", Convert.ToString(amount)); } double creditAmt = 0; double.TryParse(Convert.ToString(dtBank.Rows[0]["debit"]), out creditAmt); Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = Convert.ToString(creditAmt); if (creditAmt == 0) { Fpspread1.Sheets[0].Cells[rowCnt, 4].Text = "-"; } if (!htSubTot.ContainsKey("Credit")) { htSubTot.Add("Credit", creditAmt); } else { double amount = 0; double.TryParse(Convert.ToString(htSubTot["Credit"]), out amount); amount += creditAmt; htSubTot.Remove("Credit"); htSubTot.Add("Credit", Convert.ToString(amount)); } } } } // Fpspread1.Sheets[0].PageSize = ds.Tables[0].Rows.Count + 1; if (boolCheck) { Fpspread1.Sheets[0].Rows.Count++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 2].Text = "Deficit"; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].Rows.Count - 1].Font.Bold = true; // Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].Rows.Count - 1].BackColor = Color.Green; double debit = 0; double credit = 0; double.TryParse(Convert.ToString(htSubTot["Debit"]), out debit); double.TryParse(Convert.ToString(htSubTot["Credit"]), out credit); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 3].Text = "-"; if (debit > credit) { Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 3].Text = Convert.ToString(debit - credit); } Fpspread1.Sheets[0].Rows.Count++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 0].Text = "Total"; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].Rows.Count - 1].Font.Bold = true; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].Rows.Count - 1].BackColor = Color.Green; Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].Rows.Count - 1].ForeColor = Color.White; double grandvalue = 0; double.TryParse(Convert.ToString(htSubTot["OpenBal"]), out grandvalue); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 1].Text = Convert.ToString(grandvalue); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 3].Text = Convert.ToString(debit); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].Rows.Count - 1, 4].Text = Convert.ToString(credit); } //for (int j = 2; j < FpSpread1.Sheets[0].ColumnCount; j++) //{ // double.TryParse(Convert.ToString(grandtotal[j]), out grandvalue); // FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].Rows.Count - 1, j].Text = Convert.ToString(grandvalue); //} // } Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; Fpspread1.Visible = true; print.Attributes.Add("Style", "display:block;"); // print.Visible = true; Fpspread1.SaveChanges(); #endregion } catch { } }
protected void btn_go_Click(object sender, EventArgs e) { try { try { Printcontrol.Visible = false; string clgcode = ""; clgcode = Convert.ToString(ddl_collegename.SelectedItem.Value); string itemheadercode = ""; for (int i = 0; i < cbl_roomtype.Items.Count; i++) { if (cbl_roomtype.Items[i].Selected == true) { if (itemheadercode == "") { itemheadercode = "" + cbl_roomtype.Items[i].Value.ToString() + ""; } else { itemheadercode = itemheadercode + "'" + "," + "'" + cbl_roomtype.Items[i].Value.ToString() + ""; } } } if (itemheadercode.Trim() != "") { string selectquery = ""; selectquery = "select Room_Type,CONVERT(varchar(10), From_Date,103) as From_Date,CONVERT(varchar(10), To_Date,103) as To_Date, case when Rent_Type=1 then 'Monthly' when Rent_Type =2 then 'Yearly' when Rent_Type =3 then 'Semester' end as renttype,Room_Cost,CONVERT(varchar(10), Due_Date,103) as Due_Date,RoomCost_Code from RoomCost_Master where Room_Type in('" + itemheadercode + "')and college_code in('" + clgcode + "')"; ds.Clear(); ds = d2.select_method_wo_parameter(selectquery, "Text"); if (ds.Tables[0].Rows.Count > 0) { Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 0; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].AutoPostBack = true; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].ColumnCount = 7; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[0].Width = 50; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Room Type"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[1].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "From Date"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[2].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "To Date"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[3].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Rent Type"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[4].Width = 100; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Room Cost"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Due Date"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].HorizontalAlign = HorizontalAlign.Center; // FarPoint.Web.Spread.TextCellType txtcell = new FarPoint.Web.Spread.TextCellType(); for (int row = 0; row < ds.Tables[0].Rows.Count; row++) { Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[row]["Room_Type"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["RoomCost_Code"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["From_Date"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["To_Date"]); // Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].CellType = txtcell; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[row]["renttype"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(ds.Tables[0].Rows[row]["Room_Cost"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Right; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(ds.Tables[0].Rows[row]["Due_Date"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua"; } Fpspread1.Visible = true; rptprint.Visible = true; div1.Visible = true; lbl_error.Visible = false; Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Records Found"; } } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "Please Select Any one Item Name"; } } catch { } } catch { } }
public void btn_go_Click(object sender, EventArgs e) { try { div_report.Visible = false; Printcontrol.Visible = false; FpSpread1.Visible = false; FpSpread1.SaveChanges(); string itemheadercode = ""; for (int i = 0; i < cbl_hostelname.Items.Count; i++) { if (cbl_hostelname.Items[i].Selected == true) { if (itemheadercode == "") { itemheadercode = "" + cbl_hostelname.Items[i].Value.ToString() + ""; } else { itemheadercode = itemheadercode + "'" + "," + "'" + cbl_hostelname.Items[i].Value.ToString() + ""; } } } string month = ""; for (int i = 0; i < cbl_month.Items.Count; i++) { if (cbl_month.Items[i].Selected == true) { if (month == "") { month = "" + cbl_month.Items[i].Value.ToString() + ""; } else { month = month + "'" + "," + "'" + cbl_month.Items[i].Value.ToString() + ""; } } } if (txt_hostelname.Text == "--Select--") { lblerror.Visible = true; lblerror.Text = "Kindly Select The Hostel"; btnsave.Visible = false; btn_reset.Visible = false; } else { if (txt_month.Text == "--Select--") { lblerror.Visible = true; lblerror.Text = "Kindly Select The Month"; btnsave.Visible = false; btn_reset.Visible = false; //FpSpread1.Visible = false; } else { //FpSpread1.Visible = true; if (itemheadercode.Trim() != "") { FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].AutoPostBack = false; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].ColumnCount = 1; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[0].Width = 50; FpSpread1.Columns[0].Locked = true; FpSpread1.Sheets[0].ColumnCount++; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = "Days"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread1.Columns[1].Width = 150; FpSpread1.Columns[1].Locked = true; for (int i = 0; i < cbl_month.Items.Count; i++) { if (cbl_month.Items[i].Selected == true) { FpSpread1.Sheets[0].ColumnCount++; FarPoint.Web.Spread.DoubleCellType db = new FarPoint.Web.Spread.DoubleCellType(); db.ErrorMessage = "Enter only Numbers"; FpSpread1.Columns[FpSpread1.Sheets[0].ColumnCount - 1].CellType = db; // FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, i].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Text = Convert.ToString(cbl_month.Items[i].Text); FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Tag = Convert.ToString(cbl_month.Items[i].Value); FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, FpSpread1.Sheets[0].ColumnCount - 1].Font.Size = FontUnit.Medium; FpSpread1.Columns[1].Width = 150; } } for (int row = 0; row < 31; row++) { FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(row + 1); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; } DataView dv = new DataView(); string query = ""; string rebatetype = ""; if (rdbdate.Checked == true) { rebatetype = "1"; } else { rebatetype = "2"; } query = "select RebateActDays, RebateDays,RebateAmount ,RebateMonth from HM_RebateMaster where HostelFK in ('" + itemheadercode + "') and RebateMonth in ('" + month + "') and RebateType ='" + rebatetype + "'"; //} //else //{ // rebatetype = "2"; // query = "select Actual_Day, Grant_Day,Grant_Amount ,Rebate_Month from Rebate_Master where Hostel_Code in ('" + itemheadercode + "') and Rebate_Month in ('" + month + "') and Rebate_Type ='" + rebatetype + "'"; //} ds1 = d2.select_method_wo_parameter(query, "Text"); if (ds1.Tables[0].Rows.Count > 0) { if (FpSpread1.Sheets[0].ColumnCount > 2) { for (int ik = 2; ik < FpSpread1.Sheets[0].ColumnCount; ik++) { string getmonthvalue = Convert.ToString(FpSpread1.Sheets[0].ColumnHeader.Cells[0, ik].Tag); if (FpSpread1.Sheets[0].RowCount > 0) { for (int row = 0; row < FpSpread1.Sheets[0].RowCount; row++) { string currentday = Convert.ToString(FpSpread1.Sheets[0].Cells[row, 1].Text); ds1.Tables[0].DefaultView.RowFilter = "RebateActDays='" + currentday + "' and RebateMonth='" + getmonthvalue + "'"; dv = ds1.Tables[0].DefaultView; if (dv.Count > 0) { if (rdbdate.Checked == true) { FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateDays"]); FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right; } else { FpSpread1.Sheets[0].Cells[row, ik].Text = Convert.ToString(dv[0]["RebateAmount"]); FpSpread1.Sheets[0].Cells[row, ik].HorizontalAlign = HorizontalAlign.Right; } } } } } } } //25.04.16 //if (txt_allmonth.Text.Trim() != "") //{ // if (FpSpread1.Sheets[0].ColumnCount > 2) // { // for (int i = 0; i < FpSpread1.Sheets[0].ColumnCount - 2; i++) // { // int k = 0; // for (int row = 0; row < 31; row++) // { // k++; // FpSpread1.Sheets[0].Cells[k - 1, i + 2].Text = Convert.ToString(txt_allmonth.Text); // FpSpread1.Sheets[0].Cells[k - 1, i + 2].HorizontalAlign = HorizontalAlign.Center; // FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Size = FontUnit.Medium; // FpSpread1.Sheets[0].Cells[k - 1, i + 2].Font.Name = "Book Antiqua"; // } // } // } //} } FpSpread1.Visible = true; div_report.Visible = true; //div1.Visible = true; lblerror.Visible = false; btnsave.Visible = true; btn_reset.Visible = true; FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; } } } catch { } }
protected void btn_go_Click(object sender, EventArgs e) { try { Printcontrol.Visible = false; string itemheadercode = ""; for (int i = 0; i < cbl_menuname.Items.Count; i++) { if (cbl_menuname.Items[i].Selected == true) { if (itemheadercode == "") { itemheadercode = "" + cbl_menuname.Items[i].Value.ToString() + ""; } else { itemheadercode = itemheadercode + "'" + "," + "'" + cbl_menuname.Items[i].Value.ToString() + ""; } } } string itemheadercode1 = ""; for (int i = 0; i < cbl_menutype.Items.Count; i++) { if (cbl_menutype.Items[i].Selected == true) { if (itemheadercode1 == "") { itemheadercode1 = "" + cbl_menutype.Items[i].Value.ToString() + ""; } else { itemheadercode1 = itemheadercode1 + "'" + "," + "'" + cbl_menutype.Items[i].Value.ToString() + ""; } } } string selectquery = ""; if (txt_menuid.Text.Trim() != "") { selectquery = " select (select StudentTypeName From HostelStudentType where StudentType-1=MenuType) as MenuType,MenuType as MenuTypecode,MenuCode,MenuName,MenuMasterPK from HM_MenuMaster where CollegeCode='" + collegecode1 + "' and MenuCode like '%" + txt_menuid.Text + "%' order by MenuCode"; } else if (txt_search.Text.Trim() != "") { selectquery = "select (select StudentTypeName From HostelStudentType where StudentType-1=MenuType) as MenuType,MenuType as MenuTypecode,MenuCode,MenuName,MenuMasterPK from HM_MenuMaster where CollegeCode='" + collegecode1 + "' and MenuName like '%" + txt_search.Text + "%' order by MenuCode"; } else { if (itemheadercode.Trim() != "" && itemheadercode1.Trim() != "") { selectquery = "select (select StudentTypeName From HostelStudentType where StudentType-1=MenuType) as MenuType,MenuType as MenuTypecode,MenuCode,MenuName ,MenuMasterPK from HM_MenuMaster where CollegeCode='" + collegecode1 + "' and MenuCode in ('" + itemheadercode + "') and MenuType in ('" + itemheadercode1 + "') order by MenuCode"; }//case when MenuType ='0' then 'Veg' else 'Non Veg' end else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "Please Select All Field"; } } ds.Clear(); if (selectquery.Trim() != "") { ds = d2.select_method_wo_parameter(selectquery, "Text"); if (ds.Tables[0].Rows.Count > 0) { Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 0; Fpspread1.CommandBar.Visible = false; Fpspread1.Sheets[0].AutoPostBack = true; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.Sheets[0].ColumnCount = 4; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Columns[0].Width = 50; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Menu Type"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Menu Code"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Menu Name"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; for (int row = 0; row < ds.Tables[0].Rows.Count; row++) { Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(row + 1); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[row]["MenuType"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(ds.Tables[0].Rows[row]["MenuMasterPK"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[row]["MenuCode"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(ds.Tables[0].Rows[row]["MenuTypecode"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[row]["MenuName"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; } Fpspread1.Visible = true; rptprint.Visible = true; div1.Visible = true; lbl_error.Visible = false; Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Records Found"; } } else { div1.Visible = false; Fpspread1.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "Please Select All Fields"; } } catch { } }
public void btn_go_Click(object sender, EventArgs e) { try { Printcontrol.Visible = false; if (txt_hostelname.Text.Trim() != "--Select--" && txt_groupname.Text.Trim() != "--Select--" && txt_description.Text.Trim() != "--Select--") { DateTime dt = new DateTime(); DateTime dt1 = new DateTime(); string firstdate = Convert.ToString(txt_fromdate.Text); string seconddate = Convert.ToString(txt_todate.Text); string[] split = firstdate.Split('/'); dt = Convert.ToDateTime(split[1] + "/" + split[0] + "/" + split[2]); string[] split1 = seconddate.Split('/'); dt1 = Convert.ToDateTime(split1[1] + "/" + split1[0] + "/" + split1[2]); string hostel = ""; for (int i = 0; i < cbl_hostelname.Items.Count; i++) { if (cbl_hostelname.Items[i].Selected == true) { if (hostel == "") { hostel = "" + cbl_hostelname.Items[i].Value.ToString() + ""; } else { hostel = hostel + "'" + "," + "" + "'" + cbl_hostelname.Items[i].Value.ToString() + ""; } } } string group = ""; for (int i = 0; i < cbl_groupname.Items.Count; i++) { if (cbl_groupname.Items[i].Selected == true) { if (group == "") { group = "" + cbl_groupname.Items[i].Value.ToString() + ""; } else { group = group + "'" + "," + "" + "'" + cbl_groupname.Items[i].Value.ToString() + ""; } } } string gn = d2.GetFunction(""); string q1 = ""; if (rdb_datewise.Checked == true) { // q1 = "select CONVERT(varchar(10), Entry_Date,103) as Entry_Date, hd.Hostel_Name,hi.IncGroup_Code,(select TextVal from TextValTable where TextCode = ISNULL( hi.IncGroup_Code,0)) as IncGroup_Code_txt,hi.Inc_Amount,hi.Inc_Description from Hostel_Income hi,Hostel_Details hd where hd.Hostel_code=hi.Hostel_Code and hd.college_code='" + collegecode1 + "' and hi.Entry_Date between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' and hi.Hostel_Code=hd.Hostel_code and hi.Hostel_Code in('" + hostel + "')and hi.IncGroup_Code in('" + group + "')"; q1 = "select CONVERT(varchar(10), IncomeDate,103) as IncomeDate, hd.HostelName,hi.IncomeGroup,(select MasterValue from CO_MasterValues where MasterCode = ISNULL( hi.IncomeGroup,0)) as IncGroup_Code_txt,hi.IncomeAmount,hi.IncomeDesc from HT_HostelIncome hi,HM_HostelMaster hd where hd.HostelMasterPK=hi.HostelMasterFK and hi.IncomeDate between '" + dt.ToString("MM/dd/yyyy") + "' and '" + dt1.ToString("MM/dd/yyyy") + "' and hi.HostelMasterFK in('" + hostel + "')and hi.IncomeGroup in('" + group + "')";//and hd.collegecode='" + collegecode1 + "' } else { lbl_error1.Visible = false; q1 = "select CONVERT(varchar(10), IncomeDate,103) as IncomeDate, hd.HostelName,hi.IncomeGroup,(select MasterValue from CO_MasterValues where MasterCode = ISNULL( hi.IncomeGroup,0)) as IncGroup_Code_txt,SUM(hi.IncomeAmount)as IncomeAmount,hi.IncomeDesc from HT_HostelIncome hi,HM_HostelMaster hd where hd.HostelMasterPK=hi.HostelMasterFK and hi.HostelMasterFK in('" + hostel + "') and hi.IncomeGroup in('" + group + "') group by hi.IncomeGroup,hd.HostelName,hi.IncomeDesc,hi.IncomeDate";// } ds.Clear(); ds = d2.select_method_wo_parameter(q1, "Text"); if (ds.Tables[0].Rows.Count > 0) { Fpspread2.Sheets[0].RowCount = 0; Fpspread2.Sheets[0].ColumnCount = 0; Fpspread2.CommandBar.Visible = false; Fpspread2.Sheets[0].AutoPostBack = true; Fpspread2.Sheets[0].ColumnHeader.RowCount = 1; Fpspread2.Sheets[0].RowHeader.Visible = false; Fpspread2.Sheets[0].ColumnCount = 6; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); darkstyle.ForeColor = Color.White; Fpspread2.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; Fpspread2.Columns[0].Width = 50; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Hostel Name"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; Fpspread2.Columns[1].Width = 200; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Group Name"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; Fpspread2.Columns[2].Width = 100; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Description"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; Fpspread2.Columns[3].Width = 200; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Amount"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; Fpspread2.Columns[4].Width = 150; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Date"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Font.Bold = true; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].ColumnHeader.Cells[0, 5].Font.Size = FontUnit.Medium; Fpspread2.Columns[4].Width = 150; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Fpspread2.Sheets[0].RowCount++; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(i + 1); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(ds.Tables[0].Rows[i]["HostelName"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(ds.Tables[0].Rows[i]["IncGroup_Code_txt"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Tag = Convert.ToString(ds.Tables[0].Rows[i]["IncomeGroup"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(ds.Tables[0].Rows[i]["IncomeDesc"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(ds.Tables[0].Rows[i]["IncomeAmount"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Right; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua"; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(ds.Tables[0].Rows[i]["IncomeDate"]); Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Right; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium; Fpspread2.Sheets[0].Cells[Fpspread2.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua"; } Fpspread2.Sheets[0].PageSize = Fpspread2.Sheets[0].RowCount; Fpspread2.SaveChanges(); Fpspread2.Visible = true; rptprint.Visible = true; div2.Visible = true; lbl_error.Visible = false; } else { Fpspread2.Visible = false; div2.Visible = false; rptprint.Visible = false; lbl_error.Visible = true; lbl_error.Text = "No Record Found"; } } else { Fpspread2.Visible = false; rptprint.Visible = false; div2.Visible = false; lbl_error.Visible = true; lbl_error.Text = "Please Select All Field"; } } catch { } }