protected void SaveUniversity() { UniversityBO objUniversity = new UniversityBO(); objUniversity.UserId = Userid; objUniversity.UniversityName = txtUniversity.Text; objUniversity.AttendedFor = txtAttendFor.Text; objUniversity.ClassYear = Convert.ToInt32(lstClassYear.SelectedValue); objUniversity.Degree = txtDegree.Text; objUniversity.Purpose = txtPurpose.Text; if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtUniversity.Text + ".jpg"))) { objUniversity.Image = txtUniversity.Text + ".jpg"; } else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtUniversity.Text + ".png"))) { objUniversity.Image = txtUniversity.Text + ".png"; } else { objUniversity.Image = "DefaultUniversity.png"; } if (!objUniversity.UniversityName.Equals("")) { string UniversityId = UniversityDAL.insertUniversity(objUniversity); } LoadDataListUniversity(); }
////////////////////////////////////////////////////////////// // SELECT BY PARAMETER List of Emps ////////////////////////////////////////////////////////////// public static ArrayList getUnisByUserId(string Id) { ArrayList Unis = new ArrayList(); MongoCollection<University> objCollection = db.GetCollection<University>("c_University"); UniversityBO objClass = new UniversityBO(); foreach (University item in objCollection.Find(Query.EQ("UserId", ObjectId.Parse(Id)))) { Unis.Add(item.UniversityName); } return Unis; }
////////////////////////////////////////////////////////////// // SELECT BY PARAMETER List of Emps ////////////////////////////////////////////////////////////// public static ArrayList getUnisByUserId(string Id) { ArrayList Unis = new ArrayList(); MongoCollection <University> objCollection = db.GetCollection <University>("c_University"); UniversityBO objClass = new UniversityBO(); foreach (University item in objCollection.Find(Query.EQ("UserId", ObjectId.Parse(Id)))) { Unis.Add(item.UniversityName); } return(Unis); }
public static List <UserFriendsBO> getAllSuggestions(string UserId) { List <UserFriendsBO> list = FriendsDAL.getAllSuggestions(UserId); foreach (UserFriendsBO Useritem in list) { BasicInfoBO info = BasicInfoDAL.getBasicInfoByUserId(Useritem.FriendUserId); Useritem.Hometown = info.HomeTown; Useritem.Location = info.CurrentCity; EmployerBO emp = EmployerDAL.getEmployerByUserId(Useritem.FriendUserId); Useritem.Employer = emp.Organization; UniversityBO uni = UniversityDAL.getUniversityByUniversityId(Useritem.FriendUserId); Useritem.Education = uni.UniversityName; } return(list); }
public static void updateUniversity(UniversityBO objClass) { MongoCollection <University> objCollection = db.GetCollection <University>("c_University"); var query = Query.EQ("_id", ObjectId.Parse(objClass.Id)); var sortBy = SortBy.Descending("_id"); var update = Update.Set("UserId", ObjectId.Parse(objClass.UserId)) .Set("UniversityName", objClass.UniversityName) .Set("ClassYear", objClass.ClassYear) .Set("Purpose", objClass.Purpose) .Set("Degree", objClass.Degree) .Set("AttendedFor", objClass.AttendedFor) .Set("Image", objClass.Image) ; var result = objCollection.FindAndModify(query, sortBy, update, true); }
/////////////////////////////////////////////////////////////// // SELECT BY PARAMETER ////////////////////////////////////////////////////////////// public static UniversityBO getUniversityByUniversityId(string Id) { MongoCollection<University> objCollection = db.GetCollection<University>("c_University"); UniversityBO objClass = new UniversityBO(); foreach (University item in objCollection.Find(Query.EQ("UserId", ObjectId.Parse(Id)))) { objClass.Id = item._id.ToString(); objClass.UserId = item.UserId.ToString(); objClass.UniversityName = item.UniversityName; objClass.Purpose = item.Purpose; objClass.ClassYear = item.ClassYear; objClass.Degree = item.Degree; objClass.AttendedFor = item.AttendedFor; objClass.Image = item.Image; break; } return objClass; }
public static string insertUniversity(UniversityBO objClass) { MongoCollection <BsonDocument> objCollection = db.GetCollection <BsonDocument>("c_University"); BsonDocument doc = new BsonDocument { { "UserId", ObjectId.Parse(objClass.UserId) }, { "UniversityName", objClass.UniversityName }, { "ClassYear", objClass.ClassYear }, { "Purpose", objClass.Purpose }, { "Degree", objClass.Degree }, { "AttendedFor", objClass.AttendedFor }, { "Image", objClass.Image } }; var rt = objCollection.Insert(doc); return(doc["_id"].ToString()); }
/////////////////////////////////////////////////////////////// // SELECT BY PARAMETER ////////////////////////////////////////////////////////////// public static UniversityBO getUniversityByUniversityId(string Id) { MongoCollection <University> objCollection = db.GetCollection <University>("c_University"); UniversityBO objClass = new UniversityBO(); foreach (University item in objCollection.Find(Query.EQ("UserId", ObjectId.Parse(Id)))) { objClass.Id = item._id.ToString(); objClass.UserId = item.UserId.ToString(); objClass.UniversityName = item.UniversityName; objClass.Purpose = item.Purpose; objClass.ClassYear = item.ClassYear; objClass.Degree = item.Degree; objClass.AttendedFor = item.AttendedFor; objClass.Image = item.Image; break; } return(objClass); }
public static void updateUniversity(UniversityBO objClass) { MongoCollection<University> objCollection = db.GetCollection<University>("c_University"); var query = Query.EQ("_id", ObjectId.Parse(objClass.Id)); var sortBy = SortBy.Descending("_id"); var update = Update.Set("UserId", ObjectId.Parse(objClass.UserId)) .Set("UniversityName", objClass.UniversityName) .Set("ClassYear", objClass.ClassYear) .Set("Purpose", objClass.Purpose) .Set("Degree", objClass.Degree) .Set("AttendedFor", objClass.AttendedFor) .Set("Image", objClass.Image) ; var result = objCollection.FindAndModify(query, sortBy, update, true); }
public static string insertUniversity(UniversityBO objClass) { MongoCollection<BsonDocument> objCollection = db.GetCollection<BsonDocument>("c_University"); BsonDocument doc = new BsonDocument { { "UserId" , ObjectId.Parse(objClass.UserId) }, { "UniversityName" , objClass.UniversityName}, { "ClassYear", objClass.ClassYear }, { "Purpose" , objClass.Purpose }, { "Degree", objClass.Degree }, { "AttendedFor" , objClass.AttendedFor }, { "Image",objClass.Image } }; var rt = objCollection.Insert(doc); return doc["_id"].ToString(); }
protected void SaveUniversity() { UniversityBO objUniversity = new UniversityBO(); objUniversity.UserId = Userid; objUniversity.UniversityName = txtUniversity.Text; objUniversity.AttendedFor = txtAttendFor.Text; objUniversity.ClassYear = Convert.ToInt32(lstClassYear.SelectedValue); objUniversity.Degree = txtDegree.Text; objUniversity.Purpose = txtPurpose.Text; if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtUniversity.Text + ".jpg"))) objUniversity.Image = txtUniversity.Text + ".jpg"; else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtUniversity.Text + ".png"))) objUniversity.Image = txtUniversity.Text + ".png"; else objUniversity.Image = "DefaultUniversity.png"; if (!objUniversity.UniversityName.Equals("")) { string UniversityId = UniversityDAL.insertUniversity(objUniversity); } LoadDataListUniversity(); }