public int UserAdd(WinEntity.Users.UserEntity UserEntity)
{
index = DB.cmd("INSERT INTO USERS (USERNAME,PASSWORD,EMAIL,AUTHORITYID) VALUES ('" + UserEntity.Username + "','" + UserEntity.Password + "','" + UserEntity.UserEmail + "',0)");
getValue = DB.cmdSingle("select top 1 ID from USERS order by ID desc");
if (index > 0)
{
index = DB.cmd("INSERT INTO AUTHORITY (USER_ID,FILE_OPERATIONS,STATIC_OPERATIONS,GRAPH_OPERATIONS,USER_OPERATIONS,NEW_WINDY_POWER,EMAIL_OPERATIONS,SYSTEM_FILES) VALUES (" + getValue + ",0,0,0,0,0,0,0)");
getValue = DB.cmdSingle("select top 1 ID from AUTHORITY order by ID desc");
index = DB.cmd("UPDATE USERS SET AUTHORITYID=" + getValue + " where EMAIL='" + UserEntity.UserEmail + "'");
}
return(index);
}
public DataRow getAuthority(WinEntity.Users.UserEntity UserEntity)
{
return(DB.getRowTable("select * from AUTHORITY WHERE USER_ID=" + UserEntity.UserID));
}
public int getUserID(WinEntity.Users.UserEntity UserEntity)
{
getValue = DB.cmdSingle("select * from USERS where USERNAME='******' AND PASSWORD='******'");
return(Convert.ToInt16(getValue));
}
public int UserLogin(WinEntity.Users.UserEntity UserEntity)
{
index = DB.UserLogin("select * from USERS where USERNAME='******' AND PASSWORD='******'");
return(index);
}
