public DataTable GetData(Dprivilegios entiti)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_PRIVILEGIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_rol", entiti.Id_rol);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
dt.Load(reader);
reader.Close();
}
}
}
return(dt);
}
public List <NPrivilegios> Getall()
{
Dprivilegios dp = new Dprivilegios();
dp.Id_rol = Id_rol;
using (DataTable dt = rpriv.GetData(dp))
{
listpriv = new List <NPrivilegios>();
foreach (DataRow item in dt.Rows)
{
listpriv.Add(new NPrivilegios()
{
Id_privilegios = Convert.ToInt32(item[0]),
Btipopla = Convert.ToBoolean(item[1]),
Btipocont = Convert.ToBoolean(item[2]),
Bregimensalud = Convert.ToBoolean(item[3]),
Bsubsinosub = Convert.ToBoolean(item[4]),
Bcargo = Convert.ToBoolean(item[5]),
Btipodoc = Convert.ToBoolean(item[6]),
Bbanco = Convert.ToBoolean(item[7]),
Broles = Convert.ToBoolean(item[8]),
Bregimenpen = Convert.ToBoolean(item[9]),
Bcomisiones = Convert.ToBoolean(item[10]),
Bempleado = Convert.ToBoolean(item[11]),
Bempresa = Convert.ToBoolean(item[12]),
Bsucursal = Convert.ToBoolean(item[13]),
Busuario = Convert.ToBoolean(item[14]),
Bplanilla = Convert.ToBoolean(item[15])
});
}
}
return(listpriv);
}
public string SaveChanges()
{
string message;
using (Dprivilegios dp = new Dprivilegios())
{
try
{
dp.Id_privilegios = Id_privilegios;
dp.Id_rol = Id_rol;
dp.Btipopla = Btipopla;
dp.Btipocont = Btipocont;
dp.Bregimensalud = Bregimensalud;
dp.Bsubsinosub = Bsubsinosub;
dp.Bcargo = Bcargo;
dp.Btipodoc = Btipodoc;
dp.Bbanco = Bbanco;
dp.Broles = Broles;
dp.Bregimenpen = Bregimenpen;
dp.Bcomisiones = Bcomisiones;
dp.Bempleado = Bempleado;
dp.Bempresa = Bempresa;
dp.Bsucursal = Bsucursal;
dp.Busuario = Busuario;
dp.Bplanilla = Bplanilla;
switch (State)
{
case EntityState.Guardar:
rpriv.SaveAddUpdate(dp);
message = "¡Guardado!";
break;
default:
message = "Error in Transaction!";
break;
}
}
catch (Exception ex)
{
message = ex.Message;
}
finally { }
}
return(message);
}
public int SaveAddUpdate(Dprivilegios entiti)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_RegistroPrivilegios";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idprivilegios", entiti.Id_privilegios);
cmd.Parameters.AddWithValue("@idrol", entiti.Id_rol);
cmd.Parameters.AddWithValue("@btipopla", entiti.Btipopla);
cmd.Parameters.AddWithValue("@btipocont", entiti.Btipocont);
cmd.Parameters.AddWithValue("@bregimensalud ", entiti.Bregimensalud);
cmd.Parameters.AddWithValue("@bsubsinosub", entiti.Bsubsinosub);
cmd.Parameters.AddWithValue("@bcargo", entiti.Bcargo);
cmd.Parameters.AddWithValue("@btipodoc", entiti.Btipodoc);
cmd.Parameters.AddWithValue("@bbanco", entiti.Bbanco);
cmd.Parameters.AddWithValue("@broles", entiti.Broles);
cmd.Parameters.AddWithValue("@bregimenpen", entiti.Bregimenpen);
cmd.Parameters.AddWithValue("@bcomisiones", entiti.Bcomisiones);
cmd.Parameters.AddWithValue("@bempleado", entiti.Bempleado);
cmd.Parameters.AddWithValue("@bempresa", entiti.Bempresa);
cmd.Parameters.AddWithValue("@bsucursal", entiti.Bsucursal);
cmd.Parameters.AddWithValue("@busuario", entiti.Busuario);
cmd.Parameters.AddWithValue("@bplanilla", entiti.Bplanilla);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
return(result);
}
