public GridCompany GetGridCompany(int selectedId) { GridCompany ret = new GridCompany(); Execute((commnad) => { commnad.CommandText = @" select d.name, e.name, e.surname, d.Id from Department as d join Employee as e on d.CheifEmployeeId = e.Id where d.Id = @selectedId"; commnad.Parameters.Add("selectedId", SqlDbType.Int).Value = selectedId; using (SqlDataReader reader = commnad.ExecuteReader()) { while (reader.Read()) { ret = new GridCompany() { CompanyName = reader.GetString(0), CheifName = reader.GetString(1), CheifSurname = reader.GetString(2), Id = reader.GetInt32(3) }; } } }); return(ret); }
private void btnOk_Click(object sender, EventArgs e) { _employeeViewModel.Employee.Name = txtName.Text; _employeeViewModel.Employee.SurName = txtSurname.Text; _employeeViewModel.Employee.Degree = txtDegree.Text; _employeeViewModel.Employee.Phone = int.Parse(txtPhone.Text); _employeeViewModel.Employee.Mail = txtMail.Text; GridCompany temp = (GridCompany)cmbWorkingDepartment.SelectedValue; _employeeViewModel.Employee.DepartmentId = temp == null ? null : temp.Id; _employeeViewModel.SaveEmployee(); }
public void FillGridCompany() { try { DataTable Dt = new DataTable(); // Dt = COMPANYLogicLayer.GetAllCOMPANYDetials(); GridCompany.DataSource = Dt; GridCompany.DataBind(); } catch (Exception) { throw; } }
public void FillGridCompany() { try { DataTable Dt = new DataTable(); Dt = COMPANYLogicLayer.GetAllCOMPANYDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); GridCompany.DataSource = Dt; GridCompany.DataBind(); } catch (Exception) { throw; } }
private void GetCompanyOfSelectedUser() { try { DataTable Dt = new DataTable(); string selectedUser = DdlUser.SelectedValue; Dt = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(selectedUser); GridCompany.DataSource = Dt; GridCompany.DataBind(); } catch (Exception) { throw; } }
public GridCompany GetEmployeeDepartment(int?departmentId) { GridCompany ret = new GridCompany(); Execute((command) => { command.CommandText = @"select d.id, d.Name, e.Name, e.Surname from Department as d join Employee as e on d.CheifEmployeeId = e.Id where e.DepartmentId = @departmentId"; command.Parameters.Add("@departmentId", SqlDbType.Int).Value = departmentId; using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { ret.Id = reader.GetInt32(0); ret.CompanyName = reader.GetString(1); ret.CheifName = reader.GetString(2); ret.CheifSurname = reader.GetString(3); } } }); return(ret); }