public bool CreateUserProfile(UserProfileDAO s) { UserProfile userProfile = new UserProfile { UserId = s.UserId, UserName = s.UserName }; using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { db.UserProfiles.InsertOnSubmit(userProfile); try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public IList<UserProfileDAO> GetUserProfiles() { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { IList<UserProfile> userProfiles = (from userProfile in db.UserProfiles select userProfile).OrderBy(o => o.UserId).ToList(); List<UserProfileDAO> result = new List<UserProfileDAO>(); foreach (var userProfile in userProfiles) { UserProfileDAO temp = new UserProfileDAO { ID = userProfile.UserId, UserId = userProfile.UserId, UserName = userProfile.UserName }; result.Add(temp); } return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }
public bool UpdateUserProfile(UserProfileDAO newUserProfile) { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { UserProfile userProfile = db.UserProfiles.Single(s => s.UserId == newUserProfile.UserId); userProfile.UserId = newUserProfile.UserId; userProfile.UserName = newUserProfile.UserName; try { db.SubmitChanges(); } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } } return true; }
public UserProfileDAO GetUserProfileByID(int id) { try { using (AESDatabaseDataContext db = new AESDatabaseDataContext()) { UserProfile userProfile = (from uspro in db.UserProfiles where uspro.UserId == id select uspro).FirstOrDefault(); UserProfileDAO result = new UserProfileDAO { ID = userProfile.UserId, UserId = userProfile.UserId, UserName = userProfile.UserName }; return (result != null ? result : null); } } catch (Exception e) { throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message)); } }