public string Get(string login_local)
{
OracleDataReader d = SendRequests.send("SELECT data_izmenenia as Dat FROM users_list WHERE login_user ='******'");
d.Read();
if (d.HasRows)
{
return(d["Dat"].ToString());
}
else
{
return((-1).ToString());
}
}
public string Get(string login_local)
{
OracleDataReader d = SendRequests.send("SELECT tes.Poisk_id_po_loginu('" + login_local + "') as ID FROM dual");
d.Read();
if (d.HasRows)
{
return(d.GetInt32(0).ToString());
}
else
{
return((-1).ToString());
}
}
public string Get(string login_local)
{
OracleDataReader d = SendRequests.send("SELECT TO_CHAR(MONTHS_BETWEEN((SELECT CURRENT_DATE FROM DUAL),(select data_izmenenia FROM users_list WHERE login_user = '******'))) as dif1 FROM DUAL");
d.Read();
if (d.HasRows)
{
return(d.GetString(0));
}
else
{
return((-1).ToString());
}
}
public string Get(string id_local)
{
OracleDataReader d = SendRequests.send("SELECT tes.Poisk_password_po_id(" + id_local + ") as Password FROM dual");
d.Read();
if (d.HasRows)
{
return(d.GetString(0));
}
else
{
return((-1).ToString());
}
}
public string Get(string id_pol)
{
OracleDataReader d = SendRequests.send("SELECT data_lists.ID_TABLE " +
"FROM data_lists, users_list, role_user " +
"WHERE data_lists.UROVEN_KRITICHNOSTI <= role_user.UROVEN_PROZRACHNOSTI AND users_list.role = role_user.id_role AND users_list.id_user = " + id_pol);
List <int> dataList = new List <int>();
while (d.Read())
{
dataList.Add(d.GetInt32(0));
}
return(JsonConvert.SerializeObject(dataList));
}
public string Get()
{
OracleDataReader d = SendRequests.send("SELECT * FROM role_user");
List <role> dataList = new List <role>();
while (d.Read())
{
role fl = new role();
fl.id_role = d.GetInt32(0);
fl.name = d.GetString(1);
fl.lvl = d.GetInt32(2);
dataList.Add(fl);
}
return(JsonConvert.SerializeObject(dataList));
}
public string Get()
{
OracleDataReader d = SendRequests.send("SELECT * FROM users_list");
List <users> dataList = new List <users>();
while (d.Read())
{
users fl = new users();
fl.id_user = d.GetInt32(0);
fl.login = d.GetString(1);
fl.password = d.GetString(2);
fl.data = d.GetDateTime(3).ToString();
fl.role = d.GetInt32(4);
dataList.Add(fl);
}
return(JsonConvert.SerializeObject(dataList));
}
public string Get()
{
OracleDataReader d = SendRequests.send("SELECT * FROM films");
List <films> dataList = new List <films>();
while (d.Read())
{
films fl = new films();
fl.id_film = d.GetInt32(0);
fl.avtor = d.GetString(1);
fl.nazvanie = d.GetString(2);
fl.annotacia = d.GetString(3);
fl.strana = d.GetString(4);
fl.god = d.GetInt32(5);
fl.zhanr = d.GetString(6);
dataList.Add(fl);
}
return(JsonConvert.SerializeObject(dataList));
}
