//ADD
public static bool AddCommunity(communities comm)
{
Context.communities.Add(comm);
try
{
Context.SaveChanges();
}
catch (DbUpdateException dbEx)
{
return false;
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}",
subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
Console.WriteLine(message);
}
// Rollback changes
switch (entry.State)
{
case EntityState.Added:
entry.State = EntityState.Detached;
break;
case EntityState.Modified:
entry.CurrentValues.SetValues(entry.OriginalValues);
entry.State = EntityState.Unchanged;
break;
case EntityState.Deleted:
entry.State = EntityState.Unchanged;
break;
}
}
return false;
}
Context.Entry(comm).Reload();
return true;
}
public static List<events> GetEventsByCommunity(communities comm)
{
return comm.events.ToList();
}
public static List<events> FilterEvents(DateTime? sT, DateTime? eT, communities c, associations a, categories cat, subcategories subCat, string word)
{
List<events> resultList = GetAllEvents();
if (sT != null)
{
resultList = resultList.Where(e => e.StartDate >= sT).ToList();
}
if (eT != null)
{
resultList = resultList.Where(e => e.EndDate <= eT).ToList();
}
if (c != null)
{
var preResultList = new List<events>();
preResultList.AddRange(resultList.Where(e => e.communities.Contains(c)).ToList());
List<events> list = resultList;
foreach (var ev in c.associations.SelectMany(asso => list.Where(e => e.associations.Contains(asso)).Where(ev => !preResultList.Contains(ev))))
{
preResultList.Add(ev);
}
resultList = preResultList;
}
if (a != null)
{
resultList = resultList.Where(e => e.associations.Contains(a)).ToList();
}
if (cat != null)
{
List<events> eventsInAsso = new List<events>();
foreach (var asso in cat.associations)
{
eventsInAsso.AddRange(resultList.Where(e => e.associations.Contains(asso)));
}
resultList = eventsInAsso;
}
if (subCat != null)
{
resultList = resultList.Where(e => e.subcategories.Contains(subCat)).ToList();
}
if (!String.IsNullOrWhiteSpace(word))
{
resultList = GetEventsFromListBySearchWord(resultList, word);
}
return resultList;
}
//private List<communities> FilterDropDownCommItems(associations a)
//{
//}
private List<associations> FilterDropDownAssoItems(communities c)
{
PopulateDropDownAsso(AssociationDB.GetAllAssociationsInCommunity(c));
return AssociationDB.GetAllAssociationsInCommunity(c).ToList();
}
// Still in use vvv (optimize/merge)
public List<events> RenderEventList(communities comm)
{
List<events> eventList = new List<events>();
if (comm != null)
{
eventList = EventDB.GetEventsByCommunity(comm).Where(e => !e.IsDeleted).ToList();
GridViewEventList.DataSource = eventList.OrderBy(e => e.StartDate);
GridViewEventList.DataBind();
return eventList;
}
return RenderEventList();
}
public communities GetCommunityFromQueryStringsAndSelectInDropDown()
{
communities comm = new communities();
//Hämtar WebPageId från URL.
var stId = Request.QueryString["Id"];
int id;
//Om Id värdet som tas från URLn är i giltigt format hämtas WebPage objektet och visas på sidan.
if (!string.IsNullOrWhiteSpace(stId) && int.TryParse(stId, out id))
{
webpages webPage = WebPageDB.GetWebPageById(id);
if (webPage != null)
{
if (webPage.CommunityId != null)
{
comm = CommunityDB.GetCommunityById(webPage.CommunityId.GetValueOrDefault());
if (comm != null)
{
DropDownListComm.SelectedIndex =
DropDownListComm.Items.IndexOf(
DropDownListComm.Items.FindByValue(
comm.Id.ToString()));
}
else
{
DropDownListComm.SelectedIndex = DropDownListComm.Items.IndexOf(
DropDownListComm.Items.FindByValue(""));
}
}
}
}
return comm;
}
public static bool HasUserPermissionForCommunityWithRole(users u, communities c, string r)
{
return GetAllCommunityPermissionsByCommunity(c).Any(cP => cP.users.Id == u.Id && cP.Role.Equals(r));
}
public static bool HasUserPermissionForCommunity(users u, communities c)
{
return GetAllCommunityPermissionsByCommunity(c).Any(cP => cP.users.Id == u.Id);
}
public static List<community_permissions> GetAllCommunityPermissionsByCommunity(communities comm)
{
return GetAllNotDeletedCommunityPermissions().Where(p => p.communities_Id.Equals(comm.Id)).ToList();
}
public static List<users> GetAllUsersByCommunity(communities c)
{
var usersInCommunity = new List<users>();
foreach (
var user in
CommunityPermissionsDB.GetAllCommunityPermissionsByCommunity(c)
.Select(aP => aP.users)
.Where(user => !usersInCommunity.Contains(user)))
{
usersInCommunity.Add(user);
}
return usersInCommunity;
}
public static List<associations> GetAllAssociationsInCommunity(communities com)
{
return GetAllNotDeletedAssociations().Where(a => a.communities.Equals(com)).ToList();
}
// UPDATE
public static int UpdateCommunity(communities comm)
{
communities commToUpdate = GetCommunityById(comm.Id);
commToUpdate.Name = comm.Name;
commToUpdate.Description = comm.Description;
int affectedRows;
try
{
affectedRows = Context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = string.Format("Error '{0}' occurred in {1} at {2}",
subItem.ErrorMessage, entityTypeName, subItem.PropertyName);
Console.WriteLine(message);
}
// Rollback changes
switch (entry.State)
{
case EntityState.Added:
entry.State = EntityState.Detached;
break;
case EntityState.Modified:
entry.CurrentValues.SetValues(entry.OriginalValues);
entry.State = EntityState.Unchanged;
break;
case EntityState.Deleted:
entry.State = EntityState.Unchanged;
break;
}
}
return affectedRows = 0;
}
Context.Entry(commToUpdate).Reload();
return affectedRows;
}
// För att skapa en ny community
protected void ButtonCreateComm_OnClick(object sender, EventArgs e)
{
bool isUniqueName = true;
//Kontrollera att namnet inte redan finns
foreach (communities commChecking in CommunityDB.GetAllCommunities())
{
if (commChecking.Name == TextBoxCommNameCreate.Text)
{
isUniqueName = false;
}
};
if (!isUniqueName)
{
LabelCreateComm.Text = "Community was not created. A community with the same name already exists. ";
LabelCreateComm.Style.Add(HtmlTextWriterStyle.Color, "red");
return;
}
var comm = new communities
{
Name = TextBoxCommNameCreate.Text,
LogoUrl = TextBoxCommLogoUrl.Text,
CreatedBy = HttpContext.Current.User.Identity.Name,
UpdatedBy = HttpContext.Current.User.Identity.Name
};
if (CommunityDB.AddCommunity(comm))
{
webpages wp = new webpages
{
Title = TextBoxCommNameCreate.Text,
CommunityId = CommunityDB.GetCommunityByName(comm.Name).Id,
//Layout och style - fixa dropdownlistor senare!
CreatedBy = HttpContext.Current.User.Identity.Name,
UpdatedBy = HttpContext.Current.User.Identity.Name
};
if (WebPageDB.AddWebPage(wp))
{
components compCal = new components
{
webpages_Id = wp.Id,
OrderingNumber = 1,
controls_Id = 3 //Calendar
};
components compAbout = new components
{
webpages_Id = wp.Id,
OrderingNumber = 2,
controls_Id = 1 //About
};
if (ComponentDB.AddComponent(compCal) && ComponentDB.AddComponent(compAbout))
{
MultiViewCommDetails.ActiveViewIndex = 0;
MultiViewCommCreate.ActiveViewIndex = -1;
ShowCommunityDetails(CommunityDB.GetCommunityByName(comm.Name));
}
else
{
LabelCreateComm.Text = "Components could not be created. Please try again!";
LabelCreateComm.Style.Add(HtmlTextWriterStyle.Color, "red");
}
}
else
{
LabelCreateComm.Text = "Webpage could not be created. Try again!";
LabelCreateComm.Style.Add(HtmlTextWriterStyle.Color, "red");
}
//Välj admin för communityn som skapas
if (UserDB.GetUserByUsername(ddlAdminUser.SelectedValue) != null)
{
community_permissions cP = new community_permissions
{
users_Id = UserDB.GetUserByUsername(ddlAdminUser.SelectedValue).Id,
communities_Id = CommunityDB.GetCommunityByName(comm.Name).Id, //comm.Id
Role = "Administrators"
};
CommunityPermissionsDB.AddCommunityPermissions(cP);
if (!Roles.IsUserInRole(ddlAdminUser.SelectedValue, "Administrators"))
{
Roles.AddUserToRole(ddlAdminUser.SelectedValue, "Administrators");
}
}
}
else
{
LabelCreateComm.Text = "Community could not be created. Try again!";
LabelCreateComm.Style.Add(HtmlTextWriterStyle.Color, "red");
}
PopulateCommunityDropDownList(DropDownListCommunity);
ListBoxAsso.Items.Clear();
LabelCommSave.Text = string.Empty; //Use string.Empty instead of "". ALWAYS.
}
public void ShowCommunityDetails(communities comm)
{
// Visa Community Name i textboxen och i rubrik över föreningslista
TextBoxCommName.Text = comm.Name;
TextBoxCommDescript.Text = comm.Description ?? "";
TextBoxCommLogoImgUrl.Text = comm.LogoUrl ?? "~/Images/Community.jpg";
LabelAssoInComm.Text = "Associations in " + comm.Name;
LabelAssoInComm.Style.Add(HtmlTextWriterStyle.Color, "black");
// Visa Community logga med länk innehållande tooltip
ImageLogoCommunity.ImageUrl = comm.LogoUrl ?? "~/Images/Community.jpg";
HyperLinkLogoCommunity.NavigateUrl =
"/SitePage.aspx?id=" +
(WebPageDB.GetWebPageByCommunityId(comm.Id) != null
? WebPageDB.GetWebPageByCommunityId(comm.Id).Id.ToString()
: "") + "&type=C";
HyperLinkLogoCommunity.Target = "_blank";
HyperLinkLogoCommunity.ToolTip = "This link goes to the web page of " +
comm.Name + ". (^-^)v";
// Visa Created och Created By
LabelCreated.Text = "<b>Created: </b>" +
CommunityDB.GetCommunityById(comm.Id)
.Created.ToShortDateString();
LabelCreatedBy.Text = "<b>Created by: </b>" +
CommunityDB.GetCommunityById(comm.Id)
.CreatedBy;
}
