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 { }
}
