private void btnSave_Click(object sender, EventArgs e)
{
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
AsyncHelper.TaskAwaiter(() =>
{
var user = (User_tbl)UserSource.Current;
var priv = user.Privilege_tbl.Where(x => x.DbID == selectDB);
if (priv.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
}
BusinessAccessLayer.GetEntity().SaveChanges();
return(true);
});
}
private void OnChangeDataSelect()
{
var user = (User_tbl)UserSource.Current;
var Dbtbl = (DB_tbl)DBSource.Current;
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
var dataAwaiter = AsyncHelper.TaskAwaiter(() =>
{
var privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
if (privList.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
BusinessAccessLayer.GetEntity().SaveChanges();
privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
}
return(privList);
});
dataAwaiter.OnCompleted(() =>
{
var privList = dataAwaiter.GetResult();
if (privList.Count() > 0)
{
SubPrivSource.DataSource = privList.First().Sub_Priv_tbl;
}
});
}
