public void InsertRepair(Repair model)
{
try
{
using (var context = new BJContext())
{
context.Insert <Repair>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public List <Repair> SelectAllRepair()
{
try
{
using (var context = new BJContext())
{
return(context.Repair.OrderByDescending(u => u.ID).ToList());
}
}
catch
{
return(null);
}
}
public void UpdateRepair(Repair model)
{
try
{
using (var context = new BJContext())
{
context.Update <Repair>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public void InsertMonitorHistory(MonitorHistory model)
{
try
{
using (var context = new BJContext())
{
context.Insert <MonitorHistory>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public MonitorHistory SelectMonitorHistory(int id)
{
try
{
using (var context = new BJContext())
{
return(context.MonitorHistory.Where(u => u.ID == id).FirstOrDefault());
}
}
catch
{
return(null);
}
}
public List <MonitorHistory> SelectAllMonitorHistory()
{
try
{
using (var context = new BJContext())
{
return(context.MonitorHistory.OrderByDescending(u => u.ID).ToList());
}
}
catch
{
return(null);
}
}
public Controler SelectControler(int id)
{
try
{
using (var context = new BJContext())
{
return(context.Controler.Where(u => u.ID == id).FirstOrDefault());
}
}
catch
{
return(null);
}
}
public void UpdateControler(Controler model)
{
try
{
using (var context = new BJContext())
{
context.Update <Controler>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public void InsertControler(Controler model)
{
try
{
using (var context = new BJContext())
{
context.Insert <Controler>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public void UpdateMonitor(Monitor model)
{
try
{
using (var context = new BJContext())
{
context.Update <Monitor>(model);
}
}
catch (Exception exception)
{
throw exception;
}
}
public void DeleteControlerHistory(List <int> ids)
{
try
{
using (var context = new BJContext())
{
context.ControlerHistory.Where(u => ids.Contains(u.ID)).ToList().ForEach(a => { context.ControlerHistory.Remove(a); });
context.SaveChanges();
}
}
catch (Exception exception)
{
throw exception;
}
}
List <Cards> IDeck.GetDeck(int size = 1)
{
List <Cards> deck = new List <Cards>();
using (var db = new BJContext())
{
var query = from C in db.Cards
where C.CardID <= DECK_SIZE * size
select C;
foreach (var card in query)
{
deck.Add(card);
}
}
return(deck);
}
public Cards GetCardPicture(int id)
{
Cards c = new Cards();
using (var db = new BJContext())
{
var query = from C in db.Cards
where C.CardID == id
select C;
foreach (var Card in query)
{
c = Card;
}
return(c);
}
}
public int GetPLayerID(string NIck)
{
using (var db = new BJContext())
{
int id = 0;
var query = from s in db.PLAYERS
where s.NickName == NIck
select s;
foreach (var student in query)
{
if (student.PlayerID != 0)
{
id = student.PlayerID;
}
}
return(id);
}
}
public bool CheckPlayer(string nick)
{
using (var db = new BJContext())
{
bool exist = false;
var query = from s in db.PLAYERS
where s.NickName == nick
select s;
foreach (var student in query)
{
if (student.PlayerID != 0)
{
exist = true;
}
}
return(exist);
}
}
private PLAYERS GetPLAYERS(int playerID)
{
PLAYERS pl = new PLAYERS();
using (var db = new BJContext())
{
var query = from s in db.PLAYERS
where s.PlayerID == playerID
select s;
foreach (var student in query)
{
if (student.PlayerID != 0)
{
pl = student;
}
}
}
return(pl);
}
public BotRepository(BJContext context) : base(context)
{
}
public StepUserRepository(BJContext context) : base(context)
{
}
public CardRepository(BJContext context) : base(context)
{
}
public GameRepository(BJContext context) : base(context)
{
}
public EFUnitOfWork(BJContext context)
{
db = context;
}
