C# Class HicsBL.itin18_aktEntities

Inheritance: DbContext
Afficher le fichier Open project: in18/hics Class Usage Examples

Méthodes publiques

Méthode Description
itin18_aktEntities ( ) : System
sp_add_lamp ( string username, byte password, string address, string name ) : int
sp_add_lamp_to_lampgroup ( string username, byte password, Nullable roomgroup_id, Nullable lamp_id ) : int
sp_add_lampgroup ( string name, byte password, string group_name ) : int
sp_add_user ( string username, byte password, string new_username, byte new_password ) : int
sp_add_user_to_usergroup ( string username, byte password, Nullable user_id, Nullable usergroup_id ) : int
sp_add_usergroup ( string username, byte password, string gourpname ) : int
sp_change_password ( string name, byte oldpassword, byte newpassword ) : int
sp_change_password_by_admin ( string username, byte password, Nullable change_id, byte newpassword ) : int
sp_delete_lamp ( Nullable lamp_id, string username, byte password ) : int
sp_delete_lamp_from_roomgroup ( string username, byte password, Nullable roomgroup_id, Nullable lamp_id ) : int
sp_delete_roomgroup ( string username, byte password, Nullable roomgroup_id ) : int
sp_delete_user ( string username, byte password, Nullable del_id ) : int
sp_delete_user_from_usergroup ( string username, byte password, Nullable user_id, Nullable usergroup_id ) : int
sp_delete_usergroup ( string username, byte password, Nullable del_id ) : int
sp_lamp_dimm ( string username, byte password, Nullable lamp_id, Nullable bright ) : int
sp_lamp_off ( string username, byte password, Nullable lamp_id ) : int
sp_lamp_on ( string username, byte password, Nullable lamp_id ) : int
sp_set_lamp_stat ( string username, byte password, Nullable lamp_id, Nullable bright, Nullable stat ) : int

Méthodes protégées

Méthode Description
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Private Methods

Méthode Description
fn_check_admin_table ( string username, byte password ) : IQueryable>
fn_check_user_table ( string username, byte password ) : IQueryable>
fn_show_deleted_lamps ( string username, byte password ) : IQueryable
fn_show_deleted_roomgroups ( string username, byte password ) : IQueryable
fn_show_deleted_usergroups ( string username, byte password ) : IQueryable
fn_show_deleted_users ( string username, byte password ) : IQueryable
fn_show_lamp_control ( string username, byte password ) : IQueryable
fn_show_lamp_control_history ( string username, byte password ) : IQueryable
fn_show_lamp_status ( string username, byte password, Nullable lamp_id ) : IQueryable
fn_show_lampgroup_allocate ( string username, byte password ) : IQueryable
fn_show_lampgroup_status ( string username, byte password, Nullable group_id ) : IQueryable
fn_show_lampgroups ( string username, byte password ) : IQueryable
fn_show_lamps ( string username, byte password ) : IQueryable
fn_show_usergroup ( string username, byte password ) : IQueryable
fn_show_usergroups ( string username, byte password ) : IQueryable
fn_show_users ( string username, byte password ) : IQueryable

Method Details

OnModelCreating() protected méthode

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder DbModelBuilder
Résultat void

itin18_aktEntities() public méthode

public itin18_aktEntities ( ) : System
Résultat System

sp_add_lamp() public méthode

public sp_add_lamp ( string username, byte password, string address, string name ) : int
username string
password byte
address string
name string
Résultat int

sp_add_lamp_to_lampgroup() public méthode

public sp_add_lamp_to_lampgroup ( string username, byte password, Nullable roomgroup_id, Nullable lamp_id ) : int
username string
password byte
roomgroup_id Nullable
lamp_id Nullable
Résultat int

sp_add_lampgroup() public méthode

public sp_add_lampgroup ( string name, byte password, string group_name ) : int
name string
password byte
group_name string
Résultat int

sp_add_user() public méthode

public sp_add_user ( string username, byte password, string new_username, byte new_password ) : int
username string
password byte
new_username string
new_password byte
Résultat int

sp_add_user_to_usergroup() public méthode

public sp_add_user_to_usergroup ( string username, byte password, Nullable user_id, Nullable usergroup_id ) : int
username string
password byte
user_id Nullable
usergroup_id Nullable
Résultat int

sp_add_usergroup() public méthode

public sp_add_usergroup ( string username, byte password, string gourpname ) : int
username string
password byte
gourpname string
Résultat int

sp_change_password() public méthode

public sp_change_password ( string name, byte oldpassword, byte newpassword ) : int
name string
oldpassword byte
newpassword byte
Résultat int

sp_change_password_by_admin() public méthode

public sp_change_password_by_admin ( string username, byte password, Nullable change_id, byte newpassword ) : int
username string
password byte
change_id Nullable
newpassword byte
Résultat int

sp_delete_lamp() public méthode

public sp_delete_lamp ( Nullable lamp_id, string username, byte password ) : int
lamp_id Nullable
username string
password byte
Résultat int

sp_delete_lamp_from_roomgroup() public méthode

public sp_delete_lamp_from_roomgroup ( string username, byte password, Nullable roomgroup_id, Nullable lamp_id ) : int
username string
password byte
roomgroup_id Nullable
lamp_id Nullable
Résultat int

sp_delete_roomgroup() public méthode

public sp_delete_roomgroup ( string username, byte password, Nullable roomgroup_id ) : int
username string
password byte
roomgroup_id Nullable
Résultat int

sp_delete_user() public méthode

public sp_delete_user ( string username, byte password, Nullable del_id ) : int
username string
password byte
del_id Nullable
Résultat int

sp_delete_user_from_usergroup() public méthode

public sp_delete_user_from_usergroup ( string username, byte password, Nullable user_id, Nullable usergroup_id ) : int
username string
password byte
user_id Nullable
usergroup_id Nullable
Résultat int

sp_delete_usergroup() public méthode

public sp_delete_usergroup ( string username, byte password, Nullable del_id ) : int
username string
password byte
del_id Nullable
Résultat int

sp_lamp_dimm() public méthode

public sp_lamp_dimm ( string username, byte password, Nullable lamp_id, Nullable bright ) : int
username string
password byte
lamp_id Nullable
bright Nullable
Résultat int

sp_lamp_off() public méthode

public sp_lamp_off ( string username, byte password, Nullable lamp_id ) : int
username string
password byte
lamp_id Nullable
Résultat int

sp_lamp_on() public méthode

public sp_lamp_on ( string username, byte password, Nullable lamp_id ) : int
username string
password byte
lamp_id Nullable
Résultat int

sp_set_lamp_stat() public méthode

public sp_set_lamp_stat ( string username, byte password, Nullable lamp_id, Nullable bright, Nullable stat ) : int
username string
password byte
lamp_id Nullable
bright Nullable
stat Nullable
Résultat int