/// <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);
}
