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);
}
}
