public Hashtable CreateSession(Object username) { using (XinJishu.Data.SQLServer.DataAccess conn = new Data.SQLServer.DataAccess(connectionStringName)) { using (var cmd = conn.GetCommand()) { List<RoleModel> roles = new List<RoleModel>(); cmd.CommandText = "[xju].[Session_Create]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@username", username); return conn.ExecuteHash(cmd).FirstOrDefault(); } } }
public IList<Hashtable> ListRolesForUser(Object userId) { using (XinJishu.Data.SQLServer.DataAccess conn = new Data.SQLServer.DataAccess(connectionStringName)) { using (var cmd = conn.GetCommand()) { List<RoleModel> roles = new List<RoleModel>(); cmd.CommandText = "[xju].[Roles_ListForUserId]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@userId", userId); return conn.ExecuteHash(cmd); } } }
public IList<Hashtable> ListSessions() { using (XinJishu.Data.SQLServer.DataAccess conn = new Data.SQLServer.DataAccess(connectionStringName)) { using (var cmd = conn.GetCommand()) { List<RoleModel> roles = new List<RoleModel>(); cmd.CommandText = "[xju].[Session_List]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; return conn.ExecuteHash(cmd); } } }
public Hashtable GetUserByEmail(String email) { using (XinJishu.Data.SQLServer.DataAccess conn = new Data.SQLServer.DataAccess(connectionStringName)) { using (var cmd = conn.GetCommand()) { List<RoleModel> roles = new List<RoleModel>(); cmd.CommandText = "[xju].[User_GetByEmail]"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@email", email); return conn.ExecuteHash(cmd).FirstOrDefault(); } } }