C# Class HicsBL.itin18_aktEntities

Inheritance: DbContext
Mostra file Open project: in18/hics Class Usage Examples

Public Methods

Method 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

Protected Methods

Method Description
OnModelCreating ( DbModelBuilder modelBuilder ) : void

Private Methods

Method 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 method

protected OnModelCreating ( DbModelBuilder modelBuilder ) : void
modelBuilder DbModelBuilder
return void

itin18_aktEntities() public method

public itin18_aktEntities ( ) : System
return System

sp_add_lamp() public method

public sp_add_lamp ( string username, byte password, string address, string name ) : int
username string
password byte
address string
name string
return int

sp_add_lamp_to_lampgroup() public method

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
return int

sp_add_lampgroup() public method

public sp_add_lampgroup ( string name, byte password, string group_name ) : int
name string
password byte
group_name string
return int

sp_add_user() public method

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
return int

sp_add_user_to_usergroup() public method

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
return int

sp_add_usergroup() public method

public sp_add_usergroup ( string username, byte password, string gourpname ) : int
username string
password byte
gourpname string
return int

sp_change_password() public method

public sp_change_password ( string name, byte oldpassword, byte newpassword ) : int
name string
oldpassword byte
newpassword byte
return int

sp_change_password_by_admin() public method

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
return int

sp_delete_lamp() public method

public sp_delete_lamp ( Nullable lamp_id, string username, byte password ) : int
lamp_id Nullable
username string
password byte
return int

sp_delete_lamp_from_roomgroup() public method

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
return int

sp_delete_roomgroup() public method

public sp_delete_roomgroup ( string username, byte password, Nullable roomgroup_id ) : int
username string
password byte
roomgroup_id Nullable
return int

sp_delete_user() public method

public sp_delete_user ( string username, byte password, Nullable del_id ) : int
username string
password byte
del_id Nullable
return int

sp_delete_user_from_usergroup() public method

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
return int

sp_delete_usergroup() public method

public sp_delete_usergroup ( string username, byte password, Nullable del_id ) : int
username string
password byte
del_id Nullable
return int

sp_lamp_dimm() public method

public sp_lamp_dimm ( string username, byte password, Nullable lamp_id, Nullable bright ) : int
username string
password byte
lamp_id Nullable
bright Nullable
return int

sp_lamp_off() public method

public sp_lamp_off ( string username, byte password, Nullable lamp_id ) : int
username string
password byte
lamp_id Nullable
return int

sp_lamp_on() public method

public sp_lamp_on ( string username, byte password, Nullable lamp_id ) : int
username string
password byte
lamp_id Nullable
return int

sp_set_lamp_stat() public method

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
return int