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