public ActionResult Edit(int id)
{
var user = new UserD().ViewDetail(id);
SetViewBag();
return(View(user));
}
public IHttpActionResult AddUser([FromBody] UserViewModel newUser)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest("Please provide a valid model"));
}
UserD model = new UserD();
model.FirstName = newUser.FirstName;
model.LastName = newUser.LastName;
model.Dob = newUser.Dob;
model.Designation = newUser.Designation;
context.UserDs.Add(model);
context.SaveChanges();
return(Ok(model));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var dao = new UserD();
var model = dao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public JsonResult ChangeStatus(long id)
{
var result = new UserD().ChangeStatus(id);
return(Json(new
{
status = result
}));
}
public List <UserInformation> GetUserFriendshipOffers(UserD user)
{
var userFriendshipOffers = new List <UserInformation>();
var foundUserFriendshipOffers = _friends.Where(friend => friend.ToUser.UserId == user.UserId && friend.SendDate > user.LastVisit && friend.Status != 3);
foreach (var friendshipOffer in foundUserFriendshipOffers)
{
userFriendshipOffers.Add(UserInf(friendshipOffer.FromUser.UserId));
}
return(userFriendshipOffers.Distinct().ToList());
}
public static UserD open(string email)
{
string connetion_string = null;
string database_name = "MyDatabase.sqlite";
SQLiteConnection connection;
SQLiteCommand command;
connetion_string = $"Data Source={database_name};Version=3;";
connection = new SQLiteConnection(connetion_string);
SQLiteDataReader dataReader;
UserD userD = null;
try
{
connection.Open();
string sql = "select * from UserTable WHERE UserID ='" + email + "'";
command = new SQLiteCommand(sql, connection);
dataReader = command.ExecuteReader();
if (dataReader.Read())
{
Boolean login;
if (dataReader["Login"].Equals("true"))
{
login = true;
}
else
{
login = false;
}
string userName = (string)dataReader.GetValue(0);
string password = (string)dataReader.GetValue(1);
int numOfTasks = (int)((long)dataReader.GetValue(3));
string lastBoard = (string)dataReader.GetValue(4);
userD = new UserD(userName, password, login, numOfTasks, lastBoard);
}
dataReader.Close();
command.Dispose();
Log.Info("Open user: "******"Failed to Open user: " + email);
return(null);
}
finally
{
connection.Close();
}
}
public IHttpActionResult Post(UserD value)
{
try
{
if (value == null)
{
return(NotFound());
}
context.UserDs.Add(value);
context.SaveChanges();
return(Ok(value));
}
catch (Exception ex)
{
throw;
}
}
public List <News> GetUserNews(UserD user)
{
var userNews = new List <News>();
var foundUserNews = _messages.Where(message => message.SendDate > user.LastVisit);
foreach (var currentUserNews in foundUserNews)
{
var newsInf = new News
{
AuthorId = currentUserNews.User.UserId,
AuthorName = UserInf(currentUserNews.User.UserId).Name,
Likes = currentUserNews.Likes,
Text = currentUserNews.Text
};
userNews.Add(newsInf);
}
return(userNews);
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new UserD();
var result = dao.login(model.UserName, Encryptor.MD5Hash(model.Password), true);
if (result == 1)
{
var user = dao.GetById(model.UserName);
var userSession = new UserLogin();
userSession.UserName = user.UserName;
userSession.UserID = user.ID;
userSession.GroupID = user.GroupID;
var listCredentials = dao.GetListCreadential(model.UserName);
Session.Add(Common.CommonConstants.SESSION_CREDENTIALS, listCredentials);
Session.Add(Common.CommonConstants.USER_SESSION, userSession);
return(RedirectToAction("Index", "Home"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại");
}
else if (result == -1)
{
ModelState.AddModelError("", "Tài khoản đang bị khóa");
}
else if (result == -2)
{
ModelState.AddModelError("", "Mật Khẩu không đúng");
}
else if (result == -3)
{
ModelState.AddModelError("", "Tài khoản của bạn không có quyền đăng nhập");
}
else
{
ModelState.AddModelError("", "Đăng Nhập Không Đúng");
}
}
return(View("Index"));
}
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
var dao = new UserD();
var encryptedMd5Pas = Encryptor.MD5Hash(user.Password);
user.Password = encryptedMd5Pas;
long id = dao.Insert(user);
if (id > 0)
{
SetAlert("Thêm user thành công", "success");
return(RedirectToAction("Index", "User"));
}
else
{
ModelState.AddModelError("", "Thêm User không thành công");
}
}
return(View("Index"));
}
public UserD GetUserInformation(string userName)
{
var userInformation = new UserD();
var foundUser = _users.Where(user => user.Name == userName);
try
{
userInformation.Name = foundUser.Single().Name;
userInformation.UserId = foundUser.Single().UserId;
userInformation.DateOfBirth = foundUser.Single().DateOfBirth;
userInformation.Gender = foundUser.Single().Gender;
userInformation.LastVisit = foundUser.Single().LastVisit;
userInformation.Online = foundUser.Single().Online;
}
catch (InvalidOperationException)
{
Console.WriteLine("Такого имени пользователя нет в БД или таких имен несколько");
}
return(userInformation);
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
var dao = new UserD();
if (dao.CheckUserName(model.UserName))
{
ModelState.AddModelError("", "Tên đăng nhập đã tồn tại");
}
else if (dao.CheckEmail(model.Email))
{
ModelState.AddModelError("", "Email đã tồn tại");
}
else
{
var user = new User();
user.Name = model.Name;
user.UserName = model.UserName;
user.Password = Encryptor.MD5Hash(model.Password);
user.Phone = model.Phone;
user.Email = model.Email;
user.Address = model.Address;
user.CreatedDate = DateTime.Now;
user.Status = true;
var result = dao.Insert(user);
if (result > 0)
{
ViewBag.Success = "Đăng ký thành công";
model = new RegisterModel();
}
else
{
ModelState.AddModelError("", "Đăng ký không thành công");
}
}
}
return(View(model));
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
var dao = new UserD();
if (!string.IsNullOrEmpty(user.Password))
{
var encryptedMd5Pas = Encryptor.MD5Hash(user.Password);
user.Password = encryptedMd5Pas;
}
var result = dao.Update(user);
if (result)
{
SetAlert("Sửa user thành công", "success");
return(RedirectToAction("Index", "User"));
}
else
{
ModelState.AddModelError("", "Cập Nhật User không thành công");
}
}
return(View("Index"));
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
var dao = new UserD();
var result = dao.login(model.UserName, Encryptor.MD5Hash(model.Password));
if (result == 1)
{
var user = dao.GetById(model.UserName);
var userSession = new UserLogin();
userSession.UserName = user.UserName;
userSession.UserID = user.ID;
userSession.GroupID = user.GroupID;
Session.Add(Common.CommonConstants.USER_SESSION, userSession);
return(Redirect("/"));
}
else if (result == 0)
{
ModelState.AddModelError("", "Tài khoản không tồn tại.");
}
else if (result == -1)
{
ModelState.AddModelError("", "Tài khoản đang bị khoá.");
}
else if (result == -2)
{
ModelState.AddModelError("", "Mật khẩu không đúng.");
}
else
{
ModelState.AddModelError("", "đăng nhập không đúng.");
}
}
return(View(model));
}
static void Main(string[] args)
{
#region LoadChannel
_channel = ChannelD.GetChannel();
_channelId = _channel._id;
#endregion
#region LoadStream
_stream = StreamD.GetStreamByUser(_channelId);
if (_stream.stream == null)
{
_streamUptime = new DateTime();
}
else
{
_streamUptime = _stream.stream.created_at.ToLocalTime();
}
#endregion
_irc = new IrcClient("irc.twitch.tv", 6667, ChatBot.botName, _password, _channel.name);
TwitchApi api = new TwitchApi();
TmiApi tmi = new TmiApi();
ViewerList chatters = new ViewerList();
AppDomain.CurrentDomain.ProcessExit += new EventHandler(CurrentDomain_ProcessExit);
TwitchSocket twitchSocket = new TwitchSocket();
ChatBot.init();
#region LoadBroadCasterInfo
_broadcaster = UserD.GetUser(_broadcasterName);
#endregion
_moderators.Add("gaelLevel");
_moderators.Add("terror_seeds");
_moderators.Add("nebulea");
_moderators.Add("novaevermoon");
#region LoadCommands
List <CommandO> commands = new List <CommandO>();
commands = CommandD.LoadCommands();
LaunchTimer launchTimer = new LaunchTimer(_irc);
foreach (CommandO command in commands)
{
if (command.type == "timed")
{
launchTimer.createTimer(command);
}
}
if (commands.Count != 0)
{
_commandsText = new StringBuilder();
foreach (CommandO command in commands)
{
if (command.userLevel == "everyone" && command.timer == 0)
{
_commandsText.Append("!" + command.keyword + ", ");
}
}
_commandsText.Length = _commandsText.Length - 2;
}
#endregion
//chatters = tmi.getViewerList(_channel);
//_viewers = tmi.getViewers(chatters);
twitchSocket.ClientWebSocket = twitchSocket.WebSocketConnectAsync().Result;
var testSocket = twitchSocket.WhisperSubscribeAsync(twitchSocket.ClientWebSocket, _broadcaster.users[0]._id);
//ClientWebSocket webSocket = twitchSocket.WebSocketConnectAsync().Result;
//var testWebSocket = twitchSocket.WhisperSubscribeAsync(twitchSocket.whisperWebSocket,_broadcaster.users[0]._id).Result;
PingSender ping = new PingSender(_irc);
ping.Start();
while (true)
{
string fullMessage = _irc.ReadMessage();
CommandO foundCommand = new CommandO();
if (fullMessage.Contains("PRIVMSG"))
{
_username = UserD.GetUsername(fullMessage);
string message = ChatBot.GetMessage(fullMessage);
_user = UserD.GetUser(_username);
UserD.InsertUser(_user);
bool isSubscriber = SubscriberD.IsSubscriber(_user.users[0]._id, _broadcaster.users[0]._id);
if (isSubscriber == false && _user.isPermit == false)
{
bool link = ChatBot.checkLink(message);
if (link == true)
{
_irc.WriteChatMessage(".timeout " + _username + " 15");
_irc.WriteChatMessage("Posting links is not allowed here for non-subs, if you think this link might interest me, just whisper me or one of my mods ♡");
}
}
char firstCharacter = message[0];
try
{
if (firstCharacter == '!')
{
string commandMessage = message.Substring(message.IndexOf('!') + 1);
bool kappamonCommand = CommandD.IsKappamonCommand(commandMessage);
if (!kappamonCommand)
{
if (commandMessage.Contains(" "))
{
_command = commandMessage.Split(' ');
if (_command.Length == 2)
{
commandMessage = _command[0];
_chatterUsername = _command[1];
}
}
else
{
_command[0] = commandMessage;
}
if (commands.Any(c => c.keyword == commandMessage))
{
foundCommand = commands.Single(c => c.keyword == commandMessage);
if (foundCommand.parameters != 0)
{
Type testType = typeof(Program);
Dictionary <string, dynamic> newDic = new Dictionary <string, dynamic>();
foreach (KeyValuePair <string, dynamic> dic in foundCommand.parameterList)
{
var fieldInfo = testType.GetField(dic.Key.ToString(), BindingFlags.Static | BindingFlags.Public).GetValue(testType);
newDic.Add(dic.Key.ToString(), fieldInfo.ToString());
}
foundCommand.parameterList = newDic;
}
if (foundCommand.userLevel == "moderator" && !_moderators.Contains(_username))
{
_irc.WriteChatMessage("You are not allowed to use this command !");
}
else
{
DateTime date = DateTime.Now;
if (foundCommand.startedTime.AddMilliseconds(foundCommand.cooldown) < DateTime.Now)
{
foundCommand.startedTime = DateTime.Now;
if (foundCommand.keyword == "commands")
{
foundCommand.message += _commandsText;
}
switch (foundCommand.type)
{
case "request":
string query = foundCommand.request;
using (MySqlConnection mySqlConnection = new MySqlConnection("" /*connectionString*/))
{
if (foundCommand.condition != "")
{
switch (foundCommand.condition)
{
case "userName":
foundCommand.request = string.Format(foundCommand.request, _username);
foundCommand.message = string.Format(foundCommand.message, _username);
break;
}
}
if (foundCommand.request.Contains("SELECT"))
{
Tuple <int, string> test = CommandD.ExecuteSelectCommand(foundCommand.request);
if (foundCommand.message.Contains("@"))
{
_irc.WriteChatMessage(foundCommand.message.Replace("@", test.Item1.ToString()));
}
else
{
_irc.WriteChatMessage(test.Item2);
}
}
else if (foundCommand.request.Contains("UPDATE"))
{
Tuple <int, string> result = CommandD.ExecuteUpdateCommand(foundCommand.request, foundCommand.message);
mySqlConnection.Close();
if (result.Item1 < 0)
{
}
else
{
_irc.WriteChatMessage(result.Item2);
}
}
}
break;
case "regular":
if (foundCommand.message.Contains("{"))
{
_irc.WriteChatMessage(string.Format(foundCommand.message, _username));
}
else
{
_irc.WriteChatMessage(foundCommand.message);
}
break;
case "api":
MethodInfo mInfo;
Type type = Assembly.Load("MoonBot_Data").GetType(foundCommand.assembly, false, true);
mInfo = type.GetMethod(foundCommand.message);
object[] parameters;
if (foundCommand.parameters == 0)
{
parameters = new object[] {};
}
else
{
//Type testType = typeof(Program);
parameters = new object[] { foundCommand.parameterList };
}
object apiAnswer = mInfo.Invoke(null, parameters);
_irc.WriteChatMessage(apiAnswer.ToString());
break;
case "moonlights":
_irc.WriteChatMessage("Switching color to : " + foundCommand.keyword);
_port.Open();
_port.Write(foundCommand.message);
_port.Close();
break;
}
}
else
{
TimeSpan span = date - foundCommand.startedTime;
int ms = (int)span.TotalMilliseconds;
if (ms <= foundCommand.cooldown)
{
_irc.WriteChatMessage("This command is in cooldown right now, be patient !");
}
else
{
_irc.WriteChatMessage(foundCommand.message);
foundCommand.startedTime = DateTime.Now;
}
}
}
}
else
{
_irc.WriteChatMessage("This command does not exist, type !commands to know what commands are available");
}
}
}
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder(DateTime.Now.ToString("dd-MM-yyyy") + " : " + ex.Message);
Console.WriteLine(sb);
}
}
}
}