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