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