/// <summary> /// Name:Bindgrid /// Description:Bind the grid if datatable is blank then it displays message in label /// Author:Monal Shah /// created Date:2010/11/26 /// </summary> public void BindGrid() { try { objcl.GetSqlStmt = objcl.SelectQuery("Employees"); objDt = objcl.DataTables(); if (objDt.Rows.Count > 0) { EmployeeGrid.DataSource = objDt; EmployeeGrid.DataBind(); } else { LblMsg.Visible = true; LblMsg.Text = ConstantMessage.NoRecord; EmployeeGrid.Visible = false; BtnExportToExcel.Visible = false; FileUpload.Enabled = false; BtnFileUpload.Enabled = false; } } catch (Exception) { Response.Redirect("Error.aspx", false); } finally { objcl = null; objDt.Dispose(); } }
/// <summary> /// Name:EmployeeGrid_PageIndexChanging /// Description:here pageindex is set and data is bind the grid /// Author:Monal Shah /// created Date:2010/10/21 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EmployeeGrid_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e) { EmployeeGrid.PageIndex = e.NewPageIndex; objDv = SortDataTable(true); EmployeeGrid.DataSource = objDv; EmployeeGrid.DataBind(); }
private void UpdateDataGrid() { using (HREntities hr = new HREntities()) { // Membuat Data Table untuk dijadikan DataSource GridView DataTable dataTable = new DataTable("employee"); // Menambahkan colum/field ke Data Table dataTable.Columns.Add("EmployeeId"); dataTable.Columns.Add("FirstName"); dataTable.Columns.Add("LastName"); dataTable.Columns.Add("Email"); // Mengambil data Employee untuk dimasukan ke dalam Data Table List <COPY_EMP> employees = (from COPY_EMP emp in hr.COPY_EMP select emp).ToList(); foreach (COPY_EMP emp in employees) { dataTable.Rows.Add(emp.EMPLOYEE_ID, emp.FIRST_NAME, emp.LAST_NAME, emp.EMAIL); } // Set DataSource GridView EmployeeGrid.DataSource = dataTable; EmployeeGrid.DataBind(); } }
private void BindDummyRow() { DataTable dummy = new DataTable(); dummy.Columns.Add("ID"); dummy.Columns.Add("EmployeeIdent"); dummy.Columns.Add("FirstName"); dummy.Columns.Add("LastName"); dummy.Rows.Add(); EmployeeGrid.DataSource = dummy; EmployeeGrid.DataBind(); }
private void GetAllEmployees() { try { if (EmployeeDataAccess.GetAllUsers() == null) { lblEmployee.Text = "Some error occored"; } EmployeeGrid.DataSource = EmployeeDataAccess.GetAllUsers(); EmployeeGrid.DataBind(); } catch (Exception ex) { lblEmployee.Text = ex.Message; } }
public void FillEmployeeData() { try { int ServiceTypeID = Convert.ToInt32(drpServiceTypeFilter.SelectedValue); String EmployeeName = txtEmployeeFilter.Text.ToString(); Resident res = new Resident(); DataSet ds = res.GetEmployee(muser.currentResident.SocietyID, ServiceTypeID, EmployeeName); if (ds.Tables.Count > 0) { EmployeeGrid.DataSource = ds; EmployeeGrid.DataBind(); // btnEmpShwall.Visible = false; //String EmpTotalCountQuery = " select count(UserID) from dbo.ViewEmployee where SocietyID = " + muser.currentResident.SocietyID.ToString(); //lblTotalEmployees.Text = daAccess.GetSingleValue(EmpTotalCountQuery).ToString(); // lblTotalEmployees.Text = ds.Tables[0].Rows.Count.ToString(); if (ds.Tables[0].Rows.Count == 0) { // txtEmpNamesrch.Visible = false; // drpEmpServtFilter.Visible = false; } else { // txtEmpNamesrch.Visible = true; drpServiceTypeFilter.Visible = true; } } else { } //ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "ShowEmployePopup();", true); } catch (Exception ex) { } }
private void Search(string date, string fromDate, string toDate, string keywords) { EmployeeFilterBuilder employeeFilterBuilder = new EmployeeFilterBuilder(); if (!string.IsNullOrEmpty(keywords)) { employeeFilterBuilder.Append(EmployeeDB.BLL.EmployeeColumn.FullName, $"%{keywords}%", true); } if (!string.IsNullOrEmpty(date)) { DateTime.TryParse(date, out DateTime dateResult); employeeFilterBuilder.AppendEquals(EmployeeColumn.DOB, dateResult.ToString("yyyy-MM-dd")); } //if (!string.IsNullOrEmpty(fromDate)) //{ // DateTime.TryParse(fromDate, out DateTime fromDateResult); // employeeFilterBuilder.AppendGreaterThan(EmployeeColumn.DOB, fromDateResult.ToShortDateString()); //} //if (!string.IsNullOrEmpty(toDate)) //{ // DateTime.TryParse(toDate, out DateTime toDateResult); // employeeFilterBuilder.AppendLessThan(EmployeeColumn.DOB, toDateResult.ToShortDateString()); // employeeFilterBuilder.AppendIn(EmployeeColumn.DOB, toDateResult.ToShortDateString()); //} //employeeFilterBuilder.Append(EmployeeColumn.DOB, "London, Berlin"); //employeeFilterBuilder.Append(EmployeeColumn.DOB, fromDate.ToString(), toDate.ToString()); int count = 0; EmployeeService employeeService = new EmployeeService(); TList <Employee> employees = DataRepository.EmployeeProvider.GetPaged(employeeFilterBuilder.ToString(), null, 0, 100, out count); employeeService.DeepLoad(employees); List <EmployeeModel> addressModels = new List <EmployeeModel>(); foreach (var employee in employees) { var employeeModel = new EmployeeModel(employee.EmployeeId, employee.EmployeeCode, employee.FullName, employee.FirstName, employee.MiddlesName, employee.LastName, employee.DOB, employee.Email, employee.Bio, employee.CreatedOn, employee.AddressCollection); addressModels.Add(employeeModel); } //EmployeeGrid.DataSource = addressModels.OrderByDescending(e => e.CreatedOn).ToList(); EmployeeGrid.DataSource = addressModels; EmployeeGrid.DataBind(); }
private void FillGridView() { EmployeeService employeeService = new EmployeeService(); var employees = employeeService.GetAll(); employeeService.DeepLoad(employees); List <EmployeeModel> addressModels = new List <EmployeeModel>(); foreach (var employee in employees) { var employeeModel = new EmployeeModel(employee.EmployeeId, employee.EmployeeCode, employee.FullName, employee.FirstName, employee.MiddlesName, employee.LastName, employee.DOB, employee.Email, employee.Bio, employee.CreatedOn, employee.AddressCollection); addressModels.Add(employeeModel); } //EmployeeGrid.DataSource = addressModels.OrderByDescending(e => e.CreatedOn).ToList(); EmployeeGrid.DataSource = addressModels; EmployeeGrid.DataBind(); }
private void UpdateDataGrid() { using (ChasierCRUD chasierCRUD = new ChasierCRUD()) { DataTable data = new DataTable("employee"); data.Columns.Add("EmployeeId"); data.Columns.Add("FirstName"); data.Columns.Add("LastName"); data.Columns.Add("Email"); List <Chasier> cs = chasierCRUD.SelectEmployees(); foreach (Chasier emp in cs) { data.Rows.Add(emp.Id_Item, emp.Nama_Item, emp.Kode_Item, emp.Harga_Item); } EmployeeGrid.DataSource = data; EmployeeGrid.DataBind(); } }
/// <summary> /// Name:BtnDisplay_Click /// Decription:Display record of that employee which is selected from dropdownlist. /// Author:Monal shah /// Created Date:2010/11/11 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnDisplay_Click(object sender, EventArgs e) { try { if (Cache[DdlEmployee.SelectedItem.Text] == null) { BindGrid(); } else { PanelGrid.Visible = true; EmployeeGrid.Visible = true; objDt = (DataTable)Cache[DdlEmployee.SelectedItem.Text]; EmployeeGrid.DataSource = objDt; EmployeeGrid.DataBind(); } } catch (Exception) { Response.Redirect("Error.aspx", false); } finally { objDt.Dispose(); } }
public void BindGrid() { EmployeeGrid.DataSource = objWebService.DispalyTable(); EmployeeGrid.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { TestOne_SQLDataClass.getAllEmployees(); EmployeeGrid.DataSource = TestOne_SQLDataClass.tblEmployee; EmployeeGrid.DataBind(); }
/// <summary> /// Name:BtnSearch_Click /// Description:Serching criteria set /// Author Name:Monal shah /// Created Date:2010/11/2 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSearch_Click(object sender, EventArgs e) { PnlGrid.Visible = true; objSb = new StringBuilder(); try { objSb.Append("Select "); objSb.Append("* "); objSb.Append("From "); objSb.Append("EmployeeTable "); objSb.Append("Where "); if (TxtFirstName.Text != null && TxtFirstName.Text != "") { objSb.Append("FirstName "); objSb.Append("LIKE "); objSb.Append("'"); objSb.Append(TxtFirstName.Text); objSb.Append("%"); objSb.Append("'"); objSb.Append(" AND "); } if (TxtLastName.Text != null && TxtLastName.Text != "") { objSb.Append("LastName "); objSb.Append("LIKE "); objSb.Append("'"); objSb.Append(TxtLastName.Text); objSb.Append("%"); objSb.Append("'"); objSb.Append(" AND "); } if (TxtAge.Text != null && TxtAge.Text != "") { objSb.Append("age"); objSb.Append("="); objSb.Append("'"); objSb.Append(TxtAge.Text); objSb.Append("'"); objSb.Append(" AND "); } if (RdbtnSex.SelectedIndex > -1 && RdbtnSex.SelectedItem.Selected) { objSb.Append("Sex"); objSb.Append("="); objSb.Append("'"); objSb.Append(RdbtnSex.SelectedValue); objSb.Append("'"); objSb.Append(" AND "); } if (DdlEducation.SelectedIndex > -1 && DdlEducation.SelectedItem.Text != ConstantMessage.EducationSelect) { objSb.Append("Education"); objSb.Append("="); objSb.Append("'"); objSb.Append(DdlEducation.SelectedItem.Value); objSb.Append("'"); objSb.Append(" AND "); } if (DdlExperience.SelectedIndex > -1 && DdlExperience.SelectedItem.Text != ConstantMessage.ExperienceSelect) { objSb.Append("Experience"); objSb.Append("="); objSb.Append("'"); objSb.Append(DdlExperience.SelectedItem.Value); objSb.Append("'"); objSb.Append(" AND "); } if (DdlSalary.SelectedIndex > -1 && DdlSalary.SelectedItem.Text != ConstantMessage.SalarySelect) { splitValue = DdlSalary.SelectedItem.Value.Split('-'); objSb.Append("Salary"); objSb.Append(">="); objSb.Append(splitValue[0].ToString()); objSb.Append(" And "); objSb.Append("Salary"); objSb.Append("<"); objSb.Append(splitValue[1].ToString()); objSb.Append(" AND "); } strRemove = Convert.ToString(objSb); strGetProperValue = strRemove.Substring(0, strRemove.Length - 4); objCl.GetSqlStmt = strGetProperValue.ToString(); objDt = objCl.DataTables(); if (objDt.Rows.Count > 0) { EmployeeGrid.Visible = true; EmployeeGrid.DataSource = objDt; EmployeeGrid.DataBind(); LblNoRecord.Visible = false; } else { LblNoRecord.Visible = true; LblNoRecord.Text = ConstantMessage.NoRecord; EmployeeGrid.Visible = false; } } catch (Exception) { Response.Redirect("Error.aspx", false); } finally { objCl = null; objSb = null; objDt.Dispose(); } }