public static UserChatRoomRights GetUserRightTemplate(int UserId) { DataTable dt = DBHelper.GetDataTable(" select * from user_rights_template where user_id = " + UserId.ToString(), Util.ConnectionString); UserChatRoomRights userChatRoomRightsTemplate = new UserChatRoomRights(); if (dt.Rows.Count > 0) { userChatRoomRightsTemplate._fieldsTemplate = dt.Rows[0]; } return userChatRoomRightsTemplate; }
public static UserChatRoomRights GetUserChatRights(int UserId, int ChatRoomId) { DataTable dt = DBHelper.GetDataTable(" select * from user_chat_room_rights where user_id = " + UserId.ToString() + " and chat_room_id = " + ChatRoomId.ToString(), Util.ConnectionString); UserChatRoomRights userChatRoomRights = new UserChatRoomRights(); if (dt.Rows.Count > 0) { userChatRoomRights._fieldsChatRoom = dt.Rows[0]; } return userChatRoomRights; }