CommodityRoots(Guest19.Database.CommodityRoots commodityRoots)
{
Id = commodityRoots.Id;
CommodityChapterId = commodityRoots.CommodityChapterId;
Code = commodityRoots.Code;
Name = commodityRoots.Name;
Description = commodityRoots.Description;
Active = commodityRoots.Active;
}
public bool Save()
{
bool saved;
try
{
using (var context = new Guest19DataContext())
{
var dbItem = context.CommodityRoots.SingleOrDefault(i => i.Id == this.Id);
//update
if (dbItem != null)
{
dbItem.Active = this.Active;
dbItem.Code = this.Code;
dbItem.CommodityChapterId = this.CommodityChapterId;
dbItem.Description = this.Description;
dbItem.Name = this.Name;
context.SubmitChanges();//update il db
saved = true;
}
//new
else
{
var newDbItem = new Guest19.Database.CommodityRoots();
newDbItem.Active = this.Active;
newDbItem.Code = this.Code;
newDbItem.CommodityChapterId = this.CommodityChapterId;
newDbItem.Description = this.Description;
newDbItem.Name = this.Name;
context.CommodityRoots.InsertOnSubmit(newDbItem);//insert new records in db
context.SubmitChanges();
saved = true;
}
}
}
catch (Exception ex)
{
saved = false;
}
return(saved);
}
partial void DeleteCommodityRoots(CommodityRoots instance);
partial void UpdateCommodityRoots(CommodityRoots instance);
partial void InsertCommodityRoots(CommodityRoots instance);
private void detach_CommodityRoots(CommodityRoots entity)
{
this.SendPropertyChanging();
entity.CommodityChapters = null;
}
