private void loadheaderstaffwise(string DeptCode, string DesigCode) /* poomalar 16.10.17 */ { try { Fpspread1.Visible = false; rprint.Visible = false; lblMainErr.Visible = false; string collCode = Convert.ToString(ddlcollege.SelectedItem.Value); Fpspread1.Sheets[0].AutoPostBack = false; Fpspread1.Sheets[0].ColumnHeader.RowCount = 1; Fpspread1.Sheets[0].RowCount = 0; Fpspread1.Sheets[0].ColumnCount = 7; Fpspread1.Sheets[0].RowHeader.Visible = false; Fpspread1.CommandBar.Visible = false; darkstyle.Font.Name = "Book Antiqua"; darkstyle.Font.Bold = true; darkstyle.Font.Size = FontUnit.Medium; darkstyle.HorizontalAlign = HorizontalAlign.Center; darkstyle.ForeColor = Color.Black; darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA"); Fpspread1.Sheets[0].ColumnHeader.DefaultStyle = darkstyle; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No."; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "Select"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Staff Name"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Staff Code"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Designation"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 5].Text = "Total Hours"; Fpspread1.Sheets[0].ColumnHeader.Cells[0, 6].Text = "Amount/Hrs"; Fpspread1.Columns[0].Width = 50; Fpspread1.Columns[1].Width = 50; Fpspread1.Columns[2].Width = 200; Fpspread1.Columns[3].Width = 100; Fpspread1.Columns[4].Width = 200; Fpspread1.Columns[5].Width = 100; Fpspread1.Columns[6].Width = 100; Fpspread1.Columns[0].Locked = true; Fpspread1.Columns[2].Locked = true; Fpspread1.Columns[3].Locked = true; Fpspread1.Columns[4].Locked = true; CheckAll.AutoPostBack = true; CheckInd.AutoPostBack = false; DoubleHrs.MaximumValue = 70; DoubleHrs.ErrorMessage = "Allow only Numerics & Max Hours is 70!"; DoubleAmnt.ErrorMessage = "Allow only Numerics!"; string query = ""; ReuasableMethods rs = new ReuasableMethods(); string deptcodesel = rs.GetSelectedItemsValueAsString(cbl_dept); string desigcodesel = rs.GetSelectedItemsValueAsString(cblDesig); query = "select sm.staff_code,sm.staff_name,h.dept_name,desig.desig_name,st.stftype,sc.category_name,h.dept_code,desig.desig_code,sm.college_Code,sm.appl_no,isnull(Tot_Hrs,0) Tot_Hrs,isnull(Amnt_Per_Hrs,0) Amnt_Per_Hrs from staffmaster sm,hrdept_master h,desig_master desig,staffcategorizer sc,stafftrans st LEFT JOIN HourWise_PaySettings HW ON st.staff_code=hw.StaffCode and hw.dept_code=st.dept_code and hw.desig_code=hw.desig_code where sm.staff_code=st.staff_code and sm.college_code=h.college_code and sm.college_code=desig.collegeCode and sm.college_code=sc.college_code and (isnull(st.stfnature,0)='1' or isnull(st.stfnature,'')='part') and st.dept_code=h.dept_code and st.desig_code=desig.desig_code and st.category_code=sc.category_code and st.latestrec='1' and sm.resign='0' and sm.settled='0' and ISNULL(Discontinue,'0')='0' and sm.college_code='" + collCode + "' and h.dept_code in('" + deptcodesel + "') and desig.desig_code in('" + desigcodesel + "')";// and isnull(hw.PayType,0)='"+paytype+"'"; DataSet dquery = new DataSet(); dquery = d2.select_method_wo_parameter(query, "Text"); int sno = 1; int rowcount = 0; if (dquery.Tables.Count > 0 && dquery.Tables[0].Rows.Count > 0) { if (cbl_dept.Items.Count > 0 && txt_dept.Text.Trim() != "--Select--") { Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].CellType = CheckAll; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].Font.Bold = true; for (int st = 0; st < cbl_dept.Items.Count; st++) { if (cbl_dept.Items[st].Selected == true) { rowcount = 0; Fpspread1.Sheets[0].RowCount++; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(cbl_dept.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, 7); DataView dv = new DataView(); dquery.Tables[0].DefaultView.RowFilter = " dept_code='" + Convert.ToString(cbl_dept.Items[st].Value) + "'"; dv = dquery.Tables[0].DefaultView; if (dv.Count > 0) { for (int i = 0; i < dv.Count; i++) { 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].CellType = CheckInd; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; 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[i]["staff_name"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Left; 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[i]["staff_code"]); 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"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dv[i]["desig_name"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Tag = Convert.ToString(dv[i]["desig_code"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].Note = Convert.ToString(dv[i]["dept_code"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left; 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 = DoubleHrs; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dv[i]["Tot_Hrs"]); 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"; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dv[i]["Amnt_Per_Hrs"]); Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Center; Fpspread1.Sheets[0].Cells[Fpspread1.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua"; } } else { Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove(); } } } } } else { Fpspread1.Sheets[0].Rows[Fpspread1.Sheets[0].RowCount - 1].Remove(); } Fpspread1.Sheets[0].PageSize = Fpspread1.Sheets[0].RowCount; Fpspread1.Sheets[0].SetColumnMerge(2, FarPoint.Web.Spread.Model.MergePolicy.Always); Fpspread1.Visible = true; rprint.Visible = true; btnSave.Visible = true; lblMainErr.Visible = false; } catch (Exception e) { e.ToString(); } }