private void button1_Click(object sender, EventArgs e)
{
if (validation())
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
employees oEmployees = new employees();
position oPosition = db.position.Find(cmbPosition.SelectedValue);
oEmployees.name = txtName.Text;
oEmployees.lastname = txtLastName.Text;
oEmployees.address = txtAddress.Text;
oEmployees.birthdate = dtpBirthDate.Value;
oEmployees.phone = txtPhone.Text;
oEmployees.email = txtEmail.Text;
oEmployees.admissionDate = dtpAdmissionDate.Value;
oEmployees.huella = null;
oEmployees.gender = cmbGender.Text;
oEmployees.position = oPosition;
MemoryStream memorystream = new MemoryStream();
pictureBox1.Image.Save(memorystream, System.Drawing.Imaging.ImageFormat.Jpeg);
oEmployees.images = memorystream.ToArray();
db.employees.Add(oEmployees);
db.SaveChanges();
MessageBox.Show("Added Successfully");
}
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
employees oEmployees = db.employees.Find((int)cmbUsersDevelop.SelectedValue);
if (oEmployees != null)
{
lblName.Text = oEmployees.name;
lblPosition.Text = oEmployees.position.name;
if (oEmployees.images != null)
{
MemoryStream ms = new MemoryStream(oEmployees.images);
Image returnImage = Image.FromStream(ms);
picImage.Image = returnImage;
}
if (registerEmployee(oEmployees))
{
panelFinger.BackColor = Color.ForestGreen;
panelInformation.Visible = true;
lblError.Visible = false;
timerProfile.Start();
}
else
{
lblError.Visible = true;
}
}
else
{
lblError.Visible = true;
}
}
}
private void frmAddNewEmployee_Load(object sender, EventArgs e)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
var lstPosition = from d in db.position
select d;
cmbPosition.DataSource = lstPosition.ToList();
cmbPosition.DisplayMember = "name";
cmbPosition.ValueMember = "id";
}
}
private void Form1_Load(object sender, EventArgs e)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
var lst = from d in db.employees
select d;
cmbUsersDevelop.DataSource = lst.ToList();
cmbUsersDevelop.DisplayMember = "id";
cmbUsersDevelop.ValueMember = "id";
}
}
private void frmEmployeesInfo_Load(object sender, EventArgs e)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
employees employee = db.employees.Find(this.employeeID);
if (employee != null)
{
populateData(employee);
}
var lstemployees = from d in db.employees select d;
lblPersonalCount.Text = lstemployees.Where(p => p.idPosition == employee.idPosition).Count().ToString();
}
}
private void GetData(string option)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
if (option.Equals("employees"))
{
var lst = from d in db.employees
select new
{
id = d.id,
name = d.name,
lastname = d.lastname,
address = d.address,
birthdate = d.birthdate,
phone = d.phone,
email = d.email,
admissiondate = d.admissionDate,
position = d.position.name
};
dataGridView1.DataSource = lst.ToList();
}
if (option.Equals("checkin"))
{
var lst = from d in db.checkin
select new
{
id = d.id,
employee = d.employees.name + " " + d.employees.lastname,
Date = d.checkDate,
Hour = d.checkHour,
Observations = d.observations != null ? d.observations : "No hay observaciones"
};
dataGridView1.DataSource = lst.ToList();
}
if (option.Equals("checkout"))
{
var lst = from d in db.checkout
select new
{
id = d.id,
employee = d.employees.name + " " + d.employees.lastname,
Date = d.checkDate,
Hour = d.checkHour,
Observations = d.observations != null ? d.observations : "No hay observaciones"
};
dataGridView1.DataSource = lst.ToList();
}
}
}
private bool login(string username, string password)
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
var lst = from d in db.users
select d;
var data = lst.FirstOrDefault(p => p.username == username && p.password == password);
if (data == null)
{
return(false);
}
else
{
return(true);
}
}
}
private bool registerEmployee(employees e)
{
try
{
using (smartclocksrldbEntities db = new smartclocksrldbEntities())
{
if (!this.Cache.Contains(e.id))
{
checkin oCheckin = new checkin
{
employeeID = e.id,
checkDate = DateTime.Now.Date,
checkHour = DateTime.Now.ToString("HH:mm:ss"),
observations = null
};
db.checkin.Add(oCheckin);
db.SaveChanges();
lblStatus.Text = "Check In";
lblStatus.ForeColor = Color.LightGreen;
this.Cache.Add(e.id);
return(true);
}
else
{
checkout oCheckout = new checkout
{
employeeID = e.id,
checkDate = DateTime.Now.Date,
checkHour = DateTime.Now.ToString("HH:mm:ss"),
observations = null
};
db.checkout.Add(oCheckout);
db.SaveChanges();
lblStatus.Text = "Check Out";
lblStatus.ForeColor = Color.LightGreen;
this.Cache.Remove(e.id);
return(true);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message);
return(false);
}
}
