private void BindgvEmpDetails() { try { if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand("getEmployeePersoDetails", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (conn.State == ConnectionState.Open) { conn.Close(); } if (txtEmpID.Text.ToString() == "" && txtEmpName.Text.ToString() == "") { gvEmpDetails.DataSource = dt; gvEmpDetails.DataBind(); } else { String[,] values = { { "EPD_EMPID~" + txtEmpID.Text.Trim(), "S" }, { "Emp_Name~" + txtEmpName.Text.Trim(), "S" } }; DataTable _tempDT = new DataTable(); Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, dt); gvEmpDetails.DataSource = _tempDT; gvEmpDetails.DataBind(); } if (dt.Rows.Count > 0) { DropDownList ddl = (DropDownList)gvEmpDetails.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvEmpDetails.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvEmpDetails.PageIndex + 1).ToString(); Label lblcount = (Label)gvEmpDetails.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvEmpDetails.DataSource).Rows.Count.ToString() + " Records."; if (gvEmpDetails.PageCount == 0) { ((Button)gvEmpDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvEmpDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpDetails.PageIndex + 1 == gvEmpDetails.PageCount) { ((Button)gvEmpDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpDetails.PageIndex == 0) { ((Button)gvEmpDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvEmpDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpDetails.PageSize * gvEmpDetails.PageIndex) + 1) + " to " + (gvEmpDetails.PageSize * (gvEmpDetails.PageIndex + 1)); gvEmpDetails.BottomPagerRow.Visible = true; } } catch (Exception ex) { } }
protected void btnSearch_Click(object sender, EventArgs e) { try { lblMessages.Text = string.Empty; lblMsg.Text = string.Empty; lblError.Text = string.Empty; DataTable dt = clsTimeZoneViewHandler.GetAllDetails("All"); if (txtTimezoneDesc.Text.ToString() == "" && txtTimezoneId.Text.ToString() == "") { gvTimezone.DataSource = dt; gvTimezone.DataBind(); } else { String[,] values = { { "TZ_CODE~" + txtTimezoneId.Text.Trim(), "S" }, { "TZ_DESCRIPTION~" + txtTimezoneDesc.Text.Trim(), "S" } }; DataTable _tempDT = new DataTable(); Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, dt); gvTimezone.DataSource = _tempDT; gvTimezone.DataBind(); } DropDownList ddl = (DropDownList)gvTimezone.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvTimezone.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvTimezone.PageIndex + 1).ToString(); Label lblcount = (Label)gvTimezone.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvTimezone.DataSource).Rows.Count.ToString() + " Records."; if (gvTimezone.PageCount == 0) { ((Button)gvTimezone.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvTimezone.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvTimezone.PageIndex + 1 == gvTimezone.PageCount) { ((Button)gvTimezone.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvTimezone.PageIndex == 0) { ((Button)gvTimezone.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvTimezone.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvTimezone.PageSize * gvTimezone.PageIndex) + 1) + " to " + (((gvTimezone.PageSize * (gvTimezone.PageIndex + 1)) - gvTimezone.PageSize) + gvTimezone.Rows.Count); gvTimezone.BottomPagerRow.Visible = true; } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { String _strWhere = ""; DataTable dt = new DataTable(); if (cmbContrller.SelectedValue.ToString() == "-1") { _strWhere = ""; } else { _strWhere = " and C.CTLR_ID='" + cmbContrller.SelectedValue.ToString() + "'"; } String _tableName = "EVENT_LOG_"; if (DateTime.Now.Date.Month < 10) { _tableName = _tableName + "0" + DateTime.Now.Date.Month + DateTime.Now.Date.Year; } else { _tableName = _tableName + DateTime.Now.Date.Month + DateTime.Now.Date.Year; } if (conn.State == ConnectionState.Closed) { conn.Open(); } try { SqlCommand cmd = new SqlCommand("usp_GetActivityData", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tableName", _tableName); cmd.Parameters.AddWithValue("@strwhereclause", _strWhere); SqlDataAdapter da = new SqlDataAdapter(cmd); da.SelectCommand.CommandTimeout = 0; da.Fill(dt); //cmd.ExecuteNonQuery(); } catch (Exception ex) { if (conn.State == ConnectionState.Open) { conn.Close(); } } if (conn.State == ConnectionState.Open) { conn.Close(); } if (txtUserID.Text.ToString() == "" && txtLevelID.Text.ToString() == "") { gvActivity.DataSource = dt; gvActivity.DataBind(); } else { String[,] values = { { "CTLR_DESCRIPTION-" + txtUserID.Text.Trim(), "S" }, { "EVENT_DESC-" + txtLevelID.Text.Trim(), "S" } }; DataTable _tempDT = new DataTable(); Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, dt); gvActivity.DataSource = _tempDT; gvActivity.DataBind(); } DropDownList ddl = (DropDownList)gvActivity.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvActivity.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvActivity.PageIndex + 1).ToString(); Label lblcount = (Label)gvActivity.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvActivity.DataSource).Rows.Count.ToString() + " Records."; if (gvActivity.PageCount == 0) { ((Button)gvActivity.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvActivity.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvActivity.PageIndex + 1 == gvActivity.PageCount) { ((Button)gvActivity.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvActivity.PageIndex == 0) { ((Button)gvActivity.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } //((Label)gvActivity.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvActivity.PageSize * gvActivity.PageIndex) + 1) + " to " + (gvActivity.PageSize * (gvActivity.PageIndex + 1)); ((Label)gvActivity.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvActivity.PageSize * gvActivity.PageIndex) + 1) + " to " + (((gvActivity.PageSize * (gvActivity.PageIndex + 1)) - 10) + gvActivity.Rows.Count); gvActivity.BottomPagerRow.Visible = true; } catch (Exception ex) { if (conn.State == ConnectionState.Open) { conn.Close(); } UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "HolidayView"); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { lblMessages.Text = ""; if (conn.State == ConnectionState.Closed) { conn.Open(); } string strsql1 = "select ESS_OD_RowID,ent_employee_personal_dtls.Epd_First_Name+ ' ' +ent_employee_personal_dtls.Epd_Last_Name as Name,ess_OD_empid as EmpCode,convert(VARCHAR(20),Ess_OD_fromdt,103) as FromDate, case when convert(VARCHAR(20),Ess_OD_Todt,103)= convert(VARCHAR(20),Ess_OD_fromdt,103) " + " then convert(VARCHAR(20),Ess_OD_fromdt,103) else convert(VARCHAR(20),Ess_OD_Todt,103) end as ToDate, ESS_OD_ODCD , Case ESS_OD_Status WHEN 'N' then 'Pending For Approval' " + " when 'A' then 'Approved' When 'R' then 'Rejected' When 'C' then 'Cancelled' End as ESS_OD_Status from ESS_TA_OD,ent_employee_personal_dtls where" + " ess_ta_od.ess_OD_empid=ent_employee_personal_dtls.epd_empid " + " and ess_od_empid='" + userid + "' and ess_od_isdeleted='0' order by convert(datetime,Ess_OD_fromdt,103) desc "; SqlDataAdapter da = new SqlDataAdapter(strsql1, conn); DataTable dt = new DataTable(); da.SelectCommand.CommandTimeout = 0; da.Fill(dt); if (conn.State == ConnectionState.Open) { conn.Close(); } if (txtTodate.Text.ToString() == "" && txtFromDate.Text.ToString() == "") { gvOD.DataSource = dt; gvOD.DataBind(); } else { String[,] values = { { "fromdate~" + txtFromDate.Text.Trim(), "D" }, { "Todate~" + txtTodate.Text.Trim(), "D" } }; DataTable _tempDT = new DataTable(); Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, dt); gvOD.DataSource = _tempDT; gvOD.DataBind(); } DropDownList ddl = (DropDownList)gvOD.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvOD.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvOD.PageIndex + 1).ToString(); Label lblcount = (Label)gvOD.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvOD.DataSource).Rows.Count.ToString() + " Records."; if (gvOD.PageCount == 0) { ((Button)gvOD.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvOD.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvOD.PageIndex + 1 == gvOD.PageCount) { ((Button)gvOD.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvOD.PageIndex == 0) { ((Button)gvOD.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvOD.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvOD.PageSize * gvOD.PageIndex) + 1) + " to " + (gvOD.PageSize * (gvOD.PageIndex + 1)); gvOD.BottomPagerRow.Visible = true; } catch (Exception ex) { if (conn.State == ConnectionState.Open) { conn.Close(); } UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "ESS_TA_OD_View"); } }
private void bindDataGrid() { try { DataSet ds = null; StringDictionary sd = new StringDictionary(); sd.Add("@cmd", "0"); ds = ExecuteSQL.ExecuteDataSet("PROC_ASSET_CTLR_MASTER", sd); if (ds != null) { ddlLocation.DataSource = ds.Tables[1]; ddlLocation.DataTextField = "OCE_DESCRIPTION"; ddlLocation.DataValueField = "OCE_ID"; ddlLocation.DataBind(); ddlLocation.Items.Insert(0, "Select Location"); ddlEditLocation.DataSource = ds.Tables[1]; ddlEditLocation.DataTextField = "OCE_DESCRIPTION"; ddlEditLocation.DataValueField = "OCE_ID"; ddlEditLocation.DataBind(); ddlEditLocation.Items.Insert(0, "Select Location"); if (txtControllerCode.Text.ToString() == "" && txtControllerDescription.Text.ToString() == "") { gvController.DataSource = ds.Tables[0]; gvController.DataBind(); } else { DataTable _tempDT = new DataTable(); String[,] values = { { "CtlrCode~" + txtControllerCode.Text.Trim(), "S" }, { "CtlrDesc~" + txtControllerDescription.Text.Trim(), "S" } }; Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, ds.Tables[0]); gvController.DataSource = _tempDT; gvController.DataBind(); } if (gvController.Rows.Count > 0) { DropDownList ddl = (DropDownList)gvController.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvController.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvController.PageIndex + 1).ToString(); Label lblcount = (Label)gvController.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvController.DataSource).Rows.Count.ToString() + " Records."; if (gvController.PageCount == 0) { ((Button)gvController.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvController.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvController.PageIndex + 1 == gvController.PageCount) { ((Button)gvController.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvController.PageIndex == 0) { ((Button)gvController.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvController.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvController.PageSize * gvController.PageIndex) + 1) + " to " + (gvController.PageSize * (gvController.PageIndex + 1)); gvController.BottomPagerRow.Visible = true; } } } catch (Exception ex) { lblMessages.Text = ex.Message; } }