protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (this.CboMenus.SelectedValue != null && this.GridView1.SelectedValue != null)
{
ConosudDataContext dc = new ConosudDataContext();
if ((from rm in dc.SegRolMenus
where rm.Menu == long.Parse(this.CboMenus.SelectedValue) &&
rm.Rol == long.Parse(this.GridView1.SelectedValue.ToString())
select rm).Count() == 0)
{
SegMenu menu = (from u in dc.SegMenus
where u.IdSegMenu == long.Parse(this.CboMenus.SelectedValue)
select u).First();
SegRol rol = (from u in dc.SegRols
where u.IdSegRol == long.Parse(this.GridView1.SelectedValue.ToString())
select u).First();
SegRolMenu Confseg = new SegRolMenu();
Confseg.ObjSegRol = rol;
Confseg.ObjSegMenu = menu;
dc.SegRolMenus.InsertOnSubmit(Confseg);
dc.SubmitChanges();
this.GridView2.DataBind();
}
else
{
string alert = "alert('Ya existe este menu para este rol');";
System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "click", alert, true);
}
}
}
public string Excluir(SegMenu Menu)
{
try
{
AcessoDados.LimparParametro();
AcessoDados.AdicionarParametro("@INintAcao", (int)AcaoBD.Excluir);
AcessoDados.AdicionarParametro("@INintIDMenu", Menu.IDMenu);
AcessoDados.AdicionarParametro("@INintIDModulo", Menu.Modulo.IDModulo);
AcessoDados.AdicionarParametro("@INvchDescricao", Menu.Descricao);
return(AcessoDados.ExecutarScalar("uspCadastrarSegMenu", CommandType.StoredProcedure).ToString());
}
catch (Exception ex)
{
throw new Exception("Não foi possivel executar comando no banco de dados.\nMotivo: " + ex.Message);
}
}
