public void TestCreateSkill() { SkillDAL objSkillDAL = new SkillDAL(); SkillInfo objSkillInfo = new SkillInfo("EJB", "Enterprise Java Beans", 304, 101, DateTime.Now, 101, DateTime.Now); objSkillDAL.CreateSkill(objSkillInfo); }
public void TestUpdateSkill() { SkillDAL objSkillDAL = new SkillDAL(); SkillInfo objSkillInfo = new SkillInfo(403, "C#", "C# Language", 302, 101, DateTime.Now, 101, DateTime.Now); objSkillDAL.UpdateSkill(objSkillInfo); }
public void TestGetkillList() { SkillDAL objSkillDAL = new SkillDAL(); DataTable objDT = objSkillDAL.SearchSkills(); foreach (DataRow row in objDT.Rows) { Console.WriteLine(row[0].ToString()); } }
public void TestViewSkill() { SkillDAL objSkillDAL = new SkillDAL(); DataTable objDT = objSkillDAL.ViewSkill(402); foreach (DataRow row in objDT.Rows) { Console.WriteLine(row[1].ToString()); } }
public List <Skill> GetCollectionSkillsByType(string type) { try { SkillDAL repository = new SkillDAL(); List <Skill> skills = new List <Skill>(); return(skills = repository.GetCollectionSkillByType(type)); } catch (Exception ex) { throw ex; } }
public List <Skill> SelectSkillsForEvent() { SkillDAL skillRepositary = new SkillDAL(); List <Electronica.Entity.Skill> skillListEntity = new List <Electronica.Entity.Skill>(); List <Skill> skillList = new List <Skill>(); Skill skill = new Skill(); skillListEntity = skillRepositary.SelectSkillForEvent(); foreach (var item in skillListEntity) { skill = new Skill(); skill.SkillID = item.SkillID; skill.SkillName = item.SkillName; skillList.Add(skill); } return(skillList); }
public static string Delete(string id) { if (id[0] == '1') { return(Convert.ToString(HeroDAL.DeleteHero(id))); } else if (id[0] == '3') { return(Convert.ToString(SkillDAL.DeleteSkill(id))); } else if (id[0] == '4') { return(Convert.ToString(MapDAL.DeleteMap(id))); } else { return("false"); } }
public static string Insert(string text1, string text2, string text3, string text4) { if (text1[0] == '1') { Hero hero = new Hero(text1, text2, text3); return(Convert.ToString(HeroDAL.InsertHero(hero))); } else if (text1[0] == '3') { Skill skill = new Skill(text1, text2, text3, text4); return(Convert.ToString(SkillDAL.InsertSkill(skill))); } else if (text1[0] == '4') { Map map = new Map(text1, text2, text3); return(Convert.ToString(MapDAL.InsertMap(map))); } else { return("false"); } }
public static string Update(string oldId, string text1, string text2, string text3, string text4) { if (oldId[0] == '1') { Hero hero = new Hero(text1, text2, text3); return(Convert.ToString(HeroDAL.UpdateHero(oldId, hero))); } else if (oldId[0] == '3') { Skill skill = new Skill(text1, text2, text3, text4); return(Convert.ToString(SkillDAL.UpdateSkill(oldId, skill))); } else if (oldId[0] == '4') { Map map = new Map(text1, text2, text3); return(Convert.ToString(MapDAL.UpdateMap(oldId, map))); } else { return("false"); } }
public static DataTable GetSkillEndorsers(string SkillID) { return(SkillDAL.GetSkillEndorsers(SkillID)); }
public static int Remove(string SkillId) { return(SkillDAL.Remove(SkillId)); }
public static int De_Endorse(string SkillId) { return(SkillDAL.De_Endorse(SkillId)); }
public static int Update(string SkillName, string FK_SkillLevelId, string SkillId) { return(SkillDAL.Update(SkillName, FK_SkillLevelId, SkillId)); }
public static int Add(string SkillName, string FK_SkillLevelId, Guid FK_UserId) { return(SkillDAL.Add(SkillName, FK_SkillLevelId, FK_UserId)); }
public static DataTable GetByUserID(Guid FK_UserId) { return(SkillDAL.GetByUserID(FK_UserId)); }
public static DataTable GetAll() { return(SkillDAL.GetAll()); }
public static List <Skill> SelectSkillByHeroId(string heroId) { return(SkillDAL.SelectSkillByHeroId(heroId)); }
public SkillBC() { objSkillDAL = new SkillDAL(); }
public SkillBC(SkillDAL objSkillDAL) { this.objSkillDAL = objSkillDAL; }
public static List <Skill> GetSkillData() { return(SkillDAL.SelectAllSkill()); }