public static ArrayList getActivitiesByUserId(string Id)
{
ArrayList Activities = new ArrayList();
MongoCollection<Activity> objCollection = db.GetCollection<Activity>("c_Activities");
ActivityBO objClass = new ActivityBO();
foreach (Activity item in objCollection.Find(Query.EQ("UserId", ObjectId.Parse(Id))))
{
Activities.Add(item.Name);
}
return Activities;
}
public static ActivityBO getActivityByActivityId(string Id)
{
MongoCollection<Activity> objCollection = db.GetCollection<Activity>("c_Activities");
ActivityBO objClass = new ActivityBO();
foreach (Activity item in objCollection.Find(Query.EQ("_id", ObjectId.Parse(Id))))
{
objClass.Id = item._id.ToString();
objClass.UserId = item.UserId.ToString();
objClass.Name = item.Name;
objClass.Type = item.Type;
objClass.Description= item.Description;
objClass.Image = item.Image;
break;
}
return objClass;
}
protected void SaveInterests()
{
ActivityBO objActivity = new ActivityBO();
objActivity.UserId = Userid;
objActivity.Name = txtInterests.Text;
objActivity.Description = txtInterestsDescription.Text;
objActivity.Type = Global.INTERESTS;
if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtInterests.Text + ".jpg")))
objActivity.Image = txtInterests.Text + ".jpg";
else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtInterests.Text + ".png")))
objActivity.Image = txtInterests.Text + ".png";
else
objActivity.Image = "DefaultInterests.png";
string ActivityId = ActivityBLL.insertActivity(objActivity);
txtInterests.Text = String.Empty;
txtInterestsDescription.Text = String.Empty;
LoadDataListInterests();
}
protected void SaveActivities()
{
ActivityBO objActivity = new ActivityBO();
objActivity.UserId = Userid;
objActivity.Name = txtActivities.Text;
objActivity.Description = txtActivitiesDescription.Text;
objActivity.Type = Global.ACTIVITIES;
if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtActivities.Text + Global.PICTURE_EXTENSION_JPG)))
objActivity.Image = txtActivities.Text + Global.PICTURE_EXTENSION_JPG;
else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtActivities.Text + ".png")))
objActivity.Image = txtActivities.Text + ".png";
else
objActivity.Image = "DefaultActivities.png";
string ActivityId = ActivityBLL.insertActivity(objActivity);
txtActivities.Text = "";
txtActivitiesDescription.Text = "";
LoadDataListActivities();
}
public static void updateActivity(ActivityBO objClass)
{
MongoCollection<Activity> objCollection = db.GetCollection<Activity>("c_Activities");
var query = Query.EQ("_id", ObjectId.Parse(objClass.Id));
var sortBy = SortBy.Descending("_id");
var update = Update.Set("UserId", ObjectId.Parse(objClass.UserId))
.Set("Name", objClass.Name)
.Set("Description", objClass.Description)
.Set("Type", objClass.Type)
.Set("Image", objClass.Image)
;
var result = objCollection.FindAndModify(query, sortBy, update, true);
}
public static string insertActivity(ActivityBO objClass)
{
MongoCollection<BsonDocument> objCollection = db.GetCollection<BsonDocument>("c_Activities");
var query = Query.And(
Query.EQ("Type", objClass.Type),
Query.EQ("Name", objClass.Name),
Query.EQ("UserId", ObjectId.Parse(objClass.UserId)));
var result = objCollection.Find(query);
if (!result.Any())
{
BsonDocument doc = new BsonDocument {
{ "UserId" , ObjectId.Parse(objClass.UserId) },
{ "Name" , objClass.Name },
{ "Description" , objClass.Description },
{ "Type", objClass.Type },
{ "Image",objClass.Image }
};
var rt=objCollection.Insert(doc);
return doc["_id"].ToString();
}
else
return null;
}
