public void TrainessEdit(int Class, string Family_name, string First_name, string Middle_name)
{
BDConnection.Select("UPDATE `trainesses` SET `class` = '" + Class + "'," +
" `family_name` = '" + Family_name + "', `first_name` = '" + First_name + "', `middle_name` = '" + Middle_name + "' WHERE (`idTrainess` = '" + idTrainess + "');");
this.Class = Class;
this.Family_name = Family_name;
this.First_name = First_name;
this.Middle_name = Middle_name;
}
public static List <DataUser> Select()
{
List <DataUser> listUser = new List <DataUser>();
DataTable data = BDConnection.Select("SELECT * FROM biblioteka.users;");
foreach (DataRow row in data.Rows)
{
listUser.Add(new DataUser(row));
}
return(listUser);
}
public static List <DataTrainess> Select(string Search)
{
List <DataTrainess> listTrainess = new List <DataTrainess>();
DataTable data = BDConnection.Select("SELECT * FROM trainesses WHERE Family_name LIKE '%" + Search + "%';");
foreach (DataRow row in data.Rows)
{
listTrainess.Add(new DataTrainess(row));
}
return(listTrainess);
}
public static List <DataIssuance> Select()
{
List <DataIssuance> listIssuance = new List <DataIssuance>();
DataTable data = BDConnection.Select("SELECT * FROM ISP333_VaskovaAN_biblioteka.issuance Inner join trainess left issuance.trainess = trainess.idTrainess where trainess = trainess.idTrainess;"); //?????????
foreach (DataRow row in data.Rows)
{
listIssuance.Add(new DataIssuance(row));
}
return(listIssuance);
}
public static bool Login(string login, string password, out DataUser listUser)
{
DataTable data = BDConnection.Select("SELECT * FROM users WHERE login = '******' and password = '******';");
listUser = null;
if (data.Rows.Count > 0)
{
listUser = new DataUser(data.Rows[0]);
return(true);
}
return(false);
}
public static void TrainessAdd(int Class, string Family_name, string First_name, string Middle_name)
{
BDConnection.Select("INSERT INTO trainesses (`class`, `family_name`, `first_name`, `middle_name`) " +
"VALUES ('" + Class + "', '" + Family_name + "', '" + First_name + "', '" + Middle_name + "');");
}
public void Delete()
{
BDConnection.Select("DELETE FROM trainesses WHERE(`idTrainess` = '" + idTrainess + "')");
}