Beispiel #1
0
        public void Insert(SkillEntity t)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

            try
            {
                conn = DALHelper.CreateSqlDbConnection();
                cmd = new SqlCommand("usp_InsertSkill", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@EmployeeId", t.EmployeeId);
                cmd.Parameters.AddWithValue("@SkillName", t.SkillName);

                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }
        public static void skillManagment(string employeeId, string value, string action)
        {
            if (string.IsNullOrEmpty(value))
            {
                throw new Exception("You must supply a value.");
            }
            if (string.IsNullOrEmpty(action))
            {
                throw new Exception("You must supply a action.");
            }

            if (action == "insert")
            {
                SkillEntity ent = new SkillEntity(){ EmployeeId= Convert.ToInt32(employeeId), SkillName= value};
                new SkillMapper().Insert(ent);
            }
            else
            {
                SkillEntity ent = new SkillEntity() { EmployeeId = Convert.ToInt32(employeeId), SkillName = value };
                new SkillMapper().Delete(ent);
            }
        }
Beispiel #3
0
        public List<SkillEntity> List(int EmployeeId, string search)
        {
            SqlConnection conn = null;
            SqlCommand cmd = null;

            try
            {
                conn = DALHelper.CreateSqlDbConnection();
                cmd = new SqlCommand("usp_ListSkillsByEmployeeId", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId);
                cmd.Parameters.AddWithValue("@SkillName", search);

                SqlDataReader rdr = cmd.ExecuteReader();
                List<SkillEntity> list = new List<SkillEntity>();

                while (rdr.Read())
                {
                    SkillEntity entity = new SkillEntity();
                    entity.EmployeeId = Convert.ToInt32(rdr["EmployeeId"]);
                    entity.SkillName = Convert.ToString(rdr["SkillName"]);

                    list.Add(entity);
                }

                return list;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                cmd.Dispose();
                conn.Dispose();
            }
        }