public void Delete(int id)
{
using (var db = new ComputerPartsContext())
{
var computerParts = new ComputerParts {
Id = id
};
db.ComputerParts.Attach(computerParts);
db.ComputerParts.Remove(computerParts);
db.SaveChanges();
}
}
public void Update(int id, ComputerPartDetailDTO detail)
{
using (var db = new ComputerPartsContext())
{
var partToEdit = db.ComputerParts.Where(a => a.Id == id).SingleOrDefault();
if (partToEdit != null)
{
partToEdit.Description = detail.Description;
partToEdit.Condition = detail.Condition;
partToEdit.PartType = detail.PartType;
partToEdit.Location = detail.Location;
partToEdit.Price = detail.Price;
partToEdit.Remarks = detail.Remarks;
db.SaveChanges();
}
}
}
public int Append(ComputerPartDetailDTO computerPart)
{
int id = -1;
using (var db = new ComputerPartsContext())
{
ComputerParts computerParts = new ComputerParts
{
Description = computerPart.Description,
Condition = computerPart.Condition,
PartType = computerPart.PartType,
Location = computerPart.Location,
Price = computerPart.Price,
Remarks = computerPart.Remarks
};
db.ComputerParts.Add(computerParts);
db.SaveChanges();
id = computerParts.Id;
}
return(id);
}