Esempio n. 1
0
        protected void btUpdate_Click(object sender, EventArgs e)
        {
            int SelectedEmpID = string.IsNullOrEmpty(ddlEmployee.SelectedValue) ? -1 : int.Parse(ddlEmployee.SelectedValue);
            //Read the record from the database.
            LearnEFEntities db = new LearnEFEntities();
            //following query will fetch a record based upon the EmpID passed through local variable empId
            var empQuery = from emp in db.Employees
                           where emp.EmpId == SelectedEmpID
                           select emp;
            Employee objEmp;

            if (!empQuery.Any())
            {
                objEmp = new Employee();
                db.Employees.Add(objEmp);
            }
            else
            {
                objEmp = empQuery.Single();
            }

            //set the new values of the columns (properties), based upon the values entered using the text boxes
            objEmp.HREmpId   = txtHREmpID.Text;
            objEmp.FirstName = txtFirstName.Text;
            objEmp.LastName  = txtLastName.Text;
            objEmp.Address   = txtAddress.Text;
            objEmp.City      = txtCity.Text;

            //save your changes into the database
            db.SaveChanges();
            ReloadData();
            ddlEmployee.SelectedValue = objEmp.EmpId.ToString();
        }
Esempio n. 2
0
        protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(ddlEmployee.SelectedValue);

            if (empId == 0)
            {
                ClearEmpForm();
                return;
            }

            btnSave.CommandArgument   = empId.ToString();
            btnSave.Text              = "UPDATE";
            btnDelete.CommandArgument = empId.ToString();

            LearnEFEntities db = new LearnEFEntities();

            var empQuery = from emp in db.Employees
                           where emp.EmpId == empId
                           select emp;

            Employee objEmp = empQuery.Single();

            txtHREmpId.Text   = objEmp.HREmpId;
            txtFirstName.Text = objEmp.FirstName;
            txtLastName.Text  = objEmp.LastName;
            txtAddress.Text   = objEmp.Address;
            txtCity.Text      = objEmp.City;
        }
Esempio n. 3
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            int             SelectedEmpID = string.IsNullOrEmpty(ddlEmployee.SelectedValue) ? -1 : int.Parse(ddlEmployee.SelectedValue);
            LearnEFEntities db            = new LearnEFEntities();
            var             empQuery      = from emp in db.Employees
                                            where emp.EmpId == SelectedEmpID
                                            select emp;

            if (!empQuery.Any())
            {
                return;
            }
            //create a new object using the value of EmpId
            Employee objEmp = new Employee()
            {
                EmpId = SelectedEmpID
            };

            //attach object in the entity set
            db.Employees.Attach(objEmp);

            //mark the object for deletion
            db.Employees.Remove(objEmp);

            //save changes
            db.SaveChanges();
            ReloadData();
            txtHREmpID.Text   = "";
            txtFirstName.Text = "";
            txtLastName.Text  = "";
            txtAddress.Text   = "";
            txtCity.Text      = "";
        }
Esempio n. 4
0
        protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
        {
            int             SelectedEmpID = string.IsNullOrEmpty(ddlEmployee.SelectedValue) ? -1 : int.Parse(ddlEmployee.SelectedValue);
            LearnEFEntities db            = new LearnEFEntities();
            var             empQuery      = from emp in db.Employees
                                            where emp.EmpId == SelectedEmpID
                                            select emp;

            if (empQuery.Any())
            {
                Employee objEmp = empQuery.Single();
                txtHREmpID.Text   = objEmp.HREmpId;
                txtFirstName.Text = objEmp.FirstName;
                txtLastName.Text  = objEmp.LastName;
                txtAddress.Text   = objEmp.Address;
                txtCity.Text      = objEmp.City;
            }
            else
            {
                txtHREmpID.Text   = "";
                txtFirstName.Text = "";
                txtLastName.Text  = "";
                txtAddress.Text   = "";
                txtCity.Text      = "";
            }
        }
Esempio n. 5
0
        private void ReloadData()
        {
            int             SelectedEmpID = string.IsNullOrEmpty(ddlEmployee.SelectedValue) ? -1 : int.Parse(ddlEmployee.SelectedValue);
            LearnEFEntities db            = new LearnEFEntities();

            var empQuery = from emp in db.Employees
                           select emp;
            List <Employee> empList = empQuery.ToList();

            ddlEmployee.DataSource     = empList;
            ddlEmployee.DataValueField = "EmpId";
            ddlEmployee.DataTextField  = "FirstName";
            ddlEmployee.DataBind();

            ddlEmployee.Items.Insert(0, new ListItem("--Add New--", "0"));
            var selected = from emp in empList
                           where emp.EmpId == SelectedEmpID
                           select emp;

            if (selected.Any())
            {
                ddlEmployee.SelectedValue = SelectedEmpID.ToString();
            }
            //bind grid
            GridView1.DataSource = empList;
            GridView1.DataBind();
        }
Esempio n. 6
0
        private void PopulateEmpList()
        {
            LearnEFEntities db = new LearnEFEntities();

            List <Employee> empList = db.SearchEmployee(txtSrchFirstName.Text, txtSrchCity.Text).ToList();

            ddlEmployee.DataSource     = empList;
            ddlEmployee.DataValueField = "EmpId";
            ddlEmployee.DataTextField  = "FirstName";
            ddlEmployee.DataBind();

            ddlEmployee.Items.Insert(0, new ListItem("--Add New--", "0"));

            //bind grid
            GridView1.DataSource = empList;
            GridView1.DataBind();
        }
Esempio n. 7
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(btnSave.CommandArgument);
            if (empId != 0)
            {
                LearnEFEntities db = new LearnEFEntities();

                Employee objEmp = new Employee() { EmpId = empId };
                db.Employees.Attach(objEmp);
                db.Employees.DeleteObject(objEmp);
                db.SaveChanges();

                //reset the form and grid
                ClearEmpForm();
                PopulateEmpList();
            }
        }
Esempio n. 8
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(btnSave.CommandArgument);

            if (empId == 0)
            {
                //INSERT
                LearnEFEntities db = new LearnEFEntities();

                Employee objEmp = new Employee();
                objEmp.HREmpId = txtHREmpId.Text;
                objEmp.FirstName = txtFirstName.Text;
                objEmp.LastName = txtLastName.Text;
                objEmp.Address = txtAddress.Text;
                objEmp.City = txtCity.Text;

                db.Employees.AddObject(objEmp);
                db.SaveChanges();
            }
            else
            {
                //UPDATE
                LearnEFEntities db = new LearnEFEntities();

                var empQuery = from emp in db.Employees
                               where emp.EmpId == empId
                               select emp;
                Employee objEmp = empQuery.Single();

                objEmp.HREmpId = txtHREmpId.Text;
                objEmp.FirstName = txtFirstName.Text;
                objEmp.LastName = txtLastName.Text;
                objEmp.Address = txtAddress.Text;
                objEmp.City = txtCity.Text;

                db.SaveChanges();

            }

            ClearEmpForm();
            PopulateEmpList();
        }
Esempio n. 9
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            //below code does not work.....
            LearnEFEntities db  = new LearnEFEntities();
            int             ret = db.SearchEmployee(txtFirstNameSearch.Text, txtCitySearch.Text);

            db.Dispose();

            using (var context = new LearnEFEntities())
            {
                var firstNameParameter = new SqlParameter("@FirstName", txtFirstNameSearch.Text);
                var cityParameter      = new SqlParameter("@City", txtCitySearch.Text);
                var result             = context.Database
                                         .SqlQuery <Employee>("SearchEmployee @FirstName, @City", firstNameParameter, cityParameter)
                                         .ToList();
                //bind grid
                GridSearch.DataSource = result;
                GridSearch.DataBind();
            }
        }
Esempio n. 10
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(btnSave.CommandArgument);

            if (empId == 0)
            {
                //INSERT
                LearnEFEntities db = new LearnEFEntities();

                Employee objEmp = new Employee();
                objEmp.HREmpId   = txtHREmpId.Text;
                objEmp.FirstName = txtFirstName.Text;
                objEmp.LastName  = txtLastName.Text;
                objEmp.Address   = txtAddress.Text;
                objEmp.City      = txtCity.Text;

                db.Employees.AddObject(objEmp);
                db.SaveChanges();
            }
            else
            {
                //UPDATE
                LearnEFEntities db = new LearnEFEntities();

                var empQuery = from emp in db.Employees
                               where emp.EmpId == empId
                               select emp;
                Employee objEmp = empQuery.Single();

                objEmp.HREmpId   = txtHREmpId.Text;
                objEmp.FirstName = txtFirstName.Text;
                objEmp.LastName  = txtLastName.Text;
                objEmp.Address   = txtAddress.Text;
                objEmp.City      = txtCity.Text;

                db.SaveChanges();
            }

            ClearEmpForm();
            PopulateEmpList();
        }
Esempio n. 11
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(btnSave.CommandArgument);

            if (empId != 0)
            {
                LearnEFEntities db = new LearnEFEntities();

                Employee objEmp = new Employee()
                {
                    EmpId = empId
                };
                db.Employees.Attach(objEmp);
                db.Employees.DeleteObject(objEmp);
                db.SaveChanges();

                //reset the form and grid
                ClearEmpForm();
                PopulateEmpList();
            }
        }
Esempio n. 12
0
        protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
        {
            Int32 empId = Convert.ToInt32(ddlEmployee.SelectedValue);

            if (empId == 0)
            {
                ClearEmpForm();
                return;
            }

            btnSave.CommandArgument = empId.ToString();
            btnSave.Text = "UPDATE";
            btnDelete.CommandArgument = empId.ToString();

            LearnEFEntities db = new LearnEFEntities();

            var empQuery = from emp in db.Employees
                           where emp.EmpId == empId
                           select emp;

            Employee objEmp = empQuery.Single();

            txtHREmpId.Text = objEmp.HREmpId;
            txtFirstName.Text = objEmp.FirstName;
            txtLastName.Text = objEmp.LastName;
            txtAddress.Text = objEmp.Address;
            txtCity.Text = objEmp.City;
        }
Esempio n. 13
0
        private void PopulateEmpList()
        {
            LearnEFEntities db = new LearnEFEntities();

            List<Employee> empList = db.SearchEmployee(txtSrchFirstName.Text, txtSrchCity.Text).ToList();

            ddlEmployee.DataSource = empList;
            ddlEmployee.DataValueField = "EmpId";
            ddlEmployee.DataTextField = "FirstName";
            ddlEmployee.DataBind();

            ddlEmployee.Items.Insert(0, new ListItem("--Add New--", "0"));

            //bind grid
            GridView1.DataSource = empList;
            GridView1.DataBind();
        }