protected int Execute(string sql, object param = null)
{
var connection = db.CreateConnection();
int count = connection.Execute(sql, param);
db.CloseConnection(connection);
return(count);
}
public List <T> ToList(int pageSize = 0)
{
var top = pageSize > 0 ? string.Format(" top {0}", pageSize) : "";
var sql = string.Format("select{0} {1}", top, this.GetSql());
var connection = db.CreateConnection();
var result = connection.Query <T>(sql, null).ToList();
db.CloseConnection(connection);
return(result);
}
/// <summary>
/// Provera korisnickog imena
/// </summary>
/// <param name="dbContext"></param>
/// <param name="username"></param>
/// <returns></returns>
public bool KorisnikProvera(IDbContext dbContext, string username)
{
bool usernameExist = false;
var isTransaction = true;
try
{
var cmd = new SqlCommand(cLogovanje_Provera)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter prmUsername = cmd.Parameters.Add("@KorisnickoIme", SqlDbType.NVarChar);
prmUsername.Size = 50;
prmUsername.Direction = ParameterDirection.Input;
prmUsername.Value = username;
cmd.Transaction = dbContext.Transaction;
cmd.Connection = dbContext.Connection;
using (IDataReader reader = cmd.ExecuteReader())
{
if (((SqlDataReader)reader).HasRows)
{
usernameExist = true;
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (!isTransaction)
{
dbContext.CloseConnection();
}
}
return(usernameExist);
}
public virtual void CloseConnection()
{
_dbContext.CloseConnection();
}
