public void Save_Dashboard(lsttbl_Dashboard info) { var db = GlobalVar.DbBI; try { System.Data.Linq.Table <lsttbl_Dashboard> dashboards = db.lsttbl_Dashboards; var objFound = dashboards.FirstOrDefault(p => p.Code == info.Code); if (objFound == null) { db.lsttbl_Dashboards.InsertOnSubmit(info); } else { objFound.UpdateOnSubmit(info); } // update IsDefault if (info.IsDefault) { foreach (lsttbl_Dashboard tbl in dashboards) { if (tbl.Code == info.Code) { continue; } tbl.IsDefault = false; } } db.SubmitChanges(); } catch { } }