public void SaveInstrumentCategory(InstrumentCategory instrumentCategory)
{
DanielsEntities context = new DanielsEntities();
COSC4210.MusicalIntruments.Web.Models.Category instrumentItemCategory = new COSC4210.MusicalIntruments.Web.Models.Category();
if (instrumentCategory.ID != 0)
{
var etItemCategory = from t in context.Categories
where t.ID == instrumentCategory.ID
select t;
instrumentItemCategory = etItemCategory.FirstOrDefault();
instrumentItemCategory.CategoryName = instrumentCategory.InstrumentCategoryName;
}
else
{
instrumentItemCategory.CategoryName = instrumentCategory.InstrumentCategoryName;
context.Categories.Add(instrumentItemCategory);
}
instrumentItemCategory.LastModified = DateTime.Now;
instrumentItemCategory.LastModifiedBy = "Phil";
context.SaveChanges();
}
public void SaveMusicalInstrument(MusicalInstrument MusicalInstrument)
{
DanielsEntities context = new DanielsEntities();
COSC4210.MusicalIntruments.Web.Models.Item instrumentItem = new COSC4210.MusicalIntruments.Web.Models.Item();
if (MusicalInstrument.ID != 0)
{
var etItem = from t in context.Items
where t.ID == MusicalInstrument.ID
select t;
instrumentItem = etItem.FirstOrDefault();
instrumentItem.ItemName = MusicalInstrument.Name;
instrumentItem.Brand = MusicalInstrument.Brand;
instrumentItem.TypeID = MusicalInstrument.TypeID;
instrumentItem.Price = MusicalInstrument.Price;
}
else
{
instrumentItem.ItemName = MusicalInstrument.Name;
instrumentItem.Brand = MusicalInstrument.Brand;
instrumentItem.Price = MusicalInstrument.Price;
instrumentItem.TypeID = MusicalInstrument.TypeID;
context.Items.Add(instrumentItem);
}
instrumentItem.LastModified = DateTime.Now;
instrumentItem.LastModifiedBy = "Phil";
context.SaveChanges();
}
public void SaveInstrumentType(InstrumentType instrumentType)
{
DanielsEntities context = new DanielsEntities();
COSC4210.MusicalIntruments.Web.Models.Type instrumentItemType = new COSC4210.MusicalIntruments.Web.Models.Type();
if (instrumentType.ID != 0)
{
var etItemType = from t in context.Types
where t.ID == instrumentType.ID
select t;
instrumentItemType = etItemType.FirstOrDefault();
instrumentItemType.TypeName = instrumentType.TypeName;
}
else
{
instrumentItemType.TypeName = instrumentType.TypeName;
context.Types.Add(instrumentItemType);
}
instrumentItemType.LastModified = DateTime.Now;
instrumentItemType.LastModifiedBy = "Phil";
context.SaveChanges();
}
public IList <InstrumentCategory> DeleteCategoryAssociation(int InstrumentID, int CategoryID)
{
DanielsEntities context = new DanielsEntities();
var assoc = from t in context.ItemCategories
where t.ItemID == InstrumentID && t.CategoryID == CategoryID
select t;
ItemCategory category = assoc.FirstOrDefault();
context.ItemCategories.Remove(category);
context.SaveChanges();
return(GetCategoryAssociations(InstrumentID));
}
public IList <InstrumentCategory> AddCategoryAssociation(int InstrumentID, int CategoryID)
{
DanielsEntities context = new DanielsEntities();
Models.ItemCategory association = new ItemCategory();
association.CategoryID = CategoryID;
association.ItemID = InstrumentID;
association.LastModified = DateTime.Now;
association.LastModifiedBy = "Phil";
context.ItemCategories.Add(association);
context.SaveChanges();
return(GetCategoryAssociations(InstrumentID));
}
