public void SaveInstrument(tbl_logbook_instrument_master tblObj) { if (tblObj.id == 0) { dt.tbl_logbook_instrument_masters.InsertOnSubmit(tblObj); } dt.SubmitChanges(); }
public void DeleteInstrument(int InstrumentId) { tbl_logbook_instrument_master obj = dt.tbl_logbook_instrument_masters.Where(e => e.id == InstrumentId).SingleOrDefault(); if (obj != null) { dt.tbl_logbook_instrument_masters.DeleteOnSubmit(obj); } dt.SubmitChanges(); }
public void ChangeStatus(int id) { tbl_logbook_instrument_master obj = dt.tbl_logbook_instrument_masters.Where(e => e.id == id).SingleOrDefault(); if (obj != null) { obj.IsActive = obj.IsActive == true ? false : true; } dt.SubmitChanges(); }