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