示例#1
0
        public PartialViewResult allEmployees()
        {
            //List<Employee> emps = new List<Employee>();
            //Employee emp1 = new Employee() { EmployeeId = 001, EmployeeGender = "male", EmployeeName = "Ram", DepartmentId = 1 };
            //Employee emp2 = new Employee() { EmployeeId = 002, EmployeeGender = "female", EmployeeName = "Sita", DepartmentId = 2 };
            //emps.Add(emp1);
            //emps.Add(emp2);

            //Employee emp = new Employee();
            //if (emps.Count() != 0)
            //{
            //    var list = emps.Where(x => x.EmployeeId == 002).FirstOrDefault();
            //    emp = list;

            //}
            Employee empp = new Employee();
            var empslist = db.GetEmployees();
            foreach (Employee e in empslist)
            {

                empp = e;
                break;

            }

            return PartialView("_employees", empp);
        }
示例#2
0
        public ActionResult Create(Employee emp, string Command)
        {
            if (ModelState.IsValid)
            {
                db.SaveData(emp);
                TempData["Msg"] = "Data has been saved succeessfully";
                return RedirectToAction("Index2");
            }

            return View(emp);
        }
示例#3
0
        public IList<Employee> GetEmployees()
        {
            string strConfig = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            List<Employee> emplist = new List<Employee>();
            using (SqlConnection conn = new SqlConnection(strConfig))
            {

                SqlCommand cmd = new SqlCommand();

                cmd.Connection = conn;

                cmd.CommandText = "SELECT [EmpId],[Name],[Gender],[DeptId] FROM [Sample].[dbo].[tblEmployee]";

                cmd.CommandType = CommandType.Text;

                conn.Open();

                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                while (rdr.Read())
                {

                    Employee emp = new Employee();

                    emp.EmployeeId = Convert.ToInt32(rdr["EmpId"]);
                    emp.EmployeeName = Convert.ToString(rdr["Name"]);
                    emp.EmployeeGender = Convert.ToString(rdr["Gender"]);
                    emp.DepartmentId = Convert.ToInt32(rdr["DeptId"]);
                    emplist.Add(emp);

                }

                conn.Close();

                rdr = null;

                cmd = null;

            }

            return emplist;
        }
示例#4
0
        public void SaveData(Employee emp)
        {
            // define INSERT query with parameters
            string query = "INSERT INTO [Sample].[dbo].[tblEmployee] (Name,Gender,DeptId) " +
                   "VALUES ('"+emp.EmployeeName+"','"+emp.EmployeeGender+"','"+emp.DepartmentId+"') ";

            // create connection and command
            string strConfig = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection cn = new SqlConnection(strConfig))
            using(SqlCommand cmd = new SqlCommand(query, cn))
            {
            // define parameters and their values
            cmd.Parameters.Add("@EmployeeName", SqlDbType.VarChar, 50).Value = emp.EmployeeName;
            cmd.Parameters.Add("@EmployeeGender", SqlDbType.VarChar, 50).Value = emp.EmployeeGender;
            cmd.Parameters.Add("@DepartmentId", SqlDbType.VarChar, 50).Value = emp.DepartmentId;

            // open connection, execute INSERT, close connection
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();
            }
        }
示例#5
0
        public void UpdateData(Employee emp)
        {
            // define INSERT query with parameters
            string query = "UPDATE [Sample].[dbo].[tblEmployee] SET Name='" + emp.EmployeeName + "',Gender='" + emp.EmployeeGender + "',DeptId='" + emp.DepartmentId + "' where EmpId='"+emp.EmployeeId+"'";

            // create connection and command
            string strConfig = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection cn = new SqlConnection(strConfig))
            using (SqlCommand cmd = new SqlCommand(query, cn))
            {

                // open connection, execute Delete, close connection
                cn.Open();
                cmd.ExecuteNonQuery();
                cn.Close();
            }
        }
示例#6
0
 public ActionResult Edit(Employee emp)
 {
     if (ModelState.IsValid)
     {
         db.UpdateData(emp);
         TempData["Msg"] = "Data has been updated succeessfully";
         return RedirectToAction("Index2");
     }
     return View(emp);
 }