public ActionResult Edit(UserSocialNetwork usersocialnetwork)
{
if (ModelState.IsValid)
{
context.Entry(usersocialnetwork).State = EntityState.Modified;
context.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.PossibleSocialNetworks = context.SocialNetworks;
return View(usersocialnetwork);
}
public ActionResult Create(UserSocialNetwork usersocialnetwork)
{
if (ModelState.IsValid)
{
context.UserSocialNetworks.Add(usersocialnetwork);
context.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.PossibleSocialNetworks = context.SocialNetworks;
return View(usersocialnetwork);
}
public virtual List<UserSocialNetwork> UserSocialNetwork_GetAllForUser(int UserId)
{
UserSocialNetwork item = new UserSocialNetwork();
if (UserId < 1)
return (new List<UserSocialNetwork>() { item });
IEnumerable<UserSocialNetwork> items = _context.UserSocialNetworks.Where(x => x.UserID == UserId);
return (items.ToList());
}
//public virtual ObjectResult<UserProfileSummary_Get_Result> UserProfileSummary_Get(Nullable<int> userID)
//{
// var userIDParameter = userID.HasValue ?
// new SqlParameter("UserID", userID) :
// new SqlParameter("UserID", typeof(int));
// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<UserProfileSummary_Get_Result>("UserProfileSummary_Get @UserID", userIDParameter);
//}
//public virtual UserProfileSummary_Get_Result UserProfileSummary_Get(int userID)
//{
// //using (NuvolaResumeContext context = new NuvolaResumeContext())
// {
// UserProfile item = UserProfile_GetUserProfile(userID);
// UserProfileSummary_Get_Result ret = new UserProfileSummary_Get_Result();
// ret.ID = item.ID;
// ret.AchievementsCount = item.Achievements.Count();
// ret.CompanyCount = item.Companies.Count();
// ret.EducationsCount = item.Educations.Count();
// ret.SkillsCount = item.Skills.Count();
// ret.UserSocialNetworksCount = item.UserSocialNetworks.Count();
// ret.VolunteerExperiencesCount = item.VolunteerExperiences.Count();
// UserProfilePercentCompleteView upPer = UserProfilePercentCompleteView(userID);
// ret.PercentComplete = upPer.PercentComplete;
// return (ret);
// }
//}
//public virtual UserProfilePercentCompleteView UserProfilePercentCompleteView(int userID)
//{
// //SELECT UserID, Flag, CONVERT(decimal(18, 0), Flag) / 8 AS PercentComplete
// //FROM (
// // SELECT ID AS UserID,
// //CAST(CASE WHEN FirstName IS NULL THEN 0 ELSE 1 END +
// //CASE WHEN LastName IS NULL
// // THEN 0 ELSE 1 END + CASE WHEN Street IS NULL THEN 0 ELSE 1 END +
// //CASE WHEN City IS NULL
// // THEN 0 ELSE 1 END + CASE WHEN StateProvince IS NULL THEN 0 ELSE 1 END + CASE WHEN CountryID IS NULL
// // THEN 0 ELSE 1 END + CASE WHEN PhoneNumber1 IS NULL THEN 0 ELSE 1 END + CASE WHEN EMailAddress1 IS NULL
// //THEN 0 ELSE 1 END AS int)
// // AS Flag
// //FROM dbo.UserProfiles) AS UserComplete
// //using (NuvolaResumeContext context = new NuvolaResumeContext())
// {
// UserProfile item = UserProfile_GetUserProfile(userID);
// UserProfilePercentCompleteView ret = new UserProfilePercentCompleteView();
// int flag = (
// (String.IsNullOrEmpty(item.FirstName) ? 0 : 1) +
// (String.IsNullOrEmpty(item.LastName) ? 0 : 1) +
// (String.IsNullOrEmpty(item.Street) ? 0 : 1) +
// (String.IsNullOrEmpty(item.City) ? 0 : 1) +
// (String.IsNullOrEmpty(item.StateProvince) ? 0 : 1) +
// (String.IsNullOrEmpty(item.PhoneNumber1) ? 0 : 1) +
// (item.CountryID == null ? 0 : 1) +
// (String.IsNullOrEmpty(item.EMailAddress1) ? 0 : 1));
// ret.UserID = item.ID;
// ret.Flag = flag;
// ret.PercentComplete = ((decimal)flag / 8) * 100;
// return (ret);
// }
//}
//public virtual ObjectResult<int> UserSearch(string searchWord)
//{
// var searchWordParameter = searchWord != null ?
// new SqlParameter("SearchWord", searchWord) :
// new SqlParameter("SearchWord", typeof(string));
// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<int>("UserSearch", searchWordParameter);
//}
////public virtual ObjectResult<int> UserSocialNetwork_Save(Nullable<int> iD, Nullable<int> userID, Nullable<int> socialNetworkID, string socialNetworkAccount, string displayAs)
////{
//// var iDParameter = iD.HasValue ?
//// new SqlParameter("ID", iD) :
//// new SqlParameter("ID", typeof(int));
//// var userIDParameter = userID.HasValue ?
//// new SqlParameter("UserID", userID) :
//// new SqlParameter("UserID", typeof(int));
//// var socialNetworkIDParameter = socialNetworkID.HasValue ?
//// new SqlParameter("SocialNetworkID", socialNetworkID) :
//// new SqlParameter("SocialNetworkID", typeof(int));
//// var socialNetworkAccountParameter = socialNetworkAccount != null ?
//// new SqlParameter("SocialNetworkAccount", socialNetworkAccount) :
//// new SqlParameter("SocialNetworkAccount", typeof(string));
//// var displayAsParameter = displayAs != null ?
//// new SqlParameter("DisplayAs", displayAs) :
//// new SqlParameter("DisplayAs", typeof(string));
//// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<int>("UserSocialNetwork_Save", iDParameter, userIDParameter, socialNetworkIDParameter, socialNetworkAccountParameter, displayAsParameter);
////}
//public virtual UserSocialNetwork UserSocialNetwork_Save(Nullable<int> iD, Nullable<int> userID, Nullable<int> socialNetworkID, string socialNetworkAccount, string displayAs)
//{
// //using (NuvolaResumeContext context = new NuvolaResumeContext())
// {
// UserSocialNetwork item = new UserSocialNetwork();
// if (iD.HasValue)
// {
// //Find the item
// item = _context.UserSocialNetworks.SingleOrDefault(x => x.ID == iD.Value);
// }
// else
// {
// //Create a new item, we don't have an ID
// item = new UserSocialNetwork();
// }
// //Update / Set properties
// item.UserID = userID;
// item.SocialNetworkID = socialNetworkID;
// item.SocialNetworkAccount = socialNetworkAccount;
// item.DisplayAs = displayAs;
// if (iD.HasValue)
// {
// //Add the new item to the database
// _context.UserSocialNetworks.Add(item);
// }
// _context.SaveChanges();
// return (item);
// }
//}
//public virtual ObjectResult<int> UserSocialNetworks_DeleteAllByUserId(Nullable<int> userId)
//{
// var userIdParameter = userId.HasValue ?
// new SqlParameter("UserId", userId) :
// new SqlParameter("UserId", typeof(int));
// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<int>("UserSocialNetworks_DeleteAllByUserId", userIdParameter);
//}
////public virtual ObjectResult<UserSocialNetworks_GetAllForUser_Result> UserSocialNetworks_GetAllForUser(Nullable<int> userID)
////{
//// var userIDParameter = userID.HasValue ?
//// new SqlParameter("UserID", userID) :
//// new SqlParameter("UserID", typeof(int));
//// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<UserSocialNetworks_GetAllForUser_Result>("UserSocialNetworks_GetAllForUser", userIDParameter);
////}
//public virtual IEnumerable<UserSocialNetwork> UserSocialNetworks_GetAllForUser(Nullable<int> userID)
//{
// //using (NuvolaResumeContext context = new NuvolaResumeContext())
// {
// IEnumerable<UserSocialNetwork> items = _context.UserSocialNetworks.Where(x => x.UserID == userID);
// return (items.ToList());
// }
//}
//public virtual ObjectResult<UserSocialNetworks_GetById_Result> UserSocialNetworks_GetById(Nullable<int> iD)
//{
// var iDParameter = iD.HasValue ?
// new SqlParameter("ID", iD) :
// new SqlParameter("ID", typeof(int));
// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<UserSocialNetworks_GetById_Result>("UserSocialNetworks_GetById", iDParameter);
//}
//public virtual ObjectResult<int> VolunteerExperience_Save(Nullable<int> iD, string name, string summary, Nullable<System.DateTime> dateStart, Nullable<System.DateTime> dateEnd, Nullable<int> userID)
//{
// var iDParameter = iD.HasValue ?
// new SqlParameter("ID", iD) :
// new SqlParameter("ID", typeof(int));
// var nameParameter = name != null ?
// new SqlParameter("Name", name) :
// new SqlParameter("Name", typeof(string));
// var summaryParameter = summary != null ?
// new SqlParameter("Summary", summary) :
// new SqlParameter("Summary", typeof(string));
// var dateStartParameter = dateStart.HasValue ?
// new SqlParameter("DateStart", dateStart) :
// new SqlParameter("DateStart", typeof(System.DateTime));
// var dateEndParameter = dateEnd.HasValue ?
// new SqlParameter("DateEnd", dateEnd) :
// new SqlParameter("DateEnd", typeof(System.DateTime));
// var userIDParameter = userID.HasValue ?
// new SqlParameter("UserID", userID) :
// new SqlParameter("UserID", typeof(int));
// return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<int>("VolunteerExperience_Save", iDParameter, nameParameter, summaryParameter, dateStartParameter, dateEndParameter, userIDParameter);
//}
public virtual UserSocialNetwork UserSocialNetwork_Get(int Id)
{
UserSocialNetwork item = new UserSocialNetwork();
if (Id < 1)
return (item);
//using (NuvolaResumeContext context = new NuvolaResumeContext())
{
//_context.Configuration.ProxyCreationEnabled = false;
item = _context.UserSocialNetworks.Include(x => x.SocialNetwork).SingleOrDefault(x => x.ID == Id);
if (item == null)
return (new UserSocialNetwork());
return (item);
}
}
