public bool Delete(string empresaid, tb_perfilitems BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPerfilitems_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idper", SqlDbType.Char, 9).Value = BE.idper;
cmd.Parameters.Add("@plataforma", SqlDbType.Char, 1).Value = BE.plataforma;
cmd.Parameters.Add("@menid", SqlDbType.Int).Value = BE.menid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_perfilitems BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPerfilitems_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idper", SqlDbType.Char, 9).Value = BE.idper;
cmd.Parameters.Add("@plataforma", SqlDbType.Char, 1).Value = BE.plataforma;
cmd.Parameters.Add("@menid", SqlDbType.Int).Value = BE.menid;
//cmd.Parameters.Add("@padid", SqlDbType.Int).Value = BE.padid;
//cmd.Parameters.Add("@posic", SqlDbType.Int).Value = BE.posic;
cmd.Parameters.Add("@descr", SqlDbType.VarChar, 100).Value = BE.descr;
cmd.Parameters.Add("@icono", SqlDbType.VarChar, 100).Value = BE.icono;
//cmd.Parameters.Add("@habil", SqlDbType.Bit).Value = BE.habil;
cmd.Parameters.Add("@pgurl", SqlDbType.VarChar, 100).Value = BE.pgurl;
cmd.Parameters.Add("@nivelacc", SqlDbType.Char, 5).Value = BE.nivelacc;
cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_actives(string empresaid, tb_perfilitems BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPerfilitems_SEARCH_actives", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idper", SqlDbType.Char, 9).Value = BE.idper;
cmd.Parameters.Add("@plataforma", SqlDbType.Char, 1).Value = BE.plataforma;
cmd.Parameters.Add("@menid", SqlDbType.Int).Value = BE.menid;
cmd.Parameters.Add("@descr", SqlDbType.VarChar, 100).Value = BE.descr;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Update_propied(string empresaid, tb_perfilitems BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbPerfilitems_UPDATE_propied", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idper", SqlDbType.Char, 9).Value = BE.idper;
cmd.Parameters.Add("@plataforma", SqlDbType.Char, 1).Value = BE.plataforma;
cmd.Parameters.Add("@menid", SqlDbType.Int).Value = BE.menid;
cmd.Parameters.Add("@padid", SqlDbType.Int).Value = BE.padid;
cmd.Parameters.Add("@posic", SqlDbType.Int).Value = BE.posic;
cmd.Parameters.Add("@descr", SqlDbType.VarChar, 100).Value = BE.descr;
cmd.Parameters.Add("@icono", SqlDbType.VarChar, 100).Value = BE.icono;
cmd.Parameters.Add("@habil", SqlDbType.Bit).Value = BE.habil;
cmd.Parameters.Add("@pgurl", SqlDbType.VarChar, 100).Value = BE.pgurl;
cmd.Parameters.Add("@nivelacc", SqlDbType.Char, 5).Value = BE.nivelacc;
cmd.Parameters.Add("@dominioid", SqlDbType.Char, 2).Value = BE.dominioid;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void Update_propied()
{
try
{
if (idper.Text.Trim().Length != 9)
{
MessageBox.Show("Ingrese Perfil !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (menid.Text.Trim().Length != 3)
{
MessageBox.Show("No existe Id Menu !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
data_nuevoperfil();
var BL = new perfilitemsBL();
var BE = new tb_perfilitems();
BE.idper = idper.Text.Trim();
BE.plataforma = "1";
BE.menid = Convert.ToInt16(menid.Text.Trim());
BE.descr = descr.Text.Trim();
if (nivelacc.SelectedIndex != -1 && nivelacc.SelectedValue.ToString().Trim().Trim().Length > 0)
{
BE.nivelacc = nivelacc.SelectedValue.ToString().PadRight(5, '0');
}
BE.habil = habil.Checked;
if (BL.Update_propied(EmpresaID, BE))
{
MessageBox.Show("Datos Modificados", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
data_Perfil_user(idper.Text.Trim());
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void data_Perfil_user(String perfil)
{
try
{
TreeNode Tperfil;
var BL = new perfilitemsBL();
var BE = new tb_perfilitems();
var dt = new DataTable();
treeperfil.Nodes.Clear();
if (perfil.Trim().Length != 9)
{
MessageBox.Show("Seleccione un perfil !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
BE.idper = perfil.Trim();
BE.plataforma = "1";
dt = BL.GetAll_actives(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
Tablaperfil = dt;
treeperfil.CheckBoxes = true;
foreach (DataRow DRmenu in dt.Rows)
{
Tperfil = new TreeNode();
Tperfil.Name = DRmenu["menid"].ToString();
Tperfil.Text = DRmenu["descr"].ToString();
Tperfil.ToolTipText = DRmenu["padid"].ToString();
if (DRmenu["activo"].ToString().Trim().Length > 0)
{
Tperfil.Checked = Convert.ToBoolean(DRmenu["activo"]);
}
if (DRmenu["menid"].Equals(DRmenu["padid"]))
{
treeperfil.Nodes.Add(Tperfil);
}
Perfil_item_user(ref Tperfil, dt);
}
}
else
{
MessageBox.Show("No hay Datos !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Update()
{
try
{
if (idper.Text.Trim().Length != 9)
{
MessageBox.Show("Ingrese Perfil !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
data_nuevoperfil();
var BL = new perfilitemsBL();
var BE = new tb_perfilitems();
var Detalle = new tb_perfilitems.Item();
var ListaItems = new List<tb_perfilitems.Item>();
foreach (DataRow fila in Tablanuevoperfil.Rows)
{
Detalle = new tb_perfilitems.Item();
Detalle.idper = fila["idper"].ToString();
Detalle.plataforma = fila["plataforma"].ToString();
Detalle.menid = Convert.ToInt16(fila["menid"]);
Detalle.padid = Convert.ToInt16(fila["padid"]);
Detalle.posic = Convert.ToInt16(fila["posic"]);
Detalle.descr = fila["descr"].ToString();
Detalle.grupo = fila["grupo"].ToString();
Detalle.icono = fila["icono"].ToString();
Detalle.habil = Convert.ToBoolean(fila["habil"]);
Detalle.pgurl = fila["pgurl"].ToString();
Detalle.nivelacc = fila["nivelacc"].ToString();
Detalle.dominioid = fila["dominioid"].ToString();
Detalle.moduloid = fila["moduloid"].ToString();
Detalle.local = fila["local"].ToString();
ListaItems.Add(Detalle);
}
BE.idper = idper.Text.Trim();
BE.plataforma = "1";
BE.ListaItems = ListaItems;
if (BL.Update_xml(EmpresaID, BE))
{
MessageBox.Show("Datos grabados correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Update_xml(string empresaid, tb_perfilitems BE)
{
return tablaDA.Update_xml(empresaid, BE);
}
private void Delete2()
{
try
{
if (idper2.Text.Trim().Length != 9)
{
MessageBox.Show("Seleccione Perfil !!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new perfilitemsBL();
var BE = new tb_perfilitems();
BE.idper = idper2.Text.Trim();
BL.Delete(EmpresaID, BE);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Insert_xml(string empresaid, tb_perfilitems BE)
{
return tablaDA.Insert_xml(empresaid, BE);
}
public DataSet GetOne(string empresaid, tb_perfilitems BE)
{
return tablaDA.GetOne(empresaid, BE);
}
public DataSet GetAll_nivel_acceso(string empresaid, tb_perfilitems BE)
{
return tablaDA.GetAll_nivel_acceso(empresaid, BE);
}
public DataSet GetAll_actives(string empresaid, tb_perfilitems BE)
{
return tablaDA.GetAll_actives(empresaid, BE);
}
public bool Delete(string empresaid, tb_perfilitems BE)
{
return tablaDA.Delete(empresaid, BE);
}