public List<CardActivity> GetAllCardActivities(int cardID)
{
using (var db = new CardsDBContext())
{
return db.CardActivities.Where(item => item.CardID == cardID).ToList();
}
}
public Area Add(Area area)
{
using (var db = new CardsDBContext())
{
var result = db.Areas.Add(area);
db.SaveChanges();
return result;
}
}
public CardActivity Add(CardActivity cardActivity)
{
using (var db = new CardsDBContext())
{
var result = db.CardActivities.Add(cardActivity);
db.SaveChanges();
return result;
}
}
public List<Area> GetAllAreas()
{
using (var db = new CardsDBContext())
{
var areas = db.Areas.Where(area=>area.Active).ToList();
areas.ForEach(area => area.Cards = db.Cards.Where(card => card.AreaID == area.ID && card.Active).ToList());
return areas;
}
}
public Card Add(Card card)
{
using (var db = new CardsDBContext())
{
if (card.TfsID != 0 && db.Cards.FirstOrDefault(item => item.TfsID == card.TfsID) != null)
{
return null;
}
var result = db.Cards.Add(card);
db.SaveChanges();
return result;
}
}
public Label Add(Label label)
{
using (var db = new CardsDBContext())
{
var existingItem = db.Labels.FirstOrDefault(item => item.Name == label.Name);
if (existingItem == null)
{
var result = db.Labels.Add(label);
db.SaveChanges();
return result;
}
else
{
return null;
}
}
}
public Label Update(Label label)
{
using (var db = new CardsDBContext())
{
var labelToUpdate = db.Labels.FirstOrDefault(item => item.ID == label.ID);
var existingLabel = db.Labels.FirstOrDefault(item => item.Name == label.Name);
if (labelToUpdate != null && existingLabel != null)
{
labelToUpdate.Name = label.Name;
labelToUpdate.ColorCode = label.ColorCode;
labelToUpdate.ModifiedDate = label.ModifiedDate;
labelToUpdate.ModifiedUser = label.ModifiedUser;
db.SaveChanges();
return labelToUpdate;
}
else
{
return null;
}
}
}
public Card GetCard(int id)
{
using (var db = new CardsDBContext())
{
return db.Cards.FirstOrDefault(card => card.ID == id && card.Active == true);
}
}
public Area Update(Area area)
{
using (var db = new CardsDBContext())
{
var areaToUpdate = db.Areas.FirstOrDefault(item => item.ID == area.ID);
if (areaToUpdate != null)
{
areaToUpdate.Name = area.Name;
areaToUpdate.ModifiedDate = area.ModifiedDate;
areaToUpdate.ModifiedUser = area.ModifiedUser;
db.SaveChanges();
return areaToUpdate;
}
else
{
return null;
}
}
}
public void RemoveLabel(Label label)
{
using (var db = new CardsDBContext())
{
var labelToRemove = db.Labels.FirstOrDefault(item => item.ID == label.ID);
if (labelToRemove != null)
{
labelToRemove.ModifiedDate = label.ModifiedDate;
labelToRemove.ModifiedUser = label.ModifiedUser;
labelToRemove.Active = false;
db.SaveChanges();
}
}
}
public void RemoveCard(Card card)
{
using (var db = new CardsDBContext())
{
var cardToUpdate = db.Cards.FirstOrDefault(item => item.ID == card.ID);
if (cardToUpdate != null)
{
cardToUpdate.ModifiedDate = card.ModifiedDate;
cardToUpdate.ModifiedUser = card.ModifiedUser;
cardToUpdate.Active = false;
db.SaveChanges();
}
}
}
public void RemoveArea(Area area)
{
using (var db = new CardsDBContext())
{
var itemToDelete = db.Areas.FirstOrDefault(item => item.ID == area.ID);
itemToDelete.ModifiedDate = area.ModifiedDate;
itemToDelete.ModifiedUser = area.ModifiedUser;
itemToDelete.Active = false;
db.SaveChanges();
}
}
public Label GetLabel(int labelID)
{
using (var db = new CardsDBContext())
{
return db.Labels.FirstOrDefault(item => item.ID == labelID && item.Active == true);
}
}
public CardActivity GetCardActivity(int cardActivityID)
{
using (var db = new CardsDBContext())
{
return db.CardActivities.Where(item => item.ID == cardActivityID).FirstOrDefault();
}
}
public List<Card> GetAllCards(int areaID)
{
using (var db = new CardsDBContext())
{
return db.Cards.Include("CardActivities").Where(card => card.AreaID == areaID && card.Active == true).ToList();
}
}
public Card Update(Card card)
{
using (var db = new CardsDBContext())
{
var cardToUpdate = db.Cards.FirstOrDefault(item => item.ID == card.ID);
if (cardToUpdate != null)
{
cardToUpdate.Name = card.Name;
cardToUpdate.Description = card.Description;
cardToUpdate.TfsID = card.TfsID;
cardToUpdate.AreaID = card.AreaID;
cardToUpdate.ModifiedDate = card.ModifiedDate;
cardToUpdate.ModifiedUser = card.ModifiedUser;
cardToUpdate.AssignedTo = card.AssignedTo;
db.SaveChanges();
return cardToUpdate;
}
else
{
return null;
}
}
}
public List<Label> GetAllLabels()
{
using (var db = new CardsDBContext())
{
return db.Labels.Where(label => label.Active == true).ToList();
}
}
public Area GetArea(int id)
{
using (var db = new CardsDBContext())
{
var resultArea = db.Areas.FirstOrDefault(area => area.ID == id && area.Active);
resultArea.Cards = db.Cards.Where(card => card.AreaID == resultArea.ID && card.Active).ToList();
return resultArea;
}
}
