Esempio n. 1
0
 private void button3_Click(object sender, RoutedEventArgs e)
 {
     using (EmployeeDataContext Empdb = new EmployeeDataContext(strConnectionString))
     {
         IQueryable<Employee> EmpQuery = from Emp in Empdb.Employees where Emp.EmployeeName == txtName.Text select Emp;
         Employee EmpRemove = EmpQuery.FirstOrDefault();
         Empdb.Employees.DeleteOnSubmit(EmpRemove);
         Empdb.SubmitChanges();
         MessageBox.Show("Employee Deleted Successfully!!!");
     }
 }
Esempio n. 2
0
 public IList<Employee> GetEmployeeList()
 {
     // Fetching data from local database
     IList<Employee> EmployeeList = null;
     using (EmployeeDataContext Empdb = new EmployeeDataContext(strConnectionString))
     {
         IQueryable<Employee> EmpQuery = from Emp in Empdb.Employees select Emp;
         EmployeeList = EmpQuery.ToList();
     }
     return EmployeeList;
 }
Esempio n. 3
0
 private void button1_Click(object sender, RoutedEventArgs e)
 {
     //create database
     using (EmployeeDataContext Empdb = new EmployeeDataContext(strConnectionString))
     {
         if (Empdb.DatabaseExists() == false)
         {
             Empdb.CreateDatabase();
             MessageBox.Show("Employee Database Created Successfully!!!");
         }
         else
         {
             MessageBox.Show("Employee Database already exists!!!");
         }
     }
 }
Esempio n. 4
0
        private void button2_Click(object sender, RoutedEventArgs e)
        {
            //Adding data to the local database
            using (EmployeeDataContext Empdb = new EmployeeDataContext(strConnectionString))
            {
                Employee newEmployee = new Employee
                {
                    EmployeeID = Convert.ToInt32(txtEmpid.Text),
                    EmployeeAge = txtAge.Text.ToString(),
                    EmployeeName = txtName.Text.ToString()
                };

                Empdb.Employees.InsertOnSubmit(newEmployee);
                Empdb.SubmitChanges();
                MessageBox.Show("Employee Added Successfully!!!");
            }
        }
Esempio n. 5
0
 private void button5_Click(object sender, RoutedEventArgs e)
 {
     //delete database
     using (EmployeeDataContext Empdb = new EmployeeDataContext(strConnectionString))
     {
         if (Empdb.DatabaseExists())
         {
             Empdb.DeleteDatabase();
             MessageBox.Show("Employee Database Deleted Successfully!!!");
         }
     }
 }