public int CheckSubscribe(string profile, string sub) { string[] arrParm = { "@profile", "@sub", "@isSub" }; string[] arrParmData = { profile, sub }; string[] arrParmOut = MySqlClass.MySQLInOut("CheckToSubscribe", arrParm, arrParmData); return(Int32.Parse(arrParmOut[0])); }
/// <summary> /// Проверяет логин\email на уникальность /// </summary> /// <param name="client">Сокет клиента</param> /// <param name="login">Логин</param> /// <param name="email">Почта</param> /// <param name="idOperation">Номер операции которая выполнется в клиенте</param> public static void CheckUnique(Socket client, string login, string email, int idOperation = 2) { string[] arrParm = { "@loginIn", "@emailIn", "@loginOutBool" }; string[] arrParmData = { login, email }; string[] arrParmOut = MySqlClass.MySQLInOut("CheckUnique", arrParm, arrParmData); ServerClass.SendMsgClient(client, 64, idOperation, Int32.Parse(arrParmOut[0])); }
/// <summary> /// Добавление свойства проекта в базу /// </summary> /// <param name="client">Сокет клиента</param> /// <param name="login">Логин пользователя</param> /// <param name="nameProject">Имя проекта</param> public static void AddNewProject(Socket client, string login, string nameProject) { string[] arrParm = { "@nameUserIn", "@nameProjectIn", "@datePublication", "@idProjectOut" }; string[] arrParmData = { login, nameProject, DateTime.Now.ToString("yyyy-MM-dd") }; string[] arrParmOut = MySqlClass.MySQLInOut("AddProject", arrParm, arrParmData); ServerClass.SendMsgClient(client, 64, 1006, arrParmOut[0]); }
/// <summary> /// Получение всей информации о проекте из базы /// </summary> /// <param name="client">Клиент</param> /// <param name="loginUser">Логин</param> /// <param name="nameProject">Имя проекта</param> public static void GetFullInfoForProject(Socket client, string loginUser, string nameProject) { string[] arrParm = { "@loginUserIn", "@nameProjectIn", "@datePub", "@rating", "@countVote", "@note", "@image", "@viewApp" }; string[] arrParmData = { loginUser, nameProject }; string[] arrParmOut = MySqlClass.MySQLInOut("GetInfoProject", arrParm, arrParmData); ServerClass.SendMsgClient(client, 512, 8, nameProject, arrParmOut[0], arrParmOut[1], arrParmOut[2], arrParmOut[3], arrParmOut[4], arrParmOut[5]); }
/// <summary> /// Получаем всю информацию о пользователе из базы /// </summary> /// <param name="client">Сокет клиента</param> /// <param name="login">Логин</param> /// <param name="isThisUser"></param> public static void CheckFullInfoOfPerson(Socket client, string login, bool isThisUser) { string[] arrParm = { "@loginUser", "@nameOut", "@lastnameOut", "@levelOut", "@likeOut", "@imageOut", "@emailOut", "@countProjectOut", "@noteOut", "@countSubOut" }; string[] arrParmData = { login }; string[] arrParmOut = MySqlClass.MySQLInOut("CheckFullInfoPerson", arrParm, arrParmData); ServerClass.SendMsgClient(client, 1024, 3, isThisUser, arrParmOut[0], arrParmOut[1], Int32.Parse(arrParmOut[2]), Int32.Parse(arrParmOut[3]), arrParmOut[4], arrParmOut[5], arrParmOut[6], arrParmOut[7], arrParmOut[8]); }
internal static List <FileSett> listFileSend = new List <FileSett>(); // Список файлов который в данный момент скачиваются из сервера #region База - Сервер /// <summary> /// Читает данные о пользователе и отправляет ответ клиенту /// </summary> /// <param name="client">Сокет клиента</param> /// <param name="login">Логин</param> /// <param name="password">Пароль</param> public static void CheckLoginAndPasswordUser(Socket client, string login, string password) { string[] arrParm = { "@loginIn", "@passIn", "@loginOut" }; string[] arrParmData = { login, password }; string[] arrParmOut = MySqlClass.MySQLInOut("CheckLoginAndPassUser", arrParm, arrParmData); Connect(ServerClass.nextID++, login, client); ServerClass.SendMsgClient(client, 64, 1, Int32.Parse(arrParmOut[0])); }
/// <summary> /// Изменяет данные у проекта в базе /// </summary> /// <param name="client">Клиент</param> /// <param name="id">id проекта</param> /// <param name="name">Имя</param> /// <param name="viewApp">Категория</param> /// <param name="note">Описание</param> /// <param name="hrefImage">Ссылка на изображение</param> public static void UpdateInfoForProject(Socket client, int id, string name, int viewApp, string note, string hrefImage) { string[] arrParm = { "@idProj", "@nameProj", "@viewApp", "@note", "@hrefImage", "@isRenameProj", "@oldNameProj" }; string[] arrParmData = { id.ToString(), name, viewApp.ToString(), note, hrefImage }; string[] arrParmOut = MySqlClass.MySQLInOut("UpdateInfoForProject", arrParm, arrParmData); if (arrParmOut[0].Equals("1")) { ServerClass.SendMsgClient(client, 512, 1007, name); string nameUser = ServerClass.clients.FirstOrDefault(f => f.socket == client).name; File.Move(ServerClass.pathProjectFile + "\\" + nameUser + "\\" + arrParmOut[1], ServerClass.pathProjectFile + "\\" + nameUser + "\\" + name); } }
/// <summary> /// Проверяем изменение в количестве лайков у пользователя /// </summary> /// <param name="client">Сокет клиента</param> /// <param name="login">Логин</param> public static void CheckNewLike(Socket client, string login) { string[] arrParm = { "@loginUser", "@likeOut" }; string[] arrParmData = { login }; string[] arrParmOut = MySqlClass.MySQLInOut("CheckNewLike", arrParm, arrParmData); //foreach (var clientU in ServerClass.clients) //{ // if (clientU.socket == client) // { // if(clientU.countLike != Int32.Parse(arrParmOut[0])) // { // clientU.countLike = Int32.Parse(arrParmOut[0]); // ServerClass.SendMsgClient(client, 64, 5, arrParmOut[0]); // } // } //} }