private void btnSupprimerExeplaire_Click(object sender, EventArgs e)
{
if (dgvExemplaires.SelectedRows.Count > 0)
{
if (MessageBox.Show("Confirmez-vous la suppression de cet exemplaire?", "Suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes)
{
MongoDB.Bson.ObjectId id = MongoDB.Bson.ObjectId.Parse(dgvExemplaires.SelectedRows[0].Cells["id"].Value.ToString());
Notice notice = GetNotice();
if (notice.exemplaires == null)
{
notice.exemplaires = new List <Exemplaire>();
}
var ex = notice.exemplaires.Find(a => a._id == id);
notice.exemplaires.Remove(ex);
RemplirExemplaires(notice);
desherbages.Add(new Desherbage()
{
idNotice = notice._id,
auteur = notice.auteur,
codeBarre = ex.codeBarre,
cote = ex.cote,
dt = DateTime.Now,
titre = notice.titre,
});
}
}
}
CartItems GetCartItems()
{
CartItems results = new CartItems();
try {
var userId = Request.Cookies["cart"].Value;
if (string.IsNullOrEmpty(userId))
{
return(results);
}
var cartsCollection = Database.GetCollection <UserCart>("Carts");
var cart = cartsCollection.Find(x => x.UserId == userId).FirstOrDefault();
if (cart == null)
{
return(results);
}
foreach (var itemId in cart.Items)
{
ObjectId obj = new MongoDB.Bson.ObjectId(itemId);
// var results = _collection.Find(x => x.Name != "").ToList();
Thingy thing = _collection.Find(x => x.Id == obj).FirstOrDefault();
if (thing != null)
{
results.Add(thing);
}
}
}
catch { }
results.Items.Sort((x, y) => string.Compare(x.Thing.Name, y.Thing.Name));
return(results);
}
private void dgvExemplaires_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvExemplaires.SelectedRows.Count > 0)
{
Notice notice = GetNotice();
if (notice.exemplaires == null)
{
notice.exemplaires = new List <Exemplaire>();
}
using (var frm = new frmrExemplaire()
{
Text = "Modifier un exemplaire"
})
{
MongoDB.Bson.ObjectId id = MongoDB.Bson.ObjectId.Parse(dgvExemplaires.SelectedRows[0].Cells["id"].Value.ToString());
frm.SetExemplaire(notice.exemplaires.Find(a => a._id == id));
if (frm.ShowDialog() == DialogResult.OK)
{
notice.exemplaires.Remove(notice.exemplaires.Find(a => a._id == id));
notice.exemplaires.Add(frm.GetExemplaire());
RemplirExemplaires(notice);
}
}
}
}
public ActionResult Remove(string id)
{
var things = _collection.Find(x => x.Name != null && x.Name != "").ToList();
ObjectId obj = new MongoDB.Bson.ObjectId(id);
_collection.DeleteOne(x => x.Id == obj);
return(RedirectToAction("index", "manage"));
}
public ActionResult Edit(string id)
{
// var things = _collection.Find(x => x.Name != null && x.Name != "").ToList();
ImagesToAdd.Clear();
ObjectId obj = new MongoDB.Bson.ObjectId(id);
var thing = _collection.Find(x => x.Id == obj).First();
return(View(thing));
}
public virtual void Delete(MongoDB.Bson.ObjectId id)
{
try
{
this.collection.Remove(Query.EQ("_id", id));
}
catch (Exception ex)
{
MongoCoreExtentions.OnError?.BeginInvoke(this.collection?.Database?.Server?.Settings?.ToString(), ex, null, null);
}
}
public void UpsertRecord <T>(string table, MongoDB.Bson.ObjectId Id, T record)
{
var collection = db.GetCollection <T>(table);
var result = collection.ReplaceOne(
new BsonDocument("_id", Id),
record,
new ReplaceOptions {
IsUpsert = true
});
}
public virtual T GetById(MongoDB.Bson.ObjectId id)
{
try
{
return(this.collection.FindOneByIdAs <T>(id));
}
catch (Exception ex)
{
MongoCoreExtentions.OnError?.BeginInvoke(this.collection?.Database?.Server?.Settings?.ToString(), ex, null, null);
}
return(default(T));
}
public ActionResult Item(string id)
{
ObjectId obj = new MongoDB.Bson.ObjectId(id);
// var results = _collection.Find(x => x.Name != "").ToList();
var result = _collection.Find(x => x.Id == obj).FirstOrDefault();
if (result != null)
{
return(View(result));
}
return(RedirectToAction("Index"));
}
public static async Task <T> LookupById <T>(string collectionName, MongoDB.Bson.ObjectId idToLookup) where T : IMongoIdentifiable
{
var collection = LookupCollectionFromDb <T>(collectionName);
var cursor = await collection.FindAsync <T>(x => x._id == idToLookup);
if (cursor == null)
{
return(default(T));
}
T match = cursor.First();
return(match);
}
//[HttpPost]
public ActionResult AddPlace(string id)
{
var user = db.GetUser(User.Identity.Name);
var obj = user.listOfFavouriteObjects;
if (obj == null)
obj = new List<ObjectId>();
MongoDB.Bson.ObjectId newObjectId = new MongoDB.Bson.ObjectId(id);
if (!obj.Contains(newObjectId))
{
obj.Add(new MongoDB.Bson.ObjectId(id));
db.UpdateFavPlaces(User.Identity.Name, obj);
}
return RedirectToAction("UserInfo", new { userEmail = user.email });
}
public ActionResult RemovePlace(string objectId)
{
var user = db.GetUser(User.Identity.Name);
var obj = user.listOfFavouriteObjects;
if (obj == null)
{
return(RedirectToAction("UserInfo", new { userEmail = user.email }));
}
MongoDB.Bson.ObjectId newObjectId = new MongoDB.Bson.ObjectId(objectId);
if (obj.Contains(newObjectId))
{
obj.Remove(new MongoDB.Bson.ObjectId(objectId));
db.UpdateFavPlaces(User.Identity.Name, obj);
}
return(RedirectToAction("UserInfo", new { userEmail = user.email }));
}
public bool LocalDelete(MongoDB.Bson.ObjectId id)
{
try
{
int r;
using (var db = new LiteDatabase(dbName))
{
var collection = db.GetCollection <T>(tableName);
r = collection.Delete(e => e.Id == id);
}
return(r > 0);
}
catch (Exception)
{
Error = "Error de eliminar local";
return(false);
}
}
public bool Delete(MongoDB.Bson.ObjectId id, bool local)
{
try
{
if (local)
{
Resultado = LocalDelete(id);
}
else
{
Resultado = Collection().DeleteOne(e => e.Id == id).DeletedCount == 1;
}
Error = null;
}
catch (Exception)
{
Resultado = false;
Error = "No se pudo eliminar " + typeof(T).Name;
}
return(Resultado);
}
public void SetMovieWatchedStatus(string movieId, bool isSetToWatched)
{
var signedInUser = GetSignedInUser();
if(signedInUser == null)
{
return;
}
var provider = new Provider.MongoDbProvider();
var movieObjId = new MongoDB.Bson.ObjectId(movieId);
if (isSetToWatched)
{
provider.AddSeenMovieToUser(movieObjId, signedInUser.Id);
}
else
{
provider.RemoveSeenMovieFromUser(movieObjId, signedInUser.Id);
}
}
public void EmitStart()
{
var document = new BsonDocument
{
{ "Type", "ACTIVITY" },
{ "ActivityType", _type.ToString() },
{ "StartTime", _startTime },
{ "StartDetails", _startDetails },
};
ActivityMonitor.ActivitiesCollection.InsertOne(document);
_objectId = (ObjectId)document.GetValue("_id");
string msg = string.Format("log4net: START: _activity: {0} ({1})", _type.ToString(), _objectId.ToString());
if (_startDetails != string.Empty)
{
msg += string.Format(", details: {0}", _startDetails);
}
debugger.WriteLine(Debugger.DebugLevel.DebugLogic, msg);
}
public FileResult GetImage(string id)
{
var folder = AppDomain.CurrentDomain.GetData("DataDirectory") + @"\pictures\";
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
var path = Path.Combine(folder, id + ".jpg"); //validate the path for security or use other means to generate the path.
ObjectId objId = new MongoDB.Bson.ObjectId(id);
var thing = DbLayer.GetEntity("Thingies", objId);
if (thing != null)
{
MemoryStream ms = new MemoryStream(thing.Images[0]);
var image = Image.FromStream(ms);
image.Save(path);
}
return(base.File(path, "image/jpeg"));
}
public async Task <OrderModel> GetByIdAsync(MongoDB.Bson.ObjectId id)
{
throw new NotImplementedException();
}
public Clientes(MongoDB.Bson.ObjectId id, string Nome)
{
this.Id = id;
this.Nome = Nome;
}
public static T FindOneByIdAs <T>(string connectionName, string database, string collection, string id)
{
var _id = new MongoDB.Bson.ObjectId(id);
return(FindOne <T>(connectionName, database, collection, new MongoQueryWarpper().EQ("_id", _id), null, null));
}
public async void Save() {
if (Id == null) {
Id = new MongoDB.Bson.ObjectId();
}; //new character
var characterCollection = MongoUtils.MongoData.GetCollection<NPC>("Characters", "NPCCharacters");
await MongoUtils.MongoData.SaveAsync<NPC>(characterCollection, n => n.Id == Id, this); //upsert
//if (npcCharacter == null) {
// //this is the NPC's first save, create everything from scratch
// npcCharacter = new NPC {
// FirstName = this.FirstName,
// LastName = this.LastName,
// _race = this._race,
// _class = this._class,
// _gender = this._gender,
// _skinColor = this._skinColor,
// _skinType = this._skinType,
// _hairColor = this._hairColor,
// _eyeColor = this._eyeColor,
// Weight = this.Weight,
// Height = this.Height,
// _actionState = this._actionState,
// _stanceState = this._stanceState,
// Description = this.Description,
// Location = this.Location,
// AiState = Fsm.state.ToString(),
// PreviousState = Fsm.previousState != null ? Fsm.previousState.ToString() : "",
// GlobalState = Fsm.globalState != null ? Fsm.globalState.ToString() : "",
// NextAiAction = this.NextAiAction.ToUniversalTime(),
// IsNPC = this.IsNPC,
// MobTypeID = this.MobTypeID,
// CurrentTarget = this.CurrentTarget != null ? this.CurrentTarget.ToString() : "",
// LastTarget = this.LastTarget != null ? this.LastTarget.ToString() : "",
// InCombat = this.InCombat,
// LastCombatTime = this.LastCombatTime,
// Experience = this.Experience,
// Level = this.Level,
// KillerID = this.KillerID,
// Title = this.Title
//BsonArray attributeList = new BsonArray();
//foreach (Attribute a in this.Attributes.Values) {
// BsonDocument attributes = new BsonDocument();
// attributes.Add("Name", a.Name);
// attributes.Add("Value", a.Value);
// attributes.Add("Max", a.Max);
// attributes.Add("RegenRate", a.RegenRate);
// attributeList.Add(attributes);
//}
//npcCharacter.Add("Attributes", attributeList);
//BsonArray xpTracker = new BsonArray();
//foreach (KeyValuePair<string, double> tracker in damageTracker) {
// BsonDocument track = new BsonDocument();
// track.Add("ID", tracker.Key);
// track.Add("Value", tracker.Value);
// xpTracker.Add(track);
//}
//BsonArray questIds = new BsonArray();
//foreach (var quest in Quests) {
// BsonDocument questDoc = new BsonDocument();
// questDoc.Add("QuestID", quest.QuestID);
// BsonArray playerSteps = new BsonArray();
// foreach (var playerStep in quest.CurrentPlayerStep) {
// BsonDocument step = new BsonDocument();
// step.Add("PlayerID", playerStep.Key);
// step.Add("Step", playerStep.Value);
// playerSteps.Add(step);
// }
// BsonArray autoProcess = new BsonArray();
// foreach (string playerStep in quest.AutoProcessPlayer) {
// autoProcess.Add(BsonValue.Create(playerStep));
// }
// questDoc.Add("AutoPlayers", autoProcess);
// questDoc.Add("PlayersIDs", playerSteps);
// questIds.Add(questDoc);
//}
//npcCharacter.Add("QuestIds", questIds);
//npcCharacter.Add("XpTracker", xpTracker);
//npcCharacter.Add("Bonuses", Bonuses.GetBson());
// };
//} else {
// npcCharacter["FirstName"] = this.FirstName;
// npcCharacter["LastName"] = this.LastName;
// npcCharacter["Race"] = this.Race;
// npcCharacter["Class"] = this.Class;
// npcCharacter["Gender"] = this.Gender.CamelCaseWord();
// npcCharacter["SkinColor"] = this.SkinColor.CamelCaseWord();
// npcCharacter["SkinType"] = this.SkinType.CamelCaseWord();
// npcCharacter["HairColor"] = this.HairColor.CamelCaseWord();
// npcCharacter["EyeColor"] = this.EyeColor.CamelCaseWord();
// npcCharacter["Weight"] = this.Weight;
// npcCharacter["Height"] = this.Height;
// npcCharacter["Description"] = this.Description;
// npcCharacter["Location"] = this.Location;
// npcCharacter["ActionState"] = this.ActionState.ToString().CamelCaseWord();
// npcCharacter["StanceState"] = this.StanceState.ToString().CamelCaseWord();
// npcCharacter["AiState"] = Fsm.state != null ? Fsm.state.ToString() : "None";
// npcCharacter["previousAiState"] = Fsm.previousState == null ? "" : Fsm.previousState.ToString();
// npcCharacter["AiGlobalState"] = Fsm.globalState == null ? "" : Fsm.globalState.ToString();
// npcCharacter["NextAiAction"] = this.NextAiAction.ToUniversalTime();
// npcCharacter["MobTypeID"] = this.MobTypeID;
// npcCharacter["IsNPC"] = this.IsNPC;
// npcCharacter["CurrentTarget"] = this.CurrentTarget == null ? "" : this.CurrentTarget;
// npcCharacter["LastTarget"] = this.LastTarget == null ? "" : this.LastTarget;
// npcCharacter["InCombat"] = this.InCombat;
// npcCharacter["LastCombatTime"] = this.LastCombatTime;
// npcCharacter["Experience"] = this.Experience;
// npcCharacter["Level"] = this.Level;
// npcCharacter["KillerID"] = this.KillerID;
// npcCharacter["Title"] = this.Title;
// BsonArray playerAttributes = new BsonArray();
// BsonArray xpTracker = new BsonArray();
// foreach (KeyValuePair<string, IAttributes> attribute in Attributes) {
// BsonDocument attrib = new BsonDocument();
// attrib.Add("Name", "");
// attrib.Add("Value", "");
// attrib.Add("Max", "");
// attrib.Add("RegenRate", "");
// attrib["Name"] = attribute.Key;
// attrib["Value"] = attribute.Value.Value;
// attrib["Max"] = attribute.Value.Max;
// attrib["RegenRate"] = attribute.Value.RegenRate;
// playerAttributes.Add(attrib);
// }
// npcCharacter["Attributes"] = playerAttributes;
// foreach (KeyValuePair<string, double> tracker in damageTracker) {
// BsonDocument track = new BsonDocument();
// track.Add("ID", "");
// track.Add("Value", 0.0d);
// track["ID"] = tracker.Key;
// track["Value"] = tracker.Value;
// xpTracker.Add(track);
// }
// BsonArray questIds = new BsonArray();
// foreach (var quest in Quests) {
// BsonDocument questDoc = new BsonDocument();
// questDoc.Add("QuestID", quest.QuestID);
// BsonArray playerSteps = new BsonArray();
// foreach (var playerStep in quest.CurrentPlayerStep) {
// BsonDocument step = new BsonDocument();
// step.Add("PlayerID", playerStep.Key);
// step.Add("Step", playerStep.Value);
// playerSteps.Add(step);
// }
// BsonArray autoProcess = new BsonArray();
// foreach (string playerStep in quest.AutoProcessPlayer) {
// autoProcess.Add(BsonValue.Create(playerStep));
// }
// questDoc.Add("AutoPlayers", autoProcess);
// questDoc.Add("PlayerIDs", playerSteps);
// questIds.Add(questDoc);
// }
// npcCharacter["QuestIds"] = questIds;
// npcCharacter["XpTracker"] = xpTracker;
// npcCharacter["Bonuses"] = Bonuses.GetBson();
//}
//characterCollection.Save(npcCharacter);
//if (this.ID == "000000000000000000000000") {
// this.ID = npcCharacter["_id"].AsObjectId.ToString();
//}
}
public BaseEntity()
{
this._id = ObjectId.GenerateNewId();
}
public void Save(T_CollectionType _Item, MongoDB.Bson.ObjectId _ID)
{
_Item.Id = _ID;
}
