protected override void DataOperation() { using (var db = new UniSpyContext()) { var result = from p in db.Pstorages where p.ProfileId == _request.ProfileId && p.Dindex == _request.DataIndex && p.Ptype == (int)_request.StorageType select p; Pstorage ps; if (result.Count() == 0) { //insert a new record in database ps = new Pstorage(); ps.Dindex = _request.DataIndex; ps.ProfileId = _request.ProfileId; ps.Ptype = (int)_request.StorageType; ps.Data = _request.KeyValues; db.Pstorages.Add(ps); } else if (result.Count() == 1) { //update an existed record in database ps = result.First(); ps.Data = _request.KeyValues; } db.SaveChanges(); } }
protected override void DataOperation() { try { using (var db = new UniSpyContext()) { db.Subprofiles.FirstOrDefault(s => s.SubProfileId == _client.Info.SubProfileInfo.SubProfileId).Uniquenick = _request.UniqueNick; db.SaveChanges(); } } catch (Exception e) { throw new GPDatabaseException(e.Message); } }
protected override void DataOperation() { using (var db = new UniSpyContext()) { var result = db.Subprofiles.Where(s => s.ProfileId == _client.Info.ProfileInfo.ProfileId && s.NamespaceId == _client.Info.SubProfileInfo.NamespaceId); //&& s.Productid == _client.Info.ProductID); if (result.Count() == 0 || result.Count() > 1) { throw new GPDatabaseException("No user infomation found in database."); } db.Subprofiles.FirstOrDefault(s => s.SubProfileId == _client.Info.SubProfileInfo.SubProfileId).Cdkeyenc = _request.CDKeyEnc; db.SaveChanges(); } }