public int deletePermiso(string _action, perfil oPerfil)
{
int result = -99;
string sql = "";
using (SqlConnection _conn = Program.sqlConn())
{
try
{
switch (_action)
{
case "0":
sql = string.Format("DELETE perfiles where id_grupo = {0} and id_formulario = {1} and id_permiso = {2}", oPerfil.Id_grupo, oPerfil.Id_formulario, oPerfil.Id_permiso);
break;
default:
break;
}
using (SqlCommand aCommand = new SqlCommand(sql, _conn))
{
// Excecute Query
result = aCommand.ExecuteNonQuery();
}
}
catch
{
}
}
return result;
}
//int _idgrupo, int id_formulario, int id_permiso,int id_menu)
public int Create(string _action, perfil oPerfil)
{
int result = -99;
string sql = "";
using (SqlConnection _conn = Program.sqlConn())
{
try
{
switch (_action)
{
case "0":
sql = string.Format("INSERT INTO perfiles ( id_grupo, id_formulario, id_permiso,id_menu) values ('{0}','{1}','{2}',{3})", oPerfil.Id_grupo, oPerfil.Id_formulario, oPerfil.Id_permiso, oPerfil.Id_menu);
break;
default:
break;
}
using (SqlCommand aCommand = new SqlCommand(sql, _conn))
{
// Excecute Query
result = aCommand.ExecuteNonQuery();
}
}
catch
{
}
}
return result;
}
public perfil[] Getform_perm(string _action, int id_form, int id_grupo, int id_permiso)
{
string sql = "";
List<perfil> _form_permisos = new List<perfil>();
using (SqlConnection _conn = Program.sqlConn())
{
try
{
switch (_action)
{
case "0":
sql = string.Format("SELECT * FROM perfiles where id_formulario = {0} and id_grupo = {1} and id_permiso = {2}", id_form, id_grupo, id_permiso);
break;
case "1":
sql = string.Format("SELECT * FROM perfiles where id_formulario = {0} and id_grupo = {1}", id_form, id_grupo);
break;
default:
break;
}
using (SqlCommand aCommand = new SqlCommand(sql, _conn))
{
using (SqlDataReader aReader = aCommand.ExecuteReader())
{
if (aReader.HasRows)
{
perfil _oform_perm;
while (aReader.Read())
{
_oform_perm = new perfil();
_oform_perm.Id_grupo = int.Parse(aReader["id_grupo"].ToString());
_oform_perm.Id_formulario = int.Parse(aReader["id_formulario"].ToString());
_oform_perm.Id_permiso = int.Parse(aReader["id_permiso"].ToString());
_form_permisos.Add(_oform_perm);
}
}
}
}
}
catch
{
}
return _form_permisos.ToArray();
}
}
public perfil GetformComp(string _action, int id_grupo, int id_formulario,int id_permiso)
{
string sql = "";
perfil _form_permiso = new perfil();
using (SqlConnection _conn = Program.sqlConn())
{
try
{
switch (_action)
{
case "0":
sql = string.Format("SELECT * FROM perfiles where id_grupo = {0} and id_formulario = {1} and id_permiso = {2}", id_grupo, id_formulario, id_permiso);
break;
default:
break;
}
using (SqlCommand aCommand = new SqlCommand(sql, _conn))
{
using (SqlDataReader aReader = aCommand.ExecuteReader())
{
if (aReader.HasRows)
{
while (aReader.Read())
{
_form_permiso.Id_grupo = int.Parse(aReader["id_grupo"].ToString());
_form_permiso.Id_formulario = int.Parse(aReader["id_formulario"].ToString());
_form_permiso.Id_permiso = int.Parse(aReader["id_permiso"].ToString());
}
}
}
}
}
catch
{
}
return _form_permiso;
}
}