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); }