public IEnumerable <Player> GetAll()
{
using (IObjectDb db = ObjectDbFactory.CreateInstance("GetAllPlayer"))
{
return(db.Query <Player>());
}
}
public IEnumerable <Round> GetListRoundByTournament(int id)
{
var parameter = new
{
TourID = id.ToString(),
};
using (IObjectDb db = ObjectDbFactory.CreateInstance("GetListRoundByTournament"))
{
return(db.Query <Round>(parameter));
}
}
public User FindUserName(string userName)
{
var parameter = new
{
UserName = userName
};
using (IObjectDb objectDb = ObjectDbFactory.CreateInstance("FindUserName"))
{
return(objectDb.Query <User>(parameter).FirstOrDefault());
}
}
public IEnumerable <Federation> GetFederationInTournament(int id)
{
var parameter = new
{
TourId = id.ToString(),
};
using (IObjectDb db = ObjectDbFactory.CreateInstance("GetFederationParticipate"))
{
return(db.Query <Federation>(parameter));
}
}
public Federation GetById(int id)
{
var parameter = new
{
TourId = id.ToString(),
};
using (IObjectDb db = ObjectDbFactory.CreateInstance("GetSingle"))
{
return(db.Query <Federation>(parameter).FirstOrDefault());
}
}
public void Add(User entity)
{
var param = new
{
UserName = entity.UserName,
Password = entity.Password,
RoleID = RoleType.Normal,
};
using (IObjectDb db = ObjectDbFactory.CreateInstance("CreateUser"))
{
db.ExecuteNonQuery(param);
}
}
public void Add(Player entity)
{
var param = new
{
Name = entity.Name,
BirthDate = entity.BirthDate,
Image = entity.Image,
Sex = entity.Sex,
FederationID = entity.Federation.ID,
};
using (IObjectDb db = ObjectDbFactory.CreateInstance("CreatePlayer"))
{
db.ExecuteNonQuery(param);
}
}
public User CheckUser(string userName, string passWord)
{
const string splitOn = "Name";
var parameter = new
{
UserName = userName,
PassWord = passWord
};
using (IObjectDb objectDb = ObjectDbFactory.CreateInstance("CheckUser"))
{
return(objectDb.Query <User, Role, User>(
(user, role) =>
{
user.Role = role;
return user;
},
splitOn,
parameter)
.FirstOrDefault());
}
}
public Repository(IReferenceDb referenceDb, IObjectDb objectDb)
{
ReferenceDb = referenceDb;
ObjectDb = objectDb;
}
