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