public int CountActivGames(int acceptUserId, int requestUserId) { string q = $"select Count(Id) from Games g where (g.RequestUser={requestUserId} and g.AcceptUser={acceptUserId} and g.Status <> 'Close') or (g.RequestUser={acceptUserId} and g.AcceptUser={requestUserId}) and g.Status <> 'Close'"; using (CommanderBase commander = DBContext.CreateCommander()) { var obj = commander.Scaller(q); return(obj != null?Convert.ToInt32(obj) : default(int)); } }
public int GetIdByColumName(string columName, object value) { string q = $"Select u.Id from AppUser u Where u.{columName} = @{columName}"; using (CommanderBase commander = DBContext.CreateCommander()) { var obj = commander.Scaller(q, new List <System.Data.Common.DbParameter>() { commander.SetParametr(columName, value) }); if (obj != null) { return(Convert.ToInt32(obj)); } else { return(default(int)); } } }