Esempio n. 1
0
        private void dgvemployees_DoubleClick(object sender, EventArgs e)
        {
            using (EmployeeManagementSystemEntities1 db = new EmployeeManagementSystemEntities1())
            {
                var employeeid = dgvemployees.CurrentRow.Cells["Id"].Value;
                var theRestOfTheEmployeeData = db.Employees.Find(employeeid);
                txtFirstName.Text = theRestOfTheEmployeeData.FirstName;
                txtLastname.Text  = theRestOfTheEmployeeData.LastName;
                if (theRestOfTheEmployeeData.Sex == "Male")
                {
                    rbtMale.Checked = true;
                }
                else if (theRestOfTheEmployeeData.Sex == "Female")
                {
                    rbtFemale.Checked = true;
                }

                cmbAge.Text     = theRestOfTheEmployeeData.Age.ToString();
                txtSalary.Text  = theRestOfTheEmployeeData.Salary.ToString();
                txtAddress.Text = theRestOfTheEmployeeData.Address;

                //id to be used to know which record to update
                empModel.id = theRestOfTheEmployeeData.id;
            }


            btnsave.Text      = "Update";
            btndelete.Enabled = true;
        }
Esempio n. 2
0
        private void btndelete_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Are you sure you want to delete", "Delete Record", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
                {
                    //var employeeid = dgvemployees.CurrentRow.Cells["Id"].Value;
                    using (EmployeeManagementSystemEntities1 db = new EmployeeManagementSystemEntities1())
                    {
                        db.Entry(empModel).State = EntityState.Deleted;
                        db.SaveChanges();
                        LoadData();
                        MessageBox.Show("Data Deleted Successfully");

                        Clear();
                        //second way
                        //var employeetodelete = db.Employees.Find(employeeid);
                        //db.Employees.Remove(employeetodelete);
                        //db.SaveChanges();
                        //LoadData();
                        //MessageBox.Show("Data Deleted Successfully");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Unable to delete data" + ex.Message);
            }
        }
Esempio n. 3
0
 public void LoadData()
 {
     using (EmployeeManagementSystemEntities1 db = new EmployeeManagementSystemEntities1())
     {
         dgvemployees.DataSource = db.Employees.ToList();
     }
 }
Esempio n. 4
0
        private void btnsave_Click(object sender, EventArgs e)
        {
            empModel.FirstName = txtFirstName.Text;
            empModel.LastName  = txtLastname.Text;
            if (rbtMale.Checked)
            {
                empModel.Sex = rbtMale.Text;
            }
            else if (rbtMale.Checked)
            {
                empModel.Sex = rbtFemale.Text;
            }
            empModel.Age     = int.Parse(cmbAge.Text);
            empModel.Salary  = decimal.Parse(txtSalary.Text);
            empModel.Address = txtAddress.Text;
            try
            {
                if (btnsave.Text == "Save")
                {
                    using (EmployeeManagementSystemEntities1 db = new EmployeeManagementSystemEntities1())
                    {
                        db.Employees.Add(empModel);
                        db.SaveChanges();
                        LoadData();
                        MessageBox.Show("Data Saved Successfully");

                        Clear();
                    }
                }
                else if (btnsave.Text == "Update")
                {
                    using (EmployeeManagementSystemEntities1 db = new EmployeeManagementSystemEntities1())
                    {
                        db.Entry(empModel).State = EntityState.Modified;
                        db.SaveChanges();
                        LoadData();
                        MessageBox.Show("Data Updated Successfully");
                        Clear();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot to save info" + ex.Message);
            }
        }