void SelectSubMenu(ENTSubMenu oENTSubMenu)
{
ENTResponse oENTResponse = new ENTResponse();
BPSubMenu oBPSubMenu = new BPSubMenu();
try{
// Transacción
oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
// Transacción exitosa
ExportExcel(oENTResponse.dsResponse.Tables[2], "SubMenu");
}catch (Exception ex){
throw (ex);
}
}
private void UpdateSubMenu_Estatus(Int32 idSubMenu, SubMenuActionTypes SubMenuActionType)
{
ENTSubMenu oENTSubMenu = new ENTSubMenu();
ENTResponse oENTResponse = new ENTResponse();
BPSubMenu oBPSubMenu = new BPSubMenu();
try
{
// Formulario
oENTSubMenu.idSubMenu = idSubMenu;
switch (SubMenuActionType)
{
case SubMenuActionTypes.DeleteSubMenu:
oENTSubMenu.tiActivo = 0;
break;
case SubMenuActionTypes.ReactivateSubMenu:
oENTSubMenu.tiActivo = 1;
break;
default:
throw new Exception("Opción inválida");
}
// Transacción
oENTResponse = oBPSubMenu.UpdateSubMenu_Estatus(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
if (oENTResponse.sMessage != "") { throw (new Exception(oENTResponse.sMessage)); }
// Actualizar datos
SelectSubMenu();
}
catch (Exception ex)
{
throw (ex);
}
}
private void UpdateSubMenu(Int32 idSubMenu)
{
ENTSubMenu oENTSubMenu = new ENTSubMenu();
ENTResponse oENTResponse = new ENTResponse();
BPSubMenu oBPSubMenu = new BPSubMenu();
try
{
// Formulario
oENTSubMenu.idSubMenu = idSubMenu;
oENTSubMenu.idMenu = Int32.Parse(this.ddlActionMenu.SelectedValue);
oENTSubMenu.sDescripcion = this.txtActionDescripcion.Text.Trim();
oENTSubMenu.sNombre = this.txtActionNombre.Text.Trim();
oENTSubMenu.sPageName = this.txtActionPageName.Text.Trim();
oENTSubMenu.sURL = this.txtActionURL.Text.Trim();
oENTSubMenu.tiActivo = Int16.Parse(this.ddlActionStatus.SelectedValue);
oENTSubMenu.tiRequired = Int16.Parse(this.ddlActionRequired.SelectedValue);
// Transacción
oENTResponse = oBPSubMenu.UpdateSubMenu(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
if (oENTResponse.sMessage != "") { throw (new Exception(oENTResponse.sMessage)); }
// Transacción exitosa
ClearActionPanel();
// Actualizar grid
SelectSubMenu();
// Mensaje de usuario
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), Convert.ToString(Guid.NewGuid()), "alert('Información actualizada con éxito!'); focusControl('" + this.ddlMenu.ClientID + "');", true);
}
catch (Exception ex)
{
throw (ex);
}
}
private void SelectSubMenu_ForEdit(Int32 idSubMenu)
{
ENTSubMenu oENTSubMenu = new ENTSubMenu();
ENTResponse oENTResponse = new ENTResponse();
ENTSession oENTSession;
BPSubMenu oBPSubMenu = new BPSubMenu();
try
{
// Información de Sesión
oENTSession = (ENTSession)this.Session["oENTSession"];
// Formulario
oENTSubMenu.idRol = oENTSession.idRol;
oENTSubMenu.idSubMenu = idSubMenu;
oENTSubMenu.idMenu = 0;
oENTSubMenu.sNombre = "";
oENTSubMenu.tiActivo = 2;
// Transacción
oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
// Mensaje de la BD
this.lblActionMessage.Text = oENTResponse.sMessage;
// Llenado de formulario
this.ddlActionMenu.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["idMenu"].ToString();
this.txtActionNombre.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sNombreSubMenu"].ToString();
this.txtActionDescripcion.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sDescripcion"].ToString();
this.txtActionPageName.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sPageName"].ToString();
this.txtActionURL.Text = oENTResponse.dsResponse.Tables[1].Rows[0]["sURL"].ToString();
this.ddlActionStatus.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["tiActivo"].ToString();
this.ddlActionRequired.SelectedValue = oENTResponse.dsResponse.Tables[1].Rows[0]["tiRequired"].ToString();
}
catch (Exception ex)
{
throw (ex);
}
}
private void SelectSubMenu()
{
ENTSubMenu oENTSubMenu = new ENTSubMenu();
ENTResponse oENTResponse = new ENTResponse();
ENTSession oENTSession;
BPSubMenu oBPSubMenu = new BPSubMenu();
String sMessage = "";
try
{
// Información de Sesión
oENTSession = (ENTSession)this.Session["oENTSession"];
// Formulario
oENTSubMenu.idRol = oENTSession.idRol;
oENTSubMenu.idSubMenu = 0;
oENTSubMenu.idMenu = Int32.Parse(this.ddlMenu.SelectedItem.Value);
oENTSubMenu.sNombre = this.txtNombre.Text;
oENTSubMenu.tiActivo = Int16.Parse(this.ddlStatus.SelectedItem.Value);
// Transacción
oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
// Mensaje de la BD
if (oENTResponse.sMessage != "") { sMessage = "alert('" + gcJavascript.ClearText(oENTResponse.sMessage) + "');"; }
// Llenado de controles
this.gvSubMenu.DataSource = oENTResponse.dsResponse.Tables[1];
this.gvSubMenu.DataBind();
// Mensaje al usuario
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), Convert.ToString(Guid.NewGuid()), sMessage, true);
}
catch (Exception ex)
{
throw (ex);
}
}
private void SelectSubMenu_ForViewState()
{
ENTSubMenu oENTSubMenu = new ENTSubMenu();
ENTResponse oENTResponse = new ENTResponse();
ENTSession oENTSession;
BPSubMenu oBPSubMenu = new BPSubMenu();
DataTable tblSubMenu = null;
DataRow rowSubMenu = null;
try
{
// Información de Sesión
oENTSession = (ENTSession)this.Session["oENTSession"];
// Formulario
oENTSubMenu.idRol = oENTSession.idRol;
oENTSubMenu.idSubMenu = 0;
oENTSubMenu.idMenu = 0;
oENTSubMenu.sNombre = "";
oENTSubMenu.tiActivo = 1;
// Transacción
oENTResponse = oBPSubMenu.SelectSubMenu(oENTSubMenu);
// Validaciones
if (oENTResponse.GeneratesException) { throw (new Exception(oENTResponse.sErrorMessage)); }
// Mensaje de la BD
if (oENTResponse.sMessage != "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), Convert.ToString(Guid.NewGuid()), "alert('" + gcJavascript.ClearText(oENTResponse.sMessage) + "');", true); }
// Definición del DataTable
tblSubMenu = new DataTable("tblSubMenu");
tblSubMenu.Columns.Add("idMenu", typeof(Int32));
tblSubMenu.Columns.Add("idSubMenu", typeof(Int32));
tblSubMenu.Columns.Add("sNombreMenu", typeof(String));
tblSubMenu.Columns.Add("sNombreSubMenu", typeof(String));
tblSubMenu.Columns.Add("tiSelected", typeof(Int32));
tblSubMenu.Columns.Add("tiRequired", typeof(Int32));
// Llenado de DataTable
foreach (DataRow rowCurrentSubMenu in oENTResponse.dsResponse.Tables[1].Rows)
{
rowSubMenu = tblSubMenu.NewRow();
rowSubMenu["idMenu"] = rowCurrentSubMenu["idMenu"];
rowSubMenu["idSubMenu"] = rowCurrentSubMenu["idSubMenu"];
rowSubMenu["sNombreMenu"] = rowCurrentSubMenu["sNombreMenu"];
rowSubMenu["sNombreSubMenu"] = rowCurrentSubMenu["sNombreSubMenu"];
rowSubMenu["tiSelected"] = rowCurrentSubMenu["tiRequired"];
rowSubMenu["tiRequired"] = rowCurrentSubMenu["tiRequired"];
tblSubMenu.Rows.Add(rowSubMenu);
}
// Almacenar en ViewState
this.ViewState["tblSubMenu"] = tblSubMenu;
this.ViewState["tblSubMenu_Filtered"] = this.ViewState["tblSubMenu"];
// Llenado de controles
this.gvActionSubMenu.DataSource = tblSubMenu;
this.gvActionSubMenu.DataBind();
}
catch (Exception ex)
{
throw (ex);
}
}
