public bool find_user(string email, string pass)
{
using (english_projectEntities db = new english_projectEntities())
{
bool user_found = db.users.Any(us => us.email == email && us.pass == pass);
return(user_found);
}
}
public string get_next_question(int users_id, int?technos_id)
{
using (english_projectEntities db = new english_projectEntities())
{
if (technos_id == null)
{
technos_id = db.get_random_techno(users_id).FirstOrDefault();
}
var question = db.get_next_question(users_id, technos_id);
return(Newtonsoft.Json.JsonConvert.SerializeObject(question));
}
}
//[System.Web.Http.Route("api/users")]
//[System.Web.Http.HttpGet]
public string Get()
{
IQueryable <users> usuarios;
List <string> lista = new List <String>();
using (english_projectEntities db = new english_projectEntities())
{
usuarios = db.users;
foreach (var item in usuarios)
{
lista.Add($"Usuario: {item.username}, email: {item.email}");
}
}
return(lista[0]);
}
public bool delete_techno(int id)
{
using (english_projectEntities db = new english_projectEntities())
{
technos t = db.technos.Find(id);
try
{
db.technos.Remove(t);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool delete_word(int id)
{
using (english_projectEntities db = new english_projectEntities())
{
words w = db.words.Find(id);
try
{
db.words.Remove(w);
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool add_techno(string techno_name, bool techno_status, int users_id)
{
using (english_projectEntities db = new english_projectEntities())
{
technos x = db.technos.Add(new technos {
techno_name = techno_name, techno_status = techno_status, users_id = users_id
});
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool add_word(int users_id, int technos_id, string word, string translation)
{
using (english_projectEntities db = new english_projectEntities())
{
db.words.Add(new words {
users_id = users_id, technos_id = technos_id, word = word, translation = translation
});
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool add_test(int users_id, int correct, int total)
{
using (english_projectEntities db = new english_projectEntities())
{
tests x = db.tests.Add(new tests {
users_id = users_id, correct = correct, total = total, created_datetime = DateTime.Now
});
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool add_user(string username, string email, string pass)
{
using (english_projectEntities db = new english_projectEntities())
{
users x = db.users.Add(new users {
username = username, email = email, pass = pass
});
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool update_techno(int id, string techno_name, bool techno_status, int users_id)
{
using (english_projectEntities db = new english_projectEntities())
{
technos t = db.technos.Find(id);
t.techno_name = techno_name;
t.techno_status = techno_status;
t.users_id = users_id;
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public bool update_word(int id, int technos_id, string word, string translation)
{
using (english_projectEntities db = new english_projectEntities())
{
words w = db.words.Find(id);
w.technos_id = technos_id;
w.word = word;
w.translation = translation;
try
{
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
}
public string get_tests(int users_id)
{
using (english_projectEntities db = new english_projectEntities())
{
List <string> user_tests = new List <string>();
user_tests = (from ts in db.tests
where ts.users_id == users_id
orderby ts.id
select new testModel
{
id = ts.id,
users_id = ts.users_id,
correct = ts.correct,
total = ts.total,
created_datetime = ts.created_datetime
}).ToList <testModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
return(Newtonsoft.Json.JsonConvert.SerializeObject(user_tests));
}
}
public string get_words(int users_id, bool sort_by_word)
{
using (english_projectEntities db = new english_projectEntities())
{
List <string> ws = new List <string>();
if (sort_by_word)
{
ws = (from w in db.words
where w.users_id == users_id
orderby w.word
select new wordModel {
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else
{
ws = (from w in db.words
where w.users_id == users_id
orderby w.id
select new wordModel
{
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(ws));
}
}
public string get_technos(int users_id, bool sort_by_name)
{
using (english_projectEntities db = new english_projectEntities())
{
List <string> ts = new List <string>();
if (sort_by_name)
{
ts = (from t in db.technos
where t.users_id == users_id
orderby t.techno_name
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else
{
ts = (from t in db.technos
where t.users_id == users_id
orderby t.id
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(ts));
}
}
public string search_technos(string techno_name, bool?techno_status, int users_id, int search)
{
using (english_projectEntities db = new english_projectEntities())
{
List <string> ts = new List <string>();
if (search == 0)
{
ts = (from t in db.technos
where t.users_id == users_id &&
(techno_name == null || t.techno_name == techno_name) &&
(techno_status == null || t.techno_status == techno_status)
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 1)
{
ts = (from t in db.technos
where t.users_id == users_id &&
(techno_name == null || t.techno_name.Contains(techno_name)) &&
(techno_status == null || t.techno_status == techno_status)
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 2)
{
ts = (from t in db.technos
where t.users_id == users_id &&
(techno_name == null || t.techno_name.StartsWith(techno_name)) &&
(techno_status == null || t.techno_status == techno_status)
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 3)
{
ts = (from t in db.technos
where t.users_id == users_id &&
(techno_name == null || t.techno_name.EndsWith(techno_name)) &&
(techno_status == null || t.techno_status == techno_status)
select new technoModel
{
id = t.id,
users_id = t.users_id,
techno_name = t.techno_name,
techno_status = t.techno_status
}).ToList <technoModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(ts));
}
}
public string search_words(int?users_id, int?technos_id, string word, string translation, int search)
{
using (english_projectEntities db = new english_projectEntities())
{
List <string> ws = new List <string>();
if (search == 0)
{
ws = (from w in db.words
where w.users_id == users_id &&
(technos_id == null || w.technos_id == technos_id) &&
(word == null || w.word == word) &&
(translation == null || w.translation == translation)
select new wordModel
{
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 1)
{
ws = (from w in db.words
where w.users_id == users_id &&
(technos_id == null || w.technos_id == technos_id) &&
(word == null || w.word.Contains(word)) &&
(translation == null || w.translation.Contains(translation))
select new wordModel
{
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 2)
{
ws = (from w in db.words
where w.users_id == users_id &&
(technos_id == null || w.technos_id == technos_id) &&
(word == null || w.word.StartsWith(word)) &&
(translation == null || w.translation.StartsWith(translation))
select new wordModel
{
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
else if (search == 3)
{
ws = (from w in db.words
where w.users_id == users_id &&
(technos_id == null || w.technos_id == technos_id) &&
(word == null || w.word.EndsWith(word)) &&
(translation == null || w.translation.EndsWith(translation))
select new wordModel
{
id = w.id,
users_id = w.users_id,
technos_id = w.technos_id,
word = w.word,
translation = w.translation
}).ToList <wordModel>().
Select(i => Newtonsoft.Json.JsonConvert.SerializeObject(i)).
ToList <string>();
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(ws));
}
}
