private void btnSearch_Click(object sender, EventArgs e)
{
myRemax = new projectRemaxDBEntities1();
var employeeInfo = from emp in myRemax.Employees
select emp;
var propInfo = from prop in myRemax.Properties
select prop;
if (chkAgent.Checked && chkProperty.Checked == false)
{
employeeInfo = from emp in myRemax.Employees
where emp.RefEmployee.ToString() == cboAgents.Text
select emp;
gridResults.DataSource = employeeInfo.ToList();
}
else if (chkProperty.Checked && chkAgent.Checked == false)
{
propInfo = from prop in myRemax.Properties
where prop.RefProperty.ToString() == cboProperties.Text
select prop;
gridResults.DataSource = propInfo.ToList();
}
else
{
}
}
private void frmAdmin_Load(object sender, EventArgs e)
{
myRemax = new projectRemaxDBEntities1();
var empInfo = from emp in myRemax.Employees
select emp.RefEmployee;
var clientInfo = from cli in myRemax.Clients
select cli.RefClient;
var propertyInfo = from prop in myRemax.Properties
select prop.RefProperty;
cboEmployee.DisplayMember = "RefEmployee";
cboEmployee.ValueMember = "RefEmployee";
cboEmployee.DataSource = empInfo.ToList();
cboClients.DisplayMember = "RefClient";
cboClients.ValueMember = "RefClient";
cboClients.DataSource = clientInfo.ToList();
cboProperty.DisplayMember = "RefProperty";
cboProperty.ValueMember = "RefProperty";
cboProperty.DataSource = propertyInfo.ToList();
tabEmployees = clsGlobal.mySet.Tables["Employees"];
tabClients = clsGlobal.mySet.Tables["Clients"];
tabProperties = clsGlobal.mySet.Tables["Properties"];
}
private void frmClient_Load(object sender, EventArgs e)
{
myRemax = new projectRemaxDBEntities1();
var employeeInfo = from emp in myRemax.Employees
select emp.RefEmployee;
cboAgents.DisplayMember = "FirstName";
cboAgents.ValueMember = "RefEmployee";
cboAgents.DataSource = employeeInfo.ToList();
var propertyInfo = from prop in myRemax.Properties
select prop.RefEmployee;
cboProperties.DisplayMember = "Type";
cboProperties.ValueMember = "RefProperty";
cboProperties.DataSource = propertyInfo.ToList();
}
private void cboProperty_SelectedIndexChanged(object sender, EventArgs e)
{
Property propFound = myRemax.Properties.Find(cboProperty.SelectedValue);
if (propFound != null)
{
txtPropertyAgent.Text = propFound.RefEmployee.ToString();
txtPropertyLocation.Text = propFound.Location;
txtPropertyType.Text = propFound.Type;
txtPropertyPrice.Text = propFound.Price.ToString();
txtPropertySize.Text = propFound.Size;
}
myRemax = new projectRemaxDBEntities1();
var propInfo = from property in myRemax.Properties
where property.RefProperty.ToString() == cboProperty.SelectedValue.ToString()
select property;
gridResult.DataSource = propInfo.ToList();
}
private void cboClients_SelectedIndexChanged(object sender, EventArgs e)
{
Client cliFound = myRemax.Clients.Find(cboClients.SelectedValue);
if (cliFound != null)
{
txtFirstClient.Text = cliFound.FirstName;
txtLastClient.Text = cliFound.LastName;
txtClientsAgent.Text = cliFound.RefEmployee.ToString();
txtType.Text = cliFound.Type;
txtPropertyClient.Text = cliFound.RefProperty.ToString();
}
myRemax = new projectRemaxDBEntities1();
var clientInfo = from client in myRemax.Clients
where client.RefClient.ToString() == cboClients.SelectedValue.ToString()
select client;
gridResult.DataSource = clientInfo.ToList();
}