/// <summary> /// Действие подписки\отписки /// </summary> /// <param name="profile">имя профиля на который подписываются</param> /// <param name="sub">имя профиля который подписывается</param> /// <param name="isSub">Состояние подписки</param> public void SubscribeUser(string profile, string sub, bool isSub) { if (isSub) { string dateNow = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string[] arrParm = { "@profile", "@sub", "@dateSub" }; string[] arrParmData = { profile, sub, dateNow }; MySqlClass.MySQLIn("SubscribeUsers", arrParm, arrParmData); } else { string[] arrParm = { "@profile", "@sub" }; string[] arrParmData = { profile, sub }; MySqlClass.MySQLIn("DeleteSubscribe", arrParm, arrParmData); } }
/// <summary> /// Добавляет в базу нового пользователя /// </summary> /// <param name="login">Логин</param> /// <param name="password">Пароль</param> /// <param name="email">Пароль</param> public static void CreateNewUser(string login, string password, string email) { string[] arrParm = { "@loginIn", "@passwordIn", "@emailIn" }; string[] arrParmData = { login, password, email }; MySqlClass.MySQLIn("AddUser", arrParm, arrParmData); }
/// <summary> /// Удаление свойств проекта из базы /// </summary> /// <param name="login">Логин пользователя</param> /// <param name="nameProject">Имя проекта</param> public static void DeleteProjectDatabase(string login, string nameProject) { string[] arrParm = { "@nameUserIn", "@nameProjectIn" }; string[] arrParmData = { login, nameProject }; MySqlClass.MySQLIn("DeleteProject", arrParm, arrParmData); }
/// <summary> /// Изменение пароля (через восстановление по почте) /// </summary> /// <param name="email">Почта</param> /// <param name="password">Пароль</param> public static void UpdatePasswordMail(string email, string password) { string[] arrParm = { "@emailIn", "@passwordIn", }; string[] arrParmData = { email, password }; MySqlClass.MySQLIn("UpdatePasswordMail", arrParm, arrParmData); }
/// <summary> /// Изменение информации о пользователе в базе /// </summary> /// <param name="login">Логин</param> /// <param name="infoUser">Информация пользователя</param> public static void UpdateInfoAboutPerson(string login, string[] infoUser) { string[] arrParm = { "@loginIn", "@nameIn", "@lastnameIn", "@imageIn", "@emailIn", "@noteIn" }; string[] arrParmData = { login, infoUser[0], infoUser[1], infoUser[2], infoUser[3], infoUser[4] }; MySqlClass.MySQLIn("UpdateInfoAboutPerson", arrParm, arrParmData); }
/// <summary> /// Добавление информации о пользователе в базу /// </summary> /// <param name="login">Логин</param> /// <param name="infoUser">Информация пользователя</param> public static void AddNewInfoForPerson(string login, string[] infoUser) { string[] arrParm = { "@loginUser", "@nameUser", "@lastName", "@imageUser", "@email" }; string[] arrParmData = { login, infoUser[0], infoUser[1], infoUser[2], infoUser[3] }; MySqlClass.MySQLIn("AddPersonAtDatabase", arrParm, arrParmData); }