Пример #1
0
        // select All

        public static List <emp> selectAll()
        {
            string     query = "select * from Employee1;";
            List <emp> emps  = new List <emp>();

            Connect.Open();
            SqlCommand    cmd    = new SqlCommand(query, Connect);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                string Empid  = reader["Emp_ID"].ToString();
                int    Empid2 = Convert.ToInt32(Empid);
                emp    us     = new emp();
                us.Empid     = Empid2;
                us.EmpName   = reader["Emp_Name"].ToString();
                us.EmpSalary = reader["Emp_Salary"].ToString();
                us.UserId    = Convert.ToInt32(reader["User_ID"]);
                us.Sdate     = reader["Start_Date"].ToString();
                emps.Add(us);
            }

            Connect.Close();

            return(emps);
        }
Пример #2
0
        // update

        public static void update(emp emps)
        {
            string     query = "UPDATE Employee1 set Emp_Name=@pn,Emp_Salary=@s,Start_Date=@pass where Emp_ID=@id";
            SqlCommand cmd   = new SqlCommand(query, Connect);

            Connect.Open();
            cmd.Parameters.AddWithValue("@id", emps.Empid);
            cmd.Parameters.AddWithValue("@pn", emps.EmpName);
            cmd.Parameters.AddWithValue("@s", emps.EmpSalary);
            cmd.Parameters.AddWithValue("@pass", emps.Sdate);
            cmd.ExecuteNonQuery();
            Connect.Close();
        }
Пример #3
0
        // add new emp.
        public static void addTo(emp em)
        {
            string query = "insert into Employee1 values(@Emp_Name,@Emp_Salary,@Start_Date,@roleID,@userID)";

            Connect.Open();
            SqlCommand cmd = new SqlCommand(query, Connect);

            cmd.Parameters.AddWithValue("@userID", em.UserId);
            cmd.Parameters.AddWithValue("@Emp_Name", em.EmpName);
            cmd.Parameters.AddWithValue("@Emp_Salary", em.EmpSalary.ToString());
            cmd.Parameters.AddWithValue("@roleID", em.roleID);
            cmd.Parameters.AddWithValue("@Start_Date", em.Sdate);
            cmd.ExecuteNonQuery();
            Connect.Close();
        }