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());
}
