private void updateEmpTbl()
        {
            int v = (int)Cache["table"];
            Feb1AssignmentEntities fae = new Feb1AssignmentEntities();

            if (v == -1)
            {
                employeetbl.DataSource = fae.spGetAllEmps(-1).ToList();
            }
            else
            {
                try
                {
                    //sort by dept
                    if (v == 0)
                    {
                        employeetbl.DataSource = (from Emp in fae.Employees
                                                  join Dep in fae.Departments on Emp.DeptId equals Dep.DeptID
                                                  orderby Dep.DeptName ascending
                                                  select new { EmployeeName = Emp.EmpName, Salary = Emp.EmpSalary, Department = Dep.DeptName }).ToList();
                    }
                    //toupper
                    else if (v == 1)
                    {
                        employeetbl.DataSource = (from Emp in fae.Employees
                                                  join Dep in fae.Departments on Emp.DeptId equals Dep.DeptID
                                                  select new { EmployeeName = Emp.EmpName.ToUpper(), Salary = Emp.EmpSalary, Department = Dep.DeptName }).ToList();
                    }
                    else
                    {
                        var maxSalary = (from Emp in fae.Employees
                                         select Emp).Max(x => x.EmpSalary);
                        employeetbl.DataSource = (from Emp in fae.Employees
                                                  select Emp).Where(x => x.EmpSalary == maxSalary).ToList();
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception("Error occured while retrieving Route Info - " + ex.Message.ToString());
                }
            }
            employeetbl.DataBind();
        }
        protected void addNewItems(object sender, EventArgs e)
        {
            Feb1AssignmentEntities fae = new Feb1AssignmentEntities();
            Department             dep = new Department();

            dep.DeptName = RandomString(50);
            fae.Departments.Add(dep);
            Employee emp1 = new Employee(), emp2 = new Employee();

            emp1.DeptId    = fae.Departments.ToList()[fae.Departments.Count() - 1].DeptID;
            emp2.DeptId    = fae.Departments.ToList()[fae.Departments.Count() - 1].DeptID;
            emp1.EmpName   = RandomString(50);
            emp2.EmpName   = RandomString(50);
            emp1.EmpSalary = random.Next(200000);
            emp2.EmpSalary = random.Next(200000);
            fae.Employees.Add(emp1);
            fae.Employees.Add(emp2);
            fae.SaveChanges();
            updateEmpTbl();
        }