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();
}
