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