public void InsertEmployee(Employee emp)
{
using (posEntities db = new posEntities())
{
db.Employees.Add(emp);
db.SaveChanges();
}
RefreshGridView();
}
private void FillFields()
{
txtUsername.Text = usr.username;
using (posEntities db = new posEntities())
{
cbxEmployees.SelectedValue = db.Employees.Find(usr.employee_id);
cbxUserTypes.SelectedValue = db.User_type.Find(usr.user_type_id);
}
}
public User SearchForUser(string username)
{
User user;
using (posEntities db = new posEntities())
{
user = db.Users.FirstOrDefault(u => u.username == username);
}
return(user);
}
private void FillComboBoxes()
{
using (posEntities db = new posEntities())
{
cbxEmployees.DataSource = db.Employees.ToList();
cbxEmployees.ValueMember = "id";
cbxEmployees.DisplayMember = "first_name";
cbxUserTypes.DataSource = db.User_type.ToList();
cbxUserTypes.DisplayMember = "usr_type";
cbxUserTypes.ValueMember = "id";
}
}
public void PutEmployee(Employee newEmp)
{
using (posEntities db = new posEntities())
{
emp.first_name = newEmp.first_name;
emp.last_name = newEmp.last_name;
emp.birthdate = newEmp.birthdate;
emp.address = newEmp.address;
emp.telephone = newEmp.telephone;
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
}
RefreshGridView();
}
public void UpdateEmployee()
{
int?id = GetId();
if (id != null)
{
using (posEntities db = new posEntities())
{
emp = db.Employees.Find(id);
}
FrmNewEmployee frm = new FrmNewEmployee(this, emp);
frm.ShowDialog();
RefreshGridView();
}
}
protected List <FilteredEmployee> GetEmployees()
{
using (posEntities db = new posEntities())
{
List <FilteredEmployee> dataSourceList = (from d in db.Employees
select new FilteredEmployee()
{
id = d.id,
first_name = d.first_name,
last_name = d.last_name,
telephone = d.telephone,
hired_date = d.hired_date,
birthdate = d.birthdate,
address = d.address
}).ToList();
return(dataSourceList);
}
}
public void DeleteEmployee()
{
int?id = GetId();
if (id != null)
{
string title = "¿Estás seguro?";
string message = "Confirmar";
DialogResult dialogResult = Dialogs.YesOrNoDialog(title, message);
if (dialogResult == DialogResult.Yes)
{
using (posEntities db = new posEntities())
{
Employee emp = db.Employees.Find(id);
db.Employees.Remove(emp);
db.SaveChanges();
}
RefreshGridView();
}
}
}
