public static User getUserByUserName(string name) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = from x in db.Users where x.Username == name select new User(x); return query.FirstOrDefault(); } }
public static User getUserById(int id) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = from x in db.Users where x.ID == id select new User(x); return query.FirstOrDefault(); } }
public static List<SContact> getSContactsByUser(User user) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var results = from x in db.JagatudContacts where x.UserID == user.Id select new SContact(x); return results.ToList(); } }
public static void deleteSharedContactById(int id) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var result = (from x in db.JagatudContacts where x.ID == id select x).FirstOrDefault(); db.JagatudContacts.DeleteOnSubmit(result); db.SubmitChanges(); } }
public static void deleteUserPermanentlyById(int id) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = (from x in db.Users where x.ID == id select x).FirstOrDefault(); db.Users.DeleteOnSubmit(query); db.SubmitChanges(); } }
public static void addSharedContact(SContact scont) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { DBA.Baas.JagatudContact newSharedContact = scont.mapToDbJagatudContact(); db.JagatudContacts.InsertOnSubmit(newSharedContact); db.SubmitChanges(); } }
public static void addUser(User user) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { DBA.Baas.User newUser = user.mapToDbUser(); newUser.Loodud = System.DateTime.Now; db.Users.InsertOnSubmit(newUser); db.SubmitChanges(); } }
public void save() { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = (from x in db.JagatudContacts where x.ID == this._id select x).FirstOrDefault(); if (query == null) { SContactMethods.addSharedContact(this); } } }
public static void deleteUserByid(int id) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = (from x in db.Users where x.ID == id select x).FirstOrDefault(); if (query != null) { query.Kustutatud = DateTime.Now; db.SubmitChanges(); } } }
public static void updateUser(User usr) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = (from x in db.Users where x.ID == usr.Id select x).FirstOrDefault(); if (query != null) { query = usr.mapToDbUser(); query.Muudetud = DateTime.Now; db.SubmitChanges(); } } }
public static string getRoleById(int id) { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = from x in db.Roles where x.ID == id select x; var role = query.FirstOrDefault(); if (role != null) { return role.Nimetus; } else return null; } }
public void save() { using (DBA.Baas.ProductionDataContext db = new DBA.Baas.ProductionDataContext()) { var query = ContactMethods.getContactById(this._id); if (query == null) { ContactMethods.addContact(this); } else ContactMethods.updateContact(this); } }