public void PreencheGrid()
{
FAMIS_BLL.Employee _Employee = new FAMIS_BLL.Employee();
grvEmployee.DataSource = _Employee.Select("");
grvEmployee.DataBind();
grvEmployee.AllowPaging = true;
grvEmployee.PageSize = 5;
}
protected void btnEditar_Click(object sender, EventArgs e)
{
ImageButton btnEdit = sender as ImageButton;
GridViewRow grid = (GridViewRow)btnEdit.NamingContainer;
FAMIS_BLL.Employee _employee = new FAMIS_BLL.Employee();
List<Model.Employee> ListEmployee =
_employee.Select(" Where Employee_id=" + grvEmployee.DataKeys[grid.RowIndex].Values[0].ToString());
TxtEmployee_id.Text = ListEmployee.ElementAt(0).Employee_id.ToString();
TxtFirstName.Text = ListEmployee.ElementAt(0).First_name.ToString();
txtLast_name.Text = ListEmployee.ElementAt(0).Last_name.ToString();
DropDownPosition.SelectedValue = ListEmployee.ElementAt(0).Position_id.ToString();
DropDownAgencies.SelectedValue = ListEmployee.ElementAt(0).Agency_id.ToString();
TxtSalary.Text = ListEmployee.ElementAt(0).Salary.ToString();
txtDateHired.Text = ListEmployee.ElementAt(0).Date_hired.ToString();
TxtCode.Text = ListEmployee.ElementAt(0).Code.ToString();
HttpContext.Current.Session["EmployeePhoto"] = ListEmployee.ElementAt(0).Picture.ToString();
PicturePhoto.ImageUrl = Request.ApplicationPath + "/imagens/UsersPhoto/" + HttpContext.Current.Session["EmployeePhoto"].ToString() + ".jpg";
}
protected void btnExcluir_Click(object sender, EventArgs e)
{
try
{
ImageButton btnEdit = sender as ImageButton;
GridViewRow grid = (GridViewRow)btnEdit.NamingContainer;
FAMIS_BLL.Employee _employee = new FAMIS_BLL.Employee();
FAMIS_BLL.Employee _employeeDel = new FAMIS_BLL.Employee();
List<Model.Employee> ListEmployee =
_employee.Select(" Where Employee_id=" + grvEmployee.DataKeys[grid.RowIndex].Values[0].ToString());
_employeeDel.Remove(ListEmployee.ElementAt(0));
PreencheGrid();
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message.ToString());
}
}
protected void grvEmployee_PageIndexChanging(Object sender, GridViewPageEventArgs e)
{
FAMIS_BLL.Employee _employee = new FAMIS_BLL.Employee();
grvEmployee.DataSource = _employee.Select(""); //lista;
grvEmployee.PageIndex = e.NewPageIndex;
grvEmployee.DataBind();
}
protected void lkbSalvar_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(TxtEmployee_id.Text))
{// new
try
{
String xPhoto = HttpContext.Current.Session["CaminhoFotoEmployee"].ToString();
Model.Employee _employee = new Model.Employee();
_employee.First_name = TxtFirstName.Text;
_employee.Last_name = txtLast_name.Text;
_employee.Code = TxtCode.Text;
_employee.Date_hired = Convert.ToDateTime(txtDateHired.Text);
_employee.Last_version = DateTime.Now;
_employee.Salary = Convert.ToDecimal(TxtSalary.Text);
_employee.Agency_id = Convert.ToInt32(DropDownAgencies.SelectedValue.ToString());
_employee.Position_id = Convert.ToInt32(DropDownPosition.SelectedValue.ToString());
_employee.Picture = HttpContext.Current.Session["EmployeePhoto"].ToString();
FAMIS_BLL.Employee _employeeAdd = new FAMIS_BLL.Employee();
_employeeAdd.Add(_employee);
TxtEmployee_id.Text = "";
TxtFirstName.Text = "";
txtLast_name.Text = "";
TxtCode.Text = "";
txtDateHired.Text = "";
PicturePhoto.ImageUrl = Request.ApplicationPath + "/imagens/UsersPhoto/" + "GREY.jpg";
TxtSalary.Text = "";
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
else
{// if update client
try
{
String xPhoto = HttpContext.Current.Session["CaminhoFotoEmployee"].ToString();
Model.Employee _employee = new Model.Employee();
_employee.First_name = TxtFirstName.Text;
_employee.Last_name = txtLast_name.Text;
_employee.Code = TxtCode.Text;
_employee.Date_hired = Convert.ToDateTime(txtDateHired.Text);
_employee.Last_version = DateTime.Now;
_employee.Salary = Convert.ToDecimal(TxtSalary.Text);
_employee.Agency_id = Convert.ToInt32(DropDownAgencies.SelectedValue.ToString());
_employee.Position_id = Convert.ToInt32(DropDownPosition.SelectedValue.ToString());
_employee.Picture = HttpContext.Current.Session["EmployeePhoto"].ToString();
FAMIS_BLL.Employee _employeeAdd = new FAMIS_BLL.Employee();
_employeeAdd.Update(_employee);
TxtEmployee_id.Text = "";
TxtFirstName.Text = "";
txtLast_name.Text = "";
TxtCode.Text = "";
txtDateHired.Text = "";
PicturePhoto.ImageUrl = Request.ApplicationPath + "/imagens/UsersPhoto/" + "GREY.jpg";
TxtSalary.Text = "";
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
PreencheGrid();
}