public static RankingDto createRankingDTO(Ranking obj)
{
RankingDto ran = new RankingDto();
ran.RankingId = obj.RankingId;
ran.RankingName = obj.RankingName;
return ran;
}
public static Ranking createRanking(String RankingId, String RankingName)
{
Ranking obj = new Ranking();
obj.RankingId = RankingId;
obj.RankingName = RankingName;
return obj;
}
public Ranking selectRankingById(Ranking obj)
{
try
{
IRankingSvc svc = (IRankingSvc)this.getService(typeof(IRankingSvc).Name);
return svc.selectRankingById(obj);
}
catch (ServiceLoadException ex)
{
return null;
}
}
public Boolean deleteRanking(Ranking obj)
{
try
{
IRankingSvc svc = (IRankingSvc)this.getService(typeof(IRankingSvc).Name);
return svc.deleteRanking(obj);
}
catch (ServiceLoadException ex)
{
return false;
}
}
public Ranking selectRankingById(Ranking obj)
{
NewRecruiteeBankContext db = new NewRecruiteeBankContext();
try
{
return db.Rankings.SqlQuery("dbo.SelectRankingById @RankingId='" + obj.RankingId.ToString() + "'").Single();
}
catch (Exception ex)
{
return null;
}
}
public Boolean insertRanking(Ranking obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
db.Rankings.Add(obj);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public Boolean deleteRanking(Ranking obj)
{
using (NewRecruiteeBankContext db = new NewRecruiteeBankContext())
{
try
{
Ranking ranking = db.Rankings.SqlQuery("dbo.SelectRankingById @RankingId='" + obj.RankingId.ToString() + "'").Single();
if (ranking != null)
{
db.Rankings.Remove(ranking);
#region Database Submission
try
{
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
#endregion
}
else
{
return false;
}
}
catch (Exception ex)
{
return false;
}
}
}