private void btnDelete_Click(object sender, EventArgs e) { string id = dgvResult.Rows[dgvResult.CurrentCell.RowIndex].Cells[0].Value.ToString(); DialogResult dr = new DialogResult(); dr = MessageBox.Show("Do you really want to delete a record, ID = " + id + " ?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if ((int)dr == 6) { if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { frmLogin.admin.Houses = Remax.TabHouses(); frmLogin.admin.DeleteHouse(id); HouseDB.UpdateHousesDB(frmLogin.admin.Houses); } if (frmLogin.agent != null) { house = HouseDB.getHouse(id); if (house.IdAgent != frmLogin.agent.Id) { MessageBox.Show("The house added by another agent.You can not delete."); } else { frmLogin.agent.Houses = Remax.TabHouses(); frmLogin.agent.DeleteHouse(id); HouseDB.UpdateHousesDB(frmLogin.agent.Houses); } } } else if (frmRemax.formToManage == "client") { if (frmLogin.admin != null) { frmLogin.admin.Clients = Remax.TabClients(); frmLogin.admin.DeleteClient(id); ClientDB.UpdateClientsDB(frmLogin.admin.Clients); } else { frmLogin.agent.Clients = Remax.TabClients(); frmLogin.agent.DeleteClient(id); ClientDB.UpdateClientsDB(frmLogin.agent.Clients); } } else if (frmRemax.formToManage == "employee") { frmLogin.admin.Employees = Remax.TabEmployees(); frmLogin.admin.Languages = Remax.TabLanguages(); frmLogin.admin.DeleteEmployee(id); EmployeeDB.UpdateEmployeesDB(frmLogin.admin.Employees, frmLogin.admin.Languages); } } }
private void btnHSave_Click(object sender, EventArgs e) { House house = new House(); house.BuildingType = cboHBuilding.SelectedValue.ToString(); house.NumberParking = cboHParking.SelectedValue.ToString(); house.NumberBedrooms = cboHBedrooms.SelectedValue.ToString(); house.PropertyType = cboHProperty.SelectedValue.ToString(); house.Price = float.Parse(txtHPrice.Text); house.IdAgent = (frmLogin.agent != null) ? frmLogin.agent.Id : cboHAgent.SelectedValue.ToString(); house.IdSeller = cboHClient.SelectedValue.ToString(); house.Pool = (checkBoxPool.Checked) ? true : false; house.Waterfront = (checkBoxWater.Checked) ? true : false; house.Elevator = (checkBoxElevator.Checked) ? true : false; house.AdapterMobility = (checkBoxMobility.Checked) ? true : false; house.NetArea = int.Parse(txtHNetArea.Text); house.YearBuilt = int.Parse(txtYear.Text); house.Description = txtHDesc.Text; house.Name = txtHName.Text; house.Address = txtHAddress.Text; if (frmManage.mode == "add" && frmLogin.admin != null) { frmLogin.admin.Houses = Remax.TabHouses(); frmLogin.admin.AddHouse(house); HouseDB.UpdateHousesDB(frmLogin.admin.Houses); } if (frmManage.mode == "add" && frmLogin.agent != null) { frmLogin.agent.Houses = Remax.TabHouses(); frmLogin.agent.AddHouse(house); HouseDB.UpdateHousesDB(frmLogin.agent.Houses); } if (frmManage.mode == "edit" && frmLogin.admin != null) { house.Id = frmManage.house.Id; frmLogin.admin.Houses = Remax.TabHouses(); frmLogin.admin.EditHouse(house); HouseDB.UpdateHousesDB(frmLogin.admin.Houses); } if (frmManage.mode == "edit" && frmLogin.agent != null) { house.Id = frmManage.house.Id; frmLogin.agent.Houses = Remax.TabHouses(); frmLogin.agent.EditHouse(house); HouseDB.UpdateHousesDB(frmLogin.agent.Houses); } this.Close(); }
private void frmManage_Load(object sender, EventArgs e) { mode = ""; house = null; employee = null; client = null; agent = null; if (frmLogin.employee == null) { User(); User user = new User(); } if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { dgvResult.DataSource = HouseDB.getViewHouses("admin"); } else { dgvResult.DataSource = HouseDB.getViewHouses("user or agent"); } } else if (frmRemax.formToManage == "client") { if (frmLogin.agent != null) { dgvResult.DataSource = ClientDB.getViewClients(frmLogin.agent.Name); } else { dgvResult.DataSource = ClientDB.getViewClients(""); } } else if (frmRemax.formToManage == "employee") { dgvResult.DataSource = EmployeeDB.getViewEmployees(""); } else if (frmRemax.formToManage == "agent") { dgvResult.DataSource = EmployeeDB.getViewEmployees("agent"); dgvResult.Columns["Image"].Visible = false; dgvResult.Columns["Role"].Visible = false; dgvResult.Columns["Password"].Visible = false; } }
private void btnRefresh_Click(object sender, EventArgs e) { checkBoxName.Checked = checkBoxID.Checked = false; txtSearch.Text = ""; if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { dgvResult.DataSource = HouseDB.getViewHouses("admin"); } else { dgvResult.DataSource = HouseDB.getViewHouses("user or agent"); } } if (frmRemax.formToManage == "client") { if (frmLogin.agent == null) { dgvResult.DataSource = ClientDB.getViewClients(""); } else { dgvResult.DataSource = ClientDB.getViewClients(frmLogin.agent.Name); } } if (frmRemax.formToManage == "employee") { dgvResult.DataSource = EmployeeDB.getViewEmployees(""); } if (frmRemax.formToManage == "agent") { dgvResult.DataSource = EmployeeDB.getViewEmployees("agent"); dgvResult.Columns["Image"].Visible = false; dgvResult.Columns["Role"].Visible = false; dgvResult.Columns["Password"].Visible = false; } }
private void btnEdit_Click(object sender, EventArgs e) { mode = "edit"; string id = dgvResult.Rows[dgvResult.CurrentCell.RowIndex].Cells[0].Value.ToString(); if (frmRemax.formToManage == "house") { house = HouseDB.getHouse(id); if (frmLogin.agent != null) { if (house.IdAgent != frmLogin.agent.Id) { MessageBox.Show("The house added by another agent.You can not edit."); } else { frmHouse frmH = new frmHouse(); frmH.ShowDialog(); } } else { frmHouse frmH = new frmHouse(); frmH.ShowDialog(); } } else if (frmRemax.formToManage == "client") { client = ClientDB.getClient(id); frmClient frmC = new frmClient(); frmC.ShowDialog(); } else if (frmRemax.formToManage == "employee") { agent = EmployeeDB.getAgent(id); frmEmployee frmE = new frmEmployee(); frmE.ShowDialog(); } }
private void btnSearch_Click(object sender, EventArgs e) { if (checkBoxID.Checked) { if (txtSearch.Text == "") { MessageBox.Show("Enter a criteria"); } else { string criteria = txtSearch.Text; if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { DataView dv = HouseDB.getViewHouses("admin"); dv.RowFilter = "CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } else { DataView dv = HouseDB.getViewHouses("user or agent"); dv.RowFilter = "CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } if (frmRemax.formToManage == "client") { if (frmLogin.agent == null) { DataView dv = ClientDB.getViewClients(""); dv.RowFilter = "CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } else { DataView dv = ClientDB.getViewClients(frmLogin.agent.Name); dv.RowFilter = " CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } if (frmRemax.formToManage == "employee") { DataView dv = EmployeeDB.getViewEmployees(""); dv.RowFilter = "CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } if (frmRemax.formToManage == "agent") { DataView dv = EmployeeDB.getViewEmployees("agent"); dv.RowFilter = "CONVERT(Id, System.String) LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } } if (checkBoxName.Checked) { if (txtSearch.Text == "") { MessageBox.Show("Enter a criteria"); } else { string criteria = txtSearch.Text; if (frmRemax.formToManage == "house") { if (frmLogin.employee == null) { DataTable dt = Remax.ViewHouses("user"); DataView dv = dt.DefaultView; dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } else { DataTable dt = Remax.ViewHouses(); DataView dv = dt.DefaultView; dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } if (frmRemax.formToManage == "client") { if (frmLogin.agent != null) { DataView dv = Remax.ViewClients(frmLogin.agent.Name); dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } else { DataTable dt = Remax.ViewClients(); DataView dv = dt.DefaultView; dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } if (frmRemax.formToManage == "employee") { DataTable dt = Remax.ViewEmployees(); DataView dv = dt.DefaultView; dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } if (frmRemax.formToManage == "agent") { DataTable dt = Remax.TabAgents(); DataView dv = dt.DefaultView; dv.RowFilter = "Name LIKE '%" + criteria + "%'"; dgvResult.DataSource = dv; } } } if (!checkBoxName.Checked && !checkBoxID.Checked) { MessageBox.Show("Check type of search."); } }