private void PopulateSalesman() { try { DAL.Employees objSal = new DAL.Employees(); objSal.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString; DataTable dt = objSal.getRecord(" AND isnull(Employees.IsSalesman,0)=1"); DataRow dr = dt.NewRow(); dr["EmployeeID"] = 0; dr["EmployeeName"] = "-No Selection-"; dt.Rows.Add(dr); if (dt.Rows.Count > 0) { cboSalesman.DataSource = dt; cboSalesman.DisplayMember = "EmployeeName"; cboSalesman.ValueMember = "EmployeeID"; } cboSalesman.SelectedValue = 0; cboSalesman.SelectedText = "-No Selection-"; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }
private void txtEmployeeID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1) { try { SearchForms.SchEmployee vForm = new SearchForms.SchEmployee(); vForm.ShowDialog(); if (!string.IsNullOrEmpty(vForm.MyID)) { txtEmployeeID.Text = vForm.MyID; txtEmployeeName.Text = vForm.MyName; DAL.Employees obj = new DAL.Employees(); obj.connectionstring = objDAL.connectionstring; DataTable dt = obj.getRecord(" AND Employees.EmployeeID=" + txtEmployeeID.Text); if (dt.Rows.Count > 0) { txtDepartment.Text = dt.Rows[0]["DepartmentTitle"].ToString(); txtDesignation.Text = dt.Rows[0]["DesignationTitle"].ToString(); txtShift.Text = dt.Rows[0]["ShiftTitle"].ToString(); } dtFromDate.Focus(); } } catch (Exception exc) { Message.ShowMessage(MyMessages.MessageType.Error, exc.Message); } } else { MoveNext_KeyDown(sender, e); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { DAL.Employees emps = new DAL.Employees(); results = DAL.Employees.Search(TextSearch.Text); Session[Vars.SessionEmployeesList] = emps; RadGrid1.Rebind(); }
private void DisplayData() { string vWhere = string.Empty; if (!string.IsNullOrEmpty(txtFilter.Text)) { vWhere = " AND Employees.EmployeeName Like '%" + txtFilter.Text + "%'"; } if (int.Parse(cboDepartment.SelectedValue.ToString()) > 0) { vWhere += " AND Employees.DepartmentID=" + cboDepartment.SelectedValue; } try { DAL.Employees objDAL = new DAL.Employees(); objDAL.connectionstring = connectionString; dt = objDAL.getRecord(vWhere); Grid.AutoGenerateColumns = false; Grid.DataSource = dt; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString()); } }
/// <summary> /// /// </summary> /// <returns></returns> public int LoadSearch() { DAL.Employees emps = new DAL.Employees(); results = DAL.Employees.Search(this.SearchString); Session[Vars.SessionEmployeesList] = emps; RadGrid1.Rebind(); return(results.Rows.Count); }
private void Grid_Click(object sender, EventArgs e) { try { if (Grid.Rows.Count > 0 && Grid.CurrentRow.Index != -1) { txtID.Text = Grid.Rows[Grid.CurrentRow.Index].Cells["LeaveID"].Value.ToString(); DataTable dt = objDAL.getRecord(" AND EmployeeLeaves.LeaveID=" + txtID.Text); txtEmployeeID.Text = dt.Rows[0]["EmployeeID"].ToString(); txtEmployeeName.Text = dt.Rows[0]["EmployeeName"].ToString(); dtFromDate.Value = Convert.ToDateTime(dt.Rows[0]["LeavFrom"].ToString()); dtToDate.Value = Convert.ToDateTime(dt.Rows[0]["LeaveTo"].ToString()); chkWithoutPay.Checked = Convert.ToBoolean(dt.Rows[0]["Unpaid"].ToString()); txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); DAL.Employees obj = new DAL.Employees(); obj.connectionstring = objDAL.connectionstring; DataTable dt1 = obj.getRecord(" AND Employees.EmployeeID=" + txtEmployeeID.Text); if (dt1.Rows.Count > 0) { txtDepartment.Text = dt1.Rows[0]["DepartmentTitle"].ToString(); txtDesignation.Text = dt1.Rows[0]["DesignationTitle"].ToString(); txtShift.Text = dt1.Rows[0]["ShiftTitle"].ToString(); } dt1.Dispose(); vOpenMode = true; } } catch (Exception exc) { Message.ShowMessage(MyMessages.MessageType.Error, exc.Message); } }